diff options
Diffstat (limited to 'data/sql/customizations.sql')
| -rw-r--r-- | data/sql/customizations.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 8003c921..86d49b09 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -26,6 +26,17 @@ UPDATE grid_transformation SET interpolation_crs_auth_name = 'EPSG', interpolation_crs_code = '4289' WHERE auth_name = 'EPSG' AND code = '7001'; +-- EPSG:1312 'NAD27 to NAD83 (3)' / NTv1_0.gsb has a accuracy of 1m whereas +-- EPSG:1313 'NAD27 to NAD83 (4)' / NTv2_0.gsb has a accuracy of 1.5m +-- so we will never select automatically NTv2_0.gsb. Worse the advertize +-- accuracy of the NTv1 method + +UPDATE grid_transformation SET accuracy = 2.0 WHERE auth_name = 'EPSG' AND code = '1312'; + +-- Same for EPSG:1462 vs EPSG:1573 + +UPDATE grid_transformation SET accuracy = 2.0 WHERE auth_name = 'EPSG' AND code = '1462'; + -- Define the allowed authorities, and their precedence, when researching a -- coordinate operation |