Resource Conservation and Recovery Act (RCRA) Facility Enhanced Search Service

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.
• CSV = Facility results formatted as comma delimited file download.
• GEOJSON = Facility results formatted as GeoJSON feature collection.
• GEOJSONP = Facility results formatted as GeoJSON feature collection with Padding.
• GEOJSOND = Facility results formatted as GeoJSON feature collection download.

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.

State District Filter. Enter a single state district to restrict results.

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.

Minimum longitude value in decimal degrees.

Minimum latitude value in decimal degrees.

Maximum longitude value in decimal degrees.

Maximum latitude value in decimal degrees.

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.

Active Permits/Facilities Flag. Provide Y or N to filter results to facilities with active permits.

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

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

RCRA Current Compliance Status Limiter. Enter one or more of the following keywords to limit results. Enter multiple values as a comma-delimited list.

• No Violation
• In Violation
• In Significant Noncompliance

Law Statute Code Filter. Enter a single statute code to limit results.

Law Section Code Filter. Enter one or more law section codes to limit results. Provide multiple values as a comma-delimited list.

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.

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 Off-Site Land Releases Limiter. Enter a keyword to filter results.

• Z = Zero pounds of land releases.
• GT0 = More than zero pounds of land releases.
• GT1000 = More than one thousand pounds of land releases.
• GT5000 = More than five thousand pounds of land releases.
• GT10000 = More than ten thousand pounds of land releases.
• GT20000 = More than twenty thousand pounds of land releases.
• GT50000 = More than fifty thousand pounds of land 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.

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.

Nine-digit permit IDs. May contain up to 2000 comma-separated values.

Filter Results by Media.

• A = Air
• M = RMP (Risk Management Plan)
• R = RCRA (Hazardous Waste)
• S = SDWA (Public Drinking Water Systems)
• W = Water
• ALL = Air and Water and RCRA

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.

Owner/Operator code filter. Enter one of the following codes to filter results:

• PUBLIC
• PRIVATE
• FEDERAL

Indicates whether to AND or OR the Owner/Operator parameter (p_owop) and the federal agency code (p_fa) parameters.

Beginning of date range of most recent facility inspection.

End of date range of most recent facility inspection.

Inspection Type:

• CAC = Corrective Action Inspection
• CAV = Compliance Assistance Visit
• CDI = Case Development Inspection
• CEI = Inspection Inspection
• CSE = Compliance Schedule Evaluation
• FCI = Focused Compliance
• FRR = Financial Record Review
• FSD = Facility Self Disclosure
• FUI = Follow-Up Inspection
• GME = Groundwater Monitoring Evaluation
• NRR = Non-Financial Record Review
• OAM = Operation and Maintenance Inspection May contain multiple comma-separated values.

Compliance issuess found during inspection.

Formal Enforcement Action Date Range Start. Enter a date in MM/DD/YYYY format to set the start of the range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years.

Formal Enforcement Action Date Range End. Enter a date in MM/DD/YYYY format to set the end of the date range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years.

Formal Enforcement Action (FEA) Code Filter. Enter one or more three-letter FEA codes to restrict results to facilities with these attributes. Use p_fead1 and p_fead2 parameters to further restrict this filter by entering a date range. Provide multiple codes as a comma-delimited list.

Quarters in Significant Noncompliance Limiter. Enter a coded value to limit results to facilities with given quarter of significant noncompliance.

• Z = Zero quarters in significant noncompliance.
• GEXX = Replacing XX with a numeric value, that number of quarterd or more in significant noncompliance.
• GTXX = Replacing XX with a numeric value, more than that number of quarters in significant noncompliance.

Direct Water Discharges. Pounds of toxic chemicals released directly to surface water as reported to the Toxics Release Inventory.

Years Since Last Violation Limiter. Enter a value in the format GTXX where XX is replaced by the number of years since the last violation.

Number of Current Violations Limiter. Enter a value in the format GTXX replacing XX with a numeric value to select facilities with an equal to greater count of current violations. Enter Z to select facilities with zero violations.

Years of Continuing Violations Limiter. Enter a value in the format GTXX where XX is replaced by the number of years in continuing violation.

RCRA Violation Type. Enter one or more Resource Conservation and Recovery Act violation types to limit results. Provide multiple values as a comma-delimited list.

Universe Designation Limiter. Enter one or more universe designation codes. Provide multiple values as a comma-delimited list. Use code "TSDF" to return the full enforcement TSDF universe and "Operating TSDF" to return the operating TSDF universe.

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 =

Controls whether search is restricted to existing system. Y means the search will match the p_pid parameter against all associated permits (AIR, RCRA, SDWIS, etc).

FRS tribal land code flag. Enter "Y" or "N" to include or exclude facilities based on FRS tribal land code.

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.

Decouple Inspection Code Search Flag. Enter "Y" to search for inspection code types with p_pityp without respect to the date range search provided with p_ysl* parameters.

The number of Environmenmt Justice Indicators above the 80th percentile. Valid values are 1 through 11.

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.

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.

Optional flag to request GeoJSON formatted results to be pretty printed. Only provide a numeric value when the output needs to be human readable as pretty printing has a performance cost.