Schema
EPA Facility Registry Service (FRS) - Toxic Substances Control Act (TSCA) / EPA Facility Registry Service (FRS) - Toxic Substances Control Act (TSCA) / v1.0.0
Schema from epa-frs-toxic-substances-control-act-tsca.parquet, gcp-portolan-published, 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 Toxic Substances Control Act (TSCA) Chemical Substance Inventory System. Section 8 (b) of the Toxic Substances Control Act (TSCA) requires EPA to compile, keep current and publish a list of each chemical substance that is manufactured or processed, including imports, in the United States for uses under TSCA. Also called the "TSCA Inventory" or simply "the Inventory," it plays a central role in the regulation of most industrial chemicals in the United States. 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 TSCA facilities once the TSCA 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: 110056965137, 110006625474, 110012542276, 110028187049, 110043670710 Values: — |
| PRIMARY_NAME | string | Yes | 6 | — | — Range: —Length: 80 | Examples: HYNIX SEMICONDUCTOR MANUFACTURING SITE, WILLIAM B. TABLER CO., INC., ERGON BOISE, ELCON PRECISION LLC, HENKEL CORP Values: — |
| LOCATION_ADDRESS | string | Yes | 6 | — | — Range: —Length: 100 | Examples: 1830 WILLOW CREEK CIR, 1331 SOUTH 15TH STREET, 4303 GEKELER LN, 1009 TIMOTHY DRIVE, 923 MAULDIN RD. N.W. Values: — |
| CITY_NAME | string | No | 0 | — | — Range: —Length: 60 | Examples: HOUSTON, SAN DIEGO, FORT COLLINS, TEXAS CITY, NORTH CANTON Values: — |
| COUNTY_NAME | string | Yes | 61 | — | — Range: —Length: 35 | Examples: COOK, COOK, LEE, COLUMBIA, VERMILLION Values: — |
| FIPS_CODE | string | Yes | 434 | — | — Range: —Length: 5 | Examples: 45025, 01129, 05063, 22089, 48157 Values: — |
| STATE_CODE | string | Yes | 7 | — | — Range: —Length: 2 | Examples: NC, GA, FL, TX, KY Values: — |
| POSTAL_CODE | string | Yes | 1 | — | — Range: —Length: 10 | Examples: 29681-7150, 30059, 07458, 61360, 87107 Values: — |
| LATITUDE83 | float | No | 0 | — | — Range: 17.7102 to 70.226275Length: — | Examples: 29.79269, 32.566, 40.60344, 29.361044999999997, 40.90688 Values: — |
| LONGITUDE83 | float | No | 0 | — | — Range: -158.11629499999998 to -1.986133Length: — | Examples: -95.53443999999999, -116.97596, -105.07455, -94.930351, -81.43301 Values: — |
| HUC8_CODE | string | Yes | 2 | — | — Range: —Length: 8 | Examples: 03050109, 05120204, 02030103, 07120005, 12070205 Values: — |
| ACCURACY_VALUE | float | Yes | 1,093 | — | — Range: 0 to 20000Length: — | Examples: 30.0, 30.0, 25.0, 25.0, 30.0 Values: — |
| COLLECT_MTH_DESC | string | Yes | 735 | — | — Range: —Length: 86 | Examples: ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER, GPS CARRIER PHASE KINEMATIC RELATIVE POSITION, ADDRESS MATCHING-HOUSE NUMBER, ADDRESS MATCHING-HOUSE NUMBER Values: — |
| REF_POINT_DESC | string | Yes | 738 | — | — Range: —Length: 39 | Examples: ENTRANCE POINT OF A FACILITY OR STATION, PLANT ENTRANCE (GENERAL), CENTER OF A FACILITY OR STATION, POINT WHERE SUBSTANCE IS RELEASED, FACILITY CENTROID Values: — |
| CREATE_DATE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2014-02-07T10:11:15+00:00, 2014-09-02T21:51:37+00:00, 2008-05-15T17:39:12+00:00, 2014-08-31T21:56:11+00:00, 2019-12-17T00:00:00+00:00 Values: — |
| UPDATE_DATE | string | Yes | 3,757 | — | — Range: —Length: 25 | Examples: 2008-05-27T11:59:44+00:00, 2018-09-25T11:21:29+00:00, 2018-09-25T16:28:31+00:00, 2018-07-02T11:49:26+00:00, 2016-08-25T16:21:07+00:00 Values: — |
| LAST_REPORTED_DATE | string | Yes | 1,121 | — | — Range: —Length: 25 | Examples: 2023-01-31T00:00:00+00:00, 2022-12-08T00:00:00+00:00, 2022-03-26T15:34:09+00:00, 2021-01-12T18:00:14+00:00, 2016-10-26T12:34:17+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=110056965137, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110006625474, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110012542276, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110028187049, https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110043670710 Values: — |
| PGM_SYS_ID | string | No | 0 | — | — Range: —Length: 12 | Examples: 100606401, TSCA4507, 200000831, TSCA5130, TSCA10044923 Values: — |
| PGM_SYS_ACRNM | string | No | 0 | — | — Range: —Length: 4 | Examples: TSCA, TSCA, TSCA, TSCA, TSCA Values: TSCA |
| INTEREST_TYPE | string | No | 0 | — | — Range: —Length: 14 | Examples: TSCA SUBMITTER, TSCA SUBMITTER, TSCA SUBMITTER, TSCA SUBMITTER, TSCA SUBMITTER Values: TSCA SUBMITTER |
| 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 | 4,243 | — | — Range: —Length: 15 | Examples: ***UNCHANGED***, ***UNCHANGED***, ***UNCHANGED***, ***UNCHANGED***, ***UNCHANGED*** Values: ***UNCHANGED*** |
| FEDERAL_AGENCY_NAME | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| HUC_12 | string | Yes | 3,933 | — | — Range: —Length: 12 | Examples: 020503060602, 080703000206, 060400060105, 071300030304, 101900040403 Values: — |
| FEDERAL_LAND_IND | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| FED_FACILITY_CODE | string | Yes | 4,576 | — | — Range: —Length: 1 | Examples: N, N, N, N, N Values: N |
| EPA_REGION_CODE | string | Yes | 5 | — | — Range: —Length: 2 | Examples: 04, 06, 04, 07, 05 Values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10 |
| KEY_FIELD | string | No | 0 | — | — Range: —Length: 16 | Examples: TSCA100606401, TSCATSCA4507, TSCA200000831, TSCATSCA5130, TSCATSCA10044923 Values: — |
