Back to file

Schema

FRS INTERESTS / FRS INTERESTS / v1.0.0

View metadata

Schema from frs-interests.parquet, gcs-hifld-next-datasets-prod, v1.0.0.

This feature service consists of location and facility identification information from EPA's Facility Registry Service (FRS) for all sites that are available in the FRS individual feature layers. Although we have taken all available measures to optimize performance, because this service contains the full universe of FRS regulated facilities, the total data volume may lead to slow performance for many applications. We strongly recommend choosing from one of the feature services below which comprise the FRS major program databases, including: Assessment Cleanup and Redevelopment Exchange System (ACRES) : brownfields sites Air Facility System (AFS) : stationary sources of air pollutionICIS-AIR (AIR) : stationary sources of air pollutionBureau of Indian Affairs (BIA) : schools data on Indian landBase Realignment and Closure (BRAC) facilitiesClean Air Markets Division Business System (CAMDBS) : market-based air pollution control programsComprehensive Environmental Response, Superfund Enterprise Management System (SEMS): hazardous waste sitesIntegrated Compliance Information System (ICIS) : integrated enforcement and compliance informationNational Compliance Database (NCDB) : Federal Insecticide, Fungicide, and Rodenticide Act (FIFRA) and the Toxic Substances Control Act (TSCA)National Pollutant Discharge Elimination System (NPDES) module of ICIS : NPDES surface water permitsRadiation Information Database (RADINFO) : radiation and radioactivity facilitiesRACT/BACT/LAER Clearinghouse (RBLC) : best available air pollution technology requirementsResource Conservation and Recovery Act Information System (RCRAInfo) : tracks generators, transporters, treaters, storers, and disposers of hazardous wasteToxic Release Inventory (TRI) : certain industries that use, manufacture, treat, or transport more than 650 toxic chemicalsEmission Inventory System (EIS) : inventory of large stationary sources and voluntarily-reported smaller sources of air point pollution emittersCountermeasure (SPCC) and facility response plan (FRP) subject facilitiesElectronic Greenhouse Gas Reporting Tool (E-GGRT) : large greenhouse gas emittersEmissions and; Generation Resource Integrated Database (EGRID) : power plantsThe Facility Registry Service (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 FRS facilities that link to the programs listed above once the program data has been integrated into the FRS database. Additional information on FRS is available at the EPA website https://www.epa.gov/frs. EPA also publishes a download package that includes a file geodatabase, Esri ArcMap map document and an XML file of this metadata record and is refreshed on the same cycle as this service. Full FGDC metadata records for each layer are contained in the database.

