UIC Permit Remarks
Queryable Fixed-width
What the district office wrote on a UIC permit.
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
Free-text remarks recorded against a UIC permit — conditions, correspondence, the reasoning behind a decision.
What you can do with it
Read the conditions attached to a disposal permit in the Commission's own words.
Gotchas
Line-wrapped continuations keyed on the control number and a row number. Order and concatenate to read one.
Record layout
4 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_permit_remarks
4 columns
| # | Column | Type | Bytes | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|---|
| 1 |
cntl_no
key
join
|
text | — | — | The UIC control number this remark belongs to. | — |
| 2 |
remark_text
|
text | 3-72 | UIC-REMARK-TEXT |
One line of free-text permit remark. Order by row number to rebuild it. | — |
| 3 |
row_no
key
|
integer | — | — | Sequence number of this row within its parent record. Part of the key. | — |
| 4 |
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 Permit Remarks joins to UIC Database (ASCII) on Cntl number — many rows here share a single row there.
carries the remarks
The district office's free-text remarks on the permit, keyed on the control number.
uic-database-ascii.cntl_no = uic-permit-remarks.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_permit_remarks
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.