MyRTK

myRight-to-Know(myRTK) is an EPA website, available at http://myrtk.epa.gov/info/, designed for mobile devices. For any address, the map displays nearby facilities regulated under federal environmental laws. Facility reports provide summaries of chemical/pollutant releases, chemical effects, and compliance history from numerous data systems.

This data service provides for retrieval of chemical and health effect data stored within the myRTK database. Within the data users will find a compiled list of TRI Chemicals, along with an assessment indicating if the chemical might cause cancer and if the chemical has any of the 17 other health effects. This version of myRTK is limited to human health effects.

The carcinogenicity classifications are taken from the US Occupational Safety and Health Administration (OSHA). The assessments for Other Health Effects are taken from EPA's TRI Chemical Hazard Information Profiles (TRI-CHIP), a database compilation of health effects from numerous other sources.

To retrieve myRTK information utilizing the data service, you can use the Envirofacts REST API at http://iaspub.epa.gov/enviro/efservice/HEALTH_EFFECT_DESCRIPTIONS/. To better understand the options available for retrieving myRTK Health Effects information using the Envirofacts REST API, documentation is available on the Envirofacts Services Page.

Below are a few example Envirofacts REST API URLs that run against the myRTK data:
 

• Return the myRTK records in an EXCEL spreadsheet
  http://iaspub.epa.gov/enviro/efservice/HEALTH_EFFECT_DESCRIPTIONS/excel/
   
• Return the the myRTK information for CAS Number equal to N150
  http://iaspub.epa.gov/enviro/efservice/HEALTH_EFFECT_DESCRIPTIONS/cas_number/=/N150/
   
• Return the myRTK information for chemical equal to "STYRENE"
  http://iaspub.epa.gov/enviro/efservice/HEALTH_EFFECT_DESCRIPTIONS/chemical/=/STYRENE/

Integrated Compliance Information System (ICIS)

Concentrated Animal Feeding Operations (CAFOs) are agricultural operations where animals are kept and raised in confined situations. Manure and wastewater from CAFOs have the potential to contribute pollutants such as nitrogen and phosphorus, organic matter, sediment, pathogens, heavy metals, hormones, antibiotics, and ammonia to the environment. Animal waste can enter water bodies from spills or breaks of waste storage structures, due to accidents or excessive rain, and non-agricultural application of manure to crop land. The NPDES program regulates the discharge of pollutants from CAFOs to waters of the United States.

CAFO information is available within the ICIS tables documented at PCS-ICIS Model. Utilizing the Envirofacts REST API, the CAFO information can be queried and retrieved from the ICIS database. To simplify the process of retrieving CAFO information, a special data view has been created combining the data within all five tables. The data view is named V_ICIS_FACILITY_CAFO.

To retrieve CAFO information utilizing the data view, you can utilize the Envirofacts REST API at http://iaspub.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/ To better understand the options available in the Envirofacts REST API, the documentation is available on the Envirofacts Services Page. All of the data elements and metadata supporting the data elements is available on the V_ICIS_FACILITY_CAFO metadata page. Additional ICIS Other Data tables will be posted at the ICIS Other Data metadata page.

Below are a few example Envirofacts REST API URLs that run against the CAFO data:
 

• Return the first 500 CAFO records within an EXCEL spreadsheet
  http://iaspub.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/excel/
   
• Return the first 25 CAFO records within an XML document for the state of Arkansas
  http://iaspub.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/state_code/AR/rows/0:24
   
• Return the second 50 CAFO records within a JSON document for the ZIP Code 72655
  http://iaspub.epa.gov/enviro/efservice/V_ICIS_FACILITY_CAFO/zip/72655/rows/50:99/JSON

Enforcement & Compliance History Online (ECHO)

About the Program

ECHO focuses on facility compliance and EPA/state enforcement of environmental regulations. ECHO provides integrated compliance and enforcement information for approximately 800,000 regulated facilities nationwide. The site allows users to find inspection, violation, enforcement action, informal enforcement action, and penalty information about facilities for the past three years. Facilities regulated under the following environmental statutes are included: Clean Air Act (CAA) Stationary Source Program, Clean Water Act (CWA) National Pollutant Elimination Discharge System (NPDES), Resource Conservation and Recovery Act (RCRA), and Safe Drinking Water Act (SDWA). The information shown in ECHO accesses an integrated database called IDEA, which stands for Integrated Data for Enforcement Analysis. Some users prefer to use the raw IDEA data rather than using the ECHO web interface. The ECHO Exporter and IDEA data downloads provide a full set of information nationally, whereas ECHO has limitations on how much data can be shown at one time.

