Historic Land Use Screener - Contaminating SIC/NAICS Sites
Pricing
from $6.60 / 1,000 results
Screens a coordinate or address radius against EPA FRS SIC and NAICS classifications to find dry cleaners, gas stations, plating shops, auto shops, printers and other recognised contaminating land uses, for ASTM E1527-21 Section 8.3 prior-use review.
Pricing
from $6.60 / 1,000 results
Rating
0.0
(0)
Developer
Kyle Maloney
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
2 days ago
Last modified
Categories
Share
Row type
row_type
Optional
"facility" for one contaminating land use, or "asset_summary" for the one-per-property rollup.
Property label
asset_label
Optional
The label you supplied for this property, echoed back on every row.
Property address
asset_address
Optional
The address you supplied, or null when the property was given as a coordinate.
Property latitude
asset_lat
Optional
Latitude actually screened (WGS84), after geocoding if an address was supplied.
Property longitude
asset_lon
Optional
Longitude actually screened (WGS84), after geocoding if an address was supplied.
Property state
asset_state
Optional
Two-letter state the query coordinate falls in, resolved from the US Census geocoder. Null when the geocoder was unavailable.
Property county FIPS
asset_county_fips
Optional
5-digit county FIPS of the query coordinate from the US Census geocoder.
Property county
asset_county_name
Optional
County name of the query coordinate from the US Census geocoder.
Search radius (miles)
radius_miles
Optional
Radius screened around the property.
Facility ID
facility_id
Optional
Stable identity for the facility - the EPA FRS REGISTRY_ID, or the FRS KEY_FIELD when EPA publishes no registry id.
Facility ID basis
facility_id_basis
Optional
"registry_id" or "key_field" - which identifier facility_id came from.
EPA FRS Registry ID
registry_id
Optional
EPA Facility Registry Service REGISTRY_ID. Null when EPA publishes none for this record.
Facility name
facility_name
Optional
PRIMARY_NAME as EPA FRS publishes it.
Facility address
facility_address
Optional
LOCATION_ADDRESS as EPA FRS publishes it. Note this can be the operator mailing address - see location_confidence.
Facility city
facility_city
Optional
CITY_NAME as EPA FRS publishes it.
Facility state
facility_state
Optional
Two-letter STATE_CODE the FRS record is filed under.
Facility ZIP
facility_zip
Optional
POSTAL_CODE as EPA FRS publishes it.
Facility county
facility_county_name
Optional
COUNTY_NAME as EPA FRS publishes it.
Facility county FIPS
facility_county_fips
Optional
5-digit county FIPS normalised from the FRS FIPS_CODE column. Null when the published value could not be resolved without guessing.
Facility county FIPS (raw)
facility_county_fips_raw
Optional
The FIPS_CODE value exactly as EPA published it. Measured spellings include "08031", "CO031", "8031" and null in a single page.
Facility latitude
facility_lat
Optional
LATITUDE83 as EPA FRS publishes it (NAD83).
Facility longitude
facility_lon
Optional
LONGITUDE83 as EPA FRS publishes it (NAD83).
Distance (miles)
distance_miles
Optional
Great-circle distance from the property to the FRS coordinate. Read it together with location_confidence - a mailing-address geocode makes this distance meaningless.
Coordinate accuracy (m)
coordinate_accuracy_meters
Optional
EPA ACCURACY_VALUE - the accuracy EPA claims for the published coordinate, in metres.
Coordinate collection method
coordinate_collection_method
Optional
EPA COLLECT_MTH_DESC, e.g. "ADDRESS MATCHING-HOUSE NUMBER".
Coordinate reference point
coordinate_reference_point
Optional
EPA REF_POINT_DESC, e.g. "CENTER OF A FACILITY OR STATION".
Facilities sharing this coordinate
colocated_facility_count
Optional
How many distinct facilities in this property's radius publish this exact coordinate. A high value indicates an address-level geocode shared by many registrations.
Location confidence
location_confidence
Optional
"consistent" | "state_mismatch" (record filed in another state - almost certainly the operator mailing address) | "coordinate_stack" (many facilities on one coordinate) | "unknown" (state cross-check could not be performed).
Record state matches query state
location_state_matches_query_state
Optional
true / false / null. null means the check was not performed, never that it passed.
Location confidence reason
location_confidence_reason
Optional
Plain-language explanation of why this coordinate was classified the way it was. Null when confidence is "consistent".
Counts toward the verdict
counts_toward_verdict
Optional
Whether this facility contributed to the property's ASTM prior-use verdict. Mailing-address geocodes and coordinate stacks do not, unless crossStateRecords is set to "include".
EPA program systems
program_systems
Optional
Semicolon-separated EPA/state program systems this facility is registered in (PGM_SYS_ACRNM), e.g. "AIR; AIRS/AFS" or "NJ-NJEMS".
Program system count
program_system_count
Optional
How many distinct program systems carry this facility.
Program IDs
program_ids
Optional
Semicolon-separated program-specific identifiers (PGM_SYS_ID).
Interest types
interest_types
Optional
Semicolon-separated FRS INTEREST_TYPE values, e.g. "AIR MINOR", "SQG", "STATE MASTER".
FRS key fields
key_fields
Optional
Semicolon-separated FRS KEY_FIELD values (PGM_SYS_ACRNM + PGM_SYS_ID) - the keys the SIC and NAICS classification tables join on.
EPA FRS facility URL
frs_facility_url
Optional
EPA's own facility detail page for this record.
Operational status
operational_status
Optional
"operating" | "closed_or_terminated" | "unknown". A closed or terminated record is the strongest signal in this dataset that the use is FORMER rather than current.
Operational status basis
operational_status_basis
Optional
"explicit_phrase" | "coded_flag" (a program-specific Y/N) | "uninterpretable_value" | "not_reported". EPA publishes 47 distinct ACTIVE_STATUS values across 97 program systems; ambiguous single letters are left unknown rather than guessed.
Operational status (raw)
operational_status_raw
Optional
The ACTIVE_STATUS value exactly as EPA published it.
Record created
record_created_date
Optional
FRS CREATE_DATE as YYYY-MM-DD.
Record updated
record_updated_date
Optional
FRS UPDATE_DATE as YYYY-MM-DD.
Last reported
record_last_reported_date
Optional
FRS LAST_REPORTED_DATE as YYYY-MM-DD - how recently the program system reported this facility.
Federal agency
federal_agency_name
Optional
FEDERAL_AGENCY_NAME when the facility is a federal installation.
EPA region
epa_region_code
Optional
EPA region code (01-10).
Classification available
classification_available
Optional
Whether EPA publishes ANY SIC or NAICS classification for this facility. false means EPA published none - it does NOT mean the facility has no contaminating use.
Contaminating use match
contaminating_use_match
Optional
true when a classification matched the contaminating land-use vocabulary; false when classifications exist and none matched; null when no classification was published at all.
Land-use classes
land_use_classes
Optional
Semicolon-separated contaminating land-use class IDs matched on this facility.
Land-use class labels
land_use_class_labels
Optional
Human-readable labels for land_use_classes.
Primary land-use class
primary_land_use_class
Optional
The single class that best characterises the facility - taken from a PRIMARY-indicator code where one exists, otherwise the highest-risk match.
Primary land-use class label
primary_land_use_class_label
Optional
Human-readable label for primary_land_use_class.
Primary class basis
primary_land_use_class_basis
Optional
How primary_land_use_class was chosen, e.g. "sic_primary_indicator" or "naics_secondary_indicator" - so a secondary classification is never silently read as the facility's business type.
Contaminant risk tier
contaminant_risk_tier
Optional
"high" | "moderate" | "low" - the highest tier across the matched classes, from the vocabulary.
Contaminants of concern
contaminants_of_concern
Optional
Semicolon-separated contaminant groups the cited authorities associate with the matched land uses. These are the constituents typically investigated, not measured concentrations.
Contaminants of concern count
contaminants_of_concern_count
Optional
How many distinct contaminant groups are listed.
All SIC codes
sic_codes_all
Optional
Every SIC_CODE value EPA publishes for this facility, exactly as stored, including malformed ones.
Matched SIC codes
sic_codes_matched
Optional
The SIC codes that matched the contaminating land-use vocabulary.
Matched SIC titles
sic_titles_matched
Optional
Official OSHA SIC Manual titles for the matched SIC codes.
PRIMARY SIC codes
sic_primary_codes
Optional
SIC codes EPA marks PRIMARY_INDICATOR = PRIMARY for this facility.
SECONDARY SIC codes
sic_secondary_codes
Optional
SIC codes EPA marks SECONDARY. A secondary code is not the facility's principal business.
UNKNOWN-indicator SIC codes
sic_unknown_indicator_codes
Optional
SIC codes EPA marks UNKNOWN - EPA itself does not say whether the code is the facility's primary business.
SIC row count
sic_row_count
Optional
How many FRS_SIC rows joined to this facility.
All NAICS codes
naics_codes_all
Optional
Every NAICS_CODE value EPA publishes for this facility, exactly as stored.
Matched NAICS codes
naics_codes_matched
Optional
NAICS codes that matched the vocabulary, after leading-zero normalisation.
Matched NAICS stems
naics_stems_matched
Optional
The vocabulary stems that matched. Matching is longest-prefix because FRS stores 5- and 6-digit codes from two NAICS vintages side by side.
Matched NAICS titles
naics_titles_matched
Optional
Official Census NAICS titles for the matched stems.
Matched NAICS vintages
naics_vintages_matched
Optional
Which NAICS vintage (2017 or 2022) each matched stem belongs to.
Leading-zero NAICS codes
naics_leading_zero_codes
Optional
NAICS values EPA stored with a leading zero, which no valid NAICS code has. Reported so the normalisation is visible rather than silent.
NAICS row count
naics_row_count
Optional
How many FRS_NAICS rows joined to this facility.
PRIMARY-indicator matches
match_count_primary_indicator
Optional
How many matching classifications EPA marks PRIMARY.
SECONDARY/UNKNOWN matches
match_count_secondary_or_unknown_indicator
Optional
How many matching classifications EPA marks SECONDARY or UNKNOWN.
Malformed classification codes
malformed_classification_codes
Optional
Codes EPA published that are not resolvable classification codes (e.g. SIC "OWNE", "UNK", or a 3-digit truncation). They are reported, never guessed at, and never counted as a match.
Malformed code count
malformed_classification_code_count
Optional
How many malformed codes this facility carries.
Unmatched SIC codes
unmatched_sic_code_count
Optional
Well-formed SIC codes that are simply not contaminating land uses.
Unmatched NAICS codes
unmatched_naics_code_count
Optional
Well-formed NAICS codes that are simply not contaminating land uses.
Mapping version
contaminant_mapping_version
Optional
Version of the classification-to-contaminant vocabulary used for this row.
Mapping citation
contaminant_mapping_citation
Optional
Full citation text for those authorities.
Mapping citation URL
contaminant_mapping_url
Optional
Link to the primary cited authority.
ASTM reference
astm_reference
Optional
The ASTM E1527-21 clause this screen supports.
Temporal basis
temporal_basis
Optional
Always "current_reported_classification". EPA FRS publishes the classification a facility CURRENTLY reports, not a historical land-use record.
Temporal basis note
temporal_basis_note
Optional
Plain-language statement of exactly what the classification does and does not tell you about historic use.
State/tribal agency program systems on this facility
state_program_systems
Optional
Semicolon-separated EPA FRS PGM_SYS_ACRNM values on this facility that were measured this run to be state or tribal agency program systems (at least 90% of their national records sit in this state). null when the opt-in state leg was not requested or could not run - null means NOT CHECKED, never "checked and none".
State/tribal agency program IDs
state_program_ids
Optional
The facility's PGM_SYS_ID values in those state or tribal agency systems - the identifier to quote when requesting the file from the state agency. null when the state leg was not requested or could not run.
Carries a state/tribal equivalent record
state_equivalent_record
Optional
true when this facility carries at least one state or tribal agency program record - the ASTM E1527-21 Section 8.2 "state and tribal equivalent" record class. false is a VERIFIED negative for this facility. null means the state leg was not requested or could not run for this property. Read it together with the summary row's state_coverage: a false here inside a state whose state_coverage is "none" only means FRS holds no state system for that jurisdiction.
FRS_INTERESTS status
frs_interests_status
Optional
"ok" | "partial" | "unavailable" | "not_run" for the radius query behind this row.
FRS_SIC status
frs_sic_status
Optional
"ok" | "partial" | "unavailable" | "not_run" for the SIC classification join.
FRS_NAICS status
frs_naics_status
Optional
"ok" | "partial" | "unavailable" | "not_run" for the NAICS classification join.
Geocoder status
geocoder_status
Optional
"ok" | "unavailable" | "not_run" for the US Census geocoder used to resolve the query point's state.
FRS_INTERESTS error
frs_interests_error
Optional
Error text when the radius query did not fully succeed.
FRS_SIC error
frs_sic_error
Optional
Error text when the SIC join did not fully succeed.
FRS_NAICS error
frs_naics_error
Optional
Error text when the NAICS join did not fully succeed.
Geocoder error
geocoder_error
Optional
Error text when the Census geocoder did not answer.
Drift gate status
drift_gate_status
Optional
"verified" or "verified_degraded" on any emitted row. A failed or incomplete load-bearing gate fails the whole run before anything is emitted or billed.
Drift gate note
drift_gate_note
Optional
What the live drift gate measured on this run.
Drift probes verified
drift_probes_verified
Optional
Semicolon-separated ids of the drift probes that passed.
Data source
data_source
Optional
The upstream datasets behind this row.
Source URL
source_url
Optional
EPA Facility Registry Service homepage.
Checked at
checked_at
Optional
UTC timestamp of the run that produced this row.
Disclaimer
disclaimer
Optional
Scope statement: this is a screening aid, not a determination that a release has occurred.
Asset screen status
asset_screen_status
Optional
"complete" | "partial" | "not_screened". Whether this property was fully screened, screened but with some of its facility rows dropped by the run-level maxResults cap, or never screened at all. Every requested asset gets exactly one asset_summary row, so a property is never silently absent from the output.
Not-screened reason
not_screened_reason
Optional
When asset_screen_status is "not_screened", why this property could not be screened (for example an address the US Census geocoder could not resolve). Null on any property that was screened.
Facility rows dropped by the run-level cap
facility_rows_dropped_by_global_cap
Optional
How many of this property's facility rows the run-level maxResults cap dropped. The summary row's counts and verdict are computed over ALL facilities found, not just the rows emitted, so a non-zero value here means supporting detail is missing - never that the verdict is.
Results truncated by the run-level cap
results_truncated_global
Optional
Whether the run-level maxResults cap dropped any facility row anywhere in this run. This is a DIFFERENT cap from results_truncated, which reports the per-asset maxFacilitiesPerAsset cut. The run-level cap never drops an asset_summary row, so every property still carries its verdict.
Assets requested
assets_requested
Optional
How many properties this run was asked to screen. Compare with the number of asset_summary rows in the dataset: they are always equal.
Assets screened complete
assets_screened_complete
Optional
How many of the requested properties were screened with every facility row emitted.
Assets screened partial
assets_screened_partial
Optional
How many of the requested properties were screened but had facility rows dropped by the run-level maxResults cap. Their verdicts are still complete.
Assets not reached
assets_not_reached
Optional
How many of the requested properties could not be screened at all. Each still appears as an asset_summary row with astm_prior_use_verdict "not_screened" and a not_screened_reason.
maxResults in effect
max_results
Optional
The run-level row cap that was applied. It is a hard cap on rows and therefore a hard cap on the bill. A run whose maxResults is below the number of requested assets fails before emitting anything.
Property state name
asset_state_name
Optional
Full state name of the query coordinate from the US Census geocoder.
ASTM prior-use verdict
astm_prior_use_verdict
Optional
"contaminating_use_identified" | "no_classified_contaminating_use_found" | "inconclusive" | "not_screened". It can never read as a negative while a source was unavailable or this property's result set was truncated by maxFacilitiesPerAsset, and a property that could not be screened reads "not_screened" rather than being omitted from the output.
Verdict reason
astm_prior_use_verdict_reason
Optional
Why the verdict reads the way it does, including how many facilities published no classification at all.
Highest risk tier
highest_contaminant_risk_tier
Optional
Highest contaminant risk tier among the facilities that counted toward the verdict.
Nearest contaminating use
nearest_contaminating_use_name
Optional
Name of the nearest facility that counted toward the verdict.
Nearest contaminating use class
nearest_contaminating_use_class
Optional
Land-use class of the nearest counted facility.
Nearest contaminating use distance (mi)
nearest_contaminating_use_distance_miles
Optional
Distance to the nearest facility that counted toward the verdict.
FRS interest records in radius
frs_interest_records_in_radius
Optional
Raw FRS_INTERESTS rows returned. One facility usually carries several interest records, one per program system.
FRS facilities in radius
frs_facilities_in_radius
Optional
Distinct facilities after deduplicating interest records.
Facilities with a classification
facilities_with_classification
Optional
How many of those facilities EPA publishes any SIC or NAICS code for.
Facilities with no classification
facilities_without_any_classification
Optional
How many publish none. These are NOT evidence of no contaminating use - EPA simply does not classify them.
Classification coverage (%)
classification_coverage_pct
Optional
Share of in-radius facilities that carry any industrial classification. Read the negative verdict against this number.
Contaminating facilities found
contaminating_use_facility_count
Optional
Facilities in radius carrying a contaminating classification, before location filtering.
Contaminating facilities counted
contaminating_use_facility_count_counted_toward_verdict
Optional
Of those, how many had a reliable location and so counted toward the verdict.
Facility rows emitted
facilities_emitted
Optional
How many facility rows this property produced after the per-property cap.
Results truncated
results_truncated
Optional
Whether the PER-ASSET maxFacilitiesPerAsset cap cut this property's result set. When true a negative verdict is downgraded to inconclusive. The separate run-level maxResults cap is reported by results_truncated_global and never drops an asset_summary row. Null on a property that was not screened.
Max facilities per property
max_facilities_per_asset
Optional
The per-property cap in force for this run.
Mailing-address geocodes
mailing_address_geocode_facility_count
Optional
Contaminating facilities excluded from the verdict because the FRS record is filed in a different state than the query point.
Coordinate-stack facilities
coordinate_stack_facility_count
Optional
Contaminating facilities excluded from the verdict because many facilities share one identical coordinate.
Unknown-location facilities
unknown_location_confidence_facility_count
Optional
Contaminating facilities whose location could not be cross-checked, usually because the geocoder was unavailable.
Cross-state record mode
cross_state_records_mode
Optional
How out-of-state FRS records were handled on this run: flag, exclude or include.
Coordinate-stack threshold
coordinate_stack_threshold
Optional
The threshold in force for classifying a shared coordinate as a stack.
Land-use classes requested
land_use_classes_requested
Optional
Which classes this run screened for, or ALL.
Secondary classifications counted
include_secondary_classifications
Optional
Whether SECONDARY and UNKNOWN indicator codes counted as hits on this run.
State/tribal equivalent leg requested
state_leg_requested
Optional
Whether this run asked for the opt-in state and tribal equivalent record leg via programs: ["state"]. false means the leg never ran and every other state_* field on this row is null.
State/tribal leg status
state_leg_status
Optional
"not_requested" | "ok" | "unavailable" | "state_unknown" | "not_screened". Anything other than "ok" means no state-record conclusion was reached for this property and the counts are null rather than zero.
State/tribal record coverage for this jurisdiction
state_coverage
Optional
"complete" | "partial" | "none" | null. THE LOAD-BEARING FIELD OF THIS LEG. "none" means EPA FRS normalises NO state or tribal agency program system for this jurisdiction at all, so this record class could not be searched here - it is NOT a searched-and-empty result, and the state counts are null so no downstream filter can read it as one. Measured 2026-08-20: AK, CO, DC, MI, SD, VT, WV and the US territories all read "none". "partial" means either the radius read did not complete or one or more program systems could not be classified from the data. null means the leg did not run.
Why this coverage verdict
state_coverage_reason
Optional
Plain-language explanation of the state_coverage value, naming the jurisdiction, the systems searched and, when coverage is not complete, exactly what was not searched.
What state coverage does and does not mean
state_coverage_note
Optional
Standing disclosure that the state and tribal agency systems normalised into EPA FRS are a SUBSET of any state agency's own record holdings, and that state_coverage="none" means the class could not be searched here rather than that nothing was found.
State/tribal systems actually searched
state_program_systems_checked
Optional
The state or tribal agency program systems this property was actually screened against, with the count of records each holds in this state. null when the leg did not run or the radius read did not complete, in which case nothing was searched and nothing may be read as a negative.
Number of state/tribal systems searched
state_program_systems_checked_count
Optional
How many state or tribal agency program systems this property was actually screened against. null when the leg did not run.
State/tribal systems EPA publishes for this jurisdiction
state_program_systems_available_for_state
Optional
Every state or tribal agency program system EPA FRS publishes for this jurisdiction, measured live this run, with each system's in-state record count. null when the leg did not run; null with state_coverage="none" means EPA publishes none at all.
Number of state/tribal systems available
state_program_systems_available_for_state_count
Optional
How many state or tribal agency program systems EPA FRS publishes for this jurisdiction. 0 with state_coverage="none" is a fact about EPA's coverage of the state, not about this property.
Program systems that could not be classified
state_program_systems_indeterminate
Optional
Program systems holding between 50% and 90% of their national records in this state - too concentrated to call federal, too dispersed to call a state agency system. They are neither counted nor discarded, and their presence forces state_coverage to "partial". Measured 2026-08-20 this affects CDAFLP (ID), FARR (WA) and NNEMS (AZ).
Number of unclassifiable program systems
state_program_systems_indeterminate_count
Optional
How many program systems in this jurisdiction fell into the indeterminate confinement band. Any value above zero downgrades state_coverage to "partial".
Program systems in the live FRS universe
state_program_universe_size
Optional
How many distinct PGM_SYS_ACRNM values the whole FRS_INTERESTS layer published on this run (measured 97 on 2026-08-20). A drop below the floor fails the run rather than silently shrinking the record class.
Confinement threshold used
state_confinement_threshold
Optional
The in-state share of national records at or above which a program system was treated as a state or tribal agency system on this run (0.9). Measured basis: 57 systems sit at 96.05%-100%, three between 53% and 66%, and 37 at 42% or below, so 0.9 sits inside a 30-point empty band rather than on a cliff edge.
Facilities carrying a state/tribal record
state_equivalent_facility_count
Optional
How many FRS facilities within the radius carry at least one state or tribal agency program record. null when state_coverage is "none" - there was no record class to search, and zero would claim we looked.
State/tribal records with a reliable location
state_equivalent_facility_count_counted_toward_verdict
Optional
The subset of state-record facilities whose published coordinate passed the mailing-address and coordinate-stack checks. Only these drive astm_state_equivalent_verdict, for the same reason they drive the prior-use verdict. null when state_coverage is "none".
State/tribal records that are also contaminating uses
state_equivalent_contaminating_use_count
Optional
Facilities carrying both a state or tribal agency record and a contaminating SIC/NAICS classification - the strongest single signal this leg produces. null when state_coverage is "none".
ASTM state/tribal equivalent record verdict
astm_state_equivalent_verdict
Optional
"state_equivalent_record_identified" | "no_state_equivalent_record_found" | "state_equivalent_records_not_available_for_this_state" | "inconclusive" | "not_requested" | "not_screened". Deliberately SEPARATE from astm_prior_use_verdict, which is unchanged by this leg. It can never read as a clean negative while coverage is "partial" or "none".
ASTM reference for this leg
astm_state_equivalent_reference
Optional
The ASTM E1527-21 clause this leg addresses: Section 8.2 state and tribal equivalent record sources. Distinct from the Section 8.3 prior-use question the rest of the actor answers.
How the state inventory was derived
state_program_inventory_basis
Optional
States plainly that the per-state program-system inventory is measured live from two FRS group-by reads on every run and that no hard-coded list of state agencies is used - because such a list rots into a false clear the first time EPA onboards or retires an agency system.
Classification coverage note
classification_coverage_note
Optional
Measured statement of how much of the FRS universe carries an industrial classification at all, and why absence is never reported as an absence of contaminating use.
Negative control status
drift_negative_control_status
Optional
Outcome of the corroborating negative control (a bogus SIC code must return zero rows).
