Texas Railroad Commission RRC - Convert EBCDIC Oil and Gas Data Sets

The filters below work with TextPipe Pro (and above) to convert specific file types. They offer a quick-start and demonstrate best practices for working with TextPipe Pro.

Note - you still need TextPipe Pro to work with these filters - it is not bundled.

Oil & Gas Field Data
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) Statewide Field Data This filter works with the following Data Set: * Statewide Field Data Record Types
  • 01 FLDROOT Field Information
  • 02 GASSEG Field Gas Information
  • 03 FLMKTDMD Field Gas Market Demand Forecast
  • 04 OPRMKTDM Field Gas Operator Market Demand Forecast
  • 05 FLMKTRMK Field Gas Market Demand Remark
  • 06 FLSUPRMK Field Market Demand Supplement Adjustment Remark
  • 07 GASCYCLE Field Gas Cycle Information
  • 08 GSFLDRUL Field Gas Rule
  • 09 GASAFORM Field Gas Allocation Formula
  • 10 GASRMRKS Field Gas Remarks
  • 11 GSCOUNTY Gas County
  • 12 GASAFACT Field Gas Allocation Factors
  • 13 ASHEET A-Sheet Balancing Period
  • 14 ASHEETMO A-Sheet Monthly Information
  • 15 FLT3ROOT T-3 Root
  • 16 FLDT3 T-3 Form
  • 17 FLDMO Field Monthly Statistics
  • 18 CALC
  • 49B Field
  • 49(B) Calculations
  • 19 OILSEG Field Oil Information
  • 20 OILCYCLE Field Oil Cycle Information
  • 21 OLFLDRUL Field Oil Rules
  • 22 OILAFORM Field Oil Allocation Formula
  • 23 OILRMRKS Field Oil Remarks
  • 24 OILFTROT Field Oil Factors Root
  • 25 OILAFACT Field Oil Allocation Factors
  • 26 OLCOUNTY Oil County
  • 27 ASSOCGAS Associated Gas Fields
  • 28 FLDMAP Field Map Index
  • 29 GSOPTRUL Field Gas Optional Rule
  • 30 OLOPTRUL Field Oil Optional Rule
Each record type (of 30 types) gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by David Johnson)

Production Data
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) - Gas Ledger Dist. This filter works with the following Data Sets:
  • Gas Ledger Dist 1,2,3
  • Gas Ledger Dist 4, 5, 6, 6E
  • Gas Ledger Dist 7B, 7C, 8, 8A, 9, 10
Each record type (1. Gas Field Information, 5. Gas Well Information) gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by David Johnson)
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) - Oil Ledger Dist. This filter works with the following Data Sets:
  • Oil Ledger Dist 1 & 2
  • Oil Ledger Dist 3
  • Oil Ledger Dist 4
  • Oil Ledger Dist 5 And 6
  • Oil Ledger Dist 6E
  • Oil Ledger Dist 7B
  • Oil Ledger Dist 7C
  • Oil Ledger Dist 8
  • Oil Ledger Dist 8A
  • Oil Ledger Dist 9
  • Oil Ledger Dist 10
Each record type (1. Oil Field, 3. Oil Lease, 4. Oil Multi-Well, 5. Oil Well) gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by David Johnson)
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) - Historical Ledger. This filter works with the following Data Sets:
  • Historical Ledger – Statewide Gas
  • Historical Ledger – Statewide Oil
Record Types:
  • 01 LDROOT Root Segment
  • 02 LDGSDATA Gas Lease/RRCID Cycle data Segment
  • 03 LDGASDSP Gas Disposition Segment
  • 04 LDGCONDS Gas Condensate Disp. & Stock Adjustment Segment
  • 05 LDGSTAT Gas Balancing Period Segment
  • 06 LDOLDATA Oil Lease Cycle Data Segment
  • 07 LDOILDSP Oil Disposition & Stock Adjustment Segment
  • 08 LDOCSHDS Oil Casinghead Disposition Segment
Each record type (01-08) gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by David Johnson)
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) Statewide Production Data Oil - from ftp://ftpe.rrc.texas.gov/shpdo Each record type
  • Root Segment - Oil Version
  • Reporting Cycle Segment
  • Production Segment
  • Prod Report Discrepancy Removal Segment
  • Disposition & Stock Adjustment Segment
  • Casinghead Disposition Segment
  • Previous Production Report Segment
  • Commingle Permit Segment
  • Commingle Production Segment
  • Commingle Oil Disposition Segment
  • Commingle Oldest Ending Balance Segment
  • Commingle Previous Production Report Segment
  • Previous Allowable Segment
  • Production Remarks Segment
  • Production Oil Disposition Remarks Segment
  • Production Oil Commingle Dispostion Remarks Segment
gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by DataMystic)
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) Statewide Production Data Gas - from ftp://ftpe.rrc.texas.gov/shpdg Each record type
  • Root Segment - Gas Version
  • Reporting Cycle Segment
  • Production Report Segment
  • Disposition Segment
  • Condensate Disposition & Stock Adjustment Segment
  • Commingle Permit Production Segment
  • Balancing Period Segment
  • Reinstated Underage Segment
  • Previous Production Report Segment
  • Production Remarks Segment
  • Production Gas Dispostion Remarks Segment
  • Production Condensate Dispostion Remarks Segment
  • Gas Separation Extract Loss Segment
      • gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by DataMystic)

Oil & Gas Well Data
Box shot EBCDIC to ASCII conversion of Railroad Commission of Texas (RRC) - Wellbore. This filter works with the following Data Sets:
  • Full Wellbore
  • 3 Month Wellbore
Each record type (of 28 types) gets split into different files according to its record layout, ready to load in CSV, Tab-delimited, JSON, XML or SQL Insert script format. ( $199, provided by David Johnson)

If you're a TextPipe developer and you'd like to offer your filters here, please contact us.