Feature request #16411
Adding missing EPSG projection to srs.db tbl_srs
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 over 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 over 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 over 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 over 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