Opened 13 years ago

Closed 13 years ago

#1493 closed defect (fixed)

wrong proj4text in spatial_ref_sys for SRID 4149

Reported by: strk Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.0.0
Component: postgis Version: master
Keywords: proj4text Cc:

Description

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.

Attachments (1)

srs_hand_edits.patch (80.6 KB ) - added by pramsey 13 years ago.
Additions to the GDAL generated file

Download all attachments as: .zip

Change History (4)

comment:1 by strk, 13 years ago

Keywords: proj4text added

See also #1389 (for a spatial_ref_sys bugs ring)

comment:2 by strk, 13 years ago

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

by pramsey, 13 years ago

Attachment: srs_hand_edits.patch added

Additions to the GDAL generated file

comment:3 by pramsey, 13 years ago

Resolution: fixed
Status: newclosed

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

Note: See TracTickets for help on using tickets.