id summary reporter owner description type status priority milestone component version severity resolution keywords cc 2063 exporting ArcSDE raster results in a displaced image dcarreira warmerdam "Using FWTools 1.3.9 with gdal_SDE_92.dll plugin, and exporting a window from an ArcSDE raster results in an image that is displaced from the original. Example command:[[BR]] gdal_translate -of JPEG -co WORLDFILE=YES -projwin 271212 148107 271512 147857 SDE:,5151,database,,,.rasterdataset testgdal.jpg [[BR]] In this particular example the image was 64 pixels displaced to south. Other tests resulted in other displacements that I could not relate. [[BR]] The world file generated was the following: [[BR]] 0.4000000000 0.0000000000 0.0000000000 -0.4000000000 271212.2000000000 148107.0000000000 [[BR]] When it should have been: [[BR]] 0.4000000000 0.0000000000 0.0000000000 -0.4000000000 271212.2000000000 148132.600000000 [[BR]] The properties of this particular ArcSDE system and data are the following: [[BR]] ArcSDE 9.2 SP3, on Oracle 9.2 (remote box) Description of raster given by sderaster -o describe command: [[BR]] ArcSDE 9.2 for Oracle9i Build 1173 Thu May 31 12:02:22 2007 ---------------------------------------------------------------- Raster Layer Description ....: [[BR]] Table Name ..................: . [[BR]] Raster Column ...............: RASTER [[BR]] Raster Layer ID .............: 313 [[BR]] Minimum Raster ID ...........: 1 [[BR]] Creation Date ...............: Fri Nov 30 17:45:58 2007 [[BR]] User Privileges .............: SELECT, INSERT, DELETE, UPDATE [[BR]] Raster Layer Configuration ..: MOSAICO [[BR]] Storage Type ................: DEFAULT [[BR]] Coordinate System ...........: PROJCS[""Datum_73_Hayford_Gauss_IGeoE"",GEOGCS[""GCS _Datum_73"",DATUM[""D_Datum_73"",SPHEROID[""International_1924"",6378388.0,297.0]],PR IMEM[""Greenwich"",0.0],UNIT[""Degree"",0.0174532925199433]],PROJECTION[""Transverse_ Mercator""],PARAMETER[""False_Easting"",200180.598],PARAMETER[""False_Northing"",2999 13.01],PARAMETER[""Central_Meridian"",-8.131906111111112],PARAMETER[""Scale_Factor"" ,1.0],PARAMETER[""Latitude_Of_Origin"",39.66666666666666],UNIT[""Meter"",1.0]] [[BR]] Description of raster given by sderaster -o list -verbose command: [[BR]] ArcSDE 9.2 for Oracle9i Build 1173 Thu May 31 12:02:22 2007 ---------------------------------------------------------------- Raster ID ...................: 1 [[BR]] Raster Dimension ............: 300000, 275250+64, 3 [[BR]] Raster Tile Dimension .......: 128, 128 [[BR]] Pixel Type ..................: uchar [[BR]] Compression .................: jpeg [[BR]] Image Pyramid ...............: 9, false, bilinear [[BR]] Extent ......................: [[BR]] minx : 175050.20000000001000 miny : 99950.19999999999700 maxx : 295049.79999999999000 maxy : 210049.80000000002000 Cell Size....................: x : 0.40000000000000 y : 0.40000000000000 [[BR]] Statistics ..................: [[BR]] Could not get an answer from gdalinfo (took too long)." defect closed normal 1.5.4 GDAL_Raster 1.5.0 betas/RCs normal fixed gdal, arcsde, raster