aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
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
2018-12-06Take into account supersession information to filter out irrelevant ↵Even Rouault
transformations
2018-12-04Database: fix ingestion from ESRI of alias names for deprecated objectsEven Rouault
2018-12-04Improve recognition of WKT1 datum namesEven Rouault
2018-11-29Redirect epsg:XXXX and IGNF:XXXX CRS expansions to the database, and remove ↵Even Rouault
the data/epsg and data/IGNF files
2018-11-20Database: use official IGNF.xml registry to create content from the IGNF ↵Even Rouault
authority Up to now, we re-processed the data/IGNF PROJ.4 definition to ingest it into proj.db, but this file originally come from a processing of IGNF.xml ( http://librairies.ign.fr/geoportail/resources/IGNF.xml ) The end result is not strictly equivalent, as data/IGNF has some 'magic' to create towgs84 / nadgrids, since IGNF.xml doesn't necessary contain all transformations from its geodetic systems to WGS84. I've tried to re-add some of those missing transforms (null Helmert transforms), so it can be used for pivoting, but that might be incomplete.
2018-11-20Add grid alternatives for French vertical grids added per ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/40
2018-11-19Database: add mapping to GEOID12B height models added per ↵Even Rouault
https://github.com/OSGeo/proj-datumgrid/pull/39
2018-11-14Implement RFC 2: Initial integration of "GDAL SRS barn" workEven Rouault
This work mostly consists of: - a C++ implementation of the ISO-19111:2018 / OGC Topic 2 "Referencing by coordinates" classes to represent Datums, Coordinate systems, CRSs (Coordinate Reference Systems) and Coordinate Operations. - methods to convert between this C++ modeling and WKT1, WKT2 and PROJ string representations of those objects - management and query of a SQLite3 database of CRS and Coordinate Operation definition - a C API binding part of those capabilities This is all-in-one squashed commit of the work of https://github.com/OSGeo/proj.4/pull/1040
generated by cgit v1.2.3 (git 2.25.1) at 2026-01-08 04:28:32 +0000