[postgis-devel] [PostGIS] #318: 900913->4326 Transform

[PostGIS]

#318: 900913->4326 Transform
----------------------+-----------------------------------------------------
  Reporter:  pramsey  |       Owner:  mcayland     
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  PostGIS 1.4.1
 Component:  postgis  |     Version:  trunk        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by filbertkm):

 I had the same problem.  I upgraded from PostGIS 1.3.6 to the 1.5 svn
 version.  I used spatial_ref_sys and the postgis upgrade script.  I also
 used a 900913.sql script of my own (can't remember where I got it).

 Since PostGIS 1.3.6, the Google Spherical Mercator projection has been
 assigned an EPSG code:

 http://spatialreference.org/ref/epsg/3785/

 My database still had all the tables assigned as 900913.  To resolve the
 problem, I dropped the 900913 entry from my spatial_ref_sys table:

 Then I took the PostGIS spatial_ref_sys INSERT statement for 3785 from the
 spatial reference site.  I updated my 900913.sql statement with this one,
 but changing the srid and auth_srid to 900913.  I then readded 900913 to
 PostGIS and everything works great now.

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