Feature request #16411

Adding missing EPSG projection to srs.db tbl_srs

Added by Mark Johnson about 7 years ago. Updated about 7 years ago.

Status:Closed
Priority:Low
Assignee:-
Category:Geometry
Pull Request or Patch supplied:No Resolution:invalid
Easy fix?:No Copied to github as #:24320

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

#1 Updated by Jürgen Fischer about 7 years ago

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

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.

#2 Updated by Mark Johnson about 7 years ago

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

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

#3 Updated by Jürgen Fischer about 7 years 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).

#4 Updated by Jürgen Fischer about 7 years 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 PDF