Web Services

Envirofacts is developing web services to facilitate the sharing of its functionality and information. All of the services that are available within Envirofacts will be listed on this tab. Please check back periodically as we are developing many new services. 

A RESTful data service API is now available for Envirofacts UV Index Hourly and Daily forecast data.

Searches can now be performed using search parameters such as "BEGINNING with/CONTAINING" and a JSON output is also available.

Envirofacts Data Service API

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 JavaScript Object Notation (JSON), 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.

To locate tables and columns for use in the Envirofacts Data Service API, please visit the Envirofacts data model page. This page contains links to all of the EPA systems and data models contained within Envirofacts.

Strengths and Limitations of the Envirofacts RESTful Service
This is a simple to use, well-documented way to access multiple data sources without the need of user database connections. The resulting output can be easily used with desktop applications such as Excel or Access, or used in creating Web mash-ups.

The current release of the service, while providing easy access to a tremendous amount and range of data, is limited to querying up to three tables. Also, the output is limited to 100,000 rows of data at a time, but a user can pick which 100,000 rows of data and then return to retrieve the next 100,000.

Constructing a Search
To build a search, users create a URL with a specific set of parameters. This is done by creating a string using the following format:

1. Table Name – At least one table name is required. Up to three table names can be entered.
2. Column Name – This is an optional entry. Enter a column name and value to limit the results.
3. Operator – This is an optional entry. This parameter allows users to pass in an operator with the query. Default output is "=" and does not require an operator, but users can enter "<", " >", "!=", "BEGINNING", "CONTAINING", operators as well via the URL. The "BEGINNING" operator will return rows where the start of a column value is equal to the search value. While the "CONTAINING" will return rows where the search value is contained within the column value. Additional details on operators is available in the EF Data Service API complete documentation.
4. Column Value – This is an optional entry. The column value is queried against the database without modification. Use the program system Model to double check the case for the value.
5. Rows – This is an optional entry. Specify the rows to display by entering 'rows/ <first_row> : <last_row>' Results numbering starts at 0. So to get the first five hundred rows enter rows/0:499 If “rows” is not specified, the default is the first 100,000 rows.
6. Output Format – This is an optional entry. The default output is in XML; however, output options of JSON, CSV or Excel can be requested in the URL. The output format is not case sensitive.

• Count – This is an optional entry and not shown in the above URL. Count will show the total number of records that will be returned when using the URL without the count. This is available only with the default XML output.

For example:

• https://enviro.epa.gov/enviro/efservice/tri_facility/state_abbr/VA/rows/499:504
  returns result set records 500 to 505 from the TRI_FACILITY table where STATE_ABBR = ‘VA’.
• https://enviro.epa.gov/enviro/efservice/pcs_permit_facility/major_discharge_indicator/M
  returns the first 100,000 records from PCS_PERMIT_FACILITY table where the MAJOR_DISCHARGE_INDICATOR = ‘M’.
• https://enviro.epa.gov/enviro/efservice/t_design_for_environment/JSON/rows/1:19
  returns the first 20 records from T_DESIGN_FOR_ENVIRONMENT table as a JSON output.
• https://enviro.epa.gov/enviro/efservice/TRI_FACILITY/state_abbr/HI/TRI_REPORTING_FORM
  returns results from the TRI Facility and TRI Reporting Form tables where the state is HI in the TRI Facility table.
• https://enviro.epa.gov/enviro/efservice/TRI_FACILITY/state_abbr/VA/TRI_REPORTING_FORM/TRI_CHEM_INFO/EXCEL
  returns results from the TRI Facility, TRI Reporting Form and TRI Chem Info tables where the state is VA in the TRI Facility table in Excel format .
• https://enviro.epa.gov/enviro/efservice/tri_facility/zip_code/BEGINNING/600/JSON
  returns results from the TRI_FACILITY table where ZIP CODE "Begins With" 60085 in a JSON format.
• https://enviro.epa.gov/enviro/efservice/tri_facility/state_abbr/VA/CSV
  returns result from the TRI_FACILITY table where STATE_ABBR = ‘VA’in a CSV format.
• https://enviro.epa.gov/enviro/efservice/tri_facility/COUNT
  returns results showing the total number of records matching the user input.

More information on EF Data Service API

UV Index

Envirofacts provides two approaches for retrieving UV Index data thru web services: a RESTful data service API and a SOAP (Simple Object Access Protocol) web service. The information is searchable by ZIP Code and city, state, making it useful for any organization, either local or national. Users do not have to leave your site to see the forecast. The UV Index Overview provides additional information on the data. Both approaches are detailed below.

RESTful Data Service API

This functionality provides a user of UV Index data, within Envirofacts, the ability to query daily or hourly forecast data through the use of a URL. The four APIs for retrieving UV Index forecast information are:

• Get the Hourly UV Index forecast by ZIP Code
• Get the Hourly UV Index forecast by City and State
• Get the Daily UV Index forecast by ZIP Code
• Get the Daily UV Index forecast by City and State

Get the Hourly UV Index forecast by ZIP Code

Get the Hourly UV Index forecast by City and State

Get the Daily UV Index and Alert forecast by Zip Code

Get the Daily UV Index and Alert forecast by City and State

SOAP Web Service