aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2020-06-06Database: make sure we can deal with 'Geog3D to Geog2D+GravityRelatedHeight' ↵Even Rouault
records as we do with the more common 'Geographic3D to GravityRelatedHeight'
2020-06-06Database: register sk_gku_Slovakia_ETRS89h_to_Baltic1957.tif and ↵Even Rouault
sk_gku_Slovakia_ETRS89h_to_EVRF2007.tif geoids Related to https://github.com/OSGeo/PROJ-data/pull/29
2020-06-03customizations.sql: add entry for OSGM15 geoid_modelAndrei Marshalov
2020-06-02Database: register geoid file for UK added in OSGeo/PROJ-data#25Andrei Marshalov
2020-05-30Database: add concatenated operations for NZGD2000 -> ITRF97/2000/2005/2008/2014Even Rouault
2020-05-30Database: register NZGD2000 -> ITRF96 transformation for NZGD2000 databaseEven Rouault
Related to https://github.com/OSGeo/PROJ-data/pull/22 An entry is added in the ``other_transformation`` table, using a raw PROJ string. Later, once the deformation model has been registered in EPSG, we'll have to add code to map the EPSG transformation method and parameters to +proj=defmodel In the meantime, this works pretty well: ``` $ src/projinfo -s EPSG:4959 -t EPSG:7907 Candidate operations found: 1 ------------------------------------- Operation No. 1: PROJ:NZGD2000-20180701, NZGD2000 to ITRF96 deformation model, unknown accuracy, New Zealand PROJ string: +proj=pipeline +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=axisswap +order=2,1 +step +proj=defmodel +model=nz_linz_nzgd2000-20180701.json +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=rad +xy_out=deg WKT2:2019 string: COORDINATEOPERATION["NZGD2000 to ITRF96 deformation model", VERSION["20180701"], SOURCECRS[ GEOGCRS["NZGD2000", DATUM["New Zealand Geodetic Datum 2000", ELLIPSOID["GRS 1980",6378137,298.257222101, LENGTHUNIT["metre",1]]], PRIMEM["Greenwich",0, ANGLEUNIT["degree",0.0174532925199433]], CS[ellipsoidal,3], AXIS["geodetic latitude (Lat)",north, ORDER[1], ANGLEUNIT["degree",0.0174532925199433]], AXIS["geodetic longitude (Lon)",east, ORDER[2], ANGLEUNIT["degree",0.0174532925199433]], AXIS["ellipsoidal height (h)",up, ORDER[3], LENGTHUNIT["metre",1]], ID["EPSG",4959]]], TARGETCRS[ GEOGCRS["ITRF96", DATUM["International Terrestrial Reference Frame 1996", ELLIPSOID["GRS 1980",6378137,298.257222101, LENGTHUNIT["metre",1]]], PRIMEM["Greenwich",0, ANGLEUNIT["degree",0.0174532925199433]], CS[ellipsoidal,3], AXIS["geodetic latitude (Lat)",north, ORDER[1], ANGLEUNIT["degree",0.0174532925199433]], AXIS["geodetic longitude (Lon)",east, ORDER[2], ANGLEUNIT["degree",0.0174532925199433]], AXIS["ellipsoidal height (h)",up, ORDER[3], LENGTHUNIT["metre",1]], ID["EPSG",7907]]], METHOD["PROJ-based operation method: +proj=pipeline +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=axisswap +order=2,1 +step +proj=defmodel +model=nz_linz_nzgd2000-20180701.json +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=rad +xy_out=deg"], USAGE[ SCOPE["unknown"], AREA["New Zealand"], BBOX[-55.95,160.6,-25.88,-171.2]], ID["PROJ","NZGD2000-20180701"], REMARK["New Zealand Deformation Model. Defines the secular model (National Deformation Model) and patches for significant deformation events since 2000"]] ``` ``` $ echo "-41 173 0 2016.5" | PROJ_NETWORK=ON src/cct -d 8 +proj=pipeline +step +proj=unitconvert +xy_in=deg +xy_out=rad +step +proj=axisswap +order=2,1 +step +proj=defmodel +model=nz_linz_nzgd2000-20180701.json +step +proj=axisswap +order=2,1 +step +proj=unitconvert +xy_in=rad +xy_out=deg -40.99999402 172.99999938 0.00130333 2016.5000 ``` ``` $ echo "-41 173 0 2016.5" | PROJ_NETWORK=ON src/cs2cs -f "%.8f" EPSG:4959 EPSG:7907 -40.99999402 172.99999938 0.00130333 2016.5 ```
2020-05-25Database: add entry for Ranc08_Circe.mnt grid (New Caledonia)Even Rouault
This geoid was added in EPSG 9.8.11 and has been added in PROJ-data per https://github.com/OSGeo/PROJ-data/pull/21
2020-05-24Database: import scope and remarks for conversion (fixes #2237)Even Rouault
2020-05-24Database: update ESRI content to ArcMap 10.8.1Even Rouault
2020-05-24Database: update to EPSG v9.8.11Even Rouault
2020-05-24Database: add a same_source_target_crs column to supersession tableEven Rouault
This is in preparation for EPSG 9.8.11 import that supersedes a number of grid transformation for US transformations, but the superseded and replacement transformations don't operate on the same (source_crs, target_crs), which is a bit weird. So in that situation, ignores the supersession.
2020-05-15Database: add index on alias_name(code)Even Rouault
2020-05-14Database: add a 'WGS84' alias for the EPSG:4326 CRS (fixes #2216)Even Rouault
2020-04-26Database: map more ESRI grid namesEven Rouault
2020-04-07Database: update to EPSG v9.8.9Even Rouault
2020-03-30Database: fix registration of custom entries of ↵Even Rouault
grid_transformation_custom.sql for geoid grids (fixes #2112)
2020-03-27Add entries in grid_alternatives for Portugal grids coming from ESRI entries ↵Pedro Venancio
(#2102) Fixes #2096
2020-03-26Use jtsk03-jtsk horizontal grid from CDNMartin Dobias
2020-03-12Add proj_get_units_from_database() (fixes #2004)Even Rouault
2020-03-12Database: register grids for New Caledonia added per ↵Even Rouault
https://github.com/OSGeo/PROJ-data/pull/16
2020-02-26Database: register 4 height Austrian grids from ↵Even Rouault
https://github.com/OSGeo/PROJ-data/pull/13 + handle 'Vertical Offset by Grid Interpolation (BEV AT)' method
2020-02-26Database: update to EPSG v9.8.7Even Rouault
2020-02-23Add alternative grid for JTSK - JTSK03 transform (EPSG:8364)Martin Dobias
The definition of EPSG:8364 uses NADCON method for horizontal grid (.las/.los files) but this format is not supported by PROJ. UGKK (Slovak Geodetic and Cartographic Institute) provides NADCON .las/.los files here: https://www.geoportal.sk/files/gz/slovakia_jtsk03_to_jtsk.zip Additionally UGKK also provides the same grid file in NTv2 format: https://www.geoportal.sk/files/gz/slovakia_jtsk03_to_jtsk_ntv2.zip So let's add the NTv2 file the grid_alternatives table so that PROJ can automatically pick it up...
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
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-31 20:03:46 +0000