{"links":{"self":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1","dataset":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1","collection":"https://hifld.publicenvirodata.org/api/collections/hifld"},"collection":{"slug":"hifld","description":"HIFLD (Homeland Infrastructure Foundation-Level Data) datasets","id":1,"created_at":"2026-02-13T02:52:43.921817","updated_at":"2026-02-13T02:52:43.921841","name":"HIFLD"},"dataset":{"slug":"epa-superfund-enterprise-management-system-sems-sites-1","name":"EPA Superfund Enterprise Management System (SEMS) Sites","id":3105,"description":"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 location and attribute information for Facilities regulated under the Superfund Enterprise Management System (SEMS). SEMS integrates multiple legacy systems (e.g. CERCLIS, ICTS, SDMS) into a comprehensive inventory of active and archived hazardous waste sites evaluated by the Superfund program. It contains sites that are either proposed to be, or are on, the National Priorities List (NPL) as well as sites that are in the screening and assessment phase for possible inclusion in the NPL.","collection_id":1,"tags":{"inventory_name":"epa-superfund-enterprise-management-system-sems-sites-1","categories":["Chemicals","Public Health","Government","Natural Hazards"]},"created_at":"2026-02-15T06:46:23.493694","updated_at":"2026-02-15T06:46:23.493714"},"file":{"slug":"epa-superfund-enterprise-management-system-sems-sites-1","layer_name":null,"file_metadata":null,"updated_at":"2026-02-15T06:46:23.635130","id":3859,"name":"epa-superfund-enterprise-management-system-sems-sites-1","dataset_id":3105,"description":"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 location and attribute information for Facilities regulated under the Superfund Enterprise Management System (SEMS). SEMS integrates multiple legacy systems (e.g. CERCLIS, ICTS, SDMS) into a comprehensive inventory of active and archived hazardous waste sites evaluated by the Superfund program. It contains sites that are either proposed to be, or are on, the National Priorities List (NPL) as well as sites that are in the screening and assessment phase for possible inclusion in the NPL.","source_file_path":null,"created_at":"2026-02-15T06:46:23.635109","formats":[{"format":{"description":"GeoParquet format for efficient spatial data storage and analysis","format_type":"geoparquet","created_at":"2026-02-13T02:36:11.179416","id":1,"name":"GeoParquet","mime_type":"application/parquet","updated_at":"2026-02-13T02:36:11.179441"},"file_format":{"id":15910,"format_id":1,"created_at":"2026-02-15T06:46:23.804448","file_id":3859,"updated_at":"2026-02-15T06:46:23.804471"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T06:01:19.731401","id":18477,"file_format_id":15910,"created_at":"2026-05-19T21:57:47.810528","location":{"type":"file","version":"v1","path":"epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geoparquet/epa-superfund-enterprise-management-system-sems-sites-1.parquet"},"source_metadata":{"version":"v1","description":null,"size_bytes":1928028,"mime_type":null,"feature_count":14761,"bounds":[-179,-14.3601,177.519184,71.35589],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110020747977","110046120880","110071665172","110063172588","110022746670"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PRIMARY_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CALIFORNIA TRUCKING SALES","MAIN STREET GROUND WATER PLUME","TOWN OF BRAINTREE PROPERTY","BIOLAB, INC FIRE","NORGE TOWN DRY CLEANERS - ESPANOLA"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"LOCATION_ADDRESS","type":"string","description":null,"nullable":true,"num_null_values":1,"num_unique_values":null,"example_values":["910 RIVER ST","75-79 NORTH DIVISION ST","WRIGHT AVE.","I-95 MILE MARKER 88","920 MORSE AVENUE"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CITY_NAME","type":"string","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["VALDOSTA","MADISON","MERRIMACK","FOUR OAKS","ROSEVILLE"],"min":null,"max":null,"length":60,"possible_values":null},{"name":"COUNTY_NAME","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["LOWNDES","STARK","STORY","JOHNSTON","BROWN"],"min":null,"max":null,"length":35,"possible_values":null},{"name":"FIPS_CODE","type":"string","description":null,"nullable":true,"num_null_values":85,"num_unique_values":null,"example_values":["21149","36115","72137","20173","13047"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"STATE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CA","TX","MA","GA","NM"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"POSTAL_CODE","type":"string","description":null,"nullable":true,"num_null_values":6,"num_unique_values":null,"example_values":["61201","91763","08332","08322-2669","258130400"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"LATITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.940129999999996","30.737147999999998","42.224509999999995","33.6575","35.9914"],"min":-14.360100000000001,"max":71.287806,"length":null,"possible_values":null},{"name":"LONGITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-118.1802","-98.22543999999999","-70.98553","-84.00916699999999","-106.081384"],"min":-171.28283,"max":173.595832,"length":null,"possible_values":null},{"name":"HUC8_CODE","type":"string","description":null,"nullable":true,"num_null_values":17,"num_unique_values":null,"example_values":["04040001","02040206","07120003","17010201","16020304"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"ACCURACY_VALUE","type":"float","description":null,"nullable":true,"num_null_values":2554,"num_unique_values":null,"example_values":["50.0","25.0","30.0","50.0","30.0"],"min":1,"max":20000,"length":null,"possible_values":null},{"name":"COLLECT_MTH_DESC","type":"string","description":null,"nullable":true,"num_null_values":2487,"num_unique_values":null,"example_values":["GPS CODE (PSEUDO RANGE) DIFFERENTIAL","GPS CODE (PSEUDO RANGE) STANDARD POSITION (SA ON)","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER"],"min":null,"max":null,"length":72,"possible_values":null},{"name":"REF_POINT_DESC","type":"string","description":null,"nullable":true,"num_null_values":2564,"num_unique_values":null,"example_values":["ENTRANCE POINT 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"],"min":null,"max":null,"length":39,"possible_values":["ACRES POINTS NOT REPRESENTED BY 101-107","ADMINISTRATIVE BUILDING","CENTER OF A FACILITY OR STATION","CENTER OF FACILITY","ENTRANCE POINT OF A FACILITY OR STATION","FACILITY CENTROID","FACILITY/MONITORING SITE BOUNDARY POINT","LOADING AREA CENTROID","LOADING FACILITY","OTHER","PLANT ENTRANCE (GENERAL)","POINT WHERE SUBSTANCE IS MONITORED","POINT WHERE SUBSTANCE IS RELEASED","PROCESS UNIT AREA CENTROID","SE CORNER OF LAND PARCEL","SOLID WASTE STORAGE AREA","UNKNOWN"]},{"name":"CREATE_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00","2024-04-03T00:00:00+00:00","2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"UPDATE_DATE","type":"string","description":null,"nullable":true,"num_null_values":525,"num_unique_values":null,"example_values":["2021-11-24T13:48:56+00:00","2021-11-24T13:48:52+00:00","2021-11-24T13:48:58+00:00","2015-12-11T00:05:12+00:00","2021-11-24T13:48:57+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"LAST_REPORTED_DATE","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FAC_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020747977","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110046120880","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071665172","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110063172588","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110022746670"],"min":null,"max":null,"length":100,"possible_values":null},{"name":"PGM_SYS_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CAN000906116","TXN000607441","MAN000153839","GAD069200061","NMD986670156"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PGM_SYS_ACRNM","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMS","SEMS","SEMS","SEMS","SEMS"],"min":null,"max":null,"length":4,"possible_values":["SEMS"]},{"name":"INTEREST_TYPE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL","SUPERFUND (NON-NPL)","SUPERFUND (NON-NPL)","SUPERFUND NPL"],"min":null,"max":null,"length":19,"possible_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL"]},{"name":"PROGRAM_URL","type":"string","description":null,"nullable":true,"num_null_values":4401,"num_unique_values":null,"example_values":["http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm"],"min":null,"max":null,"length":50,"possible_values":["http://www.epa.gov/superfund/action/law/cercla.htm"]},{"name":"PGM_REPORT_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["no data yet","no data yet","no data yet","no data yet","no data yet"],"min":null,"max":null,"length":11,"possible_values":["no data yet"]},{"name":"PUBLIC_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"ACTIVE_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NOT ON THE NPL","CURRENTLY ON THE FINAL NPL","NOT ON THE NPL","NOT ON THE NPL","CURRENTLY ON THE FINAL NPL"],"min":null,"max":null,"length":28,"possible_values":["CURRENTLY ON THE FINAL NPL","DELETED FROM THE FINAL NPL","NOT ON THE NPL","PROPOSED FOR NPL","REMOVED FROM PROPOSED NPL","SITE IS PART OF NPL SITE","WITHDRAWN FROM THE FINAL NPL"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"HUC_12","type":"string","description":null,"nullable":true,"num_null_values":4357,"num_unique_values":null,"example_values":["111003030104","101900020904","051201060204","031502020204","210100050501"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FED_FACILITY_CODE","type":"string","description":null,"nullable":true,"num_null_values":3982,"num_unique_values":null,"example_values":["N","Y","Y","Y","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"EPA_REGION_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["09","06","01","04","06"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"KEY_FIELD","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMSCAN000906116","SEMSTXN000607441","SEMSMAN000153839","SEMSGAD069200061","SEMSNMD986670156"],"min":null,"max":null,"length":16,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geoparquet/epa-superfund-enterprise-management-system-sems-sites-1.parquet","storage_uri":"gs://hifld-next-datasets-prod/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geoparquet/epa-superfund-enterprise-management-system-sems-sites-1.parquet","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1/sources/18477/download-zip"}}]},{"format":{"description":"PMTiles format for tile serving and web mapping","format_type":"pmtiles","created_at":"2026-02-13T02:36:11.357073","id":2,"name":"PMTiles","mime_type":"application/x-protobuf","updated_at":"2026-02-13T02:36:11.357095"},"file_format":{"id":15911,"format_id":2,"created_at":"2026-02-15T06:46:24.173671","file_id":3859,"updated_at":"2026-02-15T06:46:24.173699"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T06:01:19.781235","id":18478,"file_format_id":15911,"created_at":"2026-05-19T21:57:48.099836","location":{"type":"file","version":"v1","path":"epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/pmtiles/epa-superfund-enterprise-management-system-sems-sites-1.pmtiles"},"source_metadata":{"version":"v1","description":null,"size_bytes":3005164,"mime_type":null,"feature_count":14761,"bounds":[-179,-14.3601,177.519184,71.35589],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110020747977","110046120880","110071665172","110063172588","110022746670"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PRIMARY_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CALIFORNIA TRUCKING SALES","MAIN STREET GROUND WATER PLUME","TOWN OF BRAINTREE PROPERTY","BIOLAB, INC FIRE","NORGE TOWN DRY CLEANERS - ESPANOLA"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"LOCATION_ADDRESS","type":"string","description":null,"nullable":true,"num_null_values":1,"num_unique_values":null,"example_values":["910 RIVER ST","75-79 NORTH DIVISION ST","WRIGHT AVE.","I-95 MILE MARKER 88","920 MORSE AVENUE"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CITY_NAME","type":"string","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["VALDOSTA","MADISON","MERRIMACK","FOUR OAKS","ROSEVILLE"],"min":null,"max":null,"length":60,"possible_values":null},{"name":"COUNTY_NAME","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["LOWNDES","STARK","STORY","JOHNSTON","BROWN"],"min":null,"max":null,"length":35,"possible_values":null},{"name":"FIPS_CODE","type":"string","description":null,"nullable":true,"num_null_values":85,"num_unique_values":null,"example_values":["21149","36115","72137","20173","13047"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"STATE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CA","TX","MA","GA","NM"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"POSTAL_CODE","type":"string","description":null,"nullable":true,"num_null_values":6,"num_unique_values":null,"example_values":["61201","91763","08332","08322-2669","258130400"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"LATITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.940129999999996","30.737147999999998","42.224509999999995","33.6575","35.9914"],"min":-14.360100000000001,"max":71.287806,"length":null,"possible_values":null},{"name":"LONGITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-118.1802","-98.22543999999999","-70.98553","-84.00916699999999","-106.081384"],"min":-171.28283,"max":173.595832,"length":null,"possible_values":null},{"name":"HUC8_CODE","type":"string","description":null,"nullable":true,"num_null_values":17,"num_unique_values":null,"example_values":["04040001","02040206","07120003","17010201","16020304"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"ACCURACY_VALUE","type":"float","description":null,"nullable":true,"num_null_values":2554,"num_unique_values":null,"example_values":["50.0","25.0","30.0","50.0","30.0"],"min":1,"max":20000,"length":null,"possible_values":null},{"name":"COLLECT_MTH_DESC","type":"string","description":null,"nullable":true,"num_null_values":2487,"num_unique_values":null,"example_values":["GPS CODE (PSEUDO RANGE) DIFFERENTIAL","GPS CODE (PSEUDO RANGE) STANDARD POSITION (SA ON)","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER"],"min":null,"max":null,"length":72,"possible_values":null},{"name":"REF_POINT_DESC","type":"string","description":null,"nullable":true,"num_null_values":2564,"num_unique_values":null,"example_values":["ENTRANCE POINT 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"],"min":null,"max":null,"length":39,"possible_values":["ACRES POINTS NOT REPRESENTED BY 101-107","ADMINISTRATIVE BUILDING","CENTER OF A FACILITY OR STATION","CENTER OF FACILITY","ENTRANCE POINT OF A FACILITY OR STATION","FACILITY CENTROID","FACILITY/MONITORING SITE BOUNDARY POINT","LOADING AREA CENTROID","LOADING FACILITY","OTHER","PLANT ENTRANCE (GENERAL)","POINT WHERE SUBSTANCE IS MONITORED","POINT WHERE SUBSTANCE IS RELEASED","PROCESS UNIT AREA CENTROID","SE CORNER OF LAND PARCEL","SOLID WASTE STORAGE AREA","UNKNOWN"]},{"name":"CREATE_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00","2024-04-03T00:00:00+00:00","2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"UPDATE_DATE","type":"string","description":null,"nullable":true,"num_null_values":525,"num_unique_values":null,"example_values":["2021-11-24T13:48:56+00:00","2021-11-24T13:48:52+00:00","2021-11-24T13:48:58+00:00","2015-12-11T00:05:12+00:00","2021-11-24T13:48:57+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"LAST_REPORTED_DATE","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FAC_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020747977","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110046120880","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071665172","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110063172588","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110022746670"],"min":null,"max":null,"length":100,"possible_values":null},{"name":"PGM_SYS_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CAN000906116","TXN000607441","MAN000153839","GAD069200061","NMD986670156"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PGM_SYS_ACRNM","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMS","SEMS","SEMS","SEMS","SEMS"],"min":null,"max":null,"length":4,"possible_values":["SEMS"]},{"name":"INTEREST_TYPE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL","SUPERFUND (NON-NPL)","SUPERFUND (NON-NPL)","SUPERFUND NPL"],"min":null,"max":null,"length":19,"possible_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL"]},{"name":"PROGRAM_URL","type":"string","description":null,"nullable":true,"num_null_values":4401,"num_unique_values":null,"example_values":["http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm"],"min":null,"max":null,"length":50,"possible_values":["http://www.epa.gov/superfund/action/law/cercla.htm"]},{"name":"PGM_REPORT_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["no data yet","no data yet","no data yet","no data yet","no data yet"],"min":null,"max":null,"length":11,"possible_values":["no data yet"]},{"name":"PUBLIC_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"ACTIVE_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NOT ON THE NPL","CURRENTLY ON THE FINAL NPL","NOT ON THE NPL","NOT ON THE NPL","CURRENTLY ON THE FINAL NPL"],"min":null,"max":null,"length":28,"possible_values":["CURRENTLY ON THE FINAL NPL","DELETED FROM THE FINAL NPL","NOT ON THE NPL","PROPOSED FOR NPL","REMOVED FROM PROPOSED NPL","SITE IS PART OF NPL SITE","WITHDRAWN FROM THE FINAL NPL"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"HUC_12","type":"string","description":null,"nullable":true,"num_null_values":4357,"num_unique_values":null,"example_values":["111003030104","101900020904","051201060204","031502020204","210100050501"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FED_FACILITY_CODE","type":"string","description":null,"nullable":true,"num_null_values":3982,"num_unique_values":null,"example_values":["N","Y","Y","Y","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"EPA_REGION_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["09","06","01","04","06"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"KEY_FIELD","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMSCAN000906116","SEMSTXN000607441","SEMSMAN000153839","SEMSGAD069200061","SEMSNMD986670156"],"min":null,"max":null,"length":16,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/pmtiles/epa-superfund-enterprise-management-system-sems-sites-1.pmtiles","storage_uri":"gs://hifld-next-datasets-prod/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/pmtiles/epa-superfund-enterprise-management-system-sems-sites-1.pmtiles","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1/sources/18478/download-zip"}}]},{"format":{"description":"GeoPackage format for geospatial data storage and exchange","format_type":"geopackage","created_at":"2026-02-15T03:18:57.332771","id":4,"name":"GeoPackage","mime_type":"application/geopackage+sqlite3","updated_at":"2026-02-15T03:18:57.332796"},"file_format":{"id":15912,"format_id":4,"created_at":"2026-02-15T06:46:24.544801","file_id":3859,"updated_at":"2026-02-15T06:46:24.544821"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T06:01:19.681245","id":18476,"file_format_id":15912,"created_at":"2026-05-19T21:57:47.514944","location":{"type":"file","version":"v1","path":"epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geopackage/epa-superfund-enterprise-management-system-sems-sites-1-FRS_INTERESTS_SEMS.gpkg"},"source_metadata":{"version":"v1","description":null,"size_bytes":7929856,"mime_type":null,"feature_count":14761,"bounds":[-179,-14.3601,177.519184,71.35589],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110020747977","110046120880","110071665172","110063172588","110022746670"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PRIMARY_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CALIFORNIA TRUCKING SALES","MAIN STREET GROUND WATER PLUME","TOWN OF BRAINTREE PROPERTY","BIOLAB, INC FIRE","NORGE TOWN DRY CLEANERS - ESPANOLA"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"LOCATION_ADDRESS","type":"string","description":null,"nullable":true,"num_null_values":1,"num_unique_values":null,"example_values":["910 RIVER ST","75-79 NORTH DIVISION ST","WRIGHT AVE.","I-95 MILE MARKER 88","920 MORSE AVENUE"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CITY_NAME","type":"string","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["VALDOSTA","MADISON","MERRIMACK","FOUR OAKS","ROSEVILLE"],"min":null,"max":null,"length":60,"possible_values":null},{"name":"COUNTY_NAME","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["LOWNDES","STARK","STORY","JOHNSTON","BROWN"],"min":null,"max":null,"length":35,"possible_values":null},{"name":"FIPS_CODE","type":"string","description":null,"nullable":true,"num_null_values":85,"num_unique_values":null,"example_values":["21149","36115","72137","20173","13047"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"STATE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CA","TX","MA","GA","NM"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"POSTAL_CODE","type":"string","description":null,"nullable":true,"num_null_values":6,"num_unique_values":null,"example_values":["61201","91763","08332","08322-2669","258130400"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"LATITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.940129999999996","30.737147999999998","42.224509999999995","33.6575","35.9914"],"min":-14.360100000000001,"max":71.287806,"length":null,"possible_values":null},{"name":"LONGITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-118.1802","-98.22543999999999","-70.98553","-84.00916699999999","-106.081384"],"min":-171.28283,"max":173.595832,"length":null,"possible_values":null},{"name":"HUC8_CODE","type":"string","description":null,"nullable":true,"num_null_values":17,"num_unique_values":null,"example_values":["04040001","02040206","07120003","17010201","16020304"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"ACCURACY_VALUE","type":"float","description":null,"nullable":true,"num_null_values":2554,"num_unique_values":null,"example_values":["50.0","25.0","30.0","50.0","30.0"],"min":1,"max":20000,"length":null,"possible_values":null},{"name":"COLLECT_MTH_DESC","type":"string","description":null,"nullable":true,"num_null_values":2487,"num_unique_values":null,"example_values":["GPS CODE (PSEUDO RANGE) DIFFERENTIAL","GPS CODE (PSEUDO RANGE) STANDARD POSITION (SA ON)","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER"],"min":null,"max":null,"length":72,"possible_values":null},{"name":"REF_POINT_DESC","type":"string","description":null,"nullable":true,"num_null_values":2564,"num_unique_values":null,"example_values":["ENTRANCE POINT 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"],"min":null,"max":null,"length":39,"possible_values":["ACRES POINTS NOT REPRESENTED BY 101-107","ADMINISTRATIVE BUILDING","CENTER OF A FACILITY OR STATION","CENTER OF FACILITY","ENTRANCE POINT OF A FACILITY OR STATION","FACILITY CENTROID","FACILITY/MONITORING SITE BOUNDARY POINT","LOADING AREA CENTROID","LOADING FACILITY","OTHER","PLANT ENTRANCE (GENERAL)","POINT WHERE SUBSTANCE IS MONITORED","POINT WHERE SUBSTANCE IS RELEASED","PROCESS UNIT AREA CENTROID","SE CORNER OF LAND PARCEL","SOLID WASTE STORAGE AREA","UNKNOWN"]},{"name":"CREATE_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00","2024-04-03T00:00:00+00:00","2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"UPDATE_DATE","type":"string","description":null,"nullable":true,"num_null_values":525,"num_unique_values":null,"example_values":["2021-11-24T13:48:56+00:00","2021-11-24T13:48:52+00:00","2021-11-24T13:48:58+00:00","2015-12-11T00:05:12+00:00","2021-11-24T13:48:57+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"LAST_REPORTED_DATE","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FAC_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020747977","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110046120880","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071665172","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110063172588","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110022746670"],"min":null,"max":null,"length":100,"possible_values":null},{"name":"PGM_SYS_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CAN000906116","TXN000607441","MAN000153839","GAD069200061","NMD986670156"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PGM_SYS_ACRNM","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMS","SEMS","SEMS","SEMS","SEMS"],"min":null,"max":null,"length":4,"possible_values":["SEMS"]},{"name":"INTEREST_TYPE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL","SUPERFUND (NON-NPL)","SUPERFUND (NON-NPL)","SUPERFUND NPL"],"min":null,"max":null,"length":19,"possible_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL"]},{"name":"PROGRAM_URL","type":"string","description":null,"nullable":true,"num_null_values":4401,"num_unique_values":null,"example_values":["http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm"],"min":null,"max":null,"length":50,"possible_values":["http://www.epa.gov/superfund/action/law/cercla.htm"]},{"name":"PGM_REPORT_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["no data yet","no data yet","no data yet","no data yet","no data yet"],"min":null,"max":null,"length":11,"possible_values":["no data yet"]},{"name":"PUBLIC_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"ACTIVE_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NOT ON THE NPL","CURRENTLY ON THE FINAL NPL","NOT ON THE NPL","NOT ON THE NPL","CURRENTLY ON THE FINAL NPL"],"min":null,"max":null,"length":28,"possible_values":["CURRENTLY ON THE FINAL NPL","DELETED FROM THE FINAL NPL","NOT ON THE NPL","PROPOSED FOR NPL","REMOVED FROM PROPOSED NPL","SITE IS PART OF NPL SITE","WITHDRAWN FROM THE FINAL NPL"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"HUC_12","type":"string","description":null,"nullable":true,"num_null_values":4357,"num_unique_values":null,"example_values":["111003030104","101900020904","051201060204","031502020204","210100050501"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FED_FACILITY_CODE","type":"string","description":null,"nullable":true,"num_null_values":3982,"num_unique_values":null,"example_values":["N","Y","Y","Y","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"EPA_REGION_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["09","06","01","04","06"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"KEY_FIELD","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMSCAN000906116","SEMSTXN000607441","SEMSMAN000153839","SEMSGAD069200061","SEMSNMD986670156"],"min":null,"max":null,"length":16,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geopackage/epa-superfund-enterprise-management-system-sems-sites-1-FRS_INTERESTS_SEMS.gpkg","storage_uri":"gs://hifld-next-datasets-prod/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geopackage/epa-superfund-enterprise-management-system-sems-sites-1-FRS_INTERESTS_SEMS.gpkg","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1/sources/18476/download-zip"}}]},{"format":{"description":"ESRI Shapefile format for geospatial vector data","format_type":"shapefile","created_at":"2026-02-15T03:18:57.546771","id":5,"name":"Shapefile","mime_type":"application/zip","updated_at":"2026-02-15T03:18:57.546794"},"file_format":{"id":15913,"format_id":5,"created_at":"2026-02-15T06:46:24.914712","file_id":3859,"updated_at":"2026-02-15T06:46:24.914733"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T06:01:19.825269","id":18479,"file_format_id":15913,"created_at":"2026-05-19T21:57:48.645074","location":{"type":"file","version":"v1","path":"epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/shapefile/epa-superfund-enterprise-management-system-sems-sites-1.zip"},"source_metadata":{"version":"v1","description":null,"size_bytes":2272274,"mime_type":null,"feature_count":14761,"bounds":[-179,-14.3601,177.519184,71.35589],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110020747977","110046120880","110071665172","110063172588","110022746670"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PRIMARY_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CALIFORNIA TRUCKING SALES","MAIN STREET GROUND WATER PLUME","TOWN OF BRAINTREE PROPERTY","BIOLAB, INC FIRE","NORGE TOWN DRY CLEANERS - ESPANOLA"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"LOCATION_ADDRESS","type":"string","description":null,"nullable":true,"num_null_values":1,"num_unique_values":null,"example_values":["910 RIVER ST","75-79 NORTH DIVISION ST","WRIGHT AVE.","I-95 MILE MARKER 88","920 MORSE AVENUE"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CITY_NAME","type":"string","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["VALDOSTA","MADISON","MERRIMACK","FOUR OAKS","ROSEVILLE"],"min":null,"max":null,"length":60,"possible_values":null},{"name":"COUNTY_NAME","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["LOWNDES","STARK","STORY","JOHNSTON","BROWN"],"min":null,"max":null,"length":35,"possible_values":null},{"name":"FIPS_CODE","type":"string","description":null,"nullable":true,"num_null_values":85,"num_unique_values":null,"example_values":["21149","36115","72137","20173","13047"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"STATE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CA","TX","MA","GA","NM"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"POSTAL_CODE","type":"string","description":null,"nullable":true,"num_null_values":6,"num_unique_values":null,"example_values":["61201","91763","08332","08322-2669","258130400"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"LATITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.940129999999996","30.737147999999998","42.224509999999995","33.6575","35.9914"],"min":-14.360100000000001,"max":71.287806,"length":null,"possible_values":null},{"name":"LONGITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-118.1802","-98.22543999999999","-70.98553","-84.00916699999999","-106.081384"],"min":-171.28283,"max":173.595832,"length":null,"possible_values":null},{"name":"HUC8_CODE","type":"string","description":null,"nullable":true,"num_null_values":17,"num_unique_values":null,"example_values":["04040001","02040206","07120003","17010201","16020304"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"ACCURACY_VALUE","type":"float","description":null,"nullable":true,"num_null_values":2554,"num_unique_values":null,"example_values":["50.0","25.0","30.0","50.0","30.0"],"min":1,"max":20000,"length":null,"possible_values":null},{"name":"COLLECT_MTH_DESC","type":"string","description":null,"nullable":true,"num_null_values":2487,"num_unique_values":null,"example_values":["GPS CODE (PSEUDO RANGE) DIFFERENTIAL","GPS CODE (PSEUDO RANGE) STANDARD POSITION (SA ON)","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER"],"min":null,"max":null,"length":72,"possible_values":null},{"name":"REF_POINT_DESC","type":"string","description":null,"nullable":true,"num_null_values":2564,"num_unique_values":null,"example_values":["ENTRANCE POINT 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"],"min":null,"max":null,"length":39,"possible_values":["ACRES POINTS NOT REPRESENTED BY 101-107","ADMINISTRATIVE BUILDING","CENTER OF A FACILITY OR STATION","CENTER OF FACILITY","ENTRANCE POINT OF A FACILITY OR STATION","FACILITY CENTROID","FACILITY/MONITORING SITE BOUNDARY POINT","LOADING AREA CENTROID","LOADING FACILITY","OTHER","PLANT ENTRANCE (GENERAL)","POINT WHERE SUBSTANCE IS MONITORED","POINT WHERE SUBSTANCE IS RELEASED","PROCESS UNIT AREA CENTROID","SE CORNER OF LAND PARCEL","SOLID WASTE STORAGE AREA","UNKNOWN"]},{"name":"CREATE_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00","2024-04-03T00:00:00+00:00","2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"UPDATE_DATE","type":"string","description":null,"nullable":true,"num_null_values":525,"num_unique_values":null,"example_values":["2021-11-24T13:48:56+00:00","2021-11-24T13:48:52+00:00","2021-11-24T13:48:58+00:00","2015-12-11T00:05:12+00:00","2021-11-24T13:48:57+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"LAST_REPORTED_DATE","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FAC_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020747977","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110046120880","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071665172","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110063172588","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110022746670"],"min":null,"max":null,"length":100,"possible_values":null},{"name":"PGM_SYS_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CAN000906116","TXN000607441","MAN000153839","GAD069200061","NMD986670156"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PGM_SYS_ACRNM","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMS","SEMS","SEMS","SEMS","SEMS"],"min":null,"max":null,"length":4,"possible_values":["SEMS"]},{"name":"INTEREST_TYPE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL","SUPERFUND (NON-NPL)","SUPERFUND (NON-NPL)","SUPERFUND NPL"],"min":null,"max":null,"length":19,"possible_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL"]},{"name":"PROGRAM_URL","type":"string","description":null,"nullable":true,"num_null_values":4401,"num_unique_values":null,"example_values":["http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm"],"min":null,"max":null,"length":50,"possible_values":["http://www.epa.gov/superfund/action/law/cercla.htm"]},{"name":"PGM_REPORT_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["no data yet","no data yet","no data yet","no data yet","no data yet"],"min":null,"max":null,"length":11,"possible_values":["no data yet"]},{"name":"PUBLIC_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"ACTIVE_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NOT ON THE NPL","CURRENTLY ON THE FINAL NPL","NOT ON THE NPL","NOT ON THE NPL","CURRENTLY ON THE FINAL NPL"],"min":null,"max":null,"length":28,"possible_values":["CURRENTLY ON THE FINAL NPL","DELETED FROM THE FINAL NPL","NOT ON THE NPL","PROPOSED FOR NPL","REMOVED FROM PROPOSED NPL","SITE IS PART OF NPL SITE","WITHDRAWN FROM THE FINAL NPL"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"HUC_12","type":"string","description":null,"nullable":true,"num_null_values":4357,"num_unique_values":null,"example_values":["111003030104","101900020904","051201060204","031502020204","210100050501"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FED_FACILITY_CODE","type":"string","description":null,"nullable":true,"num_null_values":3982,"num_unique_values":null,"example_values":["N","Y","Y","Y","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"EPA_REGION_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["09","06","01","04","06"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"KEY_FIELD","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMSCAN000906116","SEMSTXN000607441","SEMSMAN000153839","SEMSGAD069200061","SEMSNMD986670156"],"min":null,"max":null,"length":16,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/shapefile/epa-superfund-enterprise-management-system-sems-sites-1.zip","storage_uri":"gs://hifld-next-datasets-prod/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/shapefile/epa-superfund-enterprise-management-system-sems-sites-1.zip","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1/sources/18479/download-zip"}}]},{"format":{"description":"GeoJSON format for encoding geographic data structures","format_type":"geojson","created_at":"2026-02-15T03:18:57.713811","id":6,"name":"GeoJSON","mime_type":"application/geo+json","updated_at":"2026-02-15T03:18:57.713833"},"file_format":{"id":15914,"format_id":6,"created_at":"2026-02-15T06:46:25.287163","file_id":3859,"updated_at":"2026-02-15T06:46:25.287208"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T06:01:19.642486","id":18475,"file_format_id":15914,"created_at":"2026-05-19T21:57:47.224333","location":{"type":"file","version":"v1","path":"epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geojson/epa-superfund-enterprise-management-system-sems-sites-1-geojson.geojson"},"source_metadata":{"version":"v1","description":null,"size_bytes":16271788,"mime_type":null,"feature_count":14761,"bounds":[-179,-14.3601,177.519184,71.35589],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110020747977","110046120880","110071665172","110063172588","110022746670"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PRIMARY_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CALIFORNIA TRUCKING SALES","MAIN STREET GROUND WATER PLUME","TOWN OF BRAINTREE PROPERTY","BIOLAB, INC FIRE","NORGE TOWN DRY CLEANERS - ESPANOLA"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"LOCATION_ADDRESS","type":"string","description":null,"nullable":true,"num_null_values":1,"num_unique_values":null,"example_values":["910 RIVER ST","75-79 NORTH DIVISION ST","WRIGHT AVE.","I-95 MILE MARKER 88","920 MORSE AVENUE"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CITY_NAME","type":"string","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["VALDOSTA","MADISON","MERRIMACK","FOUR OAKS","ROSEVILLE"],"min":null,"max":null,"length":60,"possible_values":null},{"name":"COUNTY_NAME","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["LOWNDES","STARK","STORY","JOHNSTON","BROWN"],"min":null,"max":null,"length":35,"possible_values":null},{"name":"FIPS_CODE","type":"string","description":null,"nullable":true,"num_null_values":85,"num_unique_values":null,"example_values":["21149","36115","72137","20173","13047"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"STATE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CA","TX","MA","GA","NM"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"POSTAL_CODE","type":"string","description":null,"nullable":true,"num_null_values":6,"num_unique_values":null,"example_values":["61201","91763","08332","08322-2669","258130400"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"LATITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.940129999999996","30.737147999999998","42.224509999999995","33.6575","35.9914"],"min":-14.360100000000001,"max":71.287806,"length":null,"possible_values":null},{"name":"LONGITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-118.1802","-98.22543999999999","-70.98553","-84.00916699999999","-106.081384"],"min":-171.28283,"max":173.595832,"length":null,"possible_values":null},{"name":"HUC8_CODE","type":"string","description":null,"nullable":true,"num_null_values":17,"num_unique_values":null,"example_values":["04040001","02040206","07120003","17010201","16020304"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"ACCURACY_VALUE","type":"float","description":null,"nullable":true,"num_null_values":2554,"num_unique_values":null,"example_values":["50.0","25.0","30.0","50.0","30.0"],"min":1,"max":20000,"length":null,"possible_values":null},{"name":"COLLECT_MTH_DESC","type":"string","description":null,"nullable":true,"num_null_values":2487,"num_unique_values":null,"example_values":["GPS CODE (PSEUDO RANGE) DIFFERENTIAL","GPS CODE (PSEUDO RANGE) STANDARD POSITION (SA ON)","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER"],"min":null,"max":null,"length":72,"possible_values":null},{"name":"REF_POINT_DESC","type":"string","description":null,"nullable":true,"num_null_values":2564,"num_unique_values":null,"example_values":["ENTRANCE POINT 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"],"min":null,"max":null,"length":39,"possible_values":["ACRES POINTS NOT REPRESENTED BY 101-107","ADMINISTRATIVE BUILDING","CENTER OF A FACILITY OR STATION","CENTER OF FACILITY","ENTRANCE POINT OF A FACILITY OR STATION","FACILITY CENTROID","FACILITY/MONITORING SITE BOUNDARY POINT","LOADING AREA CENTROID","LOADING FACILITY","OTHER","PLANT ENTRANCE (GENERAL)","POINT WHERE SUBSTANCE IS MONITORED","POINT WHERE SUBSTANCE IS RELEASED","PROCESS UNIT AREA CENTROID","SE CORNER OF LAND PARCEL","SOLID WASTE STORAGE AREA","UNKNOWN"]},{"name":"CREATE_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00","2024-04-03T00:00:00+00:00","2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"UPDATE_DATE","type":"string","description":null,"nullable":true,"num_null_values":525,"num_unique_values":null,"example_values":["2021-11-24T13:48:56+00:00","2021-11-24T13:48:52+00:00","2021-11-24T13:48:58+00:00","2015-12-11T00:05:12+00:00","2021-11-24T13:48:57+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"LAST_REPORTED_DATE","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FAC_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020747977","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110046120880","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071665172","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110063172588","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110022746670"],"min":null,"max":null,"length":100,"possible_values":null},{"name":"PGM_SYS_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CAN000906116","TXN000607441","MAN000153839","GAD069200061","NMD986670156"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PGM_SYS_ACRNM","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMS","SEMS","SEMS","SEMS","SEMS"],"min":null,"max":null,"length":4,"possible_values":["SEMS"]},{"name":"INTEREST_TYPE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL","SUPERFUND (NON-NPL)","SUPERFUND (NON-NPL)","SUPERFUND NPL"],"min":null,"max":null,"length":19,"possible_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL"]},{"name":"PROGRAM_URL","type":"string","description":null,"nullable":true,"num_null_values":4401,"num_unique_values":null,"example_values":["http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm"],"min":null,"max":null,"length":50,"possible_values":["http://www.epa.gov/superfund/action/law/cercla.htm"]},{"name":"PGM_REPORT_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["no data yet","no data yet","no data yet","no data yet","no data yet"],"min":null,"max":null,"length":11,"possible_values":["no data yet"]},{"name":"PUBLIC_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"ACTIVE_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NOT ON THE NPL","CURRENTLY ON THE FINAL NPL","NOT ON THE NPL","NOT ON THE NPL","CURRENTLY ON THE FINAL NPL"],"min":null,"max":null,"length":28,"possible_values":["CURRENTLY ON THE FINAL NPL","DELETED FROM THE FINAL NPL","NOT ON THE NPL","PROPOSED FOR NPL","REMOVED FROM PROPOSED NPL","SITE IS PART OF NPL SITE","WITHDRAWN FROM THE FINAL NPL"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"HUC_12","type":"string","description":null,"nullable":true,"num_null_values":4357,"num_unique_values":null,"example_values":["111003030104","101900020904","051201060204","031502020204","210100050501"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FED_FACILITY_CODE","type":"string","description":null,"nullable":true,"num_null_values":3982,"num_unique_values":null,"example_values":["N","Y","Y","Y","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"EPA_REGION_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["09","06","01","04","06"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"KEY_FIELD","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMSCAN000906116","SEMSTXN000607441","SEMSMAN000153839","SEMSGAD069200061","SEMSNMD986670156"],"min":null,"max":null,"length":16,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geojson/epa-superfund-enterprise-management-system-sems-sites-1-geojson.geojson","storage_uri":"gs://hifld-next-datasets-prod/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/geojson/epa-superfund-enterprise-management-system-sems-sites-1-geojson.geojson","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1/sources/18475/download-zip"}}]},{"format":{"description":"ESRI File Geodatabase format for geospatial data storage","format_type":"file_geodatabase","created_at":"2026-02-15T03:18:57.882712","id":7,"name":"File Geodatabase","mime_type":"application/x-esri-shape","updated_at":"2026-02-15T03:18:57.882736"},"file_format":{"id":18017,"format_id":7,"created_at":"2026-05-19T21:57:46.754597","file_id":3859,"updated_at":"2026-05-19T21:57:46.754623"},"sources":[{"storage_location_id":1,"version":"v1.0.0","source_type":"file","references_source_id":null,"updated_at":"2026-08-14T06:01:19.589280","id":18474,"file_format_id":18017,"created_at":"2026-05-19T21:57:46.929824","location":{"type":"file","version":"v1","path":"epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/file_geodatabase/epa-superfund-enterprise-management-system-sems-sites-1-file_geodatabase.zip"},"source_metadata":{"version":"v1","description":null,"size_bytes":2195425,"mime_type":null,"feature_count":14761,"bounds":[-179,-14.3601,177.519184,71.35589],"geometry_type":"Point","invalid_geometry_count":0,"quality_check_passed":true,"columns_hash":"e2203eac49a02302d883f681d979237e4d0fe18afd9ecf2b99a67f9536d5e516","columns":[{"name":"geometry","type":"geometry","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":null,"min":null,"max":null,"length":null,"possible_values":null},{"name":"REGISTRY_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["110020747977","110046120880","110071665172","110063172588","110022746670"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PRIMARY_NAME","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CALIFORNIA TRUCKING SALES","MAIN STREET GROUND WATER PLUME","TOWN OF BRAINTREE PROPERTY","BIOLAB, INC FIRE","NORGE TOWN DRY CLEANERS - ESPANOLA"],"min":null,"max":null,"length":80,"possible_values":null},{"name":"LOCATION_ADDRESS","type":"string","description":null,"nullable":true,"num_null_values":1,"num_unique_values":null,"example_values":["910 RIVER ST","75-79 NORTH DIVISION ST","WRIGHT AVE.","I-95 MILE MARKER 88","920 MORSE AVENUE"],"min":null,"max":null,"length":50,"possible_values":null},{"name":"CITY_NAME","type":"string","description":null,"nullable":true,"num_null_values":3,"num_unique_values":null,"example_values":["VALDOSTA","MADISON","MERRIMACK","FOUR OAKS","ROSEVILLE"],"min":null,"max":null,"length":60,"possible_values":null},{"name":"COUNTY_NAME","type":"string","description":null,"nullable":true,"num_null_values":2,"num_unique_values":null,"example_values":["LOWNDES","STARK","STORY","JOHNSTON","BROWN"],"min":null,"max":null,"length":35,"possible_values":null},{"name":"FIPS_CODE","type":"string","description":null,"nullable":true,"num_null_values":85,"num_unique_values":null,"example_values":["21149","36115","72137","20173","13047"],"min":null,"max":null,"length":5,"possible_values":null},{"name":"STATE_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CA","TX","MA","GA","NM"],"min":null,"max":null,"length":2,"possible_values":null},{"name":"POSTAL_CODE","type":"string","description":null,"nullable":true,"num_null_values":6,"num_unique_values":null,"example_values":["61201","91763","08332","08322-2669","258130400"],"min":null,"max":null,"length":10,"possible_values":null},{"name":"LATITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["33.940129999999996","30.737147999999998","42.224509999999995","33.6575","35.9914"],"min":-14.360100000000001,"max":71.287806,"length":null,"possible_values":null},{"name":"LONGITUDE83","type":"float","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["-118.1802","-98.22543999999999","-70.98553","-84.00916699999999","-106.081384"],"min":-171.28283,"max":173.595832,"length":null,"possible_values":null},{"name":"HUC8_CODE","type":"string","description":null,"nullable":true,"num_null_values":17,"num_unique_values":null,"example_values":["04040001","02040206","07120003","17010201","16020304"],"min":null,"max":null,"length":8,"possible_values":null},{"name":"ACCURACY_VALUE","type":"float","description":null,"nullable":true,"num_null_values":2554,"num_unique_values":null,"example_values":["50.0","25.0","30.0","50.0","30.0"],"min":1,"max":20000,"length":null,"possible_values":null},{"name":"COLLECT_MTH_DESC","type":"string","description":null,"nullable":true,"num_null_values":2487,"num_unique_values":null,"example_values":["GPS CODE (PSEUDO RANGE) DIFFERENTIAL","GPS CODE (PSEUDO RANGE) STANDARD POSITION (SA ON)","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER","ADDRESS MATCHING-HOUSE NUMBER"],"min":null,"max":null,"length":72,"possible_values":null},{"name":"REF_POINT_DESC","type":"string","description":null,"nullable":true,"num_null_values":2564,"num_unique_values":null,"example_values":["ENTRANCE POINT 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"],"min":null,"max":null,"length":39,"possible_values":["ACRES POINTS NOT REPRESENTED BY 101-107","ADMINISTRATIVE BUILDING","CENTER OF A FACILITY OR STATION","CENTER OF FACILITY","ENTRANCE POINT OF A FACILITY OR STATION","FACILITY CENTROID","FACILITY/MONITORING SITE BOUNDARY POINT","LOADING AREA CENTROID","LOADING FACILITY","OTHER","PLANT ENTRANCE (GENERAL)","POINT WHERE SUBSTANCE IS MONITORED","POINT WHERE SUBSTANCE IS RELEASED","PROCESS UNIT AREA CENTROID","SE CORNER OF LAND PARCEL","SOLID WASTE STORAGE AREA","UNKNOWN"]},{"name":"CREATE_DATE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00","2024-04-03T00:00:00+00:00","2021-10-26T00:00:00+00:00","2021-10-26T00:00:00+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"UPDATE_DATE","type":"string","description":null,"nullable":true,"num_null_values":525,"num_unique_values":null,"example_values":["2021-11-24T13:48:56+00:00","2021-11-24T13:48:52+00:00","2021-11-24T13:48:58+00:00","2015-12-11T00:05:12+00:00","2021-11-24T13:48:57+00:00"],"min":null,"max":null,"length":25,"possible_values":null},{"name":"LAST_REPORTED_DATE","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FAC_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110020747977","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110046120880","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110071665172","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110063172588","https://ofmpub.epa.gov/frs_public2/fii_query_detail.disp_program_facility?p_registry_id=110022746670"],"min":null,"max":null,"length":100,"possible_values":null},{"name":"PGM_SYS_ID","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["CAN000906116","TXN000607441","MAN000153839","GAD069200061","NMD986670156"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"PGM_SYS_ACRNM","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMS","SEMS","SEMS","SEMS","SEMS"],"min":null,"max":null,"length":4,"possible_values":["SEMS"]},{"name":"INTEREST_TYPE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL","SUPERFUND (NON-NPL)","SUPERFUND (NON-NPL)","SUPERFUND NPL"],"min":null,"max":null,"length":19,"possible_values":["SUPERFUND (NON-NPL)","SUPERFUND NPL"]},{"name":"PROGRAM_URL","type":"string","description":null,"nullable":true,"num_null_values":4401,"num_unique_values":null,"example_values":["http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm","http://www.epa.gov/superfund/action/law/cercla.htm"],"min":null,"max":null,"length":50,"possible_values":["http://www.epa.gov/superfund/action/law/cercla.htm"]},{"name":"PGM_REPORT_URL","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["no data yet","no data yet","no data yet","no data yet","no data yet"],"min":null,"max":null,"length":11,"possible_values":["no data yet"]},{"name":"PUBLIC_IND","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["Y","Y","Y","Y","Y"],"min":null,"max":null,"length":1,"possible_values":["Y"]},{"name":"ACTIVE_STATUS","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["NOT ON THE NPL","CURRENTLY ON THE FINAL NPL","NOT ON THE NPL","NOT ON THE NPL","CURRENTLY ON THE FINAL NPL"],"min":null,"max":null,"length":28,"possible_values":["CURRENTLY ON THE FINAL NPL","DELETED FROM THE FINAL NPL","NOT ON THE NPL","PROPOSED FOR NPL","REMOVED FROM PROPOSED NPL","SITE IS PART OF NPL SITE","WITHDRAWN FROM THE FINAL NPL"]},{"name":"FEDERAL_AGENCY_NAME","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"HUC_12","type":"string","description":null,"nullable":true,"num_null_values":4357,"num_unique_values":null,"example_values":["111003030104","101900020904","051201060204","031502020204","210100050501"],"min":null,"max":null,"length":12,"possible_values":null},{"name":"FEDERAL_LAND_IND","type":"string","description":null,"nullable":true,"num_null_values":5000,"num_unique_values":null,"example_values":[],"min":null,"max":null,"length":null,"possible_values":null},{"name":"FED_FACILITY_CODE","type":"string","description":null,"nullable":true,"num_null_values":3982,"num_unique_values":null,"example_values":["N","Y","Y","Y","N"],"min":null,"max":null,"length":1,"possible_values":["N","Y"]},{"name":"EPA_REGION_CODE","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["09","06","01","04","06"],"min":null,"max":null,"length":2,"possible_values":["01","02","03","04","05","06","07","08","09","10"]},{"name":"KEY_FIELD","type":"string","description":null,"nullable":false,"num_null_values":0,"num_unique_values":null,"example_values":["SEMSCAN000906116","SEMSTXN000607441","SEMSMAN000153839","SEMSGAD069200061","SEMSNMD986670156"],"min":null,"max":null,"length":16,"possible_values":null}]},"url":"https://hifld.publicenvirodata.org/storage/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/file_geodatabase/epa-superfund-enterprise-management-system-sems-sites-1-file_geodatabase.zip","storage_uri":"gs://hifld-next-datasets-prod/epa-superfund-enterprise-management-system-sems-sites-1/epa-superfund-enterprise-management-system-sems-sites-1/v1.0.0/file_geodatabase/epa-superfund-enterprise-management-system-sems-sites-1-file_geodatabase.zip","storage_location":{"name":"GCS hifld-next-datasets-prod","description":"Google Cloud Storage production bucket for dataset files","updated_at":"2026-02-13T02:39:54.364528","slug":"gcs-hifld-next-datasets-prod","id":1,"backend_type":"s3","created_at":"2026-02-13T02:39:54.364506","config":{"version":"v1","type":"gcs","base_url":"https://hifld.publicenvirodata.org/storage","bucket":"hifld-next-datasets-prod"}},"links":{"download_zip":"https://hifld.publicenvirodata.org/api/collections/hifld/datasets/epa-superfund-enterprise-management-system-sems-sites-1/files/epa-superfund-enterprise-management-system-sems-sites-1/sources/18474/download-zip"}}]}]}}