aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2020-10-28Update GSIGEO2011 grid alternative to latest PROJ-data7.2.0Juan Hernando
2020-10-24Database: move NZGD2000 deformation model from customizations.sql to new ↵Even Rouault
other_tranformation_custom.sql
2020-10-24Added transformation from JDG2011 geog 3D to JGD2011 height using GSIGEO2011Juan Hernando
2020-10-24Sort grid_alternatives.sql by agency alphabeticallyJuan Hernando
2020-10-23Database: add Finland tinshift operationsEven Rouault
2020-10-23Database: add interpolation_crs_auth_name and interpolation_crs_code columns ↵Even Rouault
to other_transformation table
2020-10-23Database: for clarity, put usage records after the object they are forEven Rouault
2020-10-23Database: import ESRI VERTCS that uses a (geodetic) datum to express ↵Even Rouault
ellipsoidal height
2020-10-11Database: add a frame_reference_epoch column in vertical_datum to be able to ↵Even Rouault
handle dynamic vertical datums, and instanciate them properly from database
2020-10-08Database: add aliases for 'old' names of WGS84 and ETRS89 datums, and remove ↵Even Rouault
one hack
2020-10-08Database: avoid importing duplicated alias namesEven Rouault
2020-10-08Database: import datum ensemble accuracy and members (but do not use them)Even Rouault
2020-10-06Database: add a reference_frame_epoch column to the geodetic_datum for ↵Even Rouault
dynamic datums, but not yet used
2020-10-06Database: "minimal" update to EPSG v10.003Even Rouault
Content mostly unchanged since v9.9 This update is "minimal" in that it mostly reflects the removal of the 'area' table, replaced now by 'extent', 'scope' and 'usage' Other new aspects of EPSG v10 are left aside.
2020-09-10Merge pull request #2351 from rouault/update_to_epsg_9_9Even Rouault
Database: update to EPSG 9.9
2020-09-09Database: update to EPSG 9.9Even Rouault
2020-09-08Database: add OGC:CRS27 and OGC:CRS83 CRS entries for NAD27 and NAD83 in ↵Even Rouault
longitude, latitude order
2020-08-05add Canary Islands geoid file in grid_alternatives.sqlJavier Jimenez Shaw
2020-08-02Database: update to EPSG v9.8.15 databasejmckenna
Co-authored-by: jmckenna <jmckenna@gatewaygeomatics.com> Co-authored-by: Javier Jimenez Shaw <j1@jimenezshaw.com> Co-authored-by: Even Rouault <even.rouault@spatialys.com>
2020-07-01Database: register Brazil' grids (refs ↵Even Rouault
https://github.com/OSGeo/PROJ-data/pull/39) (#2277)
2020-06-19Merge pull request #2267 from rouault/update_to_epsg_9_8_12Even Rouault
Database: update to EPSG v9.8.12
2020-06-19Database: update to EPSG v9.8.12Even Rouault
2020-06-18Merge pull request #2250 from and-marsh/pr-add-main-uk-geoidEven Rouault
Database: register geoid file for UK added in OSGeo/PROJ-data#25
2020-06-16Merge pull request #2248 from rouault/database_nzgd2000_defmodelEven Rouault
Database: register NZGD2000 -> ITRF96 transformation for NZGD2000 database
2020-06-12add transformation for es_ign_egm08-rednap.tifJavier Jimenez Shaw
2020-06-11Database: register Spanish SPED2ETV2 grid for ED50->ETRS89Even Rouault
Refs https://github.com/OSGeo/PROJ-data/pull/31
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.
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-26 06:34:48 +0000