Table Name: TRI_WATER_STREAM

Description: The name of the stream, river, lake, or other water body to which the chemical is discharged. The name is listed as it appears on the NPDES permit, or, if the facility does not have a NPDES Permit, as the water body is publicly known. This is not a list of all streams through which the toxic chemical flows but is a list of direct discharges. If more than one name is listed, the facility has a separate discharge to each water body listed. (Data in TRI_WATER_STREAM were submitted on EPA Form R , Part II, Section 5, 'Quantity of the Toxic Chemical Entering each Environmental Medium'. See specific 'Data Source' for each column.)


Columns:

• DOC_CTRL_NUM
• REACH_CODE
• STORM_WATER_NA
• STORM_WATER_PERCENT
• STREAM_NAME
• WATER_SEQUENCE_NUM

Envirofacts Data Service API for TRI_WATER_STREAM: 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_WATER_STREAM table. The URL used to produce this output is:
https://data.epa.gov/efservice/TRI_WATER_STREAM/ROWS/0:10/EXCEL