diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2019-12-01 00:30:35 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2019-12-01 00:30:35 +0100 |
| commit | 43a6c1535c4d06abeb4f56b676e1bf403ae13822 (patch) | |
| tree | 9217d5e2c8a84823dccf172901dd31fc8a65df73 /scripts | |
| parent | ebe67de5dfdd793c293bf663c03bb5a9ce5a4e03 (diff) | |
| download | PROJ-43a6c1535c4d06abeb4f56b676e1bf403ae13822.tar.gz PROJ-43a6c1535c4d06abeb4f56b676e1bf403ae13822.zip | |
grid_checks.py: add is_superseded info in output
Diffstat (limited to 'scripts')
| -rwxr-xr-x | scripts/grid_checks.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/grid_checks.py b/scripts/grid_checks.py index e70f3a15..b789b1e9 100755 --- a/scripts/grid_checks.py +++ b/scripts/grid_checks.py @@ -55,9 +55,9 @@ proj_datumgrid = args.path_to_proj_datumgrid if args.not_in_grid_alternatives: conn = sqlite3.connect(dbname) - print('Authority, code, name, grid_name') + print('Authority, code, name, grid_name, is_superseded') res = conn.execute(""" - SELECT auth_name, code, name, grid_name FROM grid_transformation + SELECT auth_name, code, name, grid_name, EXISTS (SELECT 1 FROM supersession WHERE superseded_table_name = 'grid_transformation' AND superseded_auth_name = auth_name AND superseded_code = code) AS superseded FROM grid_transformation WHERE deprecated = 0 AND NOT EXISTS (SELECT 1 FROM grid_alternatives WHERE original_grid_name = grid_name)""") for row in res: |