Vocabularies — details

DIC_EQUIPMENT_TYPE

Dictionary of BGS drilling equipment types that can be booked out.

No. Column name Data type Notes
1 CODE Varchar(6) Primary key
2 DESCRIPTION Varchar(2000)  
3 TRANSLATION Varchar(50)  
4 STATUS Varchar(1)  
5 DATE_ENTERED Date  
6 DATE_UPDATED Date  


Sample data (rows 1 to 4 of 4)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
DANDO TERRIER 2002 DRILLING RIG  DANDO TERRIER DRILLING RIG  13-SEP-06  28-MAR-07 
Not Available - Applicable but try as we might,we can't find a value.  Not Available  28-MAR-07   
Not Applicable  Not Applicable  28-MAR-07   
Not Entered - We haven't assigned a value yet  Not Entered  28-MAR-07   
OpenGeoscience
Maps and viewers
Apps
Data collections
Data downloads
Scans and photos
Web services