Database: "minimal" update to EPSG v10.003

Content mostly unchanged since v9.9

This update is "minimal" in that it mostly reflects the removal of the 'area'
table, replaced now by 'extent', 'scope' and 'usage'

Other new aspects of EPSG v10 are left aside.

1 files changed, 77 insertions, 14 deletions

diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql
index 38210c00..cb8c757a 100644
--- a/data/sql/grid_transformation_custom.sql
+++ b/data/sql/grid_transformation_custom.sql
@@ -4,83 +4,146 @@
 
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_4937_TO_EPSG_5799','ETRS89 to DVR90 height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','4937', -- source CRS (ETRS89)
     'EPSG','5799', -- target CRS (DVR90 height)
-    'EPSG','3237', -- area of use: Denmark onshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','dvr90.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_4937_TO_EPSG_5799_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_4937_TO_EPSG_5799',
+    'EPSG','3237', -- area of use: Denmark onshore
+    'EPSG','1024'  -- unknown
+);
+
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_4937_TO_EPSG_5733','ETRS89 to DNN height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','4937', -- source CRS (ETRS89)
     'EPSG','5733', -- target CRS (DNN height)
-    'EPSG','3237', -- area of use: Denmark onshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','dnn.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_4937_TO_EPSG_5733_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_4937_TO_EPSG_5733',
+    'EPSG','3237', -- area of use: Denmark onshore
+    'EPSG','1024'  -- unknown
+);
+
 -- Faroe Islands
 
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_4937_TO_EPSG_5317','ETRS89 to FVR09 height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','4937', -- source CRS (ETRS89)
     'EPSG','5317', -- target CRS (FVR09 height)
-    'EPSG','3248', -- area of use: Faroe Islands - onshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','fvr09.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_4937_TO_EPSG_5317_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_4937_TO_EPSG_5317',
+    'EPSG','3248', -- area of use: Faroe Islands - onshore
+    'EPSG','1024'  -- unknown
+);
+
 -- Sweden
 
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_4977_TO_EPSG_5613','SWEREF99 to RH2000 height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','4977', -- source CRS (SWEREF99)
     'EPSG','5613', -- target CRS (RH2000 height)
-    'EPSG','3313', -- area of use: Sweden onshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_4977_TO_EPSG_5613_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_4977_TO_EPSG_5613',
+    'EPSG','3313', -- area of use: Sweden onshore
+    'EPSG','1024'  -- unknown
+);
+
 -- Iceland
 
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_5323_TO_EPSG_8089','ISN2004 to ISH2004 height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','5323', -- source CRS (ISN2004 geographic 3D)
     'EPSG','8089', -- target CRS (ISH2004 height)
-    'EPSG','1120', -- area of use: Iceland - onshore and offshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2004.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_5323_TO_EPSG_8089_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_5323_TO_EPSG_8089',
+    'EPSG','1120', -- area of use: Iceland - onshore and offshore
+    'EPSG','1024'  -- unknown
+);
+
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_4945_TO_EPSG_8089','ISN93 to ISH2004 height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','4945', -- source CRS (ISN93 geographic 3D)
     'EPSG','8089', -- target CRS (ISH2004 height)
-    'EPSG','1120', -- area of use: Iceland - onshore and offshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN93.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_4945_TO_EPSG_8089_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_4945_TO_EPSG_8089',
+    'EPSG','1120', -- area of use: Iceland - onshore and offshore
+    'EPSG','1024'  -- unknown
+);
+
 INSERT INTO "grid_transformation" VALUES(
     'PROJ','EPSG_8085_TO_EPSG_8089','ISN2016 to ISH2004 height',
-    NULL,NULL,
+    NULL,
     'EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)',
     'EPSG','8085', -- source CRS (ISN2016 geographic 3D)
     'EPSG','8089', -- target CRS (ISH2004 height)
-    'EPSG','1120', -- area of use: Iceland - onshore and offshore
     NULL,
     'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2016.gtx',
     NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+
+INSERT INTO "usage" VALUES(
+    'PROJ',
+    'EPSG_8085_TO_EPSG_8089_USAGE',
+    'grid_transformation',
+    'PROJ',
+    'EPSG_8085_TO_EPSG_8089',
+    'EPSG','1120', -- area of use: Iceland - onshore and offshore
+    'EPSG','1024'  -- unknown
+);