Database: add a frame_reference_epoch column in vertical_datum to be able to handle dynamic vertical datums, and instanciate them properly from database

1 files changed, 18 insertions, 18 deletions

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index da23f6a5..a1f89405 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -15478,40 +15478,40 @@ INSERT INTO alias_name VALUES('vertical_crs','EPSG','8841','MVGC_height','ESRI')
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','8904','TWVD_2001_height','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','8911','DACR52_height','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','9130','IGN_2008_LD_height','ESRI');
-INSERT INTO "vertical_datum" VALUES('ESRI','1256','Canadian_Geodetic_Vertical_Datum_of_2013_CGG2013a',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','1256','Canadian_Geodetic_Vertical_Datum_of_2013_CGG2013a',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '1256_USAGE','vertical_datum','ESRI','1256','EPSG','1061','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','9245','CGVD2013_CGG2013a_height',NULL,'EPSG','6499','ESRI','1256',0);
 INSERT INTO "usage" VALUES('ESRI', '9245_USAGE','vertical_crs','ESRI','9245','EPSG','1061','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','1260','Sistema_de_Referencia_Vertical_Nacional_2016',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','1260','Sistema_de_Referencia_Vertical_Nacional_2016',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '1260_USAGE','vertical_datum','ESRI','1260','EPSG','4573','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','9255','SRVN16_height',NULL,'EPSG','6499','ESRI','1260',0);
 INSERT INTO "usage" VALUES('ESRI', '9255_USAGE','vertical_crs','ESRI','9255','EPSG','4573','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','1261','European_Vertical_Reference_Frame_2000_Austria',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','1261','European_Vertical_Reference_Frame_2000_Austria',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '1261_USAGE','vertical_datum','ESRI','1261','EPSG','1037','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','9274','EVRF2000_Austria_height',NULL,'EPSG','6499','ESRI','1261',0);
 INSERT INTO "usage" VALUES('ESRI', '9274_USAGE','vertical_crs','ESRI','9274','EPSG','1037','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','1262','South_Africa_Land_Levelling_Datum',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','1262','South_Africa_Land_Levelling_Datum',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '1262_USAGE','vertical_datum','ESRI','1262','EPSG','3309','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','9279','SA_LLD_height',NULL,'EPSG','6499','ESRI','1262',0);
 INSERT INTO "usage" VALUES('ESRI', '9279_USAGE','vertical_crs','ESRI','9279','EPSG','3309','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','1269','Kingdom_of_Saudi_Arabia_Vertical_Reference_Frame_Jeddah_2014',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','1269','Kingdom_of_Saudi_Arabia_Vertical_Reference_Frame_Jeddah_2014',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '1269_USAGE','vertical_datum','ESRI','1269','EPSG','3303','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','9335','KSA-VRF14_height',NULL,'EPSG','6499','ESRI','1269',0);
 INSERT INTO "usage" VALUES('ESRI', '9335_USAGE','vertical_crs','ESRI','9335','EPSG','3303','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','105103','Red_Espanola_de_Nivelacion_de_Alta_Precision',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','105103','Red_Espanola_de_Nivelacion_de_Alta_Precision',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '105103_USAGE','vertical_datum','ESRI','105103','EPSG','3429','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105603','REDNAP_height',NULL,'EPSG','6499','ESRI','105103',0);
 INSERT INTO "usage" VALUES('ESRI', '105603_USAGE','vertical_crs','ESRI','105603','EPSG','3429','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','105100','WGS_1984_Geoid',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','105100','WGS_1984_Geoid',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '105100_USAGE','vertical_datum','ESRI','105100','EPSG','1262','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105700','WGS_1984_Geoid',NULL,'EPSG','6499','ESRI','105100',0);
 INSERT INTO "usage" VALUES('ESRI', '105700_USAGE','vertical_crs','ESRI','105700','EPSG','1262','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','105101','Dansk_Vertikal_Reference_1990',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105101','Dansk_Vertikal_Reference_1990',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105101_USAGE','vertical_datum','ESRI','105101','EPSG','3237','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105701','DVR90',NULL,'EPSG','6499','ESRI','105101',1);
 INSERT INTO "usage" VALUES('ESRI', '105701_USAGE','vertical_crs','ESRI','105701','EPSG','3237','EPSG','1024');
 INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105701','vertical_crs','EPSG','5799','ESRI',1);
-INSERT INTO "vertical_datum" VALUES('ESRI','105102','Rikets_Hojdsystem_2000',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105102','Rikets_Hojdsystem_2000',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105102_USAGE','vertical_datum','ESRI','105102','EPSG','3313','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105702','RH2000',NULL,'EPSG','6499','ESRI','105102',1);
 INSERT INTO "usage" VALUES('ESRI', '105702_USAGE','vertical_crs','ESRI','105702','EPSG','3313','EPSG','1024');
@@ -15519,31 +15519,31 @@ INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105702','vertical_crs',
 INSERT INTO "vertical_crs" VALUES('ESRI','105703','NAVD88_height_(ftUS)',NULL,'EPSG','6497','EPSG','5103',1);
 INSERT INTO "usage" VALUES('ESRI', '105703_USAGE','vertical_crs','ESRI','105703','EPSG','3664','EPSG','1024');
 INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105703','vertical_crs','EPSG','6360','ESRI',1);
-INSERT INTO "vertical_datum" VALUES('ESRI','105104','LAS07',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','105104','LAS07',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '105104_USAGE','vertical_datum','ESRI','105104','EPSG','3272','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105704','LAS07_height',NULL,'EPSG','6499','ESRI','105104',0);
 INSERT INTO "usage" VALUES('ESRI', '105704_USAGE','vertical_crs','ESRI','105704','EPSG','3272','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','105290','EGM2008_Geoid',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105290','EGM2008_Geoid',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105290_USAGE','vertical_datum','ESRI','105290','EPSG','1262','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105790','EGM2008_Geoid',NULL,'EPSG','6499','ESRI','105290',1);
 INSERT INTO "usage" VALUES('ESRI', '105790_USAGE','vertical_crs','ESRI','105790','EPSG','1262','EPSG','1024');
 INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105790','vertical_crs','EPSG','3855','ESRI',1);
-INSERT INTO "vertical_datum" VALUES('ESRI','105291','Fao_1979',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105291','Fao_1979',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105291_USAGE','vertical_datum','ESRI','105291','EPSG','3625','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105791','Fao_1979',NULL,'EPSG','6499','ESRI','105291',1);
 INSERT INTO "usage" VALUES('ESRI', '105791_USAGE','vertical_crs','ESRI','105791','EPSG','3625','EPSG','1024');
 INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105791','vertical_crs','EPSG','3886','ESRI',1);
-INSERT INTO "vertical_datum" VALUES('ESRI','105292','New_Zealand_Vertical_Datum_2009',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105292','New_Zealand_Vertical_Datum_2009',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105292_USAGE','vertical_datum','ESRI','105292','EPSG','1175','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105792','NZVD2009_height',NULL,'EPSG','6499','ESRI','105292',1);
 INSERT INTO "usage" VALUES('ESRI', '105792_USAGE','vertical_crs','ESRI','105792','EPSG','1175','EPSG','1024');
 INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105792','vertical_crs','EPSG','4440','ESRI',1);
-INSERT INTO "vertical_datum" VALUES('ESRI','105293','N2000',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105293','N2000',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105293_USAGE','vertical_datum','ESRI','105293','EPSG','3333','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105793','N2000_height',NULL,'EPSG','6499','ESRI','105293',1);
 INSERT INTO "usage" VALUES('ESRI', '105793_USAGE','vertical_crs','ESRI','105793','EPSG','3333','EPSG','1024');
 INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105793','vertical_crs','EPSG','3900','ESRI',1);
-INSERT INTO "vertical_datum" VALUES('ESRI','105294','Dunedin_Bluff_1960',NULL,NULL,NULL,1);
+INSERT INTO "vertical_datum" VALUES('ESRI','105294','Dunedin_Bluff_1960',NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', '105294_USAGE','vertical_datum','ESRI','105294','EPSG','3806','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','105794','Dunedin_Bluff_1960_height',NULL,'EPSG','6499','ESRI','105294',1);
 INSERT INTO "usage" VALUES('ESRI', '105794_USAGE','vertical_crs','ESRI','105794','EPSG','3806','EPSG','1024');
@@ -15655,15 +15655,15 @@ INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105794','vertical_crs',
 -- Skipping TUREF. Should be a CompoundCRS
 -- Skipping GDA2020. Should be a CompoundCRS
 -- Skipping BGS2005. Should be a CompoundCRS
-INSERT INTO "vertical_datum" VALUES('ESRI','105110','Unknown_height_system_(meters)',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','105110','Unknown_height_system_(meters)',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '105110_USAGE','vertical_datum','ESRI','105110','EPSG','1262','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','115807','Unknown_height_system_(meters)',NULL,'EPSG','6499','ESRI','105110',0);
 INSERT INTO "usage" VALUES('ESRI', '115807_USAGE','vertical_crs','ESRI','115807','EPSG','1262','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','105111','Unknown_height_system_(US_survey_feet)',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','105111','Unknown_height_system_(US_survey_feet)',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '105111_USAGE','vertical_datum','ESRI','105111','EPSG','1262','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','115808','Unknown_height_system_(US_survey_feet)',NULL,'EPSG','6497','ESRI','105111',0);
 INSERT INTO "usage" VALUES('ESRI', '115808_USAGE','vertical_crs','ESRI','115808','EPSG','1262','EPSG','1024');
-INSERT INTO "vertical_datum" VALUES('ESRI','105112','Unknown_height_system_(Intl_feet)',NULL,NULL,NULL,0);
+INSERT INTO "vertical_datum" VALUES('ESRI','105112','Unknown_height_system_(Intl_feet)',NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', '105112_USAGE','vertical_datum','ESRI','105112','EPSG','1262','EPSG','1024');
 INSERT INTO "vertical_crs" VALUES('ESRI','115809','Unknown_height_system_(Intl_Feet)',NULL,'EPSG','1030','ESRI','105112',0);
 INSERT INTO "usage" VALUES('ESRI', '115809_USAGE','vertical_crs','ESRI','115809','EPSG','1262','EPSG','1024');