NIM044808 for ArcSDE/Enterprise Geodatabase

Número de ID del error	NIM044808
Enviado	April 28, 2009
Última modificación	April 2, 2025
Relacionado con	ArcSDE/Enterprise Geodatabase
Versión encontrada	9.3
Sistema operativo	Windows OS
Versión de sistema operativo	2003
Estado	Will Not Be Addressed

Información adicional

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.

Solución alternativa

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.