Custom Search Results Help

Users can generate customized downloads of loadings data using the Custom Search. On the results page, the DMR Loading Tool generates a comma separated value (CSV) file of the data. The CSV results file can be transferred to an offline database program or spreadsheet program for further analysis. The Custom Search can provide pollutants loadings at three levels of detail: annual, facility, or monitoring period.

Instructions

The results page displays your selected search criteria and results column available for download. Uncheck any fields that you do not want to be included in your data file. Note that some fields are required and cannot be unchecked. For background information about pollutants loadings data and calculations, refer to the Technical Support Document or the Loading Tool Frequently Asked Questions (FAQs).

Data Fields Available for Custom Search Download by Level of Detail
 AnnualMonitoring PeriodFacility Data Type/Expected Values
Actual Average Facility Flow (MGD)XXXNumber
Average Concentration (mg/L)XX Number
Average Daily Flow (MGD)XX Number
Average Daily Load (kg/day)XX Number
Average Wastewater pHXX Number
Average Wastewater Temp (°F)XX Number
CAS NumberXX Number
Chemical NameX  Text
CityXXXText
Congressional DistrictXXXNumber
CountyXXXText
DMR Measurements X Number
CWNS ID(s)XXXNumber
EPA RegionXXXNumber
Estimation FactorX  Number
Facility Info Only  XY/N
Facility LatitudeXXXNumber
Facility LongitudeXXXNumber
Facility NameXXXText
Facility Type IndicatorXXXText
FRS IDXXXNumber
Has Loadings Data  XY/N
Has Permit Limits  XY/N
Includes non-detectsXX Y/N
Industrial Sector ID (SIC Code)XXXNumber
Impairment ClassXXXNumber
Limit Set Designator X Number
Listed for ImpairmentXXXY/N
Load Over Limit (Option 1) (kg/yr) or (kg/period)XXXNumber
Load Over Limit (Option 2) (kg/yr) or (kg/period)XXXNumber
NAICS CodeXXXNumber
Major/Minor StatusXXXM (major) or N (non-major)
Max Allowable Load (kg/yr) or (kg/period)XXXNumber
Measurement Type X Avg/min/max conc/quantity
Monitoring Location CodeXX Number
NPDES Permit NumberXXXText
Number of Combined Sewer Overflow (CSO) OutfallsXXXNumber
Number of Report X 1 or 0
Outfall NumberXX Number
Parameter CodeXX Number
Parameter DescriptionXX Text
Period: Year or Monitoring DateXXXYear (YYYY)
Permit Effective DateXXXMM/DD/YYYY
Permit Expiration DateXXXMM/DD/YYYY
Permit Feature Latitude X Number
Permit Feature Longitude X Number
Permit LimitsXX Number
Permit TypeXXXText
Pollutant Load (kg/yr) or (kg/period)XX Number
Potential OutlierXXXY/N
Reach CodeXXXNumber
Season Number X 0 or 1
StateXXX2 letter abbreviation
Substance Registry System IDXX Number
Total Facility Design Flow (MGD)XXXNumber
Total Facility Flow (MGal/yr)  XNumber
Total Facility Load (kg/yr) or (kg/period)  XNumber
Toxic Weighting Factor (TWF)XX Number
TRI ID(s)X  Text
TRI Direct ReleaseX  Number
TRI Indirect ReleaseX  Number
Wastewater Flow (MGal/yr) or (MGal/period)XX Number
Watershed ID (12-Digit HUC)XXXNumber
Watershed NameXXXText
Waterbody NameXXXText
ZIP CodeXXXNumber

Top of Page


Results Guide

Basic Record Information — Required Fields

Period: Year or Monitoring Date
The end date of the monitoring period for the pollutant discharge.
NPDES Permit Number
A nine-character code used to uniquely identify a permitted NPDES facility (NPDES ID). The NPDES permit program regulates the direct discharge of pollutants into US waters. A NPDES ID is provided for every facility.
Facility Name
The primary name used to identify a facility.

Facility Information

