Skip to content

Commit 047e5db

Browse files
committed
Database: update to EPSG 12.033
A few hacks have had to be made. Below email sent to epsg.org ``` PROJ consistency checks have detected the following issues with the 12.033 update (or changes done after 12.029): - Transformation 11064 "ETRS89-BEL [BEREF2002] to ETRF2000 (1) " lacks the unit of measure for the 3 X/Y/Z-translation terms. - Transformation 10996 "ETRS89-GBR [OSNet v2009] to Xrail84 (1)" uses EPSG:11008, a geographic 3D CRS, as source CRS, whereas its target CRS is EPSG:10991, a geocentric one. Given the transformation method is "Coordinate Frame rotation (geocentric domain)", the source should likely be EPSG:11007 - Similarly, transformation 11050 " ETRS89-ALB [KRGJSH 2010] to WGS 84 (1) " uses EPSG:11047, a geographic 2D CRS as source CRS, and EPSG:4326 as target CRS, but with "Geocentric translations (geocentric domain)Open". It should likely be either source_crs = EPSG:11045 and target_crs = EPSG:4978, or the operation method should be changed to "Geocentric translations (geog2D domain)". - Transformation 11185 "ETRS89-BGR [BGS2005] to ETRF2000 (1)" is between 2 geocentric CRS, but the operation method is "Geocentric translations (geog2D domain)". I presume it should be "Geocentric translations (geocentric domain)" / 1031 instead Independently of he above, I've some concerns regarding backwards compatibility of creating all those specialized CRS ETRS89-xxx and re-assigning past transformations between national CRS and ETRS89 to be between that national CRS and ETRS89-xxx. Such changes can be seen as regressions from users used to use generic ETRS89. For example for Romania, people doing EPSG:4179 (Pulkovo 1942(58)) to EPSG:4258 (ETRS89) previously got EPSG:15994 as the most precise result. But now EPSG:15994 is no longer between those 2 CRS but beween EPSG:4179 and EPSG:11119 ("ETRS89-ROU [ETRF2000]"), and now they get only EPSG:15993 that was superseded per EPSG:15994. My understanding was that existing objects in the database could not be changed in significant ways. I see such change of target CRS to be a significant change. Wouldn't have it been better to copy EPSG:15994 to a new object with the new target CRS? Furthermore there are no transformation records between generic ETRS89 and ETRS89-XXX (that should presumably be null transformations with some centimeric accuracy), which makes it difficult to "bridge" records. ```
1 parent ad3f880 commit 047e5db

25 files changed

+487
-206
lines changed

data/CMakeLists.txt

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ set(ALL_SQL_IN "${CMAKE_CURRENT_BINARY_DIR}/all.sql.in")
3131
set(PROJ_DB "${CMAKE_CURRENT_BINARY_DIR}/proj.db")
3232
include(sql_filelist.cmake)
3333

34-
set(PROJ_DB_SQL_EXPECTED_MD5 "f6a88a01020b8abf364ff2d27271ae60")
34+
set(PROJ_DB_SQL_EXPECTED_MD5 "cc37de05534deceb5724cb4faf8ca31c")
3535

