Feature request #16411
Adding missing EPSG projection to srs.db tbl_srs
|Pull Request or Patch supplied:||No||Resolution:||invalid|
|Easy fix?:||No||Copied to github as #:||24320|
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);
#3 Updated by Jürgen Fischer over 5 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).