diff options
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/customizations.sql | 4 | ||||
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 2 |
2 files changed, 6 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index fd67b8a1..efb0a4bc 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -136,6 +136,10 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6299','ire65','PROJ'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6272','nzgd49','PROJ'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6277','OSGB36','PROJ'); +-- Given that we have installed above a WGS84 alias to the datum, add also one +-- to the EPSG:4326 CRS, as this is a common use case (https://github.com/OSGeo/PROJ/issues/2216) +INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4326','WGS84','PROJ'); + ---- PROJ unit short names ----- -- Linear units diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index df20de31..2d820d20 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1340,6 +1340,8 @@ CREATE TABLE alias_name( source TEXT ); +CREATE INDEX idx_alias_name_code ON alias_name(code); + CREATE TRIGGER alias_name_insert_trigger BEFORE INSERT ON alias_name FOR EACH ROW BEGIN |