About this Dataset

EF NPL

EF_NPL is a subset of facilities from FRS_PROGRAM_FACILITY and associated best-available geospatial coordinates. Facility Registry Service (FRS) data are refrehsed daily. The layer shows only NPL (National Priority List) points from the SEMS (Superfund Enterprise Management System) database.
Organization: U.S. Environmental Protection Agency
Last updated: 2025-02-25T05:45:36.617217
Tags: alabama, alaska, american samoa, arizona, arkansas, california, cleanup, colorado, compliance, connecticut, contaminant, delaware, drinking water, environment, exposure, facilities, florida, georgia, ground water, hawaii, hazards, health, human, idaho, illinois, indiana, iowa, kansas, kentucky, louisiana, maine, maryland, massachusetts, michigan, minnesota, mississippi, missouri, montana, nebraska, nevada, new hampshire, new jersey, new mexico, new york, north carolina, north dakota, ohio, oklahoma, oregon, pennsylvania, puerto rico, quality, regulatory, remediation, rhode island, sites, south carolina, south dakota, spills, tennessee, texas, toxics, united states, utah, vermont, virgin islands, virginia, washington, washington dc, waste, west virginia, wisconsin, wyoming

Tables

Table 1

@usgov.epa_gov_ef_npl8.table_1

176.89 KB
1380 rows
17 columns


CREATE TABLE table_1 (
  "registry_id" BIGINT,
  "site_id" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "pgm_sys_acrnm" VARCHAR,
  "pgm_sys_id" VARCHAR,
  "primary_name" VARCHAR,
  "location_address" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "state_code" VARCHAR,
  "epa_region" VARCHAR,
  "postal_code" VARCHAR,
  "fips_code" VARCHAR,
  "huc_code" VARCHAR,
  "facility_url" VARCHAR,
  "profile_url" VARCHAR
);