Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update GeoRaster NODATA Value

Simon GreenerSep 7 2023

I have a georaster (called carbon) that has a NODATA value set to -9.

All other cell values are ≥ 0.0.

I wish to change the NODATA cell values in the georaster to -999999.

I have tried the following but the update didn't occur.

Can anyone spot what I am doing wrong?

select t.lb from carbon a, SDO_GEOR.getNODATA(a.raster, 0) t;

LB
----------
-9

declare
gr sdo_georaster;
begin
select raster into gr from carbon;
sdo_geor_ra.rasterUpdate(geoRaster => gr,
pyramidLevel => 0,
conditions => SDO_STRING2_ARRAY('{0}<0'),
vals => SDO_STRING2_ARRAYSET(SDO_STRING2_ARRAY('-999999')),
bgValues => NULL,
nodata => 'FALSE');
UPDATE carbon SET raster=gr;
commit;
end;
/

select t.lb from carbon a, SDO_GEOR.getNODATA(a.raster, 0) t;

LB
----------
-9

Comments
Post Details
Added on Sep 7 2023
7 comments
220 views