[postgis-devel] [PostGIS] #1238: [raster] Resample and upperleftx , upperlefty (was: Resample and upperleftx , upperlefty)

[PostGIS]

#1238: [raster] Resample and upperleftx , upperlefty
----------------------------+-----------------------------------------------
 Reporter:  standa          |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:  ST_Resample     |  
----------------------------+-----------------------------------------------

Comment(by dustymugs):

 No.  That is incorrect.  What versions (and revisions) of GDAL and PostGIS
 are you using?  I created a test transforming from 4326 to 3844

 {{{
 SELECT rid, (ST_Metadata(rast)).* FROM (
 (
 SELECT
         1 AS rid,
         ST_AddBand(
                 ST_MakeEmptyRaster(1, 1, 24.818115, 45.822675, 0.01, 0.01,
 0, 0, 4326),
                 1, '8BUI', 1
         ) AS rast
 ) UNION ALL (
 SELECT
         2 AS rid,
         ST_Transform(
                 ST_AddBand(
                         ST_MakeEmptyRaster(1, 1, 24.818115, 45.822675,
 0.01, 0.01, 0, 0, 4326),
                         1, '8BUI', 1
                 ),
                 3844
         ) AS rast
 )
 ) AS foo;
 }}}

 If you run the SQL above, the results should be similar to:

 {{{
 rid;upperleftx;upperlefty;width;height;scalex;scaley;skewx;skewy;srid;numbands
 1;24.818115;45.822675;1;1;0.01;0.01;0;0;4326;1
 2;485990.139598202;481453.235469657;1;1;958.718116254953;-958.718116254953;0;0;3844;1
 }}}

 The results above are from a machine running GDAL svn-trunk !r23215 and
 PostGIS svn-trunk r7964.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1238#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.