diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-12-06 23:43:03 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-12-06 23:43:03 +0100 |
| commit | ea719555f86399325b6d90840f8b3d4508b6e9bc (patch) | |
| tree | a6a713acd7c7bdf98bfc45bd86b29a98d92c1ae2 /scripts | |
| parent | 5a8c5241cc3ca35e2834221c8049d96954011b91 (diff) | |
| download | PROJ-ea719555f86399325b6d90840f8b3d4508b6e9bc.tar.gz PROJ-ea719555f86399325b6d90840f8b3d4508b6e9bc.zip | |
Database: update to EPSG v10.041
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/build_db.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/scripts/build_db.py b/scripts/build_db.py index f1920c6d..263756c9 100755 --- a/scripts/build_db.py +++ b/scripts/build_db.py @@ -278,7 +278,9 @@ def fill_geodetic_crs(proj_db_cursor): #proj_db_cursor.execute( # "INSERT INTO crs SELECT ?, coord_ref_sys_code, coord_ref_sys_kind FROM epsg.epsg_coordinatereferencesystem WHERE coord_ref_sys_kind IN ('geographic 2D', 'geographic 3D', 'geocentric') AND datum_code IS NOT NULL", (EPSG_AUTHORITY,)) - proj_db_cursor.execute("INSERT INTO geodetic_crs SELECT ?, coord_ref_sys_code, coord_ref_sys_name, NULL, coord_ref_sys_kind, ?, coord_sys_code, ?, datum_code, NULL, deprecated FROM epsg.epsg_coordinatereferencesystem WHERE coord_ref_sys_kind IN ('geographic 2D', 'geographic 3D', 'geocentric') AND datum_code IS NOT NULL", (EPSG_AUTHORITY, EPSG_AUTHORITY, EPSG_AUTHORITY)) + # There are a few deprecated records of code 61 000 000 that we have never imported in versions <= 10.039 because + # they lacked a datum code. We will continue to ignore them. + proj_db_cursor.execute("INSERT INTO geodetic_crs SELECT ?, coord_ref_sys_code, coord_ref_sys_name, NULL, coord_ref_sys_kind, ?, coord_sys_code, ?, datum_code, NULL, deprecated FROM epsg.epsg_coordinatereferencesystem WHERE coord_ref_sys_kind IN ('geographic 2D', 'geographic 3D', 'geocentric') AND datum_code IS NOT NULL AND NOT (coord_ref_sys_code > 61000000 AND deprecated)", (EPSG_AUTHORITY, EPSG_AUTHORITY, EPSG_AUTHORITY)) def fill_vertical_crs(proj_db_cursor): |