diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-10-06 17:23:45 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-10-08 17:31:55 +0200 |
| commit | e51a7db2bd5322463f8a7d345fb972bfd91ad921 (patch) | |
| tree | e507c4e4437c4745c198f846f5abe42c520e878e /scripts | |
| parent | ff9a386c72afb277aa79b86c7efb54e9843e810a (diff) | |
| download | PROJ-e51a7db2bd5322463f8a7d345fb972bfd91ad921.tar.gz PROJ-e51a7db2bd5322463f8a7d345fb972bfd91ad921.zip | |
Database: avoid importing duplicated alias names
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/build_db.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/build_db.py b/scripts/build_db.py index 47a275f1..113ee3fd 100755 --- a/scripts/build_db.py +++ b/scripts/build_db.py @@ -671,7 +671,7 @@ def fill_concatenated_operation(proj_db_cursor): def fill_alias(proj_db_cursor): - proj_db_cursor.execute("SELECT object_code, alias FROM epsg.epsg_alias WHERE object_table_name = 'epsg_datum'") + proj_db_cursor.execute("SELECT DISTINCT object_code, alias FROM epsg.epsg_alias WHERE object_table_name = 'epsg_datum'") for row in proj_db_cursor.fetchall(): code, alt_name = row proj_db_cursor.execute('SELECT 1 FROM geodetic_datum WHERE code = ?', (code,)) @@ -684,7 +684,7 @@ def fill_alias(proj_db_cursor): else: print('Cannot find datum %s in geodetic_datum or vertical_datum' % (code)) - proj_db_cursor.execute("SELECT object_code, alias FROM epsg.epsg_alias WHERE object_table_name = 'epsg_coordinatereferencesystem'") + proj_db_cursor.execute("SELECT DISTINCT object_code, alias FROM epsg.epsg_alias WHERE object_table_name = 'epsg_coordinatereferencesystem'") for row in proj_db_cursor.fetchall(): code, alt_name = row if int(code) > 60000000: |