Get the Data

The ECHO dataset is updated monthly and can be downloaded or accessed directly from the database.

To access the data real-time, that's updated monthly, within the Envirofact's database, you can use the Envirofacts RESTful API. The data can be obtained in four different output types. Please use the links below to access the most current compliance data within the Envirofacts database. The compliance data from ECHO only consists of one table, so the links below will retrieve all of the columns available within the Envirofacts database for ECHO's compliance data. These links will retrieve the first 5 rows of data within the table.

• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/CSV - (Comma Separated Value format)
• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/JSON - (JavaScript Object Notation format)
• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/EXCEL - (Microsoft Excel format)
• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/rows/0:4/XML - (Extensible Markup Language format)

The Envirofacts RESTful API can output 5000 rows of data from the table for each call to the API. For more information on how this process works, along with other functionality within the API, please visit the Envirofacts RESTful API.

Below are a few additional links to the Envirofacts RESTful API, using a few of the features to query compliance data.

• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/zip/60085/EXCEL - This URL will return all of the compliance records for ZIP Code 60085 in an EXCEL file.
• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/city/WASHINGTON/state/DC - This URL will return all of the compliance records for Washington, DC in XML.
• http://iaspub.epa.gov/enviro/efservice/t_compliance_echo/city/WASHINGTON/state/DC/CURR_COMP_STATUS/serious violation(s)/JSON - This URL will return all of the compliance records whos current compliance records are listed as "serious violations(s)" in Washington, DC as a JSON output.

Using the features of the Envirofacts RESTful API and the ECHO Exporter Version 1.0 Summary metadata information, you can query the compliance and incorporate the results within your app.  

In addition to the above Envirofacts RESTful API access to the data, the complete ECHO dataset can be downloaded. The links for these complete downloads can be found below, along with the month and year of the file. The download file is formatted as a compressed .ZIP file. The file within the .ZIP file is a Comma Separated Value file, that can be viewed within a text editor or Microsoft Excel. The metadata describing the data and the column headers, can be found at: ECHO Exporter Version 1.0 Summary (.xls file, 75 KB)

• ECHO Exporter Version 1.0 Downloads
  • November 2012 Refresh New! (.zip file, 44 MB)
  • October 2012 Refresh(.zip file, 44 MB)
  • September 2012 Refresh(.zip file, 43 MB)
  • August 2012 Refresh(.zip file, 43 MB)
  • July 2012 Refresh(.zip file, 44 MB)
  • June 2012 Refresh (.zip file, 45 MB)

Safe Drinking Water Information System (SDWIS)

National Primary Drinking Water Regulations (NPDWRs), or primary standards, are legally enforceable standards that apply to public water systems. Primary standards protect public health by limiting the levels of certain contaminants in drinking water. EPA sets a Maximum Contamination Limit (MCL) for every regulated contaminant. When public water systems are found to contain contaminants in amounts exceeding the MCL, they are in violation and must take action to restore the quality of their water. For more information about EPA regulated drinking water contaminants visit http://water.epa.gov/drink/contaminants/#List.

SDWIS information is available within the tables documented at: SDWIS Model. Utilizing the Envirofacts REST API, the SDWIS information can be queried and retrieved from the SDWIS database. To simplify the process of retrieving SDWIS information, special data views have been created combining the data within all SDWIS tables. These data views, using the REST API service, are described below. To better understand the options available in the Envirofacts REST API, the documentation is available on the Envirofacts Services Page. For information on the tables and columns available thru the service calls below, please visit the SDWIS Other Data metadata page.

SDWIS Other Data tables (metadata):
 

• SDW_COUNTY_SERVED
• SDW_VIOL_ENFORCEMENT
• SDW_CONTAM_VIOL_ZIP
• SDW_CONTAM_VIOL_CITY

Example SDWIS REST API services:
 

• I would like to know, within a specific county, what are the different Public Water Systems (PWSs), the population served by each one, the regulating agency, and the contact name and phone number.
  Rest Web Service URL: http://iaspub.epa.gov/enviro/efservice/SDW_COUNTY_SERVED/COUNTYSERVED/ACCOMACK
   
