[postgis-devel] [PostGIS] #925: [raster] ST_Transform

[PostGIS]

#925: [raster] ST_Transform
----------------------------+-----------------------------------------------
 Reporter:  dustymugs       |       Owner:  dustymugs    
     Type:  task            |      Status:  assigned     
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:  history         |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I have no idea -- I didn't see a configuration option in GDAL to allow me
 to specify the proj library (I recall that when I compiled proj 4.7 it did
 name the file libproj-0.dll).

 I went ahead and tested the examples in my PostgreSQL 9.1 install.  It
 doesn't give an error but returns the wrong answer.  Maybe new gdal
 expects proj 4.7 or above though it should error out and its not.  I'm
 running proj 4.6.1.

 So via psql -
 {{{
 SELECT
         ST_SRID(rast),
         ST_Width(rast),
         ST_Height(rast),
         ST_NumBands(rast),
         ST_ScaleX(rast),
         ST_ScaleY(rast),
         ST_Count(rast),
         ST_Mean(rast)
 FROM (SELECT ST_Transform(
         ST_SetValue(
                 ST_SetValue(
                         ST_SetValue(
                                 ST_AddBand(
                                         ST_MakeEmptyRaster(10, 10,
 -500000, 600000, 1000, 1000, 0, 0, 1002163)
                                         , 1, '64BF', 0, 0
                                 )
                                 , 1, 1, 1, -10
                         )
                         , 1, 5, 4, 0
                 )
                 , 1, 5, 5, 3.14159
         )
         , 1003310) AS rast
 ) foo;
 }}}


 Give me this -- fair enough right:


 {{{
  st_srid | st_width | st_height | st_numbands | st_scalex | st_scaley |
 st_count
  |  st_mean
 ---------+----------+-----------+-------------+-----------+-----------+----------+-----
  1003310 |       10 |        10 |           1 |      1000 |     -1000 |
 2 | -3.429205
 }}}

 Note in BBorie's regress, he gets a width of 12 , scale x and scale y
 changed and I'm getting 10 back like its not doing anything but not
 erroring out either.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/925#comment:25>
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.