[postgis-tickets] [PostGIS] #2901: raster trying to use strange SRID

PostGIS trac at osgeo.org
Wed Aug 20 00:15:39 PDT 2014


#2901: raster trying to use strange SRID
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  medium  |   Milestone:  PostGIS 2.1.4
Component:  raster  |     Version:  2.1.x        
 Keywords:          |  
--------------------+-------------------------------------------------------
 I was testing this on 2.1.2 and also 2.2.0 dev. I'm really puzzled where
 this SRS error is coming from:

 I loaded the attached pic with

 {{{
 raster2pgsql -I -e -F -Y pics/*.jpg chicago_pics | psql -U postgres -d
 pgopen2014
 }}}

 and when I tried to do something like this


 {{{
 SELECT ST_Resize(rast,100,100)
   FROM chicago_pics
   WHERE filename='Full_chicago_skyline.jpg';
 }}}


 I got this error:


 {{{
 NOTICE:  Raster has default geotransform. Adjusting metadata for use of
 GDAL Warp API
 CONTEXT:  SQL function "st_resize" statement 1


 ERROR:  rt_util_gdal_convert_sr: Could not process the provided srs:
 EPSG:32731
 CONTEXT:  SQL function "st_resize" statement 1
 ********** Error **********

 ERROR: rt_util_gdal_convert_sr: Could not process the provided srs:
 EPSG:32731
 SQL state: XX000
 Context: SQL function "st_resize" statement 1

 }}}

 Where is it getting this SRS from.  I checked the SRID of this picture

 {{{
 SELECT ST_SRID(rast)
   FROM chicago_pics
   WHERE filename='Full_chicago_skyline.jpg'
 }}}
  and it returns 0

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


More information about the postgis-tickets mailing list