Oil or gas schedule
rrc.oil_gas_code
Which schedule a lease is carried on. This is not decoration: an oil lease number and a gas lease number can be the same digits and mean different leases, so a lease key is only unique with this code and the district in it.
2 of 2 codes
| Code | Means | Normalised | Valid |
|---|---|---|---|
O |
Oil Carried on the oil proration schedule; lease numbers are oil lease numbers. | — | always |
G |
Gas Carried on the gas proration schedule; lease numbers are gas well IDs. | — | always |
Columns that use these codes
| Dataset | Column | Meaning |
|---|---|---|
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. On THIS table it is 'O' on all 17,373 rows, at both ends of every pointer: the August 2026 tape records no consolidation or subdivision of a gas well at all, so a query filtered to gas returns nothing here and that is the file, not the filter. |
| Certificate of Authorization P-4 (Oil and Gas) | oil_gas_code |
Which schedule the lease is carried on: O an oil lease, G a gas well. 294,582 gas wells and 253,517 oil leases. Part of the key -- oil lease 27587 and gas well 27587 in the same district are different leases. |
| Certificate of Authorization P-4 (Oil and Gas) | to_oil_gas_code |
Schedule of the lease at the other end of the pointer. 'O' on every row, as oil_gas_code is: a pointer never crosses from the oil schedule to the gas one on this tape. |
| Full Wellbore Database (ASCII) | h15_oil_gas_code |
'O' or 'G' — which schedule the tested completion sits on. |
| Full Wellbore Database (ASCII) | oil_code |
'O' when the completion sits on the oil proration schedule. |
| Full Wellbore Database (ASCII) | oil_code |
'O' when the identifier is an oil lease identifier. |
| Full Wellbore Database (EBCDIC) | h15_oil_gas_code |
'O' or 'G' — which schedule the tested completion sits on. |
| Full Wellbore Database (EBCDIC) | oil_code |
'O' when the completion sits on the oil proration schedule. |
| Full Wellbore Database (EBCDIC) | oil_code |
'O' when the identifier is an oil lease identifier. |
| Horizontal Drilling Permits | oil_gas |
'O' when the validated completion is on the oil schedule and 'G' when it is on the gas schedule. It decides how validated_lease_no should be read, and which half of PDQ it joins to. |
| Oil & Gas Field Rules | oil_or_gas_code |
Which schedule this row describes: 'O' oil (33,981 rows) or 'G' gas (42,140). A field classed as both has two rows here, one each. |
| Oil & Gas Field Rules | oil_or_gas_code |
Which schedule this rule governs: 'O' oil (8,407 rules) or 'G' gas (11,344). A field classed as both can carry rules on each. |
| PDQ County Lease Production by Cycle | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ County Production by Cycle | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ Lease Disposition by Cycle | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ Lease Production by Cycle | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ Lease Summary (master) | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ Onshore Lease Summary | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ Regulatory Lease Directory | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| PDQ Well Completion Directory | oil_gas_code |
Whether the lease is carried on the oil schedule or the gas schedule. |
| Statewide API Data (dBase) | oil_gas_code |
Which proration schedule the well is or was carried on: 'O' oil (812,660 entries), 'G' gas (306,668). Null on 436,791, which is also where rrc_lease_id is all zeros. |
| Statewide Gas Well Database | oil_gas_code |
'G' on every row -- this is the gas tape. |
| Statewide Oil Well Database | oil_gas_code |
'O' on every row -- this is the oil tape. |
| Wellbore Completion Records | oil_code |
'O' when the completion sits on the oil proration schedule. |
| Wellbore H-15 Inactive Well Tests | h15_oil_gas_code |
'O' or 'G' — which schedule the tested completion sits on. |
| Wellbore Well Identifiers | oil_code |
'O' when the identifier is an oil lease identifier. |
Where this mapping came from: PDQ Dump user manual; values confirmed as the complete distinct set in texas.pdq_og_lease_cycle.oil_gas_code