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 to populate 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 10 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