Feature request #16411

Adding missing EPSG projection to srs.db tbl_srs

Added by Mark Johnson 20 days ago. Updated 20 days ago.

Status:Closed Start Date:04/04/2017
Priority:Low Due date:
Assigned to:- % Done:

0%

Category:Geometry
Target version:Future Release - Nice to have
Platform:all Resolution:invalid
Platform version: Pull Request or Patch supplied:No
Status info: Tag:

Description

For some reason there are 2 projections missing from srs.db tbl_srs despite the fact that they are valid and are known to spatialite and gdal and are included in GDAL's pcs.csv file

These are 2 projections used for Warsaw Pact military maps for the are of eastern Germany.

I will be installing a collection of maps of the East German border Troops that the 'Stiftung Berliner Mauer' had received (they document everything that deals with the Berlin Wall).

The intention is to offer this to their museum visitors, using QGIS.

I have planned to run the SQL script, shown below, to resolve the problem for the moment.

But in the long term it would be better to have (at least these 2) included, so that after a QGIS update (where the srs.db may be overwritten) the needed srid will still be known.

The question is why qgis_srs.sh is not including these 2 projections I have not checked for others

-- sqlite3 srs.db < update.qgis_srs_db.sql
-- SELECT description, auth_id FROM tbl_srs WHERE srid IN (5664,5665);
INSERT INTO tbl_srs
(description,projection_acronym,ellipsoid_acronym,parameters,srid,auth_name,auth_id,is_geo,deprecated)
VALUES
('Pulkovo 1942(83) / Gauss-Kruger zone 2 (E-N)','tmerc','krass','+proj=tmerc +lat_0=0 +lon_0=9 +k=1 +x_0=2500000 +y_0=0 +ellps=krass +towgs84=26,-121,-78,0,0,0,0 +units=m +no_defs',5664,'EPSG','5664',0,0),
('Pulkovo 1942(83) / Gauss-Kruger zone 3 (E-N)','tmerc','krass','+proj=tmerc +lat_0=0 +lon_0=15 +k=1 +x_0=3500000 +y_0=0 +ellps=krass +towgs84=26,-121,-78,0,0,0,0 +units=m +no_defs',5665,'EPSG','5665',0,0);

History

Updated by Jürgen Fischer 20 days ago

  • Status changed from Open to Closed
  • Resolution set to invalid

srs.db is synced with GDAL on install using src/crssync. If GDAL has 5664 and 5665 (which current versions apparently do), srs.db will have it too.

Updated by Mark Johnson 20 days ago

Please try the SELECT command on the created srs.db from master it is not found

(I did check this before submitting this ...)

Updated by Jürgen Fischer 20 days ago

Mark Johnson wrote:

Please try the SELECT command on the created srs.db from master it is not found

(I did check this before submitting this ...)

Me too. It's there. Packages (debian/ubuntu & OSGeo4W) run crssync on install. If you run from the build directory there will be a updated srs.db in the temporary directory. For local installs you have to run crssync manually (initially and after GDAL updates).

Updated by Jürgen Fischer 20 days ago

  • Subject changed from Adding missing ESPG projection to srs.db tbl_srs to Adding missing EPSG projection to srs.db tbl_srs

Also available in: Atom