[postgis-devel] [PostGIS] #495: [wktraster] Don't seem to be able to specify non- 0 skews in ST_SetGeoReference

[PostGIS]

#495: [wktraster] Don't seem to be able to specify non- 0 skews in
ST_SetGeoReference
-----------------------+----------------------------------------------------
 Reporter:  robe       |       Owner:  pracine        
     Type:  defect     |      Status:  new            
 Priority:  medium     |   Milestone:  WKTRaster 0.1.6
Component:  wktraster  |     Version:  trunk          
 Keywords:             |  
-----------------------+----------------------------------------------------
 I assume the carriage returns in ST_SetGeoReference are optional since I
 was able to do this


 {{{
 UPDATE dummy_rast
 SET rast = ST_SetGeoReference(rast, '2 0 0 3 0.5 0.5','GDAL')
         WHERE rid=1;

 }}}

 But if I try to do this:

 {{{
 UPDATE dummy_rast
 SET rast = ST_SetGeoReference(rast, '2 -0.5 0 3 0.5 0.5','GDAL')
         WHERE rid=1;
 }}}

 I get error:

 {{{
 st_setgeoreference requires a string with 6 floating point values.
 }}}

 I assume the skew/rotation is supposed to be in radians.

 On another but related note:
 I want to verify we are renaming ST_RotationX/Y to ST_SkewX/Y -- haven't
 bothered documenting those since I figure they will change.

 Pierre,
 Also your final spec states the below -- I assume this is obsolete and
 should be changed to ST_GeoReference, ST_SetGeoReference?
 {{{
 ST_ESRIWorldFile(raster) -> string
 Return the georeference of the raster as a string representing the 6
 doubles (separated by a carriage return) of an equivalent ESRI World File
 . See.

 ST_GDALGeoTransform(raster) -> string
 Return the georeference of the raster as a string representing the 6
 doubles (separated by a carriage return) used by GDAL to georeference a
 raster.
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/495>
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.