PROJ/data/sql, branch azp Forked from https://github.com/OSGeo/PROJ Database: register 4 height Austrian grids from https://github.com/OSGeo/PROJ-data/pull/13 + handle 'Vertical Offset by Grid Interpolation (BEV AT)' method 2020-02-26T15:23:39+00:00 Even Rouault even.rouault@spatialys.com 2020-02-26T15:23:39+00:00 250e4a222bb267b33d9404ae31a1d09a0e4e16d3 






Database: update to EPSG v9.8.7
2020-02-26T13:04:09+00:00

Even Rouault
even.rouault@spatialys.com

2020-02-25T22:17:48+00:00

1f8541d6f43f7fde949772e0a2174e317542b985












Add alternative grid for JTSK - JTSK03 transform (EPSG:8364)
2020-02-23T20:46:47+00:00

Martin Dobias
wonder.sk@gmail.com

2020-02-23T20:46:47+00:00

845f700335fb31318acf831bc42d62a230478eae

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-05T17:54:04+00:00

Even Rouault
even.rouault@spatialys.com

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

aa2545bebddec14caf4bae8e7615dbb880613faa

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 custom concatenated_operation for NTF (Paris) to RGF93, using the non-deprecated EPSG:9327 for the geocentric translation
2020-01-30T13:14:12+00:00

Even Rouault
even.rouault@spatialys.com

2020-01-30T13:14:12+00:00

a1b1c4312e1270b2f5dcb44e2ba2727711cbb80f












Add EPSG records for 'Geocentric translation by Grid Interpolation (IGN)' (gr3df97a.txt) and map them to new +proj=xyzgridshift
2020-01-29T15:28:07+00:00

Even Rouault
even.rouault@spatialys.com

2020-01-29T15:28:07+00:00

6f6c53c8553541690a16775ab2c92f7703196e59












Make it possible to use grids from the CDN by their 'old name' even if not in the EPSG/grid_transformation table
2020-01-29T13:44:04+00:00

Even Rouault
even.rouault@spatialys.com

2020-01-29T13:44:04+00:00

9f6ab28f1d26561a547802a18b3a2f7877834ca8












Implement RFC 5
2020-01-25T01:23:18+00:00

Even Rouault
even.rouault@spatialys.com

2020-01-25T01:23:18+00:00

680d1eb93bfd0ffa274da2a28dc7fce704a059b9












Add nlgeo2018.gtx & rdtrans2018.gsb to grid_alternatives.
2020-01-24T13:01:19+00:00

Bas Couwenberg
sebastic@xs4all.nl

2020-01-24T13:01:15+00:00

223572d0a809ae504930279c190db13ca93a53e7

 * EPSG:9282 uses rdtrans2018.gsb
 * EPSG:9283 uses nlgeo2018.gtx





 * EPSG:9282 uses rdtrans2018.gsb
 * EPSG:9283 uses nlgeo2018.gtx







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-23T12:08:23+00:00

Even Rouault
even.rouault@spatialys.com

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

00dd98457af1f32e7bb2b9677f6319f72fcfacf9