Back to file

Schema

EPA Emergency Response (ER) Risk Management Plan (RMP) Facilities / EPA Emergency Response (ER) Risk Management Plan (RMP) Facilities / v1.0.0

View metadata

Schema from epa-emergency-response-rmp-facilities.parquet, gcs-hifld-next-datasets-prod, v1.0.0.

This web feature service contains location and facility identification information from EPA's Facility Registry Service (FRS) for the subset of facilities that link to the Risk Management Plan (RMP) System. The Risk Management Plan (RMP) database stores the risk management plans reported by companies that handle, manufacture, use, or store certain flammable or toxic substances, as required under section 112(r) of the Clean Air Act (CAA). FRS identifies and geospatially locates facilities, sites or places subject to environmental regulations or of environmental interest. Using vigorous verification and data management procedures, FRS integrates facility data from EPA's national program systems, other federal agencies, and State and tribal master facility records and provides EPA with a centrally managed, single source of comprehensive and authoritative information on facilities. This data set contains the subset of FRS integrated facilities that link to RMP facilities once the RMP data has been integrated into the FRS database. Additional information on FRS is available at the EPA website https://www.epa.gov/enviro/facility-registry-service-frs.

Columns
32 columns
Features
17,601
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0——
Range: —Length: —
Examples: —
Values: —
REGISTRY_IDstringNo0——
Range: —Length: 12
Examples: 110033219050, 110071536523, 110000514266, 110071947543, 110000569723
Values: —
PRIMARY_NAMEstringYes1——
Range: —Length: 80
Examples: AUX SABLE LIQUID PRODUCTS L.P. MONEE TERMINAL, SOUTHERN FS INC. JONESBORO LOC. # 77, CHS INC.-REEDER, SOUTHERN STATES COOPERATIVE- PLAINVIEW, TX (72249), DUTCH FARMS, INC.
Values: —
LOCATION_ADDRESSstringYes1——
Range: —Length: 56
Examples: 6251 W. STEGER ROAD, 400 S MAIN ST., RR AVE., I-27 NORTH, 801 E. 107TH ST.
Values: —
CITY_NAMEstringNo0——
Range: —Length: 60
Examples: FAIRMONT, OXFORD, WINTER HAVEN, FREDERICK, GREENVILLE
Values: —
COUNTY_NAMEstringYes1——
Range: —Length: 35
Examples: WILL, UNION, HARRIS, IBERVILLE, COOK
Values: —
FIPS_CODEstringYes11——
Range: —Length: 5
Examples: 18039, 31109, 17011, 48189, 26135
Values: —
STATE_CODEstringYes1——
Range: —Length: 2
Examples: IL, IL, ND, TX, IL
Values: —
POSTAL_CODEstringNo0——
Range: —Length: 10
Examples: 56031, 19363, 33884, 21701, 38703-3505
Values: —
LATITUDE83floatNo0——
Range: 13.359966 to 70.490861Length: —
Examples: 43.664021, 39.729600000000005, 27.96269, 39.444776999999995, 33.415555999999995
Values: —
LONGITUDE83floatNo0——
Range: -166.55519099999998 to 144.78300000000002Length: —
Examples: -94.492559, -75.9598, -81.68444, -77.39336, -91.00611099999999
Values: —
HUC8_CODEstringYes3——
Range: —Length: 8
Examples: 10210005, 05140206, 10130301, 12050005, 03010101
Values: —
ACCURACY_VALUEfloatYes498——
Range: 0 to 11000Length: —
Examples: 500.0, 25.0, 30.0, 30.0, 30.0
Values: —
COLLECT_MTH_DESCstringYes354——
Range: —Length: 72
Examples: ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, INTERPOLATION-PHOTO, ADDRESS MATCHING-STREET CENTERLINE
Values: —
REF_POINT_DESCstringYes178——
Range: —Length: 198
Examples: POINT WHERE SUBSTANCE IS RELEASED, ENTRANCE POINT OF A FACILITY OR STATION, ENTRANCE POINT OF A FACILITY OR STATION, STORAGE TANK, CENTER OF A FACILITY OR STATION
Values: —
CREATE_DATEstringNo0——
Range: —Length: 25
Examples: 2009-05-14T10:27:28+00:00, 2023-12-04T00:00:00+00:00, 2000-06-18T18:06:20+00:00, 2025-05-12T00:00:00+00:00, 2000-06-19T11:26:54+00:00
Values: —
UPDATE_DATEstringYes1,027——
Range: —Length: 25
Examples: 2014-02-14T11:05:26+00:00, 2014-12-01T13:13:45+00:00, 2014-04-10T13:00:52+00:00, 2014-02-14T11:05:15+00:00, 2014-02-14T11:04:37+00:00
Values: —
LAST_REPORTED_DATEstringNo0——
Range: —Length: 25
Examples: 2023-03-08T00:00:00+00:00, 2022-11-08T00:00:00+00:00, 1999-06-20T00:00:00+00:00, 2023-03-30T00:00:00+00:00, 2004-06-16T00:00:00+00:00
Values: —
FAC_URLstringNo0——
Range: —Length: 100
Examples: https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110033219050, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071536523, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110000514266, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071947543, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110000569723
Values: —
PGM_SYS_IDstringNo0——
Range: —Length: 12
Examples: 100000202489, 100000249732, 100000063129, 100000120255, 100000165885
Values: —
PGM_SYS_ACRNMstringNo0——
Range: —Length: 3
Examples: RMP, RMP, RMP, RMP, RMP
Values: RMP
INTEREST_TYPEstringNo0——
Range: —Length: 12
Examples: RMP REPORTER, RMP REPORTER, RMP REPORTER, RMP REPORTER, RMP REPORTER
Values: RMP REPORTER
PROGRAM_URLstringYes5,000——
Range: —Length: —
Examples: —
Values: —
PGM_REPORT_URLstringNo0——
Range: —Length: 11
Examples: no data yet, no data yet, no data yet, no data yet, no data yet
Values: no data yet
PUBLIC_INDstringNo0——
Range: —Length: 1
Examples: Y, Y, Y, Y, Y
Values: Y
ACTIVE_STATUSstringYes242——
Range: —Length: 8
Examples: INACTIVE, ACTIVE, INACTIVE, ACTIVE, INACTIVE
Values: ACTIVE, INACTIVE
FEDERAL_AGENCY_NAMEstringYes5,000——
Range: —Length: —
Examples: —
Values: —
HUC_12stringYes2,754——
Range: —Length: 12
Examples: 180701050208, 102100050102, 050800010604, 180200050406, 120602011103
Values: —
FEDERAL_LAND_INDstringYes5,000——
Range: —Length: —
Examples: —
Values: —
FED_FACILITY_CODEstringYes5,000——
Range: —Length: —
Examples: —
Values: —
EPA_REGION_CODEstringNo0——
Range: —Length: 2
Examples: 05, 03, 04, 03, 04
Values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10
KEY_FIELDstringNo0——
Range: —Length: 15
Examples: RMP100000202489, RMP100000249732, RMP100000063129, RMP100000120255, RMP100000165885
Values: —
Quality checks: Passed
Invalid geometry count: 0
Columns hash: e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516