[postgis-tickets] [PostGIS] #2417: pgsql2shp doesnt see SRID

[PostGIS]

#2417: pgsql2shp doesnt see SRID
------------------------+---------------------------------------------------
  Reporter:  darkblueb  |       Owner:  pramsey        
      Type:  defect     |      Status:  reopened       
  Priority:  medium     |   Milestone:  PostGIS 2.1.0  
 Component:  postgis    |     Version:  2.0.x          
Resolution:             |    Keywords:  srid, pgsql2shp
------------------------+---------------------------------------------------
Changes (by darkblueb):

  * status:  closed => reopened
  * resolution:  wontfix =>


Comment:

 ''... since you didn't make it a typed geometry, the srid will be 0...''

 the SRID is embedded in the geometry

 {{{
 ne3_test=# select column2 from shp_test ;
                       column2
 ----------------------------------------------------
  01010000208C1000004BCCB392569B5EC0AB05F69848E14240
 (1 row)

 ne3_test=# select
 st_asewkt('01010000208C1000004BCCB392569B5EC0AB05F69848E14240'::geometry);
                st_asewkt
 ----------------------------------------
  SRID=4236;POINT(-122.427159 37.760028)
 (1 row)

 }}}

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