Industrial Sector ID (SIC Code)
Four-digit code that describes the primary activity of the facility as part of the U.S. Standard Industrial Classification System (SIC). The two-digit code defines a major business sector; the four-digit code contains two additional numbers that denote a facility's specialty within the major sector. See the U.S. Department of Labor website for more information.Note: SIC codes are not required to be reported in ICIS-NPDES.
NAICS Code
Six-digit code that identifies NAICS industries and has replaced the U.S. Standard Industrial Classification (SIC) system. The first two-digits represent the industry sector, in which there exist 20 broad sectors. The third digit represents the industry subsector, the fourth digit represents the industry group, the fifth digit represents the industry, and the sixth digit specifies the country (i.e. U.S., Canada, or Mexico). See the U.S. Census website for more information. NAICS codes are not required in ICIS-NPDES.
FRS ID
FRS ID is the 12-character code used to uniquely identify a facility site within the EPA Facility Registry System (FRS) database. The code is also known as the UIN (Unique Identification Number). A FRS ID is assigned to every facility in ICIS-NPDES.
TRI ID
15-character code used to uniquely identify facilities in EPA's TRI database.  
CWNS ID(s)
A unique identifier for facilities in EPA's Clean Watershed Needs Survey (CWNS) database. Most facilities identified are publicly owned treatment works (POTWs). Every four years the EPA and states conduct the survey to determine the capital needs for municipal wastewater treatment facilities to meet the goals in the Clean Water Act. Only municipal wastewater treatment plants report to CWNS. This field is not displayed for industrial dischargers.
Facility Type Indicator
Facility ownership classification derived from codes in ICIS-NPDES. Facilities can be classified as publicly-owned treatment works (POTW), non-POTW, federal, or state.
Permit Type
The permit classification in the DMR Pollutant Loading Tool. These classifications include the following: NPDES Individual Permit (NPD), NPDES Master General Permit (NGP), General Permit Covered Facility (GPC), State Issued Master General Permit (SNN), Individual IU Permit (IUU), Individual State Issued Permit (SIN).
Permit Effective Date
The date the most recent permit in the selected date range became effective.
Permit Expiration Date
The date the most recently issued permit in the selected date range expires.
City
The city name for the facility location. City names can be blank in FRS and ICSI-NPDES.
State
The two-character state abbreviation for the facility location.
ZIP Code
The 5-digit mail code for the facility address. Zip codes are not required in FRS or ICIS-NPDES.
County
The county name for the facility location. County names can be blank in FRS or ICIS-NPDES.
EPA Region
The EPA-designated area that U.S. States, territories, and tribes are assigned to. The U.S. is divided into 10 EPA Regions
Congressional District
An electoral constituency that elects a single member of a congress. There are 435 congressional districts in the U.S. Congressional District information can be blank in FRS.
Facility Latitude
The latitude coordinate for the facility location in units of decimal degrees. Latitude and longitude coordinates are not required to be entered in FRS or ICIS-NPDES.
Facility Longitude
The longitude coordinate for the facility location in units of decimal degrees. Latitude and longitude coordinates are not required to be entered in FRS or ICIS-NPDES.
Major/Minor Status
A facility classification from the NPDES permitting authorities based on: toxic pollutant potential, ratio of discharge flow/stream flow volume, conventional pollutant loading, public health impact, water quality factors, and proximity to coastal waters. Major facilities have a larger impact on receiving waters if not controlled than minor facilities; therefore, they receive more regulatory attention than minor facilities. A Major/Minor status code of "M" indicates the facility is a major.
The custom search will display either "Major" or "Minor" in this field. If the custom Search displays "Major" that means that the facility has an "M" in the major/minor indicator field in ICIS-NPDES. If the custom Search displays "Minor", then the facility has either an "N" in the major/minor indicator field or the indicator field is blank in ICIS-NPDES.
Watershed ID (12-Digit HUC)
Code assigned by the US Geological Survey used to classify watersheds in the United States and the Caribbean. Code consists of twelve digits which correspond to six levels of classification: Region (first-level, 2-digit HUC), Subregion (second-level, 4- digit HUC), Accounting unit (third-level, 6-digit HUC), Cataloguing unit (fourth-level, 8-digit HUC), Watershed (fifth-level, 10-digit HUC), and Subwatershed (sixth-level, 12-digit HUC).
The Loading Tool links facilities with hydrologic unit codes (HUC-12) using a WATERS web service. Not all NPDES IDs have a matching HUC-12 in the Watershed Boundary Dataset. For more information see Overview of Watershed Data.
Watershed Name
Name of the watershed, which is linked to the watershed ID, a 12-digit code assigned by the US Geological Survey.
Waterbody Name
The State Waterbody Name for the receiving stream of the pollutant discharges from the facility. The Loading Tool obtains this data element using a Watershed Assessment Tracking and Environmental ResultS (WATERS) web service (REACH_to_GNIS) which extracts the waterbody name from USGS's Geographic Names Information System (GNIS). Not all receiving waterbodies are named in the GNIS, which means the user may have the text "Not found" displayed. Additionally, this WATERS web service uses the medium resolution NHD and the GNIS data for this resolution is variable. For example, areas around the Great Lakes are sparsely labeled and parts of Lake Michigan are mislabeled as "Techny Reservoir".
The Loading Tool links facilities with REACH Codes and waterbody names using a WATERS web service. Not all NPDES IDs have a matching REACH Code in the REACH Address Database or waterbody name in the Geographic Names Information System. For more information see Overview of Watershed Data.
Reach Code
A unique code assigned to each segment of a stream contained within the US Geological Survey (USGS) hydrography. This 14-digit code has two parts: the first 8 digits are the hydrologic unit code for the subbasin in which the reach exists; the last 6 digits are assigned in sequential order, and arbitrarily among the reaches. The Loading Tool obtains this data element using a Watershed Assessment Tracking and Environmental ResultS (WATERS) web service (OWRAD/PCS_WMERC) which obtains REACH codes from EPA's REACH Address Database (RAD).
The Loading Tool links facilities with REACH Codes using a WATERS web service. Not all NPDES IDs have a matching REACH Code in the REACH Address Database. For more information see Overview of Watershed Data.
Listed for Impairment
Displays "Y" for "Yes" if the waterbody in which the facility is located is listed for impairment.
Under section 303(d) of the CWA, states, territories, and authorized tribes are required to develop lists of impaired waters. These are waters that are too polluted or otherwise degraded to meet the water quality standards set by states, territories, or authorized tribes. The law requires that states establish priority rankings for waters on the lists and develop Total Maximum Daily Loads (TMDLs), for these waters. A TMDL is a calculation of the maximum amount of a pollutant that a water body can receive and still safely meet water quality standards. For more information about impaired waters or TMDLs, please visit EPA's Overview of Impaired Waters and TMDLs Program.
Impairment Class
The impairment class or category of the waterbody in which the facility is permitted to discharge directly.
  • 5. Impaired - Total Maximum Daily Loads (TMDLs) needed. Available information indicates that at least one designated use is not being supported and a TMDL is needed (also known as the 303(d) listed waters).
  • 4. Impaired - TMDL not needed. Available information indicates that at least one designated use is not being supported, but a TMDL is not needed (see subcategories).
  • 4a. TMDL completed. A TMDL has been completed, but impairment still exists.
  • 4b. TMDL alternative. Impairment is being addressed by a method other than a TMDL (e.g., stream bank improvements).
  • 4c. Non-pollutant causes. Cause of impairment is not a pollutant (e.g., habitat destruction).
