About this Dataset

Public Water Sources

This GIS layer consists of the geographic location of active and inactive public (Community, non-transient non-community and transient non-community) water sources labeled by the Water System Identification Number (WSID) and source number (i.e. WL001 or IN002). The water source data and locations are drawn from the State Drinking Water database (SDWIS). The water sources are wells, springs and surface water intakes that predate regulations developed in the 1970s to the present. SDWIS is the repository for state and federal information collected from and about each public water system in Vermont, including bulk and bottled water facilities along with water production and water quality data. "

For information regarding attributes of Public Water Source feature layers, please download the:
Public Water Sources Data Dictionary
Organization: Vermont Center for Geographic Information
Last updated: 2024-02-09T15:18:13.445247
Tags: appmapsandmapping, deptdec, divdwgwp, isothemewater, nodevtanr, public-water, subthemehydro, vt-anr-open-data

Tables

Table 1

@usgov.vcgi_org_public_water_sources_d24c8.table_1

188.98 kB
3,086 rows
20 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "tinwsf_is_number" BIGINT,
  "wsid" VARCHAR,
  "systemname" VARCHAR,
  "systemtype" VARCHAR,
  "systemstatus" VARCHAR,
  "systempopulation" BIGINT,
  "facilityname" VARCHAR,
  "facilityid" VARCHAR,
  "facilitystatus" VARCHAR,
  "availability" VARCHAR,
  "watertype" VARCHAR,
  "constructeddate" TIMESTAMP,
  "permittedyield" VARCHAR,
  "welltype" VARCHAR,
  "diameter_in" DOUBLE,
  "welldepth" VARCHAR,
  "casingdepth" VARCHAR,
  "staticwaterlevel" VARCHAR
);