aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
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.
2019-11-12Database: update to EPSG v9.8.4Even Rouault
2019-11-02Database: add mapping between EPSG geoid and PROJ grid names for GEOID99, ↵Even Rouault
03, 06, 09 and 18. Related to https://github.com/OSGeo/proj-datumgrid/pull/60 that add those grids in proj-datumgrid-north-america
2019-11-02Add a geoid_model name in database, use GEOIDMODEL for transformations, add ↵Even Rouault
a proj_create_vertical_crs_ex()
2019-10-30Rework importing of Vertical unit change from EPSG db, add support for ↵Even Rouault
Height Depth Reversal and use it in createOperations()
2019-10-27Database: add an auxiliary concatenated_operation_step table to allow ↵Even Rouault
arbitrary number of steps (fixes #1632) EPSG:9103 (NAD27 to ITRF2014 (1)) is now handled. Note:EPSG:9104 (NAD27 to ITRF2014 (2)) is not currently, since it uses for step EPSG:8861 (NAD83(HARN) to NAD83(FBN) (1)) an unsupported transformation method (NADCON5 (3D), EPSG:1075).
2019-10-15grid_alternatives.sql: link EPSG grid names to PROJ ones for the the 2 ↵Even Rouault
'RGSPM06 to Danger 1950 height' grids
2019-10-15Database: update to EPSG v9.8.3Even Rouault
Note: a hack has been added into customizations.sql to cancel deprecatation of USA geoid2012 grids by geoid2018 grids, as the later are not yet available in proj-datumgrid-northamerica (https://github.com/OSGeo/proj-datumgrid/issues/55)
2019-09-23Database: update to EPSG 9.8.2Even Rouault
With limitation of https://github.com/OSGeo/PROJ/issues/1632 regarding concatenated operations with more than 3 steps.
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-27 21:49:57 +0000