3636
add_custom_command(
3737
OUTPUT ${PROJ_DB}

data/sql/alias_name.sql

Lines changed: 70 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -777,10 +777,18 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1414','CSRN2025 (NAD83
777777
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1420','GR96(1996)','EPSG');
778778
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1422','NATRF2022','EPSG');
779779
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1407','EUREF89','EPSG');
780+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1425','ETRS89-GBR [OSNet v2009]','EPSG');
780781
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1403','NKG_ETRF14','EPSG');
781782
INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1424','SVD2024','EPSG');
782783
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1225','CR-SIRGAS','EPSG');
783784
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1428','CR14','EPSG');
785+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1429','Korniza Referuese Gjeodezike Shqiptare 2010','EPSG');
786+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1429','KRGJSH 2010','EPSG');
787+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1167','ETRS89-BGR [BGS2005]','EPSG');
788+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1251','ETRS89-XKX [KOSOVAREF01]','EPSG');
789+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1432','ETRS89-BEL [BEREF2002]','EPSG');
790+
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1447','ETRS89-BEL [BEREF2011]','EPSG');
791+
INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1423','LSGH','EPSG');
784792
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','21100','Genuk / NEIEZ','EPSG');
785793
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2140','NAD83(CSRS98) / SCoPQ zone 3','EPSG');
786794
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2141','NAD83(CSRS98) / SCoPQ zone 4','EPSG');
@@ -2442,7 +2450,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3443','NAD83(HPGN) / Ill
24422450
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3444','NAD83(HPGN) / Illinois West (ftUS)','EPSG');
24432451
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3445','NAD83(HPGN) / New Hampshire (ftUS)','EPSG');
24442452
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3446','NAD83(HPGN) / Rhode Island (ftUS)','EPSG');
2445-
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3447','ETRS89 / Lambert 2005','EPSG');
2453+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3447','ETRS89 / Belgian Lambert 2005','EPSG');
24462454
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4746','DHDN','EPSG');
24472455
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3397','PD/83 / Gauss-Kruger zone 4','EPSG');
24482456
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4745','DHDN','EPSG');
@@ -4417,9 +4425,9 @@ INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4191','ALB86','EPSG');
44174425
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2462','ALB86 / GK zn 4','EPSG');
44184426
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4129','Observatario Campos Rodrigues 1907','EPSG');
44194427
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6984','IG05','EPSG');
4420-
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6962','ETRS89 / Albania LCC','EPSG');
4428+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6962','ETRS89 / Albania LCC 2010','EPSG');
44214429
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6991','IG05/12','EPSG');
4422-
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6870','ETRS89 / Albania TM','EPSG');
4430+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6870','ETRS89 / Albania TM 2010','EPSG');
44234431
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2039','Israel / Israeli TM Grid','EPSG');
44244432
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6796','NAD83(CORS96) / Oregon Bend-Vale zone (m)','EPSG');
44254433
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4141','Israel','EPSG');
@@ -8156,6 +8164,9 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','10923','CSRN2025 (NAD83
81568164
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','10924','CSRN2025 (NAD83 2011) / California zone 4 (m)','EPSG');
81578165
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','10873','EUREF89','EPSG');
81588166
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','10874','EUREF89','EPSG');
8167+
INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','10989','LSGH','EPSG');
8168+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11007','ETRS89','EPSG');
8169+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11007','OSNet v2009','EPSG');
81598170
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','10875','EUREF89','EPSG');
81608171
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5105','ETRS89 / NTM zone 5','EPSG');
81618172
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5106','ETRS89 / NTM zone 6','EPSG');
@@ -8332,6 +8343,12 @@ INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5970','EUREF89 / NTM zone
83328343
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5958','EUREF89 / NTM zone 18 + NN2000 height','EPSG');
83338344
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6162','EUREF89 / NTM zone 22 + NN54 height','EPSG');
83348345
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5962','EUREF89 / NTM zone 22 + NN2000 height','EPSG');
8346+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9427','ETRS89 + Lerwick height','EPSG');
8347+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9424','ETRS89 + ODN height','EPSG');
8348+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9426','ETRS89 + ODN Orkney height','EPSG');
8349+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9430','ETRS89 + St. Marys height','EPSG');
8350+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11008','ETRS89','EPSG');
8351+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11008','OSNet v2009','EPSG');
83358352
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8905','CR-SIRGAS','EPSG');
83368353
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8906','CR-SIRGAS','EPSG');
83378354
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8907','CR-SIRGAS','EPSG');
@@ -8341,7 +8358,17 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','8909','CR-SIRGAS / UTM z
83418358
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','8910','CR-SIRGAS / UTM zone 17N','EPSG');
83428359
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11041','CR19','EPSG');
83438360
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11042','CR19','EPSG');
8361+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3416','ETRS89 / Austria Lambert','EPSG');
8362+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9500','ETRS89 + EVRF2000 Austria height','EPSG');
8363+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','8370','ETRS89 / Belgian Lambert 2008 + Ostend height','EPSG');
8364+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9907','ETRS89 + Ostend height','EPSG');
8365+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11009','ETRS89','EPSG');
8366+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3763','ETRS89 / Portugal TM06','EPSG');
8367+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','10545','ETRS89 + Cascais height','EPSG');
83448368
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11027','EUREF89 / UTM zone 37','EPSG');
8369+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11046','KRGJSH 2010','EPSG');
8370+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11047','KRGJSH 2010','EPSG');
8371+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','11045','KRGJSH 2010','EPSG');
83458372
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5971','EUREF89 / UTM zone 31 + NN2000 height','EPSG');
83468373
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5972','EUREF89 / UTM zone 32 + NN2000 height','EPSG');
83478374
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5973','EUREF89 / UTM zone 33 + NN2000 height','EPSG');
@@ -8354,3 +8381,43 @@ INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6173','EUREF89 / UTM zone
83548381
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6174','EUREF89 / UTM zone 34 + NN54 height','EPSG');
83558382
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6175','EUREF89 / UTM zone 35 + NN54 height','EPSG');
83568383
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6176','EUREF89 / UTM zone 36 + NN54 height','EPSG');
8384+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11020','ETRS89 / UTM zone 30N','EPSG');
8385+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11012','ETRS89 / UTM zone 30N (N-E)','EPSG');
8386+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11021','ETRS89 / UTM zone 31N','EPSG');
8387+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11013','ETRS89 / UTM zone 31N (N-E)','EPSG');
8388+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11022','ETRS89 / UTM zone 32N','EPSG');
8389+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11014','ETRS89 / UTM zone 32N (N-E)','EPSG');
8390+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11023','ETRS89 / UTM zone 33N','EPSG');
8391+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11015','ETRS89 / UTM zone 33N (N-E)','EPSG');
8392+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11024','ETRS89 / UTM zone 34N','EPSG');
8393+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11016','ETRS89 / UTM zone 34N (N-E)','EPSG');
8394+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11025','ETRS89 / UTM zone 35N','EPSG');
8395+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11017','ETRS89 / UTM zone 35N (N-E)','EPSG');
8396+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11026','ETRS89 / UTM zone 36N','EPSG');
8397+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11018','ETRS89 / UTM zone 36N (N-E)','EPSG');
8398+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11027','ETRS89 / UTM zone 37N','EPSG');
8399+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11019','ETRS89 / UTM zone 37N (N-E)','EPSG');
8400+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','7796','BGS2005','EPSG');
8401+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','7797','BGS2005','EPSG');
8402+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','7798','BGS2005','EPSG');
8403+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7801','BGS2005 / CCS2005','EPSG');
8404+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7803','BGS2005 / UTM zone 34N','EPSG');
8405+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7803','ETRS89 / UTM zone 34N','EPSG');
8406+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7799','ETRS89 / UTM zone 34N (N-E)','EPSG');
8407+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7799','BGS2005 / UTM zone 34N (N-E)','EPSG');
8408+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9391','BGS2005 / UTM zone 35N','EPSG');
8409+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9391','ETRS89 / UTM zone 35N','EPSG');
8410+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7800','BGS2005 / UTM zone 35N (N-E)','EPSG');
8411+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7800','ETRS89 / UTM zone 35N (N-E)','EPSG');
8412+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7805','BGS2005 / UTM zone 36N','EPSG');
8413+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7805','ETRS89 / UTM zone 36N','EPSG');
8414+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9138','KOSOVAREF01','EPSG');
8415+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9139','KOSOVAREF01','EPSG');
8416+
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9140','KOSOVAREF01','EPSG');
8417+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9141','KOSOVAREF01 / Balkans zone 7','EPSG');
8418+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3812','ETRS89 / Belgian Lambert 2008','EPSG');
8419+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11219','ETRS89 / Lambert 2008','EPSG');
8420+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','11219','ETRS89 / LB08','EPSG');
8421+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','10997','ETRS89 + LSG height','EPSG');
8422+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','10997','OSNet v2009 + LSG height','EPSG');
8423+
INSERT INTO "alias_name" VALUES('compound_crs','EPSG','11006','LSG2025','EPSG');

data/sql/alias_name_old_epsg.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1124,3 +1124,8 @@ INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3902','ETRS89-TM35FIN(N,E
11241124

11251125
-- Changed in EPSG v12.007
11261126
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25884','LKS92 / TM Baltic93','EPSG_OLD');
1127+
1128+
-- Changed in EPSG v12.033
1129+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3447','ETRS89 / Lambert 2005','EPSG_OLD');
1130+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6962','ETRS89 / Albania LCC','EPSG_OLD');
1131+
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6870','ETRS89 / Albania TM','EPSG_OLD');

0 commit comments

Comments
 (0)