aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
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
2019-03-25Database: add operation_version column to coordinate operation tablesEven Rouault
2019-03-25Database: update to IGNF v3.0.3Even Rouault
2019-03-25Database: update to EPSG v9.6.1Even Rouault
2019-03-22Port custom ellipsoid definitions from QGIS (#1337)Nyall Dawson
2019-03-18Database: fix import of deprecated ellipsoid and geodetic_datum from ESRI ↵Even Rouault
database
2019-02-22proj.db: update to EPSG 9.6.0Even Rouault
Minor update w.r.t 9.5.5 that adds a few new coordinate operations.
2019-02-22proj.db: tune so that 'NGF IGN69 height to RGF93' uses the RAF09.gtx gridEven Rouault
2019-02-21proj.db: fix direction of USA GEOID12B grid alternativesEven Rouault
2019-02-21proj.db: add grid_alternative entries for OSGM15_Malin and OSGM15_BelfastEven Rouault
2019-02-21proj.db: add custom entry for 'FVR09 height to ETRS89'Even Rouault
2019-02-21proj.db: add entries in grid_alternatives table for Oceania gridsEven Rouault
2019-02-21proj.db: add custom entry for 'RH2000 height to SWEREF99'Even Rouault
2019-02-20Add VERTCON grid name alternatives in database, and handle filename ↵Even Rouault
substitution for VERTCON method
2019-01-21Update to EPSG 9.5.5Even Rouault
2018-12-07Various speed optimizationsEven Rouault
2018-12-06Add API to retrieve non-deprecated equivalent of an objectEven Rouault
2018-12-06Coordinate operation search: add a authority_to_authority_preference table ↵Even Rouault
to restrict and prioritize searches
generated by cgit v1.2.3 (git 2.25.1) at 2026-01-02 04:25:35 +0000