Back to file

Schema

EPA Facility Registry Service (FRS) - Toxic Substances Control Act (TSCA) / EPA Facility Registry Service (FRS) - Toxic Substances Control Act (TSCA) / v1.0.0

View metadata

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.

Columns
32 columns
Features
25,806
Geometry
Point
ColumnTypeNullableNullsUniqueDescriptionExamples / Values
geometrygeometryNo0——
Range: —Length: —
Examples: —
Values: —
REGISTRY_IDstringNo0——
Range: —Length: 12
Examples: 110056965137, 110006625474, 110012542276, 110028187049, 110043670710
Values: —
PRIMARY_NAMEstringYes6——
Range: —Length: 80
Examples: HYNIX SEMICONDUCTOR MANUFACTURING SITE, WILLIAM B. TABLER CO., INC., ERGON BOISE, ELCON PRECISION LLC, HENKEL CORP
Values: —
LOCATION_ADDRESSstringYes6——
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_NAMEstringNo0——
Range: —Length: 60
Examples: HOUSTON, SAN DIEGO, FORT COLLINS, TEXAS CITY, NORTH CANTON
Values: —
COUNTY_NAMEstringYes61——
Range: —Length: 35
Examples: COOK, COOK, LEE, COLUMBIA, VERMILLION
Values: —
FIPS_CODEstringYes434——
Range: —Length: 5
Examples: 45025, 01129, 05063, 22089, 48157
Values: —
STATE_CODEstringYes7——
Range: —Length: 2
Examples: NC, GA, FL, TX, KY
Values: —
POSTAL_CODEstringYes1——
Range: —Length: 10
Examples: 29681-7150, 30059, 07458, 61360, 87107
Values: —
LATITUDE83floatNo0——
Range: 17.7102 to 70.226275Length: —
Examples: 29.79269, 32.566, 40.60344, 29.361044999999997, 40.90688
Values: —
LONGITUDE83floatNo0——
Range: -158.11629499999998 to -1.986133Length: —
Examples: -95.53443999999999, -116.97596, -105.07455, -94.930351, -81.43301
Values: —
HUC8_CODEstringYes2——
Range: —Length: 8
Examples: 03050109, 05120204, 02030103, 07120005, 12070205
Values: —
ACCURACY_VALUEfloatYes1,093——
Range: 0 to 20000Length: —
Examples: 30.0, 30.0, 25.0, 25.0, 30.0
Values: —
COLLECT_MTH_DESCstringYes735——
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_DESCstringYes738——
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_DATEstringNo0——
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_DATEstringYes3,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_DATEstringYes1,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_URLstringNo0——
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_IDstringNo0——
Range: —Length: 12
Examples: 100606401, TSCA4507, 200000831, TSCA5130, TSCA10044923
Values: —
PGM_SYS_ACRNMstringNo0——
Range: —Length: 4
Examples: TSCA, TSCA, TSCA, TSCA, TSCA
Values: TSCA
INTEREST_TYPEstringNo0——
Range: —Length: 14
Examples: TSCA SUBMITTER, TSCA SUBMITTER, TSCA SUBMITTER, TSCA SUBMITTER, TSCA SUBMITTER
Values: TSCA SUBMITTER
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_STATUSstringYes4,243——
Range: —Length: 15
Examples: ***UNCHANGED***, ***UNCHANGED***, ***UNCHANGED***, ***UNCHANGED***, ***UNCHANGED***
Values: ***UNCHANGED***
FEDERAL_AGENCY_NAMEstringYes5,000——
Range: —Length: —
Examples: —
Values: —
HUC_12stringYes3,933——
Range: —Length: 12
Examples: 020503060602, 080703000206, 060400060105, 071300030304, 101900040403
Values: —
FEDERAL_LAND_INDstringYes5,000——
Range: —Length: —
Examples: —
Values: —
FED_FACILITY_CODEstringYes4,576——
Range: —Length: 1
Examples: N, N, N, N, N
Values: N
EPA_REGION_CODEstringYes5——
Range: —Length: 2
Examples: 04, 06, 04, 07, 05
Values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10
KEY_FIELDstringNo0——
Range: —Length: 16
Examples: TSCA100606401, TSCATSCA4507, TSCA200000831, TSCATSCA5130, TSCATSCA10044923
Values: —
Quality checks: Passed
Invalid geometry count: 0
Columns hash: e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516