aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2021-02-19Update to EPSG v10.015Nyall Dawson
2021-02-11Database: update to EPSG v10.014Even Rouault
2021-02-10Update ESRI projection db to 12.7 (10.8.1/2.6)Nyall Dawson
2021-02-09Database: update to EPSG v10.013Even Rouault
2021-02-09Database: update to EPSG v10.012Nyall Dawson
2021-02-08Merge pull request #2513 from jjimenezshaw/ahd-tasmaniaEven Rouault
Better grid_alternatives entries to include 'GDA94 to AHD (Tasmania) height' using 'au_ga_AUSGeoid98.tif'
2021-02-03change grid_alternatives entries to include 'GDA94 to AHD (Tasmania) height'Javier Jimenez Shaw
2021-01-15Database: update to EPSG v10.011Modern Slave
2021-01-06Database: add Norwegian height transformations grids to grid_alternatives ↵Sveinung Himle
table (#2359)
2020-12-21Implementing the NKG transformations in proj.dbKristian Evers
This adds the NKG 2008 and 2020 transformations to proj.db. The NKG transformations offers transformations between global reference frames and the national realisations of ETRS89 in Denmark, Estonia, Finland, Latvia, Lithuania, Norway and Sweden. The 2008 transformations are already implemented in the NKG 2008 file but will now be more accessible with the modern API. The 2020 transformations are new to PROJ and offers and updated version of the 2008 transformations using a new and improved deformation model (eu_nkg_nkgrf17vel.tif). A 2020 version of the NKG transformations are currently not available for Norway but will in all likelyhood be included at a later point in time.
2020-12-18Database: register AGQG_20191107.gsb grid. Related to ↵Even Rouault
https://github.com/OSGeo/PROJ-data/pull/53
2020-12-16Database: update to EPSG v10.008Even Rouault
2020-12-04Database: fix building proj.db with SQLite built with -DSQLITE_DQS=0Even Rouault
That is the option to make SQLite reject misuses of double quotes instead of single quotes. Most SQLite builds are forgiving, but some forks proposing a CMake build system default to SQLITE_DQS=0
2020-11-30Database: add metadata with the version number of the database layout and ↵Even Rouault
check it in the code This is aimed at detecting running a PROJ version against a proj.db that is not meant to work with it. This happens sometimes in complex setups mixing PROJ versions. Hopefully this will help spotting the issue earlier.
2020-11-22Database ESRI: map 2 grids in grid_alternativesEven Rouault
2020-11-18Database: update to EPSG v10.007Even Rouault
2020-10-28Update GSIGEO2011 grid alternative to latest PROJ-dataJuan 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-31 09:31:02 +0000