Vocabularies — details

DIC_CRS_VERT_CS

Dictionary of vertical coordinate systems, mostly sourced from EPSG database and FGDC. 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 VERT_CS_TYPE Varchar(30)  
7 VERT_DATUM_CODE Varchar(20)  
8 VERT_DATUM_TRANS Varchar(80)  
9 VERT_DATUM_TYPE Varchar(30)  
10 AREA_OF_USE_DETAILS Varchar(500)  
11 AREA_OF_USE_GROUP Varchar(10)  
12 UNIT_OF_MEASURE_CODE Varchar(20)  
13 STATUS Char(1)  
14 DATE_ENTERED Date  
15 DATE_UPDATED Date  


Sample data (rows 1 to 20 of 172)

CODE DESCRIPTION TRANSLATION EPSG_CODE DATA_SOURCE VERT_CS_TYPE VERT_DATUM_CODE VERT_DATUM_TRANS VERT_DATUM_TYPE AREA_OF_USE_DETAILS AREA_OF_USE_GROUP UNIT_OF_MEASURE_CODE STATUS DATE_ENTERED DATE_UPDATED
5600  NGPF  NGPF  5600  EPSG v6.8  vertical  5195  Nivellement General de Polynesie Francaise  vertical  French Polynesia - Society Islands - main islands  WORLD  9001  22-MAY-07   
5601  IGN 1966  IGN 1966  5601  EPSG v6.8  vertical  5196  IGN 1966  vertical  French Polynesia - Society Islands - Tahiti  WORLD  9001  22-MAY-07   
5602  Moorea SAU 1981  Moorea SAU 1981  5602  EPSG v6.8  vertical  5197  Moorea SAU 1981  vertical  French Polynesia - Society Islands - Moorea  WORLD  9001  22-MAY-07   
5603  Raiatea SAU 2001  Raiatea SAU 2001  5603  EPSG v6.8  vertical  5198  Raiatea SAU 2001  vertical  French Polynesia - Society Islands - Raiatea  WORLD  9001  22-MAY-07   
5604  Maupiti SAU 2001  Maupiti SAU 2001  5604  EPSG v6.8  vertical  5199  Maupiti SAU 2001  vertical  French Polynesia - Society Islands - Maupiti  WORLD  9001  22-MAY-07   
5605  Huahine SAU 2001  Huahine SAU 2001  5605  EPSG v6.8  vertical  5200  Huahine SAU 2001  vertical  French Polynesia - Society Islands - Huahine  WORLD  9001  22-MAY-07   
5606  Tahaa SAU 2001  Tahaa SAU 2001  5606  EPSG v6.8  vertical  5201  Tahaa SAU 2001  vertical  French Polynesia - Society Islands - Tahaa  WORLD  9001  22-MAY-07   
5607  Bora Bora SAU 2001  Bora Bora SAU 2001  5607  EPSG v6.8  vertical  5202  Bora Bora SAU 2001  vertical  French Polynesia - Society Islands - Bora Bora  WORLD  9001  22-MAY-07   
5701  Newlyn  Newlyn  5701  EPSG v6.8  vertical  5101  Ordnance Datum Newlyn  vertical  UK - Great Britain mainland  UK-COMMON  9001  22-MAY-07   
5702  National Geodetic Vertical Datum of 1929  National Geodetic Vertical Datum of 1929  5702  EPSG v6.8  vertical  5102  National Geodetic Vertical Datum 1929  vertical  USA - conus  WORLD  9003  22-MAY-07   
5703  North American Vertical Datum of 1988  North American Vertical Datum of 1988  5703  EPSG v6.8  vertical  5103  North American Vertical Datum 1988  vertical  North America - NAVD88  WORLD  9001  22-MAY-07   
5704  Yellow Sea  Yellow Sea  5704  EPSG v6.8  vertical  5104  Yellow Sea 1956  vertical  China  WORLD  9001  22-MAY-07   
5705  Baltic  Baltic  5705  EPSG v6.8  vertical  5105  Baltic Sea  vertical  Europe - Soviet Union, Slovakia  WORLD  9001  22-MAY-07   
5706  Caspian  Caspian  5706  EPSG v6.8  vertical  5106  Caspian Sea  vertical  Asia - Caspian Sea  WORLD  9001  22-MAY-07   
5709  Normaal Amsterdams Peil  Normaal Amsterdams Peil  5709  EPSG v6.8  vertical  5109  Normaal Amsterdams Peil  vertical  Netherlands - onshore  UK  9001  22-MAY-07   
5710  Oostende  Oostende  5710  EPSG v6.8  vertical  5110  Oostende  vertical  Belgium - onshore  UK  9001  22-MAY-07   
5711  Australian Height Datum  Australian Height Datum  5711  EPSG v6.8  vertical  5111  Australian Height Datum  vertical  Australia - mainland  WORLD  9001  22-MAY-07   
5712  Australian Height Datum (Tasmania)  Australian Height Datum (Tasmania)  5712  EPSG v6.8  vertical  5112  Australian Height Datum (Tasmania)  vertical  Australia - Tasmania  WORLD  9001  22-MAY-07   
5713  Canadian Geodetic Vertical Datum of 1928  Canadian Geodetic Vertical Datum of 1928  5713  EPSG v6.8  vertical  5114  Canadian Geodetic Vertical Datum of 1928  vertical  Canada - CVD28  WORLD  9001  22-MAY-07   
5714  mean sea level height  mean sea level height  5714  EPSG v6.8  vertical  5100  Mean Sea Level  vertical  World  UK-COMMON  9001  22-MAY-07