EF NPDES by US Government | Healthcare

About this Dataset

EF NPDES

EF_NPDES is a subset of facilities from FRS_PROGRAM_FACILITY and associataed best-available geospatial coordinates which are refreshed daily. The layer shows only points from the NPDES (National Pollutant Discharge Elimination System) and PCS (Permit Compliance System) programs as reported in ICIS (Integrated Compliance Information System).
Organization: U.S. Environmental Protection Agency
Last updated: 2025-02-25T05:12:25.883574
Tags: alabama, alaska, american samoa, arizona, arkansas, california, colorado, compliance, connecticut, contaminant, delaware, drinking water, environment, exposure, florida, georgia, ground water, hawaii, hazards, health, human, idaho, illinois, indiana, iowa, kansas, kentucky, louisiana, maine, maryland, massachusetts, michigan, minnesota, mississippi, missouri, monitoring, montana, nebraska, nevada, new hampshire, new jersey, new mexico, new york, north carolina, north dakota, ohio, oklahoma, oregon, pennsylvania, permits, puerto rico, quality, regulatory, rhode island, sites, south carolina, south dakota, tennessee, texas, toxics, united states, utah, vermont, virgin islands, virginia, washington, washington dc, waste, water, west virginia, wisconsin, wyoming

Tables

Table 1

@usgov.epa_gov_ef_npdes8.table_1

75.91 MB
985638 rows
15 columns


CREATE TABLE table_1 (
  "registry_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" DOUBLE,
  "facility_url" VARCHAR
);