aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2021-03-26Build: simplify proj.db generation (#2605)Even Rouault
- change foreign key check, so that it is enabled outside of the transaction where we insert things, and can make the sqlite3 process fail in case of violations, without the postcheck done in the autoconf build - autoconf and cmake builds: simplification related to the above (which also means that cmake builds now have the fkey check, which was omitted until now)
2021-03-25Database: add grid alternatives and transformation custom for ↵Javier Jimenez Shaw
ch_swisstopo_chgeo2004_ETRS89_LHN95 and ch_swisstopo_chgeo2004_ETRS89_LN02 (#2584)
2021-03-23Incorrect EPGS extent code for EPSG:7789>EPSG:4976 transformationSveinung Himle
2021-03-19Database: relax trigger check when inserting a conversion to accept any ↵Even Rouault
conversion method in the PROJ namespace Helps for example to use CRS definitions using the non-EPSG codified Sinusoidal method.
2021-03-15Add C/C++ API to get SQL statements to insert a CRS into databaseEven Rouault
2021-03-11Database: fix NKG transformationsEven Rouault
2021-03-11Database: Additions to the norwegian NKG2020 transformation (#2548)Sveinung Himle
* Correction grid NKG:ETRF14 to EPSG:7922 * Added NKG:ITRF_TO_NO GIE test * Correction grid no_kv_NKGETRF14_EPSG7922_2000 added to grid_alternatives.sql * proj_method 'velocity_grid' added in check_grid_alternatives_proj_method. NKG velocity grid added to grid_alternatives.sql Co-authored-by: Even Rouault <even.rouault@spatialys.com>
2021-03-10Database: add NGO48 (EPSG:4273) to ETRS89 (EPSG:4258) triangulation-based ↵Sveinung Himle
transformation (#2554)
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