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.