Vocabularies — details


This table provides expansions of the well drilling purpose codes used in the Well Data Table (WELL_DATA). A primary key constraint has been included.

No. Column name Data type Notes
1 WELL_TYPE Varchar(3) Primary key
2 PURPOSE Varchar(32)  

Sample data (rows 1 to 7 of 7)

HYD  Hydrocarbon exploration 
MIN  Mineral exploration 
STO  Gas storage (salt cavern) 
UNK  Unknown 
WAT  Water extraction 
COA  Coal exploration 
GEO  Geological survey