Table Name: TRI_ONSITE_WASTESTREAM

Description: On-site waste treatment is the application of any of a variety of different activities or methods to the waste stream containing the toxic chemical being reported. Waste streams are reported separately by the physical type of the waste stream (i.e., gaseous, wastewater, liquid, or solid). All waste treatment methods through which the toxic chemical passes as part of that waste stream, regardless of whether or not the method has, or is intended to have, any effect on the toxic chemical is listed . The overall treatment efficiency (removal of the toxic chemical from the waste stream) is also reported. (Data in TRI_ONSITE_WASTESTREAM were submitted on EPA Form R, Part II, Section 7A, 'On-Site Waste Treatment Methods and Efficiency'. See specific 'Data Source' for each column.)


Columns:

• DOC_CTRL_NUM
• EFFICIENCY_RANGE_CODE
• INFLUENT_CONC_RANGE
• OPERATING_DATA_IND
• SEQUENTIAL_TREAT_87_90
• TREATMENT_EFFICIENCY_EST
• TREATMENT_EFFICIENCY_EST_NA
• WASTESTREAM_CODE
• WASTESTREAM_SEQ_NUM

Envirofacts Data Service API for TRI_ONSITE_WASTESTREAM: Envirofacts has developed a RESTful data service API to all of its internal data holdings. This functionality provides a user of Envirofacts with the ability to query any table through the use of a URL. The default output is in XML, which can be utilized in other applications, as well as tools such as Microsoft Excel or Access. Output options of CSV and Excel can be requested in the URL. The entire Envirofacts database metadata is available online, so that all tables and columns within Envirofacts are documented. Having the table structures available in this manner makes most of Envirofacts data easily available through the service. More information is available on the Envirofacts Services page.

Below is a sample of the first 10 rows of data for the TRI_ONSITE_WASTESTREAM table. The URL used to produce this output is:
https://data.epa.gov/efservice/TRI_ONSITE_WASTESTREAM/ROWS/0:10/EXCEL