Columns
32 columns
Features
6,266,602
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0——
Range: —Length: —
Examples: —
Values: —
REGISTRY_IDstringNo0——
Range: —Length: 12
Examples: 110035476918, 110014447189, 110020148400, 110066317266, 110071435728
Values: —
PRIMARY_NAMEstringNo0——
Range: —Length: 80
Examples: FDOT DIST 4 OLYMPIA OVERPASS, OCCIDENTAL CHEMICAL CORP, WANBLEE (OSHA) LAGOON, UTILITY TRAILER R&D FACILITY, ASHLAND WATER PLANT 1
Values: —
LOCATION_ADDRESSstringYes12——
Range: —Length: 50
Examples: 9725 3RD AVE NE, 5000 DAVIS DR., 40 AMITY ST, 11655 CO RD 59, W15898 KELLY RD
Values: —
CITY_NAMEstringYes9——
Range: —Length: 60
Examples: NEWARK, OFALLON, DAYTON, KEENESBURG, NEWARK
Values: —
COUNTY_NAMEstringYes221——
Range: —Length: 35
Examples: BROWARD, NEW HAVEN, MIDDLESEX, SUFFOLK, PICKENS COUNTY
Values: —
FIPS_CODEstringYes345——
Range: —Length: 5
Examples: 26099, 16049, 22121, 53033, 55079
Values: —
STATE_CODEstringYes1——
Range: —Length: 2
Examples: IN, NJ, MI, VT, UT
Values: —
POSTAL_CODEstringYes11——
Range: —Length: 10
Examples: 98115, 30559, 97062, 30677, 18951-3601
Values: —
LATITUDE83floatNo0——
Range: 13.504259999999999 to 66.84295999999999Length: —
Examples: 27.080553, 30.011868, 43.572027999999996, 34.09133, 29.222569999999997
Values: —
LONGITUDE83floatNo0——
Range: -162.59312 to 174.10767199999998Length: —
Examples: -80.146941, -91.13899099999999, -101.645972, -117.57905, -95.46038999999999
Values: —
HUC8_CODEstringYes3——
Range: —Length: 8
Examples: 05140101, 02030104, 04090002, 02010003, 12100301
Values: —
ACCURACY_VALUEfloatYes1,694——
Range: 0 to 15000Length: —
Examples: 30.0, 30.0, 50.0, 50.0, 50.0
Values: —
COLLECT_MTH_DESCstringYes1,012——
Range: —Length: 74
Examples: ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER
Values: —
REF_POINT_DESCstringYes1,084——
Range: —Length: 198
Examples: CENTER OF A FACILITY OR STATION, ENTRANCE POINT OF A FACILITY OR STATION, ENTRANCE POINT OF A FACILITY OR STATION, ENTRANCE POINT OF A FACILITY OR STATION, CENTER OF A FACILITY OR STATION
Values: ACRES POINTS NOT REPRESENTED BY 101-107, ADMINISTRATIVE BUILDING, AIR RELEASE STACK, CENTER OF A FACILITY OR STATION, CENTER OF FACILITY, ENTRANCE POINT OF A FACILITY OR STATION, FACILITY CENTROID, FACILITY/MONITORING SITE BOUNDARY POINT, LAGOON OR SETTLING POND, OTHER, PLANT ENTRANCE (GENERAL), POINT WHERE SUBSTANCE IS MONITORED, POINT WHERE SUBSTANCE IS PROCESSED, TREATED, STORED (POINT FROM WHICH SUBSTANCE COULD BE RELEASED INTO THE ENVIRONMENT), POINT WHERE SUBSTANCE IS RELEASED, POINT WHERE WATER OR OTHER SUBSTANCE COULD BE DRAWN FROM ENVIRONMENT FOR DELIVERY TO A FACILITY OR DISTRIBUTION SYSTEM (SUBSTANCE DESTINATION COULD RANGE FROM A SINGLE RESIDENCE TO A LARGE FACILITY), PROCESS UNIT, PROCESS UNIT AREA CENTROID, SOLID WASTE STORAGE AREA, STORAGE TANK, UNKNOWN
CREATE_DATEstringNo0——
Range: —Length: 25
Examples: 2022-08-04T00:00:00+00:00, 2015-08-18T15:36:01+00:00, 2015-10-09T13:28:43+00:00, 2015-10-14T15:21:30+00:00, 2023-07-07T00:00:00+00:00
Values: —
UPDATE_DATEstringYes3,919——
Range: —Length: 25
Examples: 2016-08-09T07:57:30+00:00, 2011-02-25T10:35:17+00:00, 2016-09-03T12:59:16+00:00, 2016-08-09T07:54:08+00:00, 2012-10-12T13:27:52+00:00
Values: —
LAST_REPORTED_DATEstringYes3,023——
Range: —Length: 25
Examples: 2009-12-31T00:00:00+00:00, 2009-12-31T00:00:00+00:00, 2018-05-17T00:00:00+00:00, 2025-01-23T00:00:00+00:00, 2013-11-26T00: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=110035476918, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110014447189, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020148400, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110066317266, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071435728
Values: —
PGM_SYS_IDstringNo0——
Range: —Length: 27
Examples: FLT020070231, LAR05N378, SDG589514, 165278, TXR1597NE
Values: —
PGM_SYS_ACRNMstringNo0——
Range: —Length: 15
Examples: RCRAINFO, NPDES, NPDES, CA-ENVIROVIEW, NPDES
Values: —
INTEREST_TYPEstringNo0——
Range: —Length: 46
Examples: VSQG, STORM WATER INDUSTRIAL, POTW, STATE MASTER, ICIS-NPDES NON-MAJOR
Values: —
PROGRAM_URLstringYes4,888——
Range: —Length: 50
Examples: http://www.epa.gov/osw/hazard/generation/lqg.htm, http://www.epa.gov/tri/, http://www.epa.gov/tri/, http://www.epa.gov/tri/, http://www.epa.gov/tri/
Values: http://cfpub.epa.gov/npdes/, http://www.epa.gov/air/oaqps/permits/obtain.html, http://www.epa.gov/osw/hazard/generation/lqg.htm, http://www.epa.gov/osw/hazard/tsd/index.htm, http://www.epa.gov/superfund/action/law/cercla.htm, http://www.epa.gov/tri/
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_STATUSstringYes1,162——
Range: —Length: 33
Examples: Y, TERMINATED, TERMINATED, ADMIN CONTINUED, EFFECTIVE
Values: —
FEDERAL_AGENCY_NAMEstringYes4,531——
Range: —Length: 55
Examples: Environmental Protection Agency, Defense: not otherwise classified, Environmental Protection Agency, Environmental Protection Agency, Defense: Air Force
Values: —
HUC_12stringYes4,381——
Range: —Length: 12
Examples: 031002010102, 030501011502, 051202090801, 111402040202, 050400030705
Values: —
FEDERAL_LAND_INDstringYes4,989——
Range: —Length: 1
Examples: Y, Y, Y, Y, Y
Values: Y
FED_FACILITY_CODEstringYes2,158——
Range: —Length: 1
Examples: N, N, Y, N, N
Values: N, Y
EPA_REGION_CODEstringYes54——
Range: —Length: 2
Examples: 06, 09, 09, 08, 09
Values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10
KEY_FIELDstringNo0——
Range: —Length: 35
Examples: RCRAINFOFLT020070231, NPDESLAR05N378, NPDESSDG589514, CA-ENVIROVIEW165278, NPDESTXR1597NE
Values: —
Quality checks: Passed
Invalid geometry count: 0
Columns hash: e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516