34 of 34 codes

Permit well code — 34 of 34 codes, each with its meaning, normalised form and the years it is valid for
Code Means Normalised Valid
O OIL Oil well. Note that the pipeline writes this with a trailing space. OIL always
G GAS Gas well. GAS always
B O-G Oil and gas. O-G always
A ABANDONED Abandoned. ABANDONED always
C CORE Core hole. CORE always
D SALTWATER-DSP Saltwater disposal. SALTWATER-DSP always
E EXPL-TEST Exploratory test. EXPL-TEST always
F GAS-INJ Gas injection. GAS-INJ always
H OBSERVATION Observation well. OBSERVATION always
I SALTWATER-INJ Saltwater injection. SALTWATER-INJ always
J GPRES-GTHERM Geopressured or geothermal. GPRES-GTHERM always
K FLUID-INJ Fluid injection. FLUID-INJ always
L LQ-PET-GS-STG Liquid petroleum gas storage. LQ-PET-GS-STG always
M UNDERGRND-STG Underground storage. UNDERGRND-STG always
N GAS-STORAGE Gas storage. GAS-STORAGE always
P REENTER-PLUG Re-enter to plug. REENTER-PLUG always
Q AIR-INJ Air injection. AIR-INJ always
R RELIEF Relief well. RELIEF always
S SULFUR Sulphur. SULFUR always
T STRAT-TEST Stratigraphic test. STRAT-TEST always
U URANIUM Uranium. URANIUM always
V WATER-SUPPLY Water supply. WATER-SUPPLY always
W WATER-INJ Water injection. WATER-INJ always
X STREAM-INJ Steam injection. STREAM-INJ always
Y SLIM-HOLE-TST Slim hole test. SLIM-HOLE-TST always
Z COAL Coal. COAL always
1 TESTING-TOOLS Tool testing. TESTING-TOOLS always
2 CATH-PROT Cathodic protection. CATH-PROT always
3 SEISMIC-EQUIP Seismic equipment. SEISMIC-EQUIP always
4 WATER-SOURCE Water source. WATER-SOURCE always
5 GAS-COND Gas condensate. GAS-COND always
6 DOMESTIC Domestic use. DOMESTIC always
7 MONITOR Monitoring well. MONITOR always
8 DEMO Demonstration well. DEMO always

Columns that use these codes

Columns that read Permit well code, and the dataset each belongs to
Dataset Column Meaning
Drilling Permit Master and Trailer application_well_code What kind of well was proposed for this field at application time — O oil, G gas, B oil and gas, I injection, T exploratory and the rest of rrc.well_code. Nine values appear in 1,577,023 rows.
Drilling Permit Master and Trailer completion_well_code What kind of well was proposed at completion time, from the same code list. NULL on 965,228 rows: most permitted fields never got a completion.

Where this mapping came from: OilGasDataProcessing process_permits.wellCodeString (OGA049 field FLD-APPLICATION-WELL-CODE)