PROJ/data/sql, branch 6.3 Forked from https://github.com/OSGeo/PROJ Add entries in grid_alternatives for Portugal grids coming from ESRI entries (#2103) 2020-03-27T14:35:31+00:00 Pedro Venancio pedrongvenancio@gmail.com 2020-03-27T14:35:31+00:00 9d596034ceecb63f290fc6d88bc0f68c1864b05a Fixes #2096 
Fixes #2096
 Improvements to the INSERT 2020-02-21T10:25:19+00:00 Martin Dobias wonder.sk@gmail.com 2020-02-19T22:25:18+00:00 b07d8d8077f832eb671c860b72e025c578a5e9d7 






Added more comments
2020-02-21T10:25:19+00:00

Martin Dobias
wonder.sk@gmail.com

2020-02-19T22:00:52+00:00

9e0148f844ab4d94542916d01ea5d4aac75cb28a












Add alternative grid for JTSK - JTSK03 transform (EPSG:8364)
2020-02-21T10:25:19+00:00

Martin Dobias
wonder.sk@gmail.com

2020-02-18T21:19:15+00:00

c9d4b0efb994ee522a036628d6becc6f6a519261

The definition of EPSG:8364 uses NADCON method for horizontal grid (.las/.los files)
but this format is not supported by PROJ.

UGKK (Slovak Geodetic and Cartographic Institute) provides NADCON .las/.los files here:
https://www.geoportal.sk/files/gz/slovakia_jtsk03_to_jtsk.zip

Additionally UGKK also provides the same grid file in NTv2 format:
https://www.geoportal.sk/files/gz/slovakia_jtsk03_to_jtsk_ntv2.zip

So let's add the NTv2 file the grid_alternatives table so that PROJ can automatically pick it up...





The definition of EPSG:8364 uses NADCON method for horizontal grid (.las/.los files)
but this format is not supported by PROJ.

UGKK (Slovak Geodetic and Cartographic Institute) provides NADCON .las/.los files here:
https://www.geoportal.sk/files/gz/slovakia_jtsk03_to_jtsk.zip

Additionally UGKK also provides the same grid file in NTv2 format:
https://www.geoportal.sk/files/gz/slovakia_jtsk03_to_jtsk_ntv2.zip

So let's add the NTv2 file the grid_alternatives table so that PROJ can automatically pick it up...







Fix performance issue, affecting projinfo EPSG:7842
2020-02-06T12:55:06+00:00

Even Rouault
even.rouault@spatialys.com

2020-02-05T16:59:55+00:00

589c44aa12f7a93e73297e76a898bae3783879c9

Fixes #1913

AuthorityFactory::createBetweenGeodeticCRSWithDatumBasedIntermediates() issued
a complex SQL query that pushes the SQLite3 query plan optimizer to its limits.
Was working reasonably with sqlite 3.11, but not with later versions.
So put less constraints in the main query and do post-processing checks and
auxiliary requests to avoid such issues.

For some unknown reason, this slightly slows down a bit execution time of the
whole test_cpp_api binary (~ 10%), but couldn't come with something better,
despite trying many variations of the main SQL query. It seems that in the
general case the non-filter LEFT JOIN on the supersession table helped,
except on this EPSG:7842 case.





Fixes #1913

AuthorityFactory::createBetweenGeodeticCRSWithDatumBasedIntermediates() issued
a complex SQL query that pushes the SQLite3 query plan optimizer to its limits.
Was working reasonably with sqlite 3.11, but not with later versions.
So put less constraints in the main query and do post-processing checks and
auxiliary requests to avoid such issues.

For some unknown reason, this slightly slows down a bit execution time of the
whole test_cpp_api binary (~ 10%), but couldn't come with something better,
despite trying many variations of the main SQL query. It seems that in the
general case the non-filter LEFT JOIN on the supersession table helped,
except on this EPSG:7842 case.







Database: add a geoid_like value for proj_method column of grid_alternatives, fix related entries and simplify/robustify logic to deal with EPSG 'Geographic3D to GravityRelatedHeight' methods
2020-01-23T18:05:50+00:00

Even Rouault
even.rouault@spatialys.com

2020-01-23T12:08:23+00:00

ba37cd70b299d8ea918f6bb219805713c9e6507a












Database: update to EPSG v9.8.6
2020-01-23T18:05:48+00:00

Even Rouault
even.rouault@spatialys.com

2020-01-22T21:09:26+00:00

ae1a0324fb51c8a357b24991c3627d5c2414a784

Fixes #1867





Fixes #1867







Database: add mapping for TOR27CSv1.GSB
2019-12-28T22:27:25+00:00

Even Rouault
even.rouault@spatialys.com

2019-12-28T22:14:53+00:00

5bd8446ef48f34a5e333cdb31b6bded29ee6a429












Database: add mapping for gg10_smv2.mnt and gg10_sbv2.mnt French grids
2019-12-28T22:27:25+00:00

Even Rouault
even.rouault@spatialys.com

2019-12-28T21:47:02+00:00

737e71f3b2909d3ef77e722c0a40b7ce4c42f9db












Database: tune accuracy of Canadian NTv1 file w.r.t NTv2
2019-12-25T15:23:31+00:00

Even Rouault
even.rouault@spatialys.com

2019-12-25T15:23:31+00:00

b8f8a708c2299ba55b3d4754aa75633e3ee5897b

As on import of EPSG, we remove the supersession of Canadian NTv1 file w.r.t NTv2
(because the default behaviour of PROJ is to ignore superseded operations). However
the NTv1 operation is advertized with an accuracy of 1m, whereas NTv2 is advertized
with 1.5m. Consequently on areas where both files are valid, and if both files are
available, NTv1 would be selected. So as a workaround, worsen the NTv1 accuracy to
2m so that NTv2 is used in priority.





As on import of EPSG, we remove the supersession of Canadian NTv1 file w.r.t NTv2
(because the default behaviour of PROJ is to ignore superseded operations). However
the NTv1 operation is advertized with an accuracy of 1m, whereas NTv2 is advertized
with 1.5m. Consequently on areas where both files are valid, and if both files are
available, NTv1 would be selected. So as a workaround, worsen the NTv1 accuracy to
2m so that NTv2 is used in priority.