NIM044808 for ArcSDE/Enterprise Geodatabase

Bug-ID-Nummer	NIM044808
Eingereicht	April 28, 2009
Zuletzt geändert	April 2, 2025
Gilt für	ArcSDE/Enterprise Geodatabase
Gefunden in Version	9.3
Betriebssystem	Windows OS
Betriebssystemversion	2003
Status	Will Not Be Addressed

Zusätzliche Informationen

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

Workaround

To get appropriate values for 1, 2, and 3 for each image, here is an example:RAS@ORCL>select objectid, sdo_geor.getSRS(raster) SRS from sdo_cat11g where objectid = 3; OBJECTID SRS(ISREFERENCED, ISRECTIFIED, ISORTHORECTIFIED, SRID, SPATIALRESOLUTION, SPATIA------------ ------------------------------------------------------------------------------------- 3 SDO_GEOR_SRS('TRUE', 'TRUE', NULL, 0, SDO_NUMBER_ARRAY(.000277778, .000277778 ), NULL, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, SDO_NUMBER_ARRAY(1, 2, 1, 3, 169205.5, 0, -3600), SDO_NUMBER_ARRAY(1, 0, 0, 1, 1), SDO_NUMBER_ARRAY( 1, 2, 1, 3, 360005.5, 3600, 0), SDO_NUMBER_ARRAY(1, 0, 0, 1, 1))There are 3 places to modify for the images you sent me:1. The srs.srid, set it to be 42692. The srs.rowNumerator:SDO_NUMBER_ARRAY(1, 2, 1, 3, 169205.5, 0, -3600) ---> just keep the original values3. The srs.columnNumerator: SDO_NUMBER_ARRAY(1, 2, 1, 3, 360005.5, 3600, 0) ---> just keep the original valuesThe function call:=======================================================DECLARE grobj sdo_georaster; srs sdo_geor_srs; BEGINSELECT raster INTO grobj FROM sdo_cat11g WHERE objectid=3;srs := sdo_geor.getSRS(grobj);srs.isReferenced := 'TRUE';srs.isRectified := 'TRUE';srs.isOrthoRectified := null;srs.srid := 4269;srs.spatialResolution := sdo_number_array(0.000277778, 0.000277778);srs.rowOff := 0;srs.columnOff := 0;srs.xOff := 0;srs.yOff := 0;srs.zOff := 0;srs.rowScale := 1;srs.columnScale := 1;srs.xScale := 1;srs.yScale := 1;srs.zScale := 1;srs.rowNumerator := SDO_NUMBER_ARRAY(1, 2, 1, 3, 169205.5, 0, -3600);srs.rowDenominator := SDO_NUMBER_ARRAY(1, 0, 0, 1, 1); srs.columnNumerator := SDO_NUMBER_ARRAY(1, 2, 1, 3, 360005.5, 3600, 0);srs.columnDenominator := SDO_NUMBER_ARRAY(1, 0, 0, 1, 1); sdo_geor.setSRS(grobj, srs); UPDATE sdo_cat11g SET raster = grobj WHERE objectid=3;COMMIT;END;/=======================================================Then, user can validate the georaster object, validate the schema, and then build the spatial index.