aboutsummaryrefslogtreecommitdiff
path: root/scripts/build_db.py
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2022-01-26 14:32:44 +0100
committerEven Rouault <even.rouault@spatialys.com>2022-01-26 14:32:44 +0100
commit5085e294875c17ab5b0a6275f35b4a41eda3b158 (patch)
tree493da0ab0ea86c61fe8dfdf53a4c9344eed2128e /scripts/build_db.py
parent76d31bfa28d3d5c92c98a9a9a27b3cfedb44b9b4 (diff)
downloadPROJ-5085e294875c17ab5b0a6275f35b4a41eda3b158.tar.gz
PROJ-5085e294875c17ab5b0a6275f35b4a41eda3b158.zip
Database: update to EPSG 10.051
Diffstat (limited to 'scripts/build_db.py')
-rwxr-xr-xscripts/build_db.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/scripts/build_db.py b/scripts/build_db.py
index 263756c9..e221c057 100755
--- a/scripts/build_db.py
+++ b/scripts/build_db.py
@@ -432,6 +432,10 @@ def fill_compound_crs(proj_db_cursor):
proj_db_cursor.execute("SELECT ?, coord_ref_sys_code, coord_ref_sys_name, NULL, ?, cmpd_horizcrs_code, ?, cmpd_vertcrs_code, deprecated FROM epsg.epsg_coordinatereferencesystem WHERE coord_ref_sys_kind IN ('compound') AND cmpd_horizcrs_code NOT IN (SELECT coord_ref_sys_code FROM epsg.epsg_coordinatereferencesystem WHERE coord_ref_sys_kind = 'engineering')", (EPSG_AUTHORITY, EPSG_AUTHORITY, EPSG_AUTHORITY))
for auth_name, code, name, description, horiz_auth_name, horiz_code, vert_auth_name, vert_code, deprecated in proj_db_cursor.fetchall():
try:
+ # FIXME: dummy test record of EPSG 10.051 that should be removed in later versoins
+ if code == 9912 and name == 'test':
+ print('Skip EPSG:9912 test record')
+ continue
proj_db_cursor.execute("INSERT INTO compound_crs VALUES (?,?,?,?,?,?,?,?,?)", (auth_name, code, name, description, horiz_auth_name, horiz_code, vert_auth_name, vert_code, deprecated))
except sqlite3.IntegrityError as e:
print(e)