Combined ECHO Facility Search Service
Validates query search parameters and returns query identifier. Use the responseset parameter to set the page size
Query parameters
Output Format Flag. Enter one of the following keywords:
- JSON = Data model formatted as Javascript Object Notation (default).
- JSONP = Data model formatted as Javascript Object Notation with Padding.
- XML = Data model formatted as Extensible Markup Language.
Facility Name Filter. Enter one or more case-insensitive facility names to filter results. Provide multiple values as a comma-delimited list. See p_fntype for additional modifiers.
Facility street address. Enter a complete or partial street address.
Facility street address. Enter a complete or partial street address. Note that p_sa1 is culmulative with p_sa.
Facility City Filter. Enter a single case-insensitive city name to filter results.
Facility County Filter. Provide a single county name in combination with a state value provided via p_st.
FIPS Code Filter. Enter a single 5-character Federal Information Processing Standards (FIPS) state + county value to restrict results. E.g. to limit results to Kenosha County, Wisconsin, use 55059.
Facility State and State-Equivalent Filter. Provide one or more USPS postal abbreviations for states and state-equivalents to filter results. Provide multiple values as a comma-delimited list.
5-Digit ZIP Code Filter. Provide one or more 5-digit postal zip codes to filter results. May contain multiple comma-separated values.
Facility Registry Service ID Filter. Enter a single 12-digit FRS identifier to filter results.
EPA Region Filter. Provide a single value of 01 thru 10 to restrict results to a single EPA region.
Standard Industrial Classification (SIC) Code Filter. Enter a single 4-digit SIC Code to filter results. If more complex filtering is required, use p_sic2 and p_sic4.
North American Industry Classification System Filter. Enter two to six digits to filter results to facilities having matching NAICS codes. Digits less than six will match to all codes beginning with the provided values.
Last Penality Date Qualifier Filter. Enter one of the following:
- NEVER = No Penalties
- ANY = Any Penalty
- LEXX = Less than or equal to XX months. Provide a number in place of XX, e.g. "LE5" for a facility with a penalty within previous 5 months.
- GTXX = Greater than XX months. Provide a number in place of XX, eg. GT12, for a facility with the last penalty greater than 12 months ago.
In decimal degrees. Latitude of 1st corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
In decimal degrees. Longitude of 1st corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
In decimal degrees. Latitude of 2nd corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
In decimal degrees. Longitude of 2nd corner of box that bounds the resulting facilities. The latitude and longitude of both corners of the bounding box must be provided.
US-Mexico Border Flag. Enter Y/N to restrict searches to facilities located within 100KM of the border.
Standard Industrial Classification (SIC) Code Filter Alternate 2. Enter a wild-card search against SIC codes. A final wild-card is always present allowing "22" to match all SIC codes beginning with 22. Use the "%" character within strings to match any SIC values with the pattern. For example, "2%21" matches 2021, 2121, 2221, etc.
Standard Industrial Classification (SIC) Code Filter Alternate 3. Enter the first 2, 3 or 4 SIC code digits to filter results to facilities having those code prefixes. As this alternative does not utilize an index, p_sic2 will generally be quicker.
Federal Agency. 1 character or 5-character values; may contain multiple comma-separated values. ALL will retrieve all facilities where the federal agency code is not null. Use the Federal Agencies lookup service to obtain a list of values.
Federal Facility Indicator Flag. Enter Y to restrict searches to federal facilities.
Active Permits/Facilities Flag. Provide Y or N to filter results to facilities with active permits.
Major Facility Flag. Enter Y to restrict results to Major facilities only.
CAA Maximum Achievable Control Technology (MACT) Subpart codes (alpha ID between 1 and 7 characters) applicable to the facility.
Formal Enforcement Actions [within / not within] specified date range indicator. The date range is determined by parameters p_fead1 and p_fead2 or by parameter p_feay.
- W = within date range
- N = not within date range
Years (1 to 5) Range. This value is used to create a date range for Formal Enforcement Actions (FEA). Used along with p_fea (which indicates whether to look within or outside of the date range) to find FEAs within (or not within) the number of years specified.
Agency associated with Formal Enforcement Actions:
- E = EPA
- S = State
- A = All
Formal Enforcment Action Last Case Date Limiter Flag. Enter a value of "Y" to additionally apply the p_feay year filter to the last formal enforcement action case date. Use the p_fea parameter to control if the filter is within or outside the date span provided.
A Y value identifies facilities that have had a formal enforcement action within the last 5 years.
Informal Enforcement Actions [within / not within] specified date range. The date range is determined by parameters p_iead1 and p_iead2 or by parameter p_ieay.
- W = within date range
- N = not within date range
Years (1 to 5) Range. This value is used to create a date range for Informal Enforcement Actions (IEA). Used along with p_iea (which indicates whether to look within or outside of the date range) to find IEAs within (or not within) the number of years specified.
Agency associated with Informal Enforcement Actions. If left blank, both agencies are included.
- E = EPA
- S = State
A Y value identifies facilities that have had an informal enforcement action within the last 5 years.
Facility Compliance Limiter. Enter 2, 3 or 4 to limit facilities returned.
- 2 = Facilities in noncompliance.
- 3 = Facilities having one or more programs reporting significant noncompliance.
- 4 = Facilities having more than one program reporting significant noncompliance.
Quarters in Noncompliance Limiter. Enter a coded value to limit results to facilities with given quarter of noncompliance.
- Z = Zero quarters in noncompliance.
- GEXX = Replacing XX with a numeric value, that number of quarterd or more in noncompliance.
- GTXX = Replacing XX with a numeric value, more than that number of quarters in noncompliance.
Non-Attainment Area Flag. Enter a Y or N to filter for or against facilities flagged as non-attainment areas.
Discharging into Impaired Waters Flag. Enter Y to limit results to facilities with discharge to waterbodies listed as impaired in the ATTAINS database.
Current Toxics Release Inventory (TRI) Reporter Limiter. Enter one of the following codes to limit results.
- CURR = Current TRI reporter.
- NONCURR = Has reported to TRI in the past but not for the current reporting year.
Toxics Release Inventory Pounds of On-Site Chemical Releases Limiter. Enter a keyword to filter results.
- Z = Zero pounds of chemical releases.
- GT0 = More than zero pounds of chemical releases.
- GT1000 = More than one thousand pounds of chemical releases.
- GT5000 = More than five thousand pounds of chemical releases.
- GT10000 = More than ten thousand pounds of chemical releases.
- GT20000 = More than twenty thousand pounds of chemical releases.
- GT50000 = More than fifty thousand pounds of chemical releases.
Toxic Release Inventory Pounds of Off-Site Chemical Releases Limiter. Enter a keyword to filter results.
- Z = Zero pounds of chemical releases.
- GT0 = More than zero pounds of chemical releases.
- GT1000 = More than one thousand pounds of chemical releases.
- GT5000 = More than five thousand pounds of chemical releases.
- GT10000 = More than ten thousand pounds of chemical releases.
- GT20000 = More than twenty thousand pounds of chemical releases.
- GT50000 = More than fifty thousand pounds of chemical releases.
Percent Minority Population Limiter. Enter a value to restrict results to facilities with a given percentage of minority population within 3-mile radius.
- NONE = 0%
- GT5 = greater than 5%
- GT10 = greater than 10%
- GT25 = greater than 25%
- GT50 = greater than 50%
- GT75 = greater than 75%
Population Density Limiter (per sq mile). Enter a value to limit results to facilities located in area of a given population density.
- NONE = 0 population density per square mile
- GT100 = More than 100 population density per square mile
- GT500 = More than 500 population density per square mile
- GT1000 = More than 1000 population density per square mile
- GT5000 = More than 5000 population density per square mile
- GT10000 = More than 10000 population density per square mile
- GT20000 = More than 20000 population density per square mile
Indian Country Flag. Enter a "Y" or "N" to restrict searches to facilities inside or outside Indian Country.
2-, 4-, 6-, or 8-character watershed code. May contain multiple comma-separated values.
Nine-digit permit IDs. May contain up to 2000 comma-separated values.
Filter Results by Media.- A = Air- C = CAMD (Clean Air Markets Division)- E = EIS (Emissions Inventory Systems)- G = GHG (Greenhouse Gases)- M = RMP (Risk Management Plan)- R = RCRA (Hazardous Waste)- S = SDWA (Public Drinking Water Systems)- T = TRI (Toxic Release Inventory)- TSCA = TSCA (Toxic Substances Control Act)- W = Water- ALL = Air and Water and RCRA
For use in identifying Facilities that have an inspection performed under the entered Statute.
Last Facility Inspection [within / not within] Specified Date Range Indicator. The date range is determined by parameters p_idt1 and p_idt2 or by parameter p_ysly.
- W = within date range
- N = not within date range
Number of years (1 to 5) since last facility inspection. A value of 1 means that it has been inspected within the year.
Facility Last Inspection Code Filter. If left blank, both agencies are included. Enter a value to limit results:
- E = EPA
- S = State
Quick Search. Allows entry for city, state, and/or zip code.
Single Facility Search Filter. Provide a facility name or program system identifier to limit results. For the all data search, the FRS registry identifier is also searched.
Numeric code for tribe (or list of tribes).
Tribe Name Filter. Enter a single tribe name to filter results.
Proximity to tribal land limiter. Enter an amount of mile between 0 and 25 to filter results. This parameter is only evaluated if p_tribeid is populated.
2-, 4-, 6-, 8-, 10-, or 12-character watershed (WBD from the USGS Watershed Boundary Dataset). May contain multiple comma-separated values. Uses the FRS Best Pick Coordinate to obtain the WBD12 Huc value.
Controls type of text search performed on facility name with parameter p_fn.
- EXACT = Find facilities having the exact provided name(s).
- BEGINS = Find facilities with names starting with the provided term(s).
- ALL = Find facilities using Oracle text search terms.
- CONTAINS =
Indian country search and/or flag. Enter "Y" to set indian country search conditions to return any results found using p_ico, p_fac_ico or p_fac_icoo. Otherwise only results matching all provided p_ico, p_fac_ico or p_fac_icoo conditions will be returned.
FRS tribal land spatial flag. Enter "Y" or "N" to include or exclude facilities based on FRS tribal land spatial flag.
Enter "Y" to limit facilities to Census block groups where one of more Environmental Justice indexes above 80th percentile.
Limit Address Search Flag. Enter Y to restrict facility searches to native data source only.
Latitude location in decimal degrees.
Longitude location in decimal degrees.
Spatial Search Radius. Enter a radius up to 100 miles in which to spatially search for facilities.
The number of Environmenmt Justice Indicators above the 80th percentile. Valid values are 1 through 11.
Indicates whether to AND or OR the Owner/Operator parameter (p_owop) and the federal agency code (p_fa) parameters.
Query Limiter. Enter a value to limit the number of records returned for each query. Value cannot exceed 70,000.
Response Set Limiter. Enter a value to limit the number of records per page. Value cannot exceed 1,000.
Table List Flag. Enter a Y to display the first page of facility results.
Map List Flag. Provide a Y to return mappable coordinates representing the full geographic extent of the queryset (all facilities that met the selection criteria).
Summary List Flag. Enter a Y to return a list of summary statistics based on the parameters submitted to the query service.
JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response.
Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.
Response
Results are summary statistics for the query and a query identifier (QID).
Example response
{
"Results": {
"CAARows": "50",
"CVRows": "0",
"CWARows": "50",
"FEARows": "1",
"Facilities": [
{
"AIRFlag": "Y",
"AIRIDs": "DC0000001100195254",
"CAA3yrComplQtrsHistory": "________VVSS",
"CAAComplianceStatus": "Violation Identified",
"CAADateLastFormalAction": "12/12/2016",
"CAADaysLastEvaluation": "7051",
"CAAEvaluationCount": "0",
"CAAHpvFlag": "Y",
"CAALastPenaltyAmt": "$17014",
"CAALastPenaltyDate": "12/12/2016",
"CAANAICS": "8111",
"CAAPermitTypes": "Minor Emissions",
"CAAQtrsWithNC": "8",
"CAASICs": "5496",
"CWA13qtrsComplHistory": "________VVSS",
"CWA13qtrsEfflntExceedances": "15",
"CWA3YrQncrCodes": "S",
"CWAComplianceStatus": "No Violation",
"CWAComplianceTracking": "On",
"CWADateLastFormalAction": "12/12/2016",
"CWADaysLastInspection": "184",
"CWAFormalActionCount": "2",
"CWAInformalCount": "1",
"CWAInspectionCount": "0",
"CWALastPenaltyAmt": "1000.0",
"CWALastPenaltyDate": "12/12/2016",
"CWANAICS": "8111",
"CWAQtrsWithNC": "8",
"CWASICs": "4596",
"CWASNCFlag": "Y",
"CensusBlockGroup": "110010096022",
"CurrSvFlag": "0",
"CurrVioFlag": "0",
"Ea5yrFlag": "0",
"EisFlag": "Y",
"EisIDs": "12620001",
"EpcraInspections5yr": "2",
"Fac3yrComplianceHistory": "________VVSS",
"FacAccuracyMeters": "35900",
"FacActiveFlag": "Y",
"FacChesapeakeBayFlg": "Y",
"FacCity": "ALEXANDRIA",
"FacCollectionMethod": "State Centroid",
"FacComplianceStatus": "No Violation",
"FacCounty": "ALEXANDRIA CITY",
"FacDateLastFormalActEPA": "12/12/2016",
"FacDateLastFormalActSt": "12/12/2016",
"FacDateLastFormalAction": "5/7/2009",
"FacDateLastInformalActEPA": "12/12/2016",
"FacDateLastInformalActSt": "12/12/2016",
"FacDateLastInformalAction": "8/6/2008",
"FacDateLastInspection": "12/18/2012",
"FacDateLastInspectionEPA": "12/12/2016",
"FacDateLastInspectionState": "12/12/2016",
"FacDateLastPenalty": "2/19/2011",
"FacDaysLastInspection": "1197",
"FacDerivedCb2010": "450850003003069",
"FacDerivedCd113": "05",
"FacDerivedHuc": "552968",
"FacDerivedRadWBDHu12": "41201040603",
"FacDerivedRadWBDHu12Name": "Cayuga Creek",
"FacDerivedRadWBDHu8": "4120104",
"FacDerivedRadWBDHu8Name": "Niagra",
"FacDerivedTRIbes": "Cherokee Nation",
"FacDerivedWBD": "20700100204",
"FacDerivedWBDHu12Name": "Cayuga Creek",
"FacDerivedWBDHu8": "2070003",
"FacDerivedWBDHu8Name": "Cacapon-Town",
"FacDerivedZip": "22126",
"FacEPARegion": "03",
"FacFIPSCode": "55001",
"FacFederalAgency": "D5700",
"FacFederalAgencyName": "EPA",
"FacFederalFlg": "Y",
"FacFormalActionCount": "0",
"FacImpWaterFlg": "Y",
"FacIndianSpatialFlg": "Y",
"FacInformalCount": "0",
"FacInspectionCount": "1",
"FacLastPenaltyAmt": "$200",
"FacLat": "38.803076",
"FacLong": "-77.085951",
"FacMajorFlag": "Y",
"FacMapFlg": "Y",
"FacMapIcon": "CWA-NC-MJ-2.png",
"FacMyrtkUniverse": "NNN",
"FacNAICSCodes": "8111 8134",
"FacNaaFlag": "Y",
"FacName": "W M A T A CENTRAL MAINT FAC",
"FacPenaltyCount": "2",
"FacPercentMinority": "45.379",
"FacPopDen": "6716.34",
"FacProgramsWithSNC": "2",
"FacQtrsWithNC": "8",
"FacReferencePoint": "CENTER OF A FACILITY OR STATION",
"FacSICCodes": "811",
"FacSNCFlg": "Y",
"FacState": "VA",
"FacStdCountyName": "Fairfax County",
"FacStreet": "3101 EISENHOWER AVENUE",
"FacTotalPenalties": "$850",
"FacUsMexBorderFlg": "Y",
"FacZip": "22314",
"FecLastCaseDate": "12/12/2016",
"FecNumberOfCases": "1",
"FecTotalPenalties": "$34400",
"FifraInspections5yr": "2",
"GHGFlag": "Y",
"GHGIDs": "110000",
"HasPollRpt": "Y",
"Infea5yrFlag": "0",
"Insp5yrFlag": "1",
"Lower48": "Y",
"MaxPctileUs": "98",
"MaxScore": "1",
"NC": "Y",
"NPDESFlag": "Y",
"NaaCategories": "8-HOUR OZONE(2015)",
"NaaPollutants": "OZONE",
"Over80CountUs": "3",
"PctileCancerUs": "99",
"PctileDpmUs": "99",
"PctileO3Us": "94",
"PctilePctpre1960Us": "14.6",
"PctilePmUs": "93",
"PctileProximityNPDESUs": "23.7",
"PctileProximityNplUs": "96",
"PctileProximityRmpUs": "91",
"PctileProximityTsdfUs": "82",
"PctileRespUs": "99",
"PctileTrafficScoreUs": "92",
"RCRA3yrComplQtrsHistory": "________VVSS",
"RCRAComplianceStatus": "No Violation",
"RCRADateLastFormalAction": "12/12/2016",
"RCRADaysLastEvaluation": "6848",
"RCRAFlag": "Y",
"RCRAFormalActionCount": "5",
"RCRAIDs": "VAD981111784",
"RCRAInformalCount": "3",
"RCRAInspectionCount": "1",
"RCRALastPenaltyAmt": "1000.0",
"RCRALastPenaltyDate": "12/12/2016",
"RCRANAICS": "8111",
"RCRAPenalties": "$987",
"RCRAPermitTypes": "LQG",
"RCRAQtrsWithNC": "8",
"RCRASNCFlag": "Y",
"RegistryID": "110020837601",
"RmpIDs": "110000",
"SDWA3yrComplQtrsHistory": "____SS__VVUU",
"SDWAComplianceStatus": "No Violation",
"SDWAFormalActionCount": "11",
"SDWAIDs": "DC0000001",
"SDWAInformalCount": "2",
"SDWAInspections5yr": "2",
"SDWAQtrsWithNC": "8",
"SDWASNCFlag": "Y",
"SDWISFlag": "Y",
"Score": "1",
"SourceID": "ALR040033",
"TRIFlag": "Y",
"TRIIDs": "20011FRTTT5001F",
"TRIOffSiteTransfers": "0",
"TRIOnSiteReleases": "11987",
"TRIReleasesTransfers": "170878",
"TRIReporter": "Y",
"TRIReporterInPast": "Y",
"TRIbalFlag": "1",
"TscaInspections5yr": "2",
"ViolFlag": "1",
"WebDocs": "C6"
}
],
"INSPRows": "1",
"IndianCountryRows": "0",
"InfFEARows": "0",
"MapOutput": {
"IconBaseURL": "https://echo.epa.gov/app/map/icons/",
"MapData": [
{
"CAAstatus": "______UUUUUU",
"CWAstatus": "VV_______V_VV",
"FormalCount": "1",
"ICON": "CAA-IC-MN-N.png",
"InformalCount": "1",
"LAT": "38.798026",
"LON": "-77.062981",
"LastInsp": "901",
"NAME": "VIRGINIA CONCRETE ALEXANDRIA PLANT",
"PUV": "110001891506",
"RCRAstatus": "________VVSS",
"SDWAstatus": "________VVSS",
"TYPE": "Facility"
}
],
"PopUpBaseURL": "https://echodata.epa.gov/echo/cwa_rest_services.pop_up?p_id=",
"QueryID": "245"
},
"Message": "Success",
"PageNo": "1",
"QueryID": "245",
"QueryRows": "5",
"RCRRows": "50",
"SVRows": "0",
"TRIRows": "50",
"TotalPenalties": "$963,531",
"V3Rows": "2",
"Version": "v2016-02-02 14:"
}
}