From eb2705fb9381ba3ce8a9791b1812c1c9e32545b5 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Tue, 8 Sep 2020 13:21:07 +0200
Subject: Database: add OGC:CRS27 and OGC:CRS83 CRS entries for NAD27 and NAD83
 in longitude, latitude order

---
 data/sql/customizations.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'data/sql/customizations.sql')

diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql
index fde530da..0a299367 100644
--- a/data/sql/customizations.sql
+++ b/data/sql/customizations.sql
@@ -20,10 +20,15 @@ INSERT INTO grid_alternatives(original_grid_name,
            'https://cdn.proj.org/au_ga_AUSGeoid98.tif', 1, 1, NULL FROM grid_transformation WHERE
                 grid_name LIKE '%DAT.htm' AND name LIKE 'GDA94 to AHD height%';
 
+-- OGC CRS84, CRS27 and CRS83 longitude/latitude ordered CRS
 
 INSERT INTO "geodetic_crs" VALUES('OGC','CRS84','WGS 84 (CRS84)',NULL,NULL,'geographic 2D','EPSG','6424','EPSG','6326','EPSG','1262',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('OGC','CRS27','NAD27 (CRS27)',NULL,NULL,'geographic 2D','EPSG','6424','EPSG','6267','EPSG','1349',NULL,0);
+INSERT INTO "geodetic_crs" VALUES('OGC','CRS83','NAD83 (CRS83)',NULL,NULL,'geographic 2D','EPSG','6424','EPSG','6269','EPSG','1350',NULL,0);
 
 INSERT INTO "other_transformation" VALUES('PROJ','CRS84_TO_EPSG_4326','OGC:CRS84 to WGS 84',NULL,NULL,'EPSG','9843','Axis Order Reversal (2D)','OGC','CRS84','EPSG','4326','EPSG','1262',0.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "other_transformation" VALUES('PROJ','CRS27_TO_EPSG_4267','OGC:CRS27 to NAD27',NULL,NULL,'EPSG','9843','Axis Order Reversal (2D)','OGC','CRS27','EPSG','4267','EPSG','1262',0.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "other_transformation" VALUES('PROJ','CRS83_TO_EPSG_4269','OGC:CRS83 to NAD83',NULL,NULL,'EPSG','9843','Axis Order Reversal (2D)','OGC','CRS83','EPSG','4269','EPSG','1262',0.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 
 -- Temporary entry for NZGD2000 deformation model
 INSERT INTO other_transformation VALUES(
-- 
cgit v1.2.3

