diff options
Diffstat (limited to 'data/sql/compound_crs.sql')
| -rw-r--r-- | data/sql/compound_crs.sql | 28 |
1 files changed, 24 insertions, 4 deletions
diff --git a/data/sql/compound_crs.sql b/data/sql/compound_crs.sql index 972dfdba..9c6faf85 100644 --- a/data/sql/compound_crs.sql +++ b/data/sql/compound_crs.sql @@ -40,13 +40,13 @@ INSERT INTO "compound_crs" VALUES('EPSG','5707','NTF (Paris) / Lambert zone I + INSERT INTO "usage" VALUES('EPSG','4150','compound_crs','EPSG','5707','EPSG','1731','EPSG','1142'); INSERT INTO "compound_crs" VALUES('EPSG','5708','NTF (Paris) / Lambert zone IV + NGF-IGN78 height',NULL,'EPSG','27574','EPSG','5721',0); INSERT INTO "usage" VALUES('EPSG','4151','compound_crs','EPSG','5708','EPSG','1327','EPSG','1142'); -INSERT INTO "compound_crs" VALUES('EPSG','5832','DB_REF / 3-degree Gauss-Kruger zone 2 (E-N) + DHHN92 height',NULL,'EPSG','5682','EPSG','5783',0); +INSERT INTO "compound_crs" VALUES('EPSG','5832','DB_REF / 3-degree Gauss-Kruger zone 2 (E-N) + DHHN92 height',NULL,'EPSG','5682','EPSG','5783',1); INSERT INTO "usage" VALUES('EPSG','4270','compound_crs','EPSG','5832','EPSG','1624','EPSG','1141'); -INSERT INTO "compound_crs" VALUES('EPSG','5833','DB_REF / 3-degree Gauss-Kruger zone 3 (E-N) + DHHN92 height',NULL,'EPSG','5683','EPSG','5783',0); +INSERT INTO "compound_crs" VALUES('EPSG','5833','DB_REF / 3-degree Gauss-Kruger zone 3 (E-N) + DHHN92 height',NULL,'EPSG','5683','EPSG','5783',1); INSERT INTO "usage" VALUES('EPSG','4271','compound_crs','EPSG','5833','EPSG','3993','EPSG','1141'); -INSERT INTO "compound_crs" VALUES('EPSG','5834','DB_REF / 3-degree Gauss-Kruger zone 4 (E-N) + DHHN92 height',NULL,'EPSG','5684','EPSG','5783',0); +INSERT INTO "compound_crs" VALUES('EPSG','5834','DB_REF / 3-degree Gauss-Kruger zone 4 (E-N) + DHHN92 height',NULL,'EPSG','5684','EPSG','5783',1); INSERT INTO "usage" VALUES('EPSG','4272','compound_crs','EPSG','5834','EPSG','3996','EPSG','1141'); -INSERT INTO "compound_crs" VALUES('EPSG','5835','DB_REF / 3-degree Gauss-Kruger zone 5 (E-N) + DHHN92 height',NULL,'EPSG','5685','EPSG','5783',0); +INSERT INTO "compound_crs" VALUES('EPSG','5835','DB_REF / 3-degree Gauss-Kruger zone 5 (E-N) + DHHN92 height',NULL,'EPSG','5685','EPSG','5783',1); INSERT INTO "usage" VALUES('EPSG','4273','compound_crs','EPSG','5835','EPSG','3998','EPSG','1141'); INSERT INTO "compound_crs" VALUES('EPSG','5845','SWEREF99 TM + RH2000 height',NULL,'EPSG','3006','EPSG','5613',0); INSERT INTO "usage" VALUES('EPSG','4280','compound_crs','EPSG','5845','EPSG','3313','EPSG','1142'); @@ -724,3 +724,23 @@ INSERT INTO "compound_crs" VALUES('EPSG','9881','MOLDOR11 Grid + ODN height',NUL INSERT INTO "usage" VALUES('EPSG','16985','compound_crs','EPSG','9881','EPSG','4655','EPSG','1141'); INSERT INTO "compound_crs" VALUES('EPSG','9883','ETRS89 + CD Norway depth',NULL,'EPSG','4258','EPSG','9672',0); INSERT INTO "usage" VALUES('EPSG','16974','compound_crs','EPSG','9883','EPSG','4656','EPSG','1198'); +INSERT INTO "compound_crs" VALUES('EPSG','9897','LUREF / Luxembourg TM + NG95 height',NULL,'EPSG','2169','EPSG','5774',0); +INSERT INTO "usage" VALUES('EPSG','17304','compound_crs','EPSG','9897','EPSG','1146','EPSG','1029'); +INSERT INTO "compound_crs" VALUES('EPSG','9924','ETRS89 + DHHN2016 height',NULL,'EPSG','4258','EPSG','7837',0); +INSERT INTO "usage" VALUES('EPSG','17168','compound_crs','EPSG','9924','EPSG','3339','EPSG','1026'); +INSERT INTO "compound_crs" VALUES('EPSG','9928','DB_REF2003 zone 2',NULL,'EPSG','5682','EPSG','9923',0); +INSERT INTO "usage" VALUES('EPSG','17297','compound_crs','EPSG','9928','EPSG','1624','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9929','DB_REF2003 zone 3',NULL,'EPSG','5683','EPSG','9923',0); +INSERT INTO "usage" VALUES('EPSG','17298','compound_crs','EPSG','9929','EPSG','3993','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9930','DB_REF2003 zone 4',NULL,'EPSG','5684','EPSG','9923',0); +INSERT INTO "usage" VALUES('EPSG','17299','compound_crs','EPSG','9930','EPSG','3996','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9931','DB_REF2003 zone 5',NULL,'EPSG','5685','EPSG','9923',0); +INSERT INTO "usage" VALUES('EPSG','17300','compound_crs','EPSG','9931','EPSG','3998','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9932','DB_REF2016 zone 2',NULL,'EPSG','5682','EPSG','9927',0); +INSERT INTO "usage" VALUES('EPSG','17293','compound_crs','EPSG','9932','EPSG','1624','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9933','DB_REF2016 zone 3',NULL,'EPSG','5683','EPSG','9927',0); +INSERT INTO "usage" VALUES('EPSG','17294','compound_crs','EPSG','9933','EPSG','3993','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9934','DB_REF2016 zone 4',NULL,'EPSG','5684','EPSG','9927',0); +INSERT INTO "usage" VALUES('EPSG','17295','compound_crs','EPSG','9934','EPSG','3996','EPSG','1141'); +INSERT INTO "compound_crs" VALUES('EPSG','9935','DB_REF2016 zone 5',NULL,'EPSG','5685','EPSG','9927',0); +INSERT INTO "usage" VALUES('EPSG','17296','compound_crs','EPSG','9935','EPSG','3998','EPSG','1141'); |