Vocabularies — details

DIC_UNIT_OF_MEASURE

Dictionary of measurement units used for a specific property; e.g. metres, centimetres, inches, chains, fathoms, kilograms, tons, pints, quarts, gallons, litres, square metres, cubic metres.

No. Column name Data type Notes
1 CODE Varchar(20) Primary key
2 DESCRIPTION Varchar(200)  
3 TRANSLATION Varchar(80)  
4 ABBREVIATION Varchar(15)  
5 EPSG_CODE Varchar(20)  
6 DATA_SOURCE Varchar(20)  
7 TARGET_UOM_CODE Varchar(20)  
8 CONV_FACTOR_NUMERATOR Numeric(22)  
9 CONV_FACTOR_DENOMINATOR Numeric(22)  
10 UNIT_OF_MEAS_DIMENSION Varchar(50)  
11 REMARKS Varchar(255)  
12 ORIG_INFORMATION_SOURCE Varchar(255)  
13 STATUS Char(1)  
14 DATE_ENTERED Date  
15 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 100)

CODE DESCRIPTION TRANSLATION ABBREVIATION EPSG_CODE DATA_SOURCE TARGET_UOM_CODE CONV_FACTOR_NUMERATOR CONV_FACTOR_DENOMINATOR UNIT_OF_MEAS_DIMENSION REMARKS ORIG_INFORMATION_SOURCE STATUS DATE_ENTERED DATE_UPDATED
9001  metre  metre  9001  EPSG  9001  length  Also known as International metre. SI standard unit.  ISO 1000.  26-APR-06   
9002  foot  foot  ft  9002  EPSG  9001  .3048  length    ISO 1000; 1958  26-APR-06   
9003  US survey foot  US survey foot  ft US  9003  EPSG  9001  12  39.37  length  Used in USA.  EPSG  26-APR-06   
9005  Clarke's foot  Clarke's foot  ft (Cla)  9005  EPSG  9001  .3047972654  length  Assumes Clarke's 1865 ratio of 1 British foot = 0.3047972654 French legal metres applies to the international metre. Used in older Australian, southern African & British West Indian mapping.  Australian Land Information Group www.auslig.gov.au  26-APR-06   
9014  fathom  fathom  9014  EPSG  9001  1.8288  length  = 6 feet.    26-APR-06   
9030  nautical mile  nautical mile  NM  9030  EPSG  9001  1852  length      26-APR-06  26-APR-06 
9031  German legal metre  German legal metre  GLM  9031  EPSG  9001  1.0000135965  length  Used in Namibia.  Chief Directorate Surveys and Land Information; Mowbray; South Africa  26-APR-06   
9033  US survey chain  US survey chain  ch US  9033  EPSG  9001  792  39.37  length  Used in USA primarily for public lands cadastral work.  Bureau of Land Management technical bulletin 6 (1973) and Standard Field Tables 8th edition (1956).  26-APR-06   
9034  US survey link  US survey link  lk US  9034  EPSG  9001  7.92  39.37  length  Used in USA primarily for public lands cadastral work.  Bureau of Land Management technical bulletin 6 (1973) and Standard Field Tables 8th edition (1956).  26-APR-06   
9035  US survey mile  US survey mile  mile US  9035  EPSG  9001  63360  39.37  length  Used in USA primarily for public lands cadastral work.  Bureau of Land Management technical bulletin 6 (1973) and Standard Field Tables 8th edition (1956).  26-APR-06