aboutsummaryrefslogtreecommitdiff
path: root/data/sql
AgeCommit message (Collapse)Author
2022-03-09Database: update to EPSG v10.055Even Rouault
2022-02-19Database: insert entries in the alias_name for ESRI transformations that ↵Even Rouault
match a EPSG entry Make it possible to query them by name. e.g. `projinfo "NAD_1927_To_WGS_1984_3"` will return EPSG:1172 transformation "NAD27 to WGS 84 (3)" Partially helps use case of https://lists.osgeo.org/pipermail/gdal-dev/2022-February/055480.html
2022-02-13Add Belgian geoid model hBG18 to grid alternativesAlexander Nehrbass
2022-02-13Database: update to EPSG v10.054Even Rouault
2022-01-27Merge pull request #3028 from rouault/epsg_10_051Even Rouault
Database: update to EPSG 10.051
2022-01-26Database: update to EPSG 10.051Even Rouault
2022-01-24[esri] Add special case when importing ESRI:102113Nyall Dawson
See https://github.com/OSGeo/PROJ/pull/2954#issuecomment-977771912 for rationale
2022-01-24Add some additional method mapping during ESRI db importNyall Dawson
2022-01-24Map ESRI Cassini method to EPSG:9806 during ESRI projection engine db ingestionNyall Dawson
2022-01-24Map ESRI Equidistant_Cylindrical method to EPSG:1029 during ESRI projection ↵Nyall Dawson
engine db ingestion
2022-01-24Map ESRI IGAC_Plano_Cartesiano method to EPSG:1052 during ESRI projection ↵Nyall Dawson
engine db ingestion
2022-01-24Map ESRI Albers method to EPSG:9822 during ESRI projection engine db ingestionNyall Dawson
2022-01-21Database: update to EPSG 10.048Even Rouault
Ultra minor update
2022-01-12Merge pull request #3010 from rouault/fix_2739Even Rouault
Implement Geographic3D to Depth/Geog2D+Depth as used by ETRS89 to CD Norway depth
2022-01-08Database: update to EPSG 10.047Even Rouault
2022-01-06Implement Geographic3D to Depth/Geog2D+Depth as used by ETRS89 to CD Norway ↵Even Rouault
depth Fixes #2739 Verified with example from IOGP Guidance Note 7-2 (ver 62, Dec 2021) page 169, with 38 = h_obs - D_obs = 50 - 12. $ echo 60.0015 4.9960 38 | PROJ_LIB=data PROJ_NETWORK=ON bin/cs2cs -d 4 EPSG:4937 EPSG:9883 60.0015 4.9960 5.8827 $ echo 60.0015 4.9960 38 | PROJ_LIB=data PROJ_NETWORK=ON bin/cs2cs -d 4 EPSG:4937 EPSG:4258+9672 60.0015 4.9960 5.8827 $ echo 60.0015 4.9960 5.8827 | PROJ_LIB=data PROJ_NETWORK=ON bin/cs2cs -d 4 EPSG:9883 EPSG:4937 60.0015 4.9960 38.0000 $ echo 60.0015 4.9960 5.8827 | PROJ_LIB=data PROJ_NETWORK=ON bin/cs2cs -d 4 EPSG:4258+9672 EPSG:4937 60.0015 4.9960 38.0000
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
generated by cgit v1.2.3 (git 2.25.1) at 2025-12-15 11:13:59 +0000