Detailed information on the categorization of waters can be found in Section V of the 2006 Integrated Report Guidance.
Number of Combined Sewer Overflow (CSO) Outfalls
A number indicating the number of CSO outfalls included on a permit. A combined sewer system (CSS) is a wastewater collection system owned by a municipality which conveys sanitary wastewater (domestic, commercial, and industrial) and stormwater through a single pipe system to a publicly owned treatment works. A combined sewer overflow (CSO) is the discharge from a CSS at a point prior to the treatment plant. CSOs are point sources subject to NPDES permit requirements including both technology-based and water quality-based requirements of the Clean Water Act.
Total Facility Design Flow (MGD)
The daily rate of wastewater flow that a facility is designed to discharge (in units of millions of gallons per day), as reported on the most recent permit application. Design flow information is not required to be entered in ICIS-NPDES.
Actual Average Facility Flow (MGD)
The daily rate of wastewater flow that a facility actually discharges (in units of millions of gallons per day), as reported on the most recent permit application. Actual average facility flow information is not required to be entered in ICIS-NPDES.

Top of Page


Discharge Identification Information

Outfall Number
A three-character code in ICIS-NPDES that identifies the point of discharge (e.g., outfall) for a facility. A NPDES permit may have multiple points of discharge. An outfall number (permit feature number) is provided for each DMR measurement and limit in ICIS-NPDES. See About the Loading Tool Data for more information.
Monitoring Location Code
A single-character code in ICIS-NPDES that indicates the sampling location for each pollutant measurement. The Loading Tool only includes locations for effluent sampling points. These include: 1 - Effluent gross discharge; 2: Effluent net discharge; A - After Disinfection; B - Before Disinfection and; SC - See Comments. A monitoring location code is provided for each DMR measurement and limit in ICIS-NPDES. See About the Loading Tool Data for more information.
Limit Set Designator
A single-character code in ICIS-NPDES that groups limits that are set on a similar basis (e.g., monthly vs. annual limits, seasonal limits). A limit set designator code is provided for each DMR measurement and limit. See About the Loading Tool Data for more information.
Season Number
Flag indicating if seasonal parameter limits are applicable. '0' indicates that seasonal parameter limits are not applicable, and '1' indicates that seasonal parameter limits are applicable.
Number of Report
The number of months in the monitoring periods for the DMRs for the limit set (e.g., monthly = 1, quarterly = 3, semi-annually = 6).
Permit Feature Latitude
The horizontal position coordinate for the point of discharge location in units of decimal degrees. Latitude and longitude coordinates are not required to be entered into ICIS-NPDES. Searching on coordinates will only return results for permit features that have latitude and longitude data in ICIS-NPDES.
Permit Feature Longitude
The vertical position coordinate for the point of discharge location in units of decimal degrees. ICIS-NPDES does not require Latitude and longitude coordinates to be entered. Searching on coordinates will only return results for permit features that have latitude and longitude data in ICIS-NPDES.
Parameter Code
A five-character code in ICIS-NDPES that identifies the regulated pollutant parameter in a NPDES permit and specifies both the pollutant name and pollutant form (e.g., dissolved or suspended). Multiple parameters can apply to a single pollutant or CAS number. A parameter code is provided for each DMR measurement and limit in ICIS-NPDES. See About the Loading Tool Data for more information.
Parameter Description
Description/parameter name that corresponds to the five-digit parameter code. A parameter description is provided for each DMR measurement and limit in ICIS-NPDES. See About the Loading Tool Data for more information.
CAS Number
Chemical Abstract Service (CAS) Number assigned by the American Chemical Society that uniquely identifies a chemical. Not all pollutants have a Chemical Abstract Service (CAS) Number (for example, Total Suspended Solids).
Toxic Weighting Factor (TWF)
EPA developed TWFs for use in its effluent limitations guidelines and standards (ELGs) development program to allow comparison of pollutants with varying toxicities. TWF is used to convert pollutant loadings into Toxic Weighted Pounds Equivalent (TWPE). Not all pollutants have a toxic weighting factor (for example, Total Suspended Solids), which means that these pollutants do not have a toxicity score (i.e., TWPE = 0). See Technical Support Documents for more information about TWFs.
Substance Registry System (SRS) ID
Unique identification number assigned to substances, such as chemicals, biological organisms, physical properties, and miscellaneous objects by EPA's Substance Registry Services, to provide a common substance identification method across multiple regulatory programs. Not all pollutants have a Chemical Abstract Service (CAS) Number; and therefore, do not have an SRS ID (for example, Total Suspended Solids).

