UIC Monitoring Records
Queryable Fixed-width
The monitoring a UIC permit requires, and the results recorded.
Get the data
Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.
What this is
The monitoring records attached to a UIC permit: the date, the type of monitoring, the method used and the result.
What you can do with it
Check that a disposal well's required monitoring is actually being done, and find wells whose monitoring results were adverse.
Gotchas
Keyed on the UIC control number only — join to the inventory record to find out which well it is.
Monitoring type and method are short codes documented in the UIA010 manual's data-item notes rather than in a code table.
Record layout
7 columns. Byte positions are 1-based and come from the RRC record layout, so you can check our decoding against the original file yourself.
uic_monitoring
7 columns
| # | Column | Type | Bytes | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|---|
| 1 |
cntl_no
key
join
|
text | — | — | The UIC control number this monitoring row belongs to. | — |
| 2 |
monitor_date
|
date | 3-10 | UIC-MONITOR-DATE |
Date of the monitoring event. | — |
| 3 |
monitor_type
|
text | 11 | UIC-MONITOR-TYPE |
What was monitored. | — |
| 4 |
monitor_method
|
text | 12-41 | UIC-MONITOR-METHOD |
How it was monitored. | — |
| 5 |
monitor_result
|
text | 42-71 | UIC-MONITOR-RESULT |
The result recorded. | — |
| 6 |
row_no
key
|
integer | — | — | Sequence number of this row within its parent record. Part of the key. | — |
| 7 |
ingested_at
|
timestamptz | — | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
What this joins to
The Railroad Commission never states these keys anywhere in the files. They are the reason the data is hard to use, so here they are with the exact columns on both sides.
UIC Monitoring Records joins to UIC Database (ASCII) on Cntl number — many rows here share a single row there.
requires the monitoring
The monitoring attached to a UIC permit, keyed on the control number.
uic-database-ascii.cntl_no = uic-monitoring-records.cntl_no
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- Fixed-width Columns are byte ranges with no separators, described only in a scanned record layout.
- Update cadence
- Updated once a month (Monthly, with the UIC database.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.uic_monitoring
EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.