Skip to content. | Skip to navigation

Personal tools

Navigation

Questions or Comments:
orteam@tceq.texas.gov
You are here: Home / Administrative Services / Data / Industrial and Hazardous Waste (IHW) Datasets

Industrial and Hazardous Waste (IHW) Datasets

Texas Solid Waste Activity statewide files from TRACs IHW system.

IHW Notice of Registration (NOR) Data

facility
contains the basic information for a site including registration number, registration type, company name, mailing address, site location, facility, contact and other notification information.
owner
contains the basic information for a facility owner including facility registration number, owner name, mailing address, phone, fax, email, business type, tax id and bankruptcy code.
operator
contains the basic information for a facility operator including facility registration number, operator name, mailing address, phone, fax, email, business type, tax id and bankruptcy code.
contact
contains the basic information for a facility contact including facility registration number, contact name, title, contact role within TCEQ, mailing address, phone, fax and email.
billing contact
contains billing contact information including billing contact name, title, phone, mailing address, customer number, customer name, and attention.
business description
contains facility registration number and company business description.
activities
contains the basic information defining used oil, waste fuel and handler activities including registration number, facility id, an activity type code, and the activity description.
waste
contains information about a generator's wastes that are registered including registration number, Texas old waste code (six digit), Texas new waste code (eight digit) 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 TRACS IHW system 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
contains the customer's textual description of its wastes. This file contains the registration number, TCEQ unique facility id, waste id, Texas 6-digit waste code, Texas 8-digit 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
contains information about a registrant's unit where wastes are managed onsite or offsite. 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
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
contains information on one-time shipment activities for facilities including the shipper registration number, site name, site address, broker information and details on the individual shipments.
unitwst
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.
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.
numhist
contains a list of current and historized registration and permit numbers associated with facilities. Each record contains a status value, a begin date and, when historized, an end date. Records are linked to hsw_fac records via the facility id.
IHW Notice of Registration (NOR) Data Microsoft Word Document
contains information on the data fields.

IHW Summary Files

The following 5 to 8 files would be included in a request for summary data. Three of the files are actual data files from the summary reports that are reported by waste receivers, generators and shippers in Texas. The last two files are reference tables used by receivers and shippers to designate out-of-state numbers for states and countries.

annual
Available January 2010, to order call 239-Data (512-239-3676), there will be a charge. This file contains the same information that comes from the TCEQ annual waste summary report form (yellow), including generator's registration number, year of report, waste, total quantity generated, quantity handled and how the waste was handled.
ship
Historical data available only. Call 239-Data (512-239-3676) to order, there will be a charge. This file contains the same information that comes from the TCEQ waste shipment summary report form (green). 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 records
Following are the monthly waste receipt records. There may actually be four identical receiver data files; one per quarter of a calendar year. Each file holds information that comes from the TCEQ monthly waste receipts summary report form (pink). It contains the receiver's registration number, the received date, waste code, quantity received, who shipped the waste and how it was handled.

2013 Monthly Waste Receipts

2012 Monthly Waste Receipts

2011 Monthly Waste Receipts

2010 Monthly Waste Receipts

2009 Monthly Waste Receipts

outstref
contains the reference table for out-of-state codes. This includes the numbers (01 - 99) used for out of state receivers and shippers. This file contains the out-of-state code used by IHW TRACS, the name of the state or country and the state abbreviation if applicable.
newoutstref
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 IHW TRACS, the name of the state or country and the state abbreviation if applicable.

IHW Reference Tables

The following three files are reference table files. They will be needed for requests for both the NOR data and Summary data.

genref
this is a file that 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
wstoldref
this file contains the five digit waste code without the waste classification and the first 80 characters of the old waste description. This file references the six digit Texas waste codes, which will eventually be phased out.
eparef
contains the EPA Hazardous waste code and the first 80 characters of EPA's description.