NIM044808 for ArcSDE/Enterprise Geodatabase

Numéro d’ID de bogue	NIM044808
Envoi	April 28, 2009
Dernière modification	April 2, 2025
S’applique à	ArcSDE/Enterprise Geodatabase
Version trouvée	9.3
Système d’exploitation	Windows OS
Version du système d’exploitation	2003
Statut	Will Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

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.