[postgis-devel] [PostGIS] #1356: [raster] srid in raster_columns view is zero

PostGIS trac at osgeo.org
Thu Dec 8 11:46:23 PST 2011


#1356: [raster] srid in raster_columns view is zero
----------------------------+-----------------------------------------------
 Reporter:  bnordgren       |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Not sure if this is a bug or not. As of r8322, I tried:


 {{{
 raster2pgsql.py -r $asciigrid -t gfed.burned_area -s 4326 -F | psql gfed
 }}}

 (It's a tiny raster so no blocking. Also, "gfed" is a brand new database
 created after r8322 was installed.)


 The `raster_columns` view reports srid=0 as follows:

 {{{
 gfed=# select r_table_schema, r_table_name, r_raster_column, srid from
 raster_columns ;
  r_table_schema | r_table_name | r_raster_column | srid
 ----------------+--------------+-----------------+------
  gfed           | burned_area  | rast            |    0
 (1 row)
 }}}

 But the raster itself knows it's srid:

 {{{
 gfed=# select ST_srid(rast) from gfed.burned_area ;
  st_srid
 ---------
     4326
 (1 row)
 }}}

 I looked thru the ticket related to the conversion of raster_columns to a
 view, but didn't see anything declaring this intent (I could have missed
 it tho.)

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1356>
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-devel mailing list