aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
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.
2019-09-12Coordinate transformation: improve transformations from/to WGS84 (Gxxxx)Even Rouault
Currently very few transformations from/to WGS84 (Gxxxx) are registered in the EPSG database, and there isn't even transformations between WGS84 EPSG:4326 and those ones. Consequently transformations to those realizations often ended up as no-operation, whereas going through WGS84 EPSG:4326 will bring more meaningful results. So register those EPSG:4326<-->WGS 84 (Gxxx) null transformations, and when having WGS 84 (Gxxx) as source/target, consider EPSG:4326 as an intermediate. This change has no effect on the existing direct transformations from/to WGS 84 (Gxxx).
2019-09-01Update grid_alternatives.sql (#1571)Pedro Venancio
grid_alternatives.sql: Add DLX_ETRS89_geo.gsb and D73_ETRS89_geo.gsb grids in grid_alternatives (added in proj-datumgrid-europe package per https://github.com/OSGeo/proj-datumgrid/pull/54)
2019-07-25Database: update to EPSG 9.7.0Even Rouault
2019-06-30Database: import scope/remarks for coordinate operation and add C APIEven Rouault
- Import scope and remarks for coordinate operations of the EPSG dataset. Database size goes from 5.2 MB to 5.55 MB - Add proj_get_scope() and proj_get_remarks()
2019-06-25grid_alternatives.sql: add the two Swisstopo grids (refs ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/53)
2019-06-06createFromUserInput(): support OGC URN to create projectedCRS, for example ↵Even Rouault
to instanciate a projected 3D CRS
2019-05-25Database: update to EPSG v9.6.3Even Rouault
2019-05-18customizations.sql: remove the removal of the deprecation entry of RAF09 by ↵Even Rouault
RAF18
2019-05-08Database: update to EPSG 9.6.2Even Rouault
2019-05-08Database: add bd72lb72_etrs89lb08.gsb grid in grid_alternatives (added in ↵Even Rouault
proj-datumgrid-europe package per https://github.com/OSGeo/proj-datumgrid/pull/50)
2019-05-07Database: register URLs for naptrans2008.gtx and rdtrans2008.gsb (non-free) ↵Even Rouault
grids
2019-05-06createOperations(): for 'Amersfoort / RD New + NAP height' (EPSG:7415) to ↵Even Rouault
ETRS89 (EPSG:4937), make sure that the vgridshift is applied first (ie on Amersfoort datum) before the hgridshift
2019-04-22Database: add checks to verify consistency of deprecated flagEven Rouault
2019-04-22Database / ESRI: use EPSG ellipsoid when possibleEven Rouault
2019-04-22Database: use non-deprecated code for SWEREF99 for 'RH2000 height to ↵Even Rouault
SWEREF99' transformation
2019-04-22Database: import common projections from ESRI projected CRS in structured formEven Rouault
That is Transverse_Mercator/Gauss_Kruger, Lambert_Conformal_Conic and Hotine_Oblique_Mercator_Azimuth_Natural_Origin Decreases proj.db from 5 853 184 bytes to 5 189 632 bytes.
2019-04-22Database: make conversion & helmert_transformation updatable viewsEven Rouault
- Transform conversion as a view, and when inserting into it, actually insert into 3 tables: conversion_table, conversion_method and conversion_param, so that method and parameter names are not repeated each time. - Similarly for helmert_tranformation, insert into helmert_transformation_tabl and coordinate_operation_method. This reduces the db size from 6 344 704 bytes to 5 853 184 bytes, without significant slowdown for queries.
2019-03-25Database: add link from RAF18.tac to RAF18.gtxEven Rouault
2019-03-25Database: update ESRI to ArcMap 10.7.0Even Rouault
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-31 22:09:37 +0000