aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2022-01-08Database: update to EPSG 10.047Even Rouault
2022-01-04Database: update to EPSG 10.044Even Rouault
2021-12-06Database: update to EPSG v10.041Even Rouault
2021-11-25Update metadata.sql to PROJ-data version 1.9Alexander Nehrbass
2021-11-25Add vertical gird files for PL-geoid-2011, Polish geoid modelAlexander Nehrbass
2021-11-22Fix mapping of coordinate system codes for ft when ingesting ESRINyall Dawson
projection db
2021-11-16When matching conversions from ESRI db, keep searching if we findNyall Dawson
a deprecated conversion for a non-deprecated CRS
2021-11-16Force conversion of Unity units to Years for epochs in esri projection engine dbNyall Dawson
2021-11-16Update ESRI projection db using wkt2 definitionsNyall Dawson
2021-11-08Update ESRI Projection Engine db to version 12.9Nyall Dawson
2021-11-04Database: update to EPSG v10.039Even Rouault
2021-10-21Database: update to EPSG v10.038Even Rouault
2021-10-21Merge pull request #2906 from jjimenezshaw/za_cdngi_sageoid2010Even Rouault
Add grid alternative for SAGEOID2010, South African geoid model
2021-10-15Merge pull request #2889 from jjimenezshaw/mx_inegi_ggm10Even Rouault
Add transformations for GGM10, Mexican geoid model
2021-10-13add za_cdngi_sageoid2010.tif vertical grid file for SAGEOID2010.datJavier Jimenez Shaw
2021-10-08update metadata.sql to PROJ_DATA version 1.8Javier Jimenez Shaw
2021-10-08Set area of use compatible with grid fileJavier Jimenez Shaw
2021-10-07add GGM10 (Mexico to NAVD88) to geoid_model sql tableJavier Jimenez Shaw
2021-10-07add mx_inegi_ggm10.tif vertical grid file, with custom transformationJavier Jimenez Shaw
2021-10-07Database: update to EPSG v10.037Even Rouault
2021-09-28Add a mapping for versioned authorities, so that one can use IAU:xxxx or ↵Even Rouault
IAU_2015:xxxx transparently
2021-09-28Database: add IAU_2015 CRSEven Rouault
2021-09-28Database: add check for Orthographic conversionEven Rouault
2021-09-28Database: add some hand made entries earlyEven Rouault
2021-09-27Database: update to EPSG v10.036Even Rouault
2021-09-17Database: add a 'anchor' field to geodetic_datum and vertical_datum tablesEven Rouault
Update database layout version number to 1.2 consequently This new capability will be used by IAU planetary CRS (refs #2601)
2021-09-15Database: update to EPSG v10.035Even Rouault
This seriously impacts French CRS users with the introduction of new datums, geodetic CRS and projected CRS based on "RGF 93 v2" and "RGF 93 v2b", and the previous single "RGF 93" being renamed as "RGF 93 v1". To be noted too, the addition of a null transformation between NAD83(2011) and WGS 84, which impacts a number of tests in the test suite.
2021-08-28Database: update to EPSG v10.033Even Rouault
2021-07-08Database: update to EPSG v10.028Even Rouault
2021-06-19Database: update to EPSG v10.027Even Rouault
2021-06-10Database: update to EPSG v10.026Even Rouault
2021-05-27Database: update to EPSG v10.024Even Rouault
2021-05-24Database: decrease DB size by using WITHOUT ROWID tablesEven Rouault
None of our tables are indexed by a INTEGER PRIMARY KEY, but most of them are by a (auth_name, code) primary key. Consequently they can benefit from being created as WITHOUT ROWID tables (https://sqlite.org/withoutrowid.html), which avoids an index to be created on the rowid we don't use. WITHOUT ROWID is a feature added in SQLite 3.8.2, so as our baseline is 3.11, we can use it. This decreases the DB size from 7,749,632 to 7,229,440 bytes, without any measurable consequence on performance.
2021-05-23Database: add a ANALYZE step during proj.db creationEven Rouault
This will create the sqlite_stat* table (generally sqlite_stat1). This speeds up a bit the test suite. Runtime of ``make test_cpp_api-check`` goes from the range [14.0 s, 14.6 s] to [13.0s, 13.5s] on my machine.
2021-05-17projsync: make it filter out files not intended for the current versionEven Rouault
* Add a PROJ_DATA.VERSION in proj.db to indicate the target PROJ-data package version * Make projsync use that information and the version_added and version_removed properties added in https://github.com/OSGeo/PROJ-data/pull/67 to filter out files that are not relevant * Add --no-version-filtering and --verbose switches
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
generated by cgit v1.2.3 (git 2.25.1) at 2026-01-07 17:27:03 +0000