[postgis-tickets] [PostGIS] #2737: [PATCH] Upgrade of spatial_ref_sys.sql to EPSG v8.4

[PostGIS]

#2737: [PATCH] Upgrade of spatial_ref_sys.sql to EPSG v8.4
---------------------+------------------------------------------------------
 Reporter:  rouault  |       Owner:  robe         
     Type:  patch    |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.2.0
Component:  postgis  |     Version:               
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 roault,
 There are quite a few differences with this spatial_ref_sys and what we
 have in 2.1. Yours looks closer to the 1.5 spatial_ref_sys. I'm not sure
 if its a difference in representation or one is more right than the other

 pramsey,

 Can you tell me why you took out all the DATUM tags and replaced with
 +towgs84 settings?  Are these two things kinda equivalent?

 So to be clear what I am talking about -- this is one thing someone
 complained about in our book on one of our examples.


 For srid=4269

 roualts has this which matches our 1.5 definition

 {{{
 +proj=longlat +datum=NAD83 +no_defs
 }}}

 and we currently have in our 2.1,2.1 (I think possibly 2.0 as well don't
 recall when the last spatial_ref_sys was loaded)

 {{{
 +proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs
 }}}

 There are 713 records such as this that do not match and at a cursory
 glance it seems because the DATUM has been removed, though not always.

 For example srid=4756

 In roualt's:

 {{{
 +proj=longlat +ellps=WGS84
 +towgs84=-192.873,-39.382,-111.202,-0.00205,-0.0005,0.00335,0.0188
 +no_defs
 }}}

 Our's is (but looking back at 1.5, its the same for 1.5 so I assume
 roault's is just a correction)

 {{{
 +proj=longlat +ellps=WGS84 +no_defs
 }}}

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