Top of Page


Permit and DMR Data

Permit Limits
The quantity or concentration standard for how much of a given pollutant a facility may release, as stipulated in a facility's NPDES permit.
DMR Measurements
The reported quantity or concentration of a given parameter.

Facility Data Availability

Facility Info Only
Number of facility permits that meet search criteria but do not have permit limits or DMR data in ICIS-NPDES.
If Pollutant criteria are specified in a query, then this result will be zero. This is because pollutant identification information is stored in permit limit data and DMR data in ICIS-NPDES, and for a facility to be identified based on pollutant criteria, the facility must have either permit limit data or DMR data. If a pollutant is not specified, then this field will display the number of facilities that meet the Location, Watershed, or Industry search criteria, but do not have permit limit data or DMR data in ICIS-NPDES.
Has Permit Limits
Number of facility permits that have numeric pollutant discharge limits in ICIS-NPDES.
Some facilities' NPDES permits require monitoring and reporting for a particular pollutant, but do not include a numeric limit for the pollutant discharge. The Water Pollution Search will count these facilities in the "With DMR Data" field, but will not count them in the "With Permit Limits" field. Only facilities with numeric permit limits are counted in the "With Permit Limits" field.
Has Loadings Data
A Yes/No field indicating if pollutant loadings were calculated in the Loading Tool.

