Oil & Gas Field Rules

What this is:

The Commission's online Field Rules data, as four related tables: 65,836 fields, 76,121 per-schedule field records, 19,751 field-specific spacing rules and the 7 standard rules that apply where a field has none of its own.

How it is laid out:

The Railroad Commission publishes this as Delimited text. Separated text, usually with an unusual delimiter such as a brace. We decode it into a table you can open anywhere. It has 48 columns and about 65.8K rows.

The columns you will most likely want:

• field_number The eight-digit field number the Oil & Gas Division's field designation section assigns.
• field_name The field name: an operator's word, the stratigraphic interval and usually the depth, e.g. JOHNSON FRIO 4700.
• field_id Oracle's surrogate key, and what the other three tables in this export are joined on.
• field_class_code 'O' oil (23,696 fields), 'G' gas (31,894) or 'B' both (10,246).
• modified_by The process that last wrote the row in RRC's Oracle database.
• field_h2s_flag Whether hydrogen sulfide has been reported in the field, from the operator's Form H-9 statewide rule 36 certificate: 'N' none (62,760 fields), 'Y' present (2,950), 'E' present but exempt from filing (126).

…and 42 more, all documented on the full page.

What we add:

Check the spacing and density governing a field before you evaluate a location: minimum lease-line distance, minimum well-to-well distance and acres per unit, with the depth-banded statewide default to fall back on when the field has no special rules.

There is more on the full page, including what this joins to.

• Decoded out of the Commission's original format into something Excel opens.
• Filterable before you download, so you can take one county instead of the whole state.
• The Commission's single-letter codes translated into words.

People who want this usually want:

• PDQ Field Directory The field number to field name lookup, with class, discovery date and rules flags.
• Oil & Gas Field Name & Numbers The eight-digit field number to field name lookup, as RRC publishes it.
• Statewide Field Data The mainframe's field master: every oil and gas field in Texas with its rules, its allocation formulas and 10.5 million rows of allowable and production history.
• Field Gas Rules (Mainframe) 13,951 gas field rules as the IMS database holds them: spacing, density, casing, diagonal, docket and the analyst's own text.
• Field Oil Rules (Mainframe) 8,565 oil field rules as the IMS database holds them, with the allocation code that says how the field's allowable is split.
• Gas Annual Report Field Table Annual gas production, condensate and well counts, per field, statewide.