PDQ Field Directory
The field number to field name lookup, with class, discovery date and rules flags.
What this is
One of the sixteen delimited tables inside the monthly Production Data Query dump. RRC publishes the dump as a single archive; EZRRC publishes each table inside it separately so you can take the one you need instead of a 3.6 GB zip.
65,000 fields: number, name, district, class, wildcat flag, hydrogen sulphide flag, salt dome flag, offshore code, discovery dates and the derived rule type — separately for the oil …
How it is laid out
The Railroad Commission publishes this as CSV. Comma-separated text. We decode it into a table you can open anywhere. It has 33 columns and about 65.8K rows.
The columns you will most likely want:
-
field_noThe eight-digit RRC field number. The field's name is not in most files; join to the field directory … -
field_nameField name. -
district_noRRC's INTERNAL district number, 01 to 14 plus 20 for statewide. This is not the district name the … -
district_nameRRC district as the industry writes it, e.g. 7B, 8A, 6E. -
field_classA field is classified as an oil field, a gas field, or as both oil and gas. If … -
field_h2s_flagThe values below indicates if hydrogen sulfide is present in the well. N - No hydrogen sulfide present …
…and 27 more, all documented on the full page.
What we add
Turn eight-digit field numbers into names, find every field discovered in a given year, and identify sour or offshore fields.
- 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.
Worth knowing before you use it
Almost every attribute exists twice, prefixed o_ for the oil schedule and g_ for the gas schedule. They frequently differ.
A field number is not unique across districts.
The full page lists every trap in this dataset.