Schema
EPA Facility Registry Service (FRS) - Toxic Release Inventory (TRI) / EPA Facility Registry Service (FRS) - Toxic Release Inventory (TRI) / v1.0.0
Schema from epa-frs-toxic-release-inventory.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
The Facility Registry Service (FRS) provides quality facility data to support EPA's mission of protecting human health and the environment by identifying and geospatially locating facilities, sites, or places subject to environmental regulations of environmental interest. Facility data is improved with geospatial processing of incoming data and data curation tools to provide an integrated, dataset to partners and the public through a variety of methods and products. For more detailed information about these facilities, use the FRS Query tool. This layer provides facility information for the Toxic Release Inventory (TRI). TRI is EPA's publicly available database that contains more than 650 toxic chemicals that are being used by industry groups and federal facilities, manufactured, treated, transported, or released into the environment. For more information on TRI and TRI facilities, visit the TRI Search tool.
| 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: 110006171711, 110016951057, 110000493136, 110000441996, 110002339531 Values: — |
| PRIMARY_NAME | string | Yes | 3 | — | — Range: —Length: 80 | Examples: MARTIN MARIETTA MAGNESIA SPECIALTIES INC, OCALA JAI-ALAI, ANTELOPE COAL LLC - ANTELOPE MINE, BERRY PLASTICS HOLDING CORP - LAKEVILLE, RUSSELL EQUIPMENT, INC. Values: — |
| LOCATION_ADDRESS | string | Yes | 5 | — | — Range: —Length: 60 | Examples: 39 DOMRELL ST, 2043 S 35TH ST, 18 MARKET ST, 2308 LINCOLN HWY, 7834 C F HAWN FWY Values: — |
| CITY_NAME | string | No | 0 | — | — Range: —Length: 60 | Examples: WALDENBURG, WAUKESHA, GALLATIN, FARBER, GROESBECK Values: — |
| COUNTY_NAME | string | Yes | 33 | — | — Range: —Length: 35 | Examples: SUFFOLK, PULASKI COUNTY, FRANKLIN , YAMHILL, HAMILTON Values: — |
| FIPS_CODE | string | Yes | 122 | — | — Range: —Length: 5 | Examples: 55115, NJ039, 39133, 08031, 45015 Values: — |
| STATE_CODE | string | Yes | 4 | — | — Range: —Length: 2 | Examples: TX, IN, TX, IL, FL Values: — |
| POSTAL_CODE | string | No | 0 | — | — Range: —Length: 10 | Examples: 72475, 53186, 37066-8714, 63345, 76642 Values: — |
| LATITUDE83 | float | No | 0 | — | — Range: -14.267653 to 64.82639Length: — | Examples: 35.564319999999995, 43.0499, 36.324600000000004, 39.270900000000005, 31.538625 Values: — |
| LONGITUDE83 | float | No | 0 | — | — Range: -170.677972 to 145.73491Length: — | Examples: -90.930859, -88.2061, -86.4026, -91.57685, -96.526502 Values: — |
| HUC8_CODE | string | Yes | 6 | — | — Range: —Length: 8 | Examples: 07080105, 02030103, 08040206, 02050107, 07120003 Values: — |
| ACCURACY_VALUE | float | Yes | 585 | — | — Range: 0 to 11000Length: — | Examples: 10.0, 30.0, 30.0, 25.0, 50.0 Values: — |
| COLLECT_MTH_DESC | string | Yes | 349 | — | — Range: —Length: 72 | Examples: ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, INTERPOLATION-PHOTO, INTERPOLATION-PHOTO, ADDRESS MATCHING-HOUSE NUMBER Values: — |
| REF_POINT_DESC | string | Yes | 399 | — | — Range: —Length: 198 | Examples: ENTRANCE POINT OF A FACILITY OR STATION, CENTER OF A FACILITY OR STATION, CENTER OF A FACILITY OR STATION, ENTRANCE POINT OF A FACILITY OR STATION, CENTER OF A FACILITY OR STATION Values: — |
| CREATE_DATE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2001-06-01T11:39:22+00:00, 2013-08-30T08:31:11+00:00, 2013-08-30T08:30:53+00:00, 2000-06-17T11:13:14+00:00, 2001-03-30T12:13:12+00:00 Values: — |
| UPDATE_DATE | string | Yes | 847 | — | — Range: —Length: 25 | Examples: 2015-12-31T14:35:35+00:00, 2015-12-31T14:36:24+00:00, 2015-12-31T14:35:19+00:00, 2015-12-31T14:36:30+00:00, 2015-12-31T14:35:52+00:00 Values: — |
| LAST_REPORTED_DATE | string | Yes | 2,525 | — | — Range: —Length: 25 | Examples: 2016-06-27T12:59:26+00:00, 2023-11-29T15:55:55+00:00, 2020-04-02T00:00:00+00:00, 2025-06-21T13:04:48+00:00, 2022-03-03T16:05:04+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=110006171711, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110016951057, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110000493136, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110000441996, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110002339531 Values: — |
| PGM_SYS_ID | string | No | 0 | — | — Range: —Length: 16 | Examples: 72479FRMRSHWY49, 53186BRCFMW229N, 37066STVGL1499S, 63345NRTHM300WL, 76642HBBSN1000H Values: — |
| PGM_SYS_ACRNM | string | No | 0 | — | — Range: —Length: 4 | Examples: TRIS, TRIS, TRIS, TRIS, TRIS Values: TRIS |
| INTEREST_TYPE | string | No | 0 | — | — Range: —Length: 12 | Examples: TRI REPORTER, TRI REPORTER, TRI REPORTER, TRI REPORTER, TRI REPORTER Values: TRI REPORTER |
| PROGRAM_URL | string | No | 0 | — | — Range: —Length: 23 | Examples: http://www.epa.gov/tri/, http://www.epa.gov/tri/, http://www.epa.gov/tri/, http://www.epa.gov/tri/, http://www.epa.gov/tri/ Values: http://www.epa.gov/tri/ |
| 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 | 605 | — | — Range: —Length: 15 | Examples: ACTIVE, ACTIVE, ACTIVE, ACTIVE, ACTIVE Values: ***UNCHANGED***, ACTIVE, CLOSED, INACTIVE, OPEN |
| FEDERAL_AGENCY_NAME | string | Yes | 4,918 | — | — Range: —Length: 49 | Examples: Defense: Air National Guard, Homeland Security: Customs and Border Protection, Justice: Bureau of Prisons, Homeland Security: Customs and Border Protection, Energy: not otherwise classified Values: Agriculture: Forest Service, Defense: Air Force, Defense: Air National Guard, Defense: Army, Defense: Defense Logistics Agency, Defense: not otherwise classified, Energy: Fermi National Accelerator Laboratory, Energy: Idaho National Laboratory, Energy: National Energy Technology Laboratory, Energy: National Nuclear Security Administration, Energy: Savannah River National Laboratory, Energy: not otherwise classified, Environmental Protection Agency, Homeland Security: Customs and Border Protection, Homeland Security: not otherwise classified, Interior: Bureau of Land Management, Justice: Bureau of Prisons, Treasury: Bureau of Engraving and Printing, Veterans Affairs: Veterans Health Administratioin |
| HUC_12 | string | Yes | 4,295 | — | — Range: —Length: 12 | Examples: 031700010603, 041402011205, 041100020605, 051002050904, 031401010604 Values: — |
| FEDERAL_LAND_IND | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| FED_FACILITY_CODE | string | Yes | 1,994 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: N, Y |
| EPA_REGION_CODE | string | Yes | 1 | — | — Range: —Length: 2 | Examples: 04, 05, 08, 09, 04 Values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10 |
| KEY_FIELD | string | No | 0 | — | — Range: —Length: 20 | Examples: TRIS72479FRMRSHWY49, TRIS53186BRCFMW229N, TRIS37066STVGL1499S, TRIS63345NRTHM300WL, TRIS76642HBBSN1000H Values: — |
