aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2021-05-17Merge pull request #2723 from rouault/grid_alternatives_AGQG_20201120Even Rouault
grid_alternatives.sql: reference AGQG_20201120.gsb
2021-05-16Database: map ESRI spain/peninsula and spain/baleares gridsEven Rouault
2021-05-16grid_alternatives.sql: reference AGQG_20201120.gsb (cf OSGeo/PROJ-data#63)Even Rouault
2021-05-16Database: update to EPSG v10.022Even Rouault
2021-05-11Update metadataNyall Dawson
2021-05-10Update ESRI projection db to 12.8Nyall Dawson
2021-04-23Remove useless file data/sql/method_triggers.sqlEven Rouault
2021-04-23Database: update to EPSG v10.019Even Rouault
Non-trivial updates: - some vertical CRS are now encoded as DerivedVerticalCRS. e.g EPSG:8228 "NAVD88 height (ft)", with base EPSG:5703 "NAVD88 height". As we don't have support in our PROJ db model for DerivedVerticalCRS, modify the import script to 'resolve' the derivation up to the original datum. - Method EPSG:1069 'Change of Vertical Unit' is no longer used. It is replaced by a generic-purpose EPSG:1104 method that doesn't take any conversion factor. And generic conversions EPSG:7812 and EPSG:7813 are now used in concatenated operations, which require code changes as well.
2021-04-08Merge pull request #2647 from rouault/integer_or_textEven Rouault
Database: decrease db size
2021-04-07Database: more thorough consistency checks on extent of coordinate operationsEven Rouault
2021-04-06Database: nullify auth_name, code of usage tableEven Rouault
We never select by those columns, so don't set them. Reduce from 8.4 to 7.9 MB. Upgrade the minor version of the database layout. (that database can still be read by PROJ 8.0)
2021-04-06Database: more consistency checks on helmert_transformation and ↵Even Rouault
grid_transformation
2021-04-06Database: do not create Helmert transformations in IGNF between CRS of ↵Even Rouault
different nature, and also adjust the method code/name to the nature of the CRS
2021-04-06Database: minor refresh of ignf.sql and import script with new locations of ↵Even Rouault
resources
2021-04-06Merge pull request #2646 from rouault/db_proj_versionEven Rouault
Database: add a PROJ.VERSION metadata entry
2021-04-04Database: decrease db size by using a INTEGER_OR_TEXT data type on codesEven Rouault
Most codes (especially *all* in EPSG) are integers. As integers are stored as variable-length in the db, it is preferable to store them as such when possible. So use a special INTEGER_OR_TEXT data type. This is a "non-standard" type declaration, but this is perfectly legal as SQLite is loosely typed. As this declaration contains the string INT, it is assigned INTEGER affinity. Which means that values provided either as text (that contains integer value) or integer will be stored as integers, whereas text values will be stored as text. See paragraph 3 and 3.1 of https://www.sqlite.org/datatype3.html. The "INTEGER_OR_TEXT" name is a hint for the user, and software like GDAL (>= 3.3) to expose the column as string... The effect of using this rather than TEXT is making the DB size go from 9 MB to 8.4. There is no need to change the DATABASE.LAYOUT version numbering as this is completely forward and backward compatible.
2021-04-04Database: add missing column type specifir for method_name in ↵Even Rouault
grid_transformation and other_transformation. No practical impact
2021-04-04Database: add a PROJ.VERSION metadata entryEven Rouault
2021-04-02Database: update to EPSG v10.018Even Rouault
Just fixes 4 wrong transformations of v10.017
2021-04-01Database: stronger checks on extent of grid_transformation regarding the ↵Even Rouault
extent of the source and target CRS
2021-04-01Database: add extra check for 'Vertical Offset by Grid Interpolation' ↵Even Rouault
transformations
2021-04-01Database: refine checks for 'Geog3D to Geog2D+XXX' transformations, and ↵Even Rouault
create less synthetic 'Geographic3D to GravityRelatedHeight' synthetic transformations
2021-04-01Database: update to EPSG 10.017Even Rouault
2021-03-27Add mapping of ESRI Equal_Area projection method to EPSG (fixes #2610)Even Rouault
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