[postgis-devel] [PostGIS] #1493: wrong proj4text in spatial_ref_sys for SRID 4149

[PostGIS]

#1493: wrong proj4text in spatial_ref_sys for SRID 4149
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 From: http://postgis.refractions.net/pipermail/postgis-
 devel/2012-January/017805.html

 proj4text entries for EPSG:1449 and EPSG:1450 are equal in
 spatial_ref_sys.sql:

 {{{
   ---
   --- EPSG 4149 : CH1903
   ---
   INSERT INTO "spatial_ref_sys"
 ("srid","auth_name","auth_srid","srtext","proj4text") VALUES
 (4149,'EPSG',4149,'GEOGCS["CH1903",DATUM["CH1903",SPHEROID["Bessel
 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[674.374,15.056,405.346,0,0,0,0],AUTHORITY["EPSG","6149"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4149"]]','+proj=longlat
 +ellps=bessel +towgs84=674.374,15.056,405.346,0,0,0,0 +no_defs ');
   ---
   --- EPSG 4150 : CH1903+
   ---
   INSERT INTO "spatial_ref_sys"
 ("srid","auth_name","auth_srid","srtext","proj4text") VALUES
 (4150,'EPSG',4150,'GEOGCS["CH1903+",DATUM["CH1903",SPHEROID["Bessel
 1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[674.374,15.056,405.346,0,0,0,0],AUTHORITY["EPSG","6150"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4150"]]','+proj=longlat
 +ellps=bessel +towgs84=674.374,15.056,405.346,0,0,0,0 +no_defs ');
 }}}

 while they are different in proj4/nad/epsg:

 {{{
   # CH1903
   <4149> +proj=longlat +ellps=bessel +towgs84=674.4,15.1,405.3,0,0,0,0
 +no_defs  <>
   # CH1903+
   <4150> +proj=longlat +ellps=bessel
 +towgs84=674.374,15.056,405.346,0,0,0,0 +no_defs  <>
 }}}

 Basically the code or CH1903 (EPSG:4149) seems bogus.

 spatial_ref_sys is from postgis trunk.
 nad/epsg is from proj4 trunk.

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