aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2020-02-05Fix performance issue, affecting projinfo EPSG:7842Even Rouault
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.
2020-01-30Database: add a custom concatenated_operation for NTF (Paris) to RGF93, ↵Even Rouault
using the non-deprecated EPSG:9327 for the geocentric translation
2020-01-29Add EPSG records for 'Geocentric translation by Grid Interpolation (IGN)' ↵Even Rouault
(gr3df97a.txt) and map them to new +proj=xyzgridshift
2020-01-29Make it possible to use grids from the CDN by their 'old name' even if not ↵Even Rouault
in the EPSG/grid_transformation table
2020-01-25Implement RFC 5Even Rouault
2020-01-24Add nlgeo2018.gtx & rdtrans2018.gsb to grid_alternatives.Bas Couwenberg
* EPSG:9282 uses rdtrans2018.gsb * EPSG:9283 uses nlgeo2018.gtx
2020-01-23Database: add a geoid_like value for proj_method column of ↵Even Rouault
grid_alternatives, fix related entries and simplify/robustify logic to deal with EPSG 'Geographic3D to GravityRelatedHeight' methods
2020-01-22Database: update to EPSG v9.8.6Even Rouault
Fixes #1867
2020-01-07Database: insert PROJ.4 +datum values in alias_name table under PROJ authorityEven Rouault
2020-01-07Database: fill alias_name with EPSG aliases for CRSEven Rouault
2019-12-28Database: add mapping for TOR27CSv1.GSBEven Rouault
2019-12-28Database: add mapping for gg10_smv2.mnt and gg10_sbv2.mnt French gridsEven Rouault
2019-12-25Database: tune accuracy of Canadian NTv1 file w.r.t NTv2Even Rouault
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.
2019-12-21proj_db_table_defs.sql: rewrite some trigger checks as normal table ↵Even Rouault
CONSTRAINT CHECK
2019-12-21Database: add consistency checks of transformation area of use w.r.t ↵Even Rouault
source/target CRS one
2019-12-21Database: add/fix consistency checksEven Rouault
2019-12-21Database: fix registration of Icegeoid_xxx.gtx files, and add corresponding ↵Even Rouault
entries in grid_alternatives.sql
2019-12-20Database: add name mappings for na27na83.gsb and cq77na83.gsb; also fix the ↵Even Rouault
mapping between CGQ77-98.gsb and CQ77SCRS.GSB
2019-12-20Adding New Zealand grid alternative namesChris Crook
2019-12-18Database: register MAY76V20.gsbEven Rouault
2019-12-17Database: register Canadian geoid models added per ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/91 (#1796)
2019-12-17Database: register SeTa2016.gsb for DHDN to ETRS89 in Saarland (refs ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/89) (#1791)
2019-12-17Merge pull request #1789 from rouault/register_100800401_gsbEven Rouault
Database: register 100800401.gsb for Catalonia ED50 -> ETRS89
2019-12-16Merge pull request #1775 from ↵Kristian Evers
rouault/grid_alternatives_use_precision_package_versions grid_alernatives.sql: point to specific revisions of the proj-datumgrid-XXXX packages
2019-12-16Merge pull request #1786 from rouault/fake_EPSG_102100Kristian Evers
Make EPSG:102100 resolve to ESRI:102100 (fixes #1730)
2019-12-16Merge pull request #1763 from dalia2/update-grid-alternatives.sql-for-IcealndKristian Evers
Update grid_alternatives.sql for Icelandic grids
2019-12-14Database: add mappings to AUSGeoid98.gtx in grid_alternativesEven Rouault
2019-12-12Merge branch 'master' into update-grid-alternatives.sql-for-Icealnddalia2
2019-12-11Make EPSG:102100 resolve to ESRI:102100 (fixes #1730)Even Rouault
2019-12-11Database: register 100800401.gsb for Catalonia ED50 -> ETRS89Even Rouault
Refs https://github.com/OSGeo/proj-datumgrid/pull/88
2019-12-10Database: update to IGNF v3.1.0Even Rouault
2019-12-06grid_alernatives.sql: point to specific revisions of the proj-datumgrid-XXXX ↵Even Rouault
packages Due to potential future shift to GTiff format, we don't want users of PROJ 6.3 being pointed to grids they won't be able to use. So point to - proj-datumgrid-1.8: already existing, unlikely to change before 6.3 - proj-datumgrid-north-america-1.3: to be released - proj-datumgrid-europe-1.5: to be released - proj-datumgrid-oceania-1.1: to be released - proj-datumgrid-world-1.0: already existing, unlikely to change before 6.3
2019-12-03Database: register NTv2_SN.gsb added per ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/73
2019-12-03Database: register AT_GIS_GRID.gsb added per ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/72
2019-12-03Database: register AUSGeoid09 and AUSGeoid2020Even Rouault
Related to https://github.com/OSGeo/proj-datumgrid/pull/66 Tune operation search so that it can work with Geog2D <--> VertCS for commandline niceness
2019-12-03Merge pull request #1759 from rouault/BWTA2017Even Rouault
Database: register the BWTA2017.gsb grid (DHDN->ETRS89 for Baden-Wurtemberg)
2019-12-02Database: register the BWTA2017.gsb grid (DHDN->ETRS89 for Baden-Wurtemberg)Even Rouault
Relates to https://github.com/OSGeo/proj-datumgrid/pull/65 , https://github.com/OSGeo/proj-datumgrid/issues/22 As EPSG has no entry for it, we create a grid_transformation, as well as a dedicated area of use based on the extent of the grid, under the PROJ authority. With the hope to be able to remove it once EPSG has an entry...
2019-12-02Update grid_transformation_custom.sqldalia2
2019-12-01Update data/sql/grid_alternatives.sqldalia2
Co-Authored-By: Even Rouault <even.rouault@spatialys.com>
2019-12-01Update data/sql/grid_alternatives.sqldalia2
Co-Authored-By: Even Rouault <even.rouault@spatialys.com>
2019-12-01Update grid_alternatives.sqldalia2
Updated the grid_alternatives.sql
2019-12-01Database: update ESRI entries with ArcGIS Desktop version 10.8.0 databaseEven Rouault
2019-11-25Merge pull request #1739 from rouault/register_canadian_hshiftgridsEven Rouault
Database: register Canadian provincial horizontal shift grids
2019-11-25Merge pull request #1740 from rouault/missing_australian_gridsEven Rouault
Database: reference GDA94_GDA2020_conformal_christmas_island.gsb and …
2019-11-23Database: add missing name mappings for a few French overseas vertical gridsEven Rouault
2019-11-23Database: reference GDA94_GDA2020_conformal_christmas_island.gsb and ↵Even Rouault
GDA94_GDA2020_conformal_christmas_island.gsb Related to https://github.com/OSGeo/proj-datumgrid/pull/62
2019-11-23Database: add missing mapping for 3 GEOID2009 grids that we have now in ↵Even Rouault
proj-datumgrid
2019-11-23Database: register Canadian provincial horizontal shift gridsEven Rouault
Counterpart of https://github.com/OSGeo/proj-datumgrid/pull/61 Fixes #202
2019-11-18Database: add a publication_date column to geodetic_datum and vertical_datumEven Rouault
Populated from realization_epoch column from EPSG The 'publication_date' naming is from OGC Topic 2, and hasn't been yet adopted by the EPSG dataset. See http://docs.opengeospatial.org/as/18-005r4/18-005r4.html , Annex G, clause 11 and https://32zn56499nov99m251h4e9t8-wpengine.netdna-ssl.com/wp-content/uploads/2019/09/EPSG-relational-data-model-changes_2019-09-18.pdf
2019-11-17createOperations(): remove the concept of geodetic_datum_preferred_hubEven Rouault
This was introduced in 63857c92b271bbcd10df0a032304982011acb2a9. Due to the fix done in the previous commit, we can mostly revert the above commit. We just keep the added tests and the custom WGS 84<-->WGS 84 (Gxxxx) null transformations.
generated by cgit v1.2.3 (git 2.25.1) at 2026-01-05 06:52:39 +0000