EZRRC
Cart Sign in

UIC Database (EBCDIC)

The injection well database in the original mainframe encoding.

What this is:

The same UIA010 records as the ASCII edition, encoded in EBCDIC.

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 84 columns and about 126.7K rows.

The columns you will most likely want:

  • record_type The two-byte record type from the original hierarchical file.
  • cntl_no The UIC control number. Primary key here, and the join key for the monitoring and remark tables.
  • next_available
  • next_dummy_lease Next available dummy lease number.
  • og_type Whether the associated lease is on the oil or gas schedule.
  • lease_id Lease identifier the injection well is on.

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

What we add:

Feed a reader that expects the original encoding. Otherwise take the ASCII edition, which EZRRC has parsed.

  • 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:

EBCDIC with packed decimals: the original is unreadable in a text editor. The decoded tables here are the same records, and are what you want unless you need the Commission's own encoding. The original is fixed 622-byte records where the ASCII edition writes each record type at its natural width.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: