Vocabularies — details

DIC_CRS_HORIZ_CS

Dictionary of horizontal coordinate systems, mostly sourced from EPSG database. Data from the normalised EPSG database is summarised and joined when populating this table. The table should be updated as new versions of the EPSG database are released.

No. Column name Data type Notes
1 CODE Varchar(20) Primary key
2 DESCRIPTION Varchar(200)  
3 TRANSLATION Varchar(80)  
4 EPSG_CODE Varchar(20)  
5 DATA_SOURCE Varchar(20)  
6 COORD_SYS_TYPE Varchar(40)  
7 DATUM_CODE Varchar(20)  
8 DATUM_TRANS Varchar(80)  
9 DATUM_ELLIPSOID Varchar(80)  
10 SOURCE_GEOGCS_CODE Varchar(20)  
11 PRIME_MERIDIAN Varchar(80)  
12 AREA_OF_USE_DETAILS Varchar(500)  
13 AREA_OF_USE_GROUP Varchar(10)  
14 COORD_TRF_EPSG_NAME Varchar(50)  
15 UNIT_OF_MEASURE_CODE Varchar(20)  
16 STATUS Char(1)  
17 DATE_ENTERED Date  
18 DATE_UPDATED Date  


Sample data (rows 1 to 20 of 3437)

CODE DESCRIPTION TRANSLATION EPSG_CODE DATA_SOURCE COORD_SYS_TYPE DATUM_CODE DATUM_TRANS DATUM_ELLIPSOID SOURCE_GEOGCS_CODE PRIME_MERIDIAN AREA_OF_USE_DETAILS AREA_OF_USE_GROUP COORD_TRF_EPSG_NAME UNIT_OF_MEASURE_CODE STATUS DATE_ENTERED DATE_UPDATED
2168  Pulkovo 1942(83) / Gauss Kruger zone 5  Pulkovo 1942(83) / Gauss Kruger zone 5  2168  EPSG v6.8  projected  6178  Pulkovo 1942/83  Krassowsky 1940  4178  Greenwich  Germany - east Germany - W of 10.5 deg E  WORLD    9001  C  03-JUN-07   
2169  Luxembourg 1930 / Gauss  Luxembourg 1930 / Gauss  2169  EPSG v6.8  projected  6181  Luxembourg 1930  International 1924  4181  Greenwich  Luxembourg  UK    9001  C  03-JUN-07   
2170  MGI / Slovenia Grid  MGI / Slovenia Grid  2170  EPSG v6.8  projected  6312  Militar-Geographische Institut  Bessel 1841  4312  Greenwich  Slovenia  WORLD    9001  C  03-JUN-07   
2171  Pulkovo 1942(58) / Poland zone I  Pulkovo 1942(58) / Poland zone I  2171  EPSG v6.8  projected  6179  Pulkovo 1942/58  Krassowsky 1940  4179  Greenwich  Poland - zone I  WORLD    9001  C  03-JUN-07   
2172  Pulkovo 1942(58) / Poland zone II  Pulkovo 1942(58) / Poland zone II  2172  EPSG v6.8  projected  6179  Pulkovo 1942/58  Krassowsky 1940  4179  Greenwich  Poland - zone II  WORLD    9001  C  03-JUN-07   
2173  Pulkovo 1942(58) / Poland zone III  Pulkovo 1942(58) / Poland zone III  2173  EPSG v6.8  projected  6179  Pulkovo 1942/58  Krassowsky 1940  4179  Greenwich  Poland - zone III  WORLD    9001  C  03-JUN-07   
2174  Pulkovo 1942(58) / Poland zone IV  Pulkovo 1942(58) / Poland zone IV  2174  EPSG v6.8  projected  6179  Pulkovo 1942/58  Krassowsky 1940  4179  Greenwich  Poland - zone IV  WORLD    9001  C  03-JUN-07   
2175  Pulkovo 1942(58) / Poland zone V  Pulkovo 1942(58) / Poland zone V  2175  EPSG v6.8  projected  6179  Pulkovo 1942/58  Krassowsky 1940  4179  Greenwich  Poland - zone V  WORLD    9001  C  03-JUN-07   
2176  ETRS89 / Poland CS2000 zone 5  ETRS89 / Poland CS2000 zone 5  2176  EPSG v6.8  projected  6258  European Terrestrial Reference System 1989  GRS 1980  4258  Greenwich  Poland - W of 16.5 deg E  WORLD    9001  C  03-JUN-07   
2177  ETRS89 / Poland CS2000 zone 6  ETRS89 / Poland CS2000 zone 6  2177  EPSG v6.8  projected  6258  European Terrestrial Reference System 1989  GRS 1980  4258  Greenwich  Poland - 16.5 to 19.5 deg E  WORLD    9001  C  03-JUN-07   
2178  ETRS89 / Poland CS2000 zone 7  ETRS89 / Poland CS2000 zone 7  2178  EPSG v6.8  projected  6258  European Terrestrial Reference System 1989  GRS 1980  4258  Greenwich  Poland - 19.5 to 22.5 deg E  WORLD    9001  C  03-JUN-07   
21780  Bern 1898 (Bern) / LV03C  Bern 1898 (Bern) / LV03C  21780  EPSG v6.8  projected  6801  CH1903 (Bern)  Bessel 1841  4801  Bern  Europe - Liechtenstein and Switzerland.  UK    9001  C  03-JUN-07   
21781  CH1903 / LV03  CH1903 / LV03  21781  EPSG v6.8  projected  6149  CH1903  Bessel 1841  4149  Greenwich  Europe - Liechtenstein and Switzerland.  UK    9001  C  03-JUN-07   
2179  ETRS89 / Poland CS2000 zone 8  ETRS89 / Poland CS2000 zone 8  2179  EPSG v6.8  projected  6258  European Terrestrial Reference System 1989  GRS 1980  4258  Greenwich  Poland - E of 22.5 deg E  WORLD    9001  C  03-JUN-07   
2180  ETRS89 / Poland CS92  ETRS89 / Poland CS92  2180  EPSG v6.8  projected  6258  European Terrestrial Reference System 1989  GRS 1980  4258  Greenwich  Poland  WORLD    9001  C  03-JUN-07   
21817  Bogota 1975 / UTM zone 17N  Bogota 1975 / UTM zone 17N  21817  EPSG v6.8  projected  6218  Bogota 1975  International 1924  4218  Greenwich  Colombia - offshore W of 78 deg W  WORLD    9001  C  03-JUN-07   
21818  Bogota 1975 / UTM zone 18N  Bogota 1975 / UTM zone 18N  21818  EPSG v6.8  projected  6218  Bogota 1975  International 1924  4218  Greenwich  Colombia - offshore Caribbean W of 72 deg W  WORLD    9001  C  03-JUN-07   
2188  Azores Occidental 1939 / UTM zone 25N  Azores Occidental 1939 / UTM zone 25N  2188  EPSG v6.8  projected  6182  Azores Occidental Islands 1939  International 1924  4182  Greenwich  Portugal - western Azores  WORLD    9001  C  03-JUN-07   
2189  Azores Central 1948 / UTM zone 26N  Azores Central 1948 / UTM zone 26N  2189  EPSG v6.8  projected  6183  Azores Central Islands 1948  International 1924  4183  Greenwich  Portugal - central Azores  WORLD    9001  C  03-JUN-07   
21891  Bogota 1975 / Colombia West zone  Bogota 1975 / Colombia West zone  21891  EPSG v6.8  projected  6218  Bogota 1975  International 1924  4218  Greenwich  Colombia - W of 75d 35m W  WORLD    9001  C  03-JUN-07