aboutsummaryrefslogtreecommitdiff
path: root/data/sql/geodetic_crs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/sql/geodetic_crs.sql')
-rw-r--r--data/sql/geodetic_crs.sql80
1 files changed, 74 insertions, 6 deletions
diff --git a/data/sql/geodetic_crs.sql b/data/sql/geodetic_crs.sql
index a4156621..979fd43a 100644
--- a/data/sql/geodetic_crs.sql
+++ b/data/sql/geodetic_crs.sql
@@ -58,9 +58,9 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','4052','Unspecified datum based upon th
INSERT INTO "geodetic_crs" VALUES('EPSG','4053','Unspecified datum based upon the International 1924 Authalic Sphere',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6053','EPSG','1263',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','4054','Unspecified datum based upon the Hughes 1980 ellipsoid',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6054','EPSG','1263',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','4055','Popular Visualisation CRS',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6055','EPSG','1262',NULL,1);
-INSERT INTO "geodetic_crs" VALUES('EPSG','4073','SREF98',NULL,NULL,'geocentric','EPSG','6500','EPSG','1034','EPSG','3534',NULL,0);
-INSERT INTO "geodetic_crs" VALUES('EPSG','4074','SREF98',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1034','EPSG','3534',NULL,0);
-INSERT INTO "geodetic_crs" VALUES('EPSG','4075','SREF98',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1034','EPSG','3534',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','4073','SREF98',NULL,NULL,'geocentric','EPSG','6500','EPSG','1034','EPSG','4543',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','4074','SREF98',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1034','EPSG','4543',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','4075','SREF98',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1034','EPSG','4543',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','4079','REGCAN95',NULL,NULL,'geocentric','EPSG','6500','EPSG','1035','EPSG','3199',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','4080','REGCAN95',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1035','EPSG','3199',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','4081','REGCAN95',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1035','EPSG','3199',NULL,0);
@@ -889,13 +889,14 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','8542','NAD83(FBN)',NULL,NULL,'geograph
INSERT INTO "geodetic_crs" VALUES('EPSG','8543','NAD83(HARN Corrected)',NULL,NULL,'geocentric','EPSG','6500','EPSG','1212','EPSG','3634',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8544','NAD83(HARN Corrected)',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1212','EPSG','3634',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8545','NAD83(HARN Corrected)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1212','EPSG','3634',NULL,0);
-INSERT INTO "geodetic_crs" VALUES('EPSG','8683','SRB_ETRS89',NULL,NULL,'geocentric','EPSG','6500','EPSG','1214','EPSG','3534',NULL,0);
-INSERT INTO "geodetic_crs" VALUES('EPSG','8684','SRB_ETRS89',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1214','EPSG','3534',NULL,0);
-INSERT INTO "geodetic_crs" VALUES('EPSG','8685','SRB_ETRS89',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1214','EPSG','3534',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8683','SRB_ETRS89',NULL,NULL,'geocentric','EPSG','6500','EPSG','1214','EPSG','4543',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8684','SRB_ETRS89',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1214','EPSG','4543',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8685','SRB_ETRS89',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1214','EPSG','4543',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8816','MTRF-2000',NULL,NULL,'geocentric','EPSG','6500','EPSG','1218','EPSG','1206',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8817','MTRF-2000',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1218','EPSG','1206',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8818','MTRF-2000',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1218','EPSG','1206',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8860','NAD83(FBN)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1211','EPSG','4515',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8888','WGS 84 (Transit)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1166','EPSG','1262',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8898','RGWF96',NULL,NULL,'geocentric','EPSG','6500','EPSG','1223','EPSG','1255',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8899','RGWF96',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1223','EPSG','1255',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8900','RGWF96',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1223','EPSG','1255',NULL,0);
@@ -904,6 +905,54 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','8902','RGWF96 (lon-lat)',NULL,NULL,'ge
INSERT INTO "geodetic_crs" VALUES('EPSG','8905','CR-SIRGAS',NULL,NULL,'geocentric','EPSG','6500','EPSG','1225','EPSG','1074',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8906','CR-SIRGAS',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1225','EPSG','1074',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8907','CR-SIRGAS',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1225','EPSG','1074',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8915','SIRGAS-CON DGF00P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1227','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8916','SIRGAS-CON DGF00P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1227','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8917','SIRGAS-CON DGF01P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1228','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8918','SIRGAS-CON DGF01P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1228','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8919','SIRGAS-CON DGF01P02',NULL,NULL,'geocentric','EPSG','6500','EPSG','1229','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8920','SIRGAS-CON DGF01P02',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1229','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8921','SIRGAS-CON DGF02P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1230','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8922','SIRGAS-CON DGF02P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1230','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8923','SIRGAS-CON DGF04P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1231','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8924','SIRGAS-CON DGF04P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1231','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8925','SIRGAS-CON DGF05P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1232','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8926','SIRGAS-CON DGF05P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1232','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8927','SIRGAS-CON DGF06P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1233','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8928','SIRGAS-CON DGF06P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1233','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8929','SIRGAS-CON DGF07P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1234','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8930','SIRGAS-CON DGF07P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1234','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8931','SIRGAS-CON DGF08P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1235','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8932','SIRGAS-CON DGF08P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1235','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8933','SIRGAS-CON SIR09P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1236','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8934','SIRGAS-CON SIR09P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1236','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8935','SIRGAS-CON SIR10P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1237','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8936','SIRGAS-CON SIR10P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1237','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8937','SIRGAS-CON SIR11P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1238','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8938','SIRGAS-CON SIR11P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1238','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8939','SIRGAS-CON SIR13P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1239','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8940','SIRGAS-CON SIR13P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1239','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8941','SIRGAS-CON SIR14P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1240','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8942','SIRGAS-CON SIR14P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1240','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8943','SIRGAS-CON SIR15P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1241','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8944','SIRGAS-CON SIR15P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1241','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8945','SIRGAS-CON SIR17P01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1242','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8946','SIRGAS-CON SIR17P01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1242','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8972','SIRGAS-CON DGF00P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1227','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8973','SIRGAS-CON DGF01P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1228','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8974','SIRGAS-CON DGF01P02',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1229','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8975','SIRGAS-CON DGF02P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1230','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8976','SIRGAS-CON DGF04P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1231','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8977','SIRGAS-CON DGF05P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1232','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8978','SIRGAS-CON DGF06P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1233','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8979','SIRGAS-CON DGF07P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1234','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8980','SIRGAS-CON DGF08P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1235','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8981','SIRGAS-CON SIR09P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1236','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8982','SIRGAS-CON SIR10P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1237','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8983','SIRGAS-CON SIR11P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1238','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8984','SIRGAS-CON SIR13P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1239','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8985','SIRGAS-CON SIR14P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1240','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8986','SIRGAS-CON SIR15P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1241','EPSG','4530',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','8987','SIRGAS-CON SIR17P01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1242','EPSG','4530',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8988','ITRF88',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6647','EPSG','1262',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8989','ITRF89',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6648','EPSG','1262',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','8990','ITRF90',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6649','EPSG','1262',NULL,0);
@@ -936,3 +985,22 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','9016','IGb08',NULL,NULL,'geographic 3D
INSERT INTO "geodetic_crs" VALUES('EPSG','9017','IGb08',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1248','EPSG','1262',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','9018','IGS14',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1191','EPSG','1262',NULL,0);
INSERT INTO "geodetic_crs" VALUES('EPSG','9019','IGS14',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1191','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9053','WGS 84 (G730)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1152','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9054','WGS 84 (G873)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1153','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9055','WGS 84 (G1150)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1154','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9056','WGS 84 (G1674)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1155','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9057','WGS 84 (G1762)',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1156','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9059','ETRF89',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1178','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9060','ETRF90',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1179','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9061','ETRF91',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1180','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9062','ETRF92',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1181','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9063','ETRF93',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1182','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9064','ETRF94',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1183','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9065','ETRF96',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1184','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9066','ETRF97',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1185','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9067','ETRF2000',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1186','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9068','ETRF2005',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1204','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9069','ETRF2014',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1206','EPSG','1298',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9138','KOSOVAREF01',NULL,NULL,'geocentric','EPSG','6500','EPSG','1251','EPSG','4542',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9139','KOSOVAREF01',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1251','EPSG','4542',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('EPSG','9140','KOSOVAREF01',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1251','EPSG','4542',NULL,0);