NIM044808 for ArcSDE/Enterprise Geodatabase

漏洞 ID 编号	NIM044808
已提交	April 28, 2009
上次修改时间	April 2, 2025
适用范围	ArcSDE/Enterprise Geodatabase
找到的版本	9.3
操作系统	Windows OS
操作系统版本	2003
状态	Will Not Be Addressed

附加信息

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.

解决办法

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.