Schema
EPA Emergency Response (ER) Risk Management Plan (RMP) Facilities / EPA Emergency Response (ER) Risk Management Plan (RMP) Facilities / v1.0.0
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.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| REGISTRY_ID | string | No | 0 | — | — Range: —Length: 12 | Examples: 110033219050, 110071536523, 110000514266, 110071947543, 110000569723 Values: — |
| PRIMARY_NAME | string | Yes | 1 | — | — 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_ADDRESS | string | Yes | 1 | — | — Range: —Length: 56 | Examples: 6251 W. STEGER ROAD, 400 S MAIN ST., RR AVE., I-27 NORTH, 801 E. 107TH ST. Values: — |
| CITY_NAME | string | No | 0 | — | — Range: —Length: 60 | Examples: FAIRMONT, OXFORD, WINTER HAVEN, FREDERICK, GREENVILLE Values: — |
| COUNTY_NAME | string | Yes | 1 | — | — Range: —Length: 35 | Examples: WILL, UNION, HARRIS, IBERVILLE, COOK Values: — |
| FIPS_CODE | string | Yes | 11 | — | — Range: —Length: 5 | Examples: 18039, 31109, 17011, 48189, 26135 Values: — |
| STATE_CODE | string | Yes | 1 | — | — Range: —Length: 2 | Examples: IL, IL, ND, TX, IL Values: — |
| POSTAL_CODE | string | No | 0 | — | — Range: —Length: 10 | Examples: 56031, 19363, 33884, 21701, 38703-3505 Values: — |
| LATITUDE83 | float | No | 0 | — | — Range: 13.359966 to 70.490861Length: — | Examples: 43.664021, 39.729600000000005, 27.96269, 39.444776999999995, 33.415555999999995 Values: — |
| LONGITUDE83 | float | No | 0 | — | — Range: -166.55519099999998 to 144.78300000000002Length: — | Examples: -94.492559, -75.9598, -81.68444, -77.39336, -91.00611099999999 Values: — |
| HUC8_CODE | string | Yes | 3 | — | — Range: —Length: 8 | Examples: 10210005, 05140206, 10130301, 12050005, 03010101 Values: — |
| ACCURACY_VALUE | float | Yes | 498 | — | — Range: 0 to 11000Length: — | Examples: 500.0, 25.0, 30.0, 30.0, 30.0 Values: — |
| COLLECT_MTH_DESC | string | Yes | 354 | — | — 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_DESC | string | Yes | 178 | — | — 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_DATE | string | No | 0 | — | — 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_DATE | string | Yes | 1,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_DATE | string | No | 0 | — | — 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_URL | string | No | 0 | — | — 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_ID | string | No | 0 | — | — Range: —Length: 12 | Examples: 100000202489, 100000249732, 100000063129, 100000120255, 100000165885 Values: — |
| PGM_SYS_ACRNM | string | No | 0 | — | — Range: —Length: 3 | Examples: RMP, RMP, RMP, RMP, RMP Values: RMP |
| INTEREST_TYPE | string | No | 0 | — | — Range: —Length: 12 | Examples: RMP REPORTER, RMP REPORTER, RMP REPORTER, RMP REPORTER, RMP REPORTER Values: RMP REPORTER |
| PROGRAM_URL | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| PGM_REPORT_URL | string | No | 0 | — | — Range: —Length: 11 | Examples: no data yet, no data yet, no data yet, no data yet, no data yet Values: no data yet |
| PUBLIC_IND | string | No | 0 | — | — Range: —Length: 1 | Examples: Y, Y, Y, Y, Y Values: Y |
| ACTIVE_STATUS | string | Yes | 242 | — | — Range: —Length: 8 | Examples: INACTIVE, ACTIVE, INACTIVE, ACTIVE, INACTIVE Values: ACTIVE, INACTIVE |
| FEDERAL_AGENCY_NAME | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| HUC_12 | string | Yes | 2,754 | — | — Range: —Length: 12 | Examples: 180701050208, 102100050102, 050800010604, 180200050406, 120602011103 Values: — |
| FEDERAL_LAND_IND | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| FED_FACILITY_CODE | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| EPA_REGION_CODE | string | No | 0 | — | — Range: —Length: 2 | Examples: 05, 03, 04, 03, 04 Values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10 |
| KEY_FIELD | string | No | 0 | — | — Range: —Length: 15 | Examples: RMP100000202489, RMP100000249732, RMP100000063129, RMP100000120255, RMP100000165885 Values: — |
