EZRRC
Cart Sign in

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.

What this is:

The 08 GSFLDRUL segment of the statewide field tape.

How it is laid out:

The Railroad Commission publishes this as EBCDIC (IBM cp037). IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first. We decode it into a table you can open anywhere. It has 28 columns and about 14K rows.

The columns you will most likely want:

  • district_no RRC district as the FL tape stores it, 01 to 14 — the INTERNAL number, not the designation the industry prints.
  • field_no The eight-digit RRC field number: five digits of field, then three of reservoir.
  • rule_seq Which rule under this field, counting from 1 in the order the tape carries them — newest first, the undated rule last.
  • rule_effective_date When this gas rule took effect.
  • proration_eff_date Date the allocation formula took effect for this prorated field, CCYYMMDD on the tape.
  • proration_suspend_date When the allocation formula was suspended for the field. Filled on 2,992 rules.

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

What we add:

Find every field on a given density: 40-acre units, 80-acre units, 660-foot lease lines, corner-to-corner diagonals. Follow one field's rules back through their revisions, since the tape keeps the superseded ones with their suspension dates.

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.

Worth knowing before use:

rule_effective_date is null on 7,496 of the 13,951 rules. The tape keys a rule on 99999999 minus its effective date, and those carry the bare 99999999: the standing rule with no order date behind it. That is why rules are numbered by position (rule_seq, 1 being the newest) rather than dated.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

  • 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.
  • Oil & Gas Field Rules Every Texas field with the spacing and density rules the Commission adopted for it.
  • Field Monthly Statistics (Allowables and Production) Field-level monthly allowables beside the P-1 and P-2 production actually reported. 4.0 million field-months, and no other RRC file has them.
  • Field Gas Information The gas half of a field's master record: discovery, testing cycle, offshore code and cumulative gas and condensate.
  • Field Oil Information The oil half of a field's master record: discovery, testing county, schedule headings and cumulative oil and casinghead gas.
  • 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.