aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2021-12-07Merge pull request #2973 from rouault/epsg_10_041Even Rouault
Database: update to EPSG v10.041
2021-11-05Merge pull request #2921 from rouault/epsg_10_039Even Rouault
Database: update to EPSG v10.039
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
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
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-31 02:26:06 +0000