• I would like to know, within a specific county and state, the violations and enforcement actions for the different PWSs, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: http://iaspub.epa.gov/enviro/efservice/SDW_VIOL_ENFORCEMENT/COUNTYSERVED/MCLEAN/STATE/IL/Excel
   
• I would like to know, for a specific PWS, the violations and enforcement actions, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: http://iaspub.epa.gov/enviro/efservice/SDW_VIOL_ENFORCEMENT/PWSID/IL3141937/JSON
   
• I would like to know, for a specific zip code, the violations and enforcement actions, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: http://iaspub.epa.gov/enviro/efservice/SDW_CONTAM_VIOL_ZIP/geolocation_zip/=/20460/rows/1:10/excel
   
• I would like to know, for a specific city and state, the violations and enforcement actions, as well as the definitions, health effects, and sources of contamination for any contaminants.
  Rest Web Service URL: http://iaspub.epa.gov/enviro/efservice/SDW_CONTAM_VIOL_CITY/geolocation_city/CROFTON/STATE/MD/rows/1:10/excel

Design for the Environment (DfE)

About the Program

EPA's mission is to protect the health of people and the environment. To further that mission, EPA labels products so that consumers can easily choose ones that are safer for people and the environment. Using EPA's science expertise, the Design for the Environment program applies stringent criteria for health and environmental safety in labeling the safest products. When consumers see the Design for the Environment (DfE) label on a product, they can be confident that the product is among the safest when compared with traditional products.

Get the Data

Learn about the API - DfE data can be downloaded via the Envirofacts RESTful API. The data can be obtained in four different output types. Please use the links below to access the most current DfE data within the Envirofacts database. DfE only consists of one table, so the links below will retrieve all of the data within the Envirofacts database for the T_DESIGN_FOR_ENVIRONMENT table.
 

• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/CSV - (Comma Separated Value format)
• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/JSON - (JavaScript Object Notation format)
• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/EXCEL - (Microsoft Excel format)
• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment/XML - (Extensible Markup Language format)

The Spanish version of this data is available in the T_DESIGN_FOR_ENVIRONMENT_ESP table.
 

• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/CSV - (Comma Separated Value format)
• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/JSON - (JavaScript Object Notation format)
• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/EXCEL - (Microsoft Excel format)
• http://iaspub.epa.gov/enviro/efservice/t_design_for_environment_esp/XML - (Extensible Markup Language format)

DfE Model page, along with the Envirofacts RESTful API documentation to create additional queries against the database.

View the Model - The data model is an important aspect of using the Envirofacts RESTful API. The model can be used to create Uniform Resource Locators (URL) that will query specific data elements for use in your applications. DfE only consists of one table, as defined below:
Table Name: T_DESIGN_FOR_ENVIRONMENT
Columns:

• PRODUCT - A DfE-labeled product that is made by a partner company.
• PARTNER - A company who has signed a partnership agreement with the DfE program.
• SECTOR - A category of products, including the audience (e.g., Consumer or Institutional/Industrial) as well as the product use such as all-purpose cleaners, laundry detergents, etc.
• SECTOR ID - A number representing the unique identifier for the product's sector.
• CATEGORY - Reported values of Industrial/Institutional Product or Consumer Product representing the audience.
• CITY - The city name of the partner's location.
• STATE - The state abbreviation for the partner's location.
• PRODUCT ID - A number representing the unique identifier for a product.

For additional information, please see the DfE Model page.

Sample Data - When running the Envirofacts RESTful API you will retrieve data in various formats. An example of how the data appears is below.

SECTOR_ID	CATEGORY	SECTOR	PARTNER	CITY	STATE	PARTNERSINCE	PRODUCT_ID	PRODUCT
7	Industrial/Institutional Product	All-Purpose Cleaners	Barnes Distribution	Cleveland	OH	Apr 2009	1085	*Biodyne - Unscented
7	Industrial/Institutional Product	All-Purpose Cleaners	BCD Supply	Crest Hill	IL	Jun 2011	3132	*Green Clean Enviro-Degreaser
7	Industrial/Institutional Product	All-Purpose Cleaners	Beaver Research Company	Portage	MI	Jan 2009	906	*FOAM BLANC

Additional Resources

• DfE Homepage
• About the Program
• DfE Labeled Products and Our Products
• DfE on Facebook