wrong proj4text in spatial_ref_sys for SRID 4149

[strk]

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.

[strk]

See also #1389 (for a spatial_ref_sys bugs ring)

[strk]

Should we just re-issue a sync with FrankW's generator scripts ?

[pramsey]

Additions to the GDAL generated file

[pramsey]

Updated to the latest GDAL generated version + hand edits at r8987