FRS EZ Query

This query allows you select key data elements from EPA's Facility Information Database and Geospatial Reference Database to build a tabular report or a Comma Separated Value (CSV) file for downloading.

There are 3 steps to follow to generate a query:

First, select one view of interest from the list below.
Select columns (data elements or fields) from the selected view.
Enter your search criteria to target specific records from the database.

The EZ Query User's Guide will provide you with detailed information on how to use the EZ Query.

Step 1: Start by selecting one view to be the focus of your query.

FRS Facility and Geospatial Reference Information
EPA FRS Facility Information	FRS Facility Information including Name, Address, and Best Pick Geospatial Information
EPA FRS Facility Information with Program Identifiers	FRS Facility Information including Name, Address, and Best Pick Geospatial Information with Program System Indentifiers. FRS Facility information is repeated for each Program System Identifier associated with the FRS Facility Site record (by Registry_ID).
EPA FRS Program Facility Information	Detailed Facility Information from the EPA Programs within FRS including Name, and Address Information
Facility SIC Codes	Standard Industrial Classification (SIC) Codes for EPA Facilities with EPA FRS Facilility Information and Best Pick Geospatial Information. Since a facility can be categorized by more than one SIC Code, the facility, latitude, and longitude information will be repeated for each SIC Code.
Facility NAICS Codes	North American Industry Classification System (NAICS) Codes for EPA Facilities with EPA FRS Facilility Information and Best Pick Geospatial Information. Since a facility can be categorized by more than one NAICS Code, the facility, latitude, and longitude information will be repeated for each NAICS Code.
ZIP Code Reference	Comprehensive list of ZIP Codes and the city, county, and Post Office names associated with those ZIP Codes, as provided by the United States Postal Service City State Product File.
Program Coordinates	Contains all program spatial data, associated facility name and address information, expanded spatial metadata code descriptions, spatially derived data, and the FRS facility representative point data for the parent facility.
FRS Facilities within and near Indian Tribes and Villages	EPA FRS Facility Information, Best Pick Geospatial Information, Tribal identifiers and distance to tribal boundaries for EPA Facilities in or within 25 miles of Alaskan Indian Village, Tribal Reservations, and Tribal Trust Land boundaries. Since a facility may be within or near more than one tribal boundary, facility information will be repeated for each tribe.
Program Facilities within and near Indian Tribes and Villages	EPA Program Facility Information, Best Pick Geospatial Information, Tribal identifiers and distance to tribal boundaries for EPA Program Facilities in or within 25 miles of Alaskan Indian Village, Tribal Reservations, and Tribal Trust Land boundaries. Since a facility may be within or near more than one tribal boundary, facility information will be repeated for each tribe.