Water Dischargers/IGD: EF NPDES by US Government | Healthcare

About this Dataset

Water Dischargers/IGD: EF NPDES

EF_NPDES is a subset of facilities from FRS_PROGRAM_FACILITY and associated 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). The NPDES subset is updated weekly.
Organization: U.S. Environmental Protection Agency
Last updated: 2025-02-25T05:39:21.857073
Tags: 020:038, 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_water_dischargers_igd_ef_npdes10.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
);