aboutsummaryrefslogtreecommitdiff
path: root/data/sql/commit.sql
AgeCommit message (Collapse)Author
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-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-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-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-02-19Update to EPSG v10.015Nyall Dawson
2021-02-11Database: update to EPSG v10.014Even Rouault
2021-02-09Database: update to EPSG v10.013Even Rouault
2020-10-08Database: add aliases for 'old' names of WGS84 and ETRS89 datums, and remove ↵Even Rouault
one hack
2020-10-08Database: import datum ensemble accuracy and members (but do not use them)Even Rouault
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-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-03-30Database: fix registration of custom entries of ↵Even Rouault
grid_transformation_custom.sql for geoid grids (fixes #2112)
2020-02-26Database: update to EPSG v9.8.7Even Rouault
2020-01-30Database: add a custom concatenated_operation for NTF (Paris) to RGF93, ↵Even Rouault
using the non-deprecated EPSG:9327 for the geocentric translation
2020-01-25Implement RFC 5Even Rouault
2020-01-22Database: update to EPSG v9.8.6Even Rouault
Fixes #1867
2019-12-21Database: add consistency checks of transformation area of use w.r.t ↵Even Rouault
source/target CRS one
2019-12-21Database: add/fix consistency checksEven Rouault
2019-12-21Database: fix registration of Icegeoid_xxx.gtx files, and add corresponding ↵Even Rouault
entries in grid_alternatives.sql
2019-12-11Make EPSG:102100 resolve to ESRI:102100 (fixes #1730)Even Rouault
2019-12-02Database: register the BWTA2017.gsb grid (DHDN->ETRS89 for Baden-Wurtemberg)Even Rouault
Relates to https://github.com/OSGeo/proj-datumgrid/pull/65 , https://github.com/OSGeo/proj-datumgrid/issues/22 As EPSG has no entry for it, we create a grid_transformation, as well as a dedicated area of use based on the extent of the grid, under the PROJ authority. With the hope to be able to remove it once EPSG has an entry...
2019-11-02Add a geoid_model name in database, use GEOIDMODEL for transformations, add ↵Even Rouault
a proj_create_vertical_crs_ex()
2019-04-22Database: make conversion & helmert_transformation updatable viewsEven Rouault
- Transform conversion as a view, and when inserting into it, actually insert into 3 tables: conversion_table, conversion_method and conversion_param, so that method and parameter names are not repeated each time. - Similarly for helmert_tranformation, insert into helmert_transformation_tabl and coordinate_operation_method. This reduces the db size from 6 344 704 bytes to 5 853 184 bytes, without significant slowdown for queries.
2018-12-07Various speed optimizationsEven Rouault
2018-11-14Implement RFC 2: Initial integration of "GDAL SRS barn" workEven Rouault
This work mostly consists of: - a C++ implementation of the ISO-19111:2018 / OGC Topic 2 "Referencing by coordinates" classes to represent Datums, Coordinate systems, CRSs (Coordinate Reference Systems) and Coordinate Operations. - methods to convert between this C++ modeling and WKT1, WKT2 and PROJ string representations of those objects - management and query of a SQLite3 database of CRS and Coordinate Operation definition - a C API binding part of those capabilities This is all-in-one squashed commit of the work of https://github.com/OSGeo/proj.4/pull/1040
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-16 13:31:59 +0000