About this Dataset

Superfund/IGD: 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 refreshed daily. The layer shows only NPL (National Priority List) points from the SEMS (Superfund Enterprise Management System) database. The NPL subset is updated weekly.
Organization: U.S. Environmental Protection Agency
Last updated: 2025-02-25T05:50:57.247198
Tags: 020:106, 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_superfund_igd_ef_npl10.table_1

181.13 kB
1,380 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
);