Skip to content. | Skip to navigation

Personal tools

Navigation

Complaint Arrow Questions or Comments:
ac@tceq.texas.gov
You are here: Home / Agency / TCEQ Data and Records / Look Up Data and Records Online / Industrial and Hazardous Waste (IHW) Datasets

Industrial and Hazardous Waste (IHW) Datasets

Texas Solid Waste Activity statewide files consist of three sets of extracts: IHW notice of registration data, IHW summary data, and reference tables affiliated with both NOR and summary data. Some are available for download here—others must be ordered.

Each file is an ASCII fixed length text file. The IHW dataset file specifications Microsoft Word Document and instructions to import into AccessAdobe Acrobat PDF Documentwill allow you to import the text files into a database program such as Access.

The IHW NOR data contains twelve files. The IHW summary data contains three files covering the past three years. The three reference table files affiliated with both the IHW NOR data and the summary data may also be downloaded if needed.

IHW Notice of Registration (NOR) Data

The following IHW datasets are current as of 3/2/2017.

  • facility (nor_ext_fac)
    contains the basic information for a site including registration number, registration type, company name, mailing address, site location, facility, contact, waste activities, and other notification information.
  • owner (nor_ext_own)
    contains the basic information for a facility owner including facility registration number, owner name, mailing address, phone, fax, email, business type, and tax ID. The mailing address, phone, fax, and email information is the information for the contact with role of owner or owner/operator. Only the most recent owner for the facility will be included in this file.
  • operator (nor_ext_oper)
    contains the basic information for a facility operator including facility registration number, operator name, mailing address, phone, fax, email, business type, and tax id.
  • contact (nor_ext_cont)
    contains the basic information for a facility contact including facility registration number, contact name, title, contact role, mailing address, phone, fax and email.
  • billing contact (nor_ext_billcont)
    contains billing contact information including billing contact name, title, phone, mailing address, customer number, and customer name.
  • waste (nor_ext_waste)
    contains information about a generator's wastes that are registered including registration number, Texas waste code, and the first 80 characters of the generator's waste description. This file also contains a waste id which is a unique id used by the PARIS IHW database for linking with other tables pertaining to waste. (See below for further explanation.) There may be zero to many waste records to one fac record and are linked to a fac record by registration number.
  • waste description (nor_ext_wastedesc)
    contains the customer's textual description of its wastes. This file contains the registration number, TCEQ unique facility id, waste id, Texas waste code, a sequence number for grouping a waste's multiple lines of descriptions and a single line of the waste description. There may be one to many waste description records per waste record and are linked to a waste record by waste id.
  • unit (nor_ext_unit)
    contains information about a registrant's waste management units where wastes are managed from on-site or off-site. Unit information includes registration number, unit sequence number and unit type. There may be zero to many unit records to one fac record and are linked by registration number.
  • unit description (nor_ext_unitdesc)
    contains the customer's textual description of its units. This file contains the registration number, TCEQ unique facility id, unit seq number and the unit description. There will be one record per unit and are linked to a unit record by unit seq number and registration number.
  • one-time shipper (nor_ext_ots)
    contains information on one-time shipment activities for facilities including the shipper unique ID number, site name, site address, and broker information.
  • unit waste (nor_ext_fac)
    contains a cross reference for a registration that indicates wastes that are currently managed onsite by a unit. This file contains the registration number, unit sequence number and the waste id. There may be many unitwst records to one unit record and/or many unitwst records to one waste record. The unitwst record is linked by registration number, unit sequence number and waste id.
  • EPA hazardous waste numbers (nor_ext_epawst)
    contains a list of EPA waste codes that are currently associated with a registered waste. This file contains the registration number, waste id and the EPA waste code. There may be many epawst records to one waste record and are linked by waste id.

IHW Summary Files

Annual Waste Summary

This file contains information from the TCEQ annual waste summary report form, including generator's registration number, year of report, waste, total quantity generated, quantity handled and how the waste was handled.

Waste Shipment Summary

This file contains information from the TCEQ waste shipment summary report form used by one-time generators. It contains the generator's registration number and name, the shipped date, waste, quantity shipped, who received the waste and how it was handled.

Monthly Waste Receipt Summary

These files have information from the TCEQ monthly waste receipts summary report form submitted by receivers of hazardous and Industrial Class 1 waste. It contains the receiver's registration number, the received date, waste code, quantity received, who shipped the waste and how it was handled.

IHW Reference Tables

The following three files are reference table files for both the NOR data and Summary data.

  • genref
    This file contains several tables of codes for the following:
    • county
    • TCEQ regions
    • measurement point
    • origin
    • system type
    • EPA system type
    • unit type
    • waste form
    • EPA waste form
    • waste source
    • EPA waste source
    • standard industrial classification
    • capacity units of measurement
  • eparef
    contains the EPA Hazardous waste code and the first 80 characters of EPA's description.
  • outstref
    contains the reference table for Foreign/Domestic out-of-state codes. This includes the numbers used for out of state receivers and shippers. This file contains the out-of-state code used by PARIS/STEERS, the name of the state or country and the state abbreviation if applicable.

If you have technical problems downloading files on this page, please contact us: orteam@tceq.texas.gov, 512-239-3282 (DATA) or fax 512-239-7106.