Top of Page


Pollutant Loadings Data

Pollutant Load (kg/year) or (kg/period)
The amount (in kg) of pollutant released during the specified monitoring period or year.
Wastewater Flow (MGal/yr) or (MGal/period)
The total wastewater volume discharged per year or specified period of time (in units of millions of gallons).
Average Daily Load (kg/day)
The average mass discharge (in units of kilograms per day) for a calendar year calculated as the arithmetic average of the average daily loads for all monitoring periods in the calendar year.
Average Concentration (mg/L)
The average pollutant concentration for a calendar year calculated as the arithmetic average of the average pollutant concentrations for all monitoring periods in the calendar year.
Average Daily Flow (MGD)
The average daily rate of flow that a facility discharges for a monitoring period (in units of millions of gallons per day).
Average Wastewater Temp (°F)
The average wastewater temperature for a monitoring period.
Average Wastewater pH
The average wastewater pH for a monitoring period.
Load Over Limit (Option 1) (kg/year) or (kg/period)
The difference between the Mass Discharge and the Mass Limit ("Load-over-Limit") calculated using the methodology described in the Technical Support Document. If the difference is positive, the discharge exceeded the permit limit. If the difference is zero, the discharge is below the limit. The Custom Search will only display results if the pollutant load is higher than the permit limit.
Load Over Limit (Option 2) (kg/year) or (kg/period)
The difference between the Mass Discharge and the Mass Limit ("Load-over-Limit") calculated using the methodology described in the Technical Support Document. If the difference is positive, the discharge exceeded the permit limit. If the difference is negative, the discharge was below the limit. The Custom Search will only display results if the pollutant load corresponds to a numeric permit limit.
Includes Non-detects
Flag indicating whether the reported pollutant concentration for the monitoring period was below the detection limit. The Custom Search identifies pollutant measurements that are not detected using data qualifiers in ICIS-NPDES. If the search finds a qualifier for the monitoring period measurement, then the search will display "Yes" in this field. If the search does not find a qualifier, then it will display "No".
Measurement Type
The indication of the measurement value type (e.g., Average Quantity, Minimum Concentration) selected to calculate the pollutant load.
Potential Outlier
A Yes/No field to indicate that a pollutant load is calculated using data flagged as potential outliers or data errors. The Technical Users Background Document describes how the Loading Tool flags potential outliers. Y = Yes; Blank = No.
Total Facility Load (kg/yr)
The annual amount (in kg) of pollutant released by a facility, based on calculations of DMR data.
Total Facility Flow (MGal/yr)
The calculated total flow a facility discharged for a given period (in units of millions of gallons per year).
Max Allowable Load (kg/yr) or (kg/period)
The quantity allowed to be discharged per year or monitoring period, calculated based on the facility’s specific permit limits. The maximum allowable load is null for pollutants in which only monitoring is required or numeric limits are not provided. This is not a determination of compliance and is intended for comparative purposes only.
Estimation Factor
Weighting factor used when the estimation function is applied to account for periods of missing data during a reporting year. This is calculated by dividing 12 by the sum of the number of months with DMR data and the number of months with no discharge. If all periods for the calendar year are accounted for in the annual load, then the Estimation Factor will equal 1. This estimation factor is not applied to monitoring periods where the facility indicated that no discharge occurred.

Top of Page


TRI Release Data

TRI release data are only displayed for NPDES permits that link to a TRI ID and reported the similar chemical on both DMRs and to TRI in the same reporting year. For more information about how DMR and TRI data are linked together and how they may be used for comparisons, see Linking DMR and TRI Data.

Chemical Name
The name associated with chemicals that are reported to EPA's TRI Program.
TRI Direct Release (lb/yr)
The amount of TRI chemical(s) released directly to surface waterbodies.
TRI Indirect Release (lb/yr)
The amount of TRI chemical(s) released to sewage treatment plants. For indirect releases, the Loading Tool adjusts the reported facility release to account for removals at the POTW. POTWs can treat and remove some or all of the chemicals from TRI indirect releases before releasing the treated wastewater to the environment. EPA estimates chemical removal rates based on a percent removal and subtracts the percent removed from the reported indirect release. The POTW chemical removal spreadsheet is available in Technical Support Documentation.

 

Top of Page