About this Dataset

Dams

This dataset is generated from Dam Inventory. The inventory is managed by the VT DEC's Dam Safety and Hydrology Section and contains information about Vermont's dams. The Dam Safety and Hydrology Section manages programs that promote dam safety and protection of flows in Vermont's rivers and streams. The inventory supports them in this effort by tracking physical attributes, managing construction (permits) and inspection information, and reporting to the US Army Corps of Engineers.
Organization: Vermont Center for Geographic Information
Last updated: 2024-02-09T15:15:57.141631
Tags: 012, 017, 019, deptdec, divwid, inlandwaters, isothemefacilities, isothemeutility, isothemewater, nodevtanr, progdams, structure, subthemeother, subthemepower, utilitiescommunication, vt-anr-open-data

Tables

Table 1

@usgov.vcgi_org_dams_bfb0f.table_1

121.55 kB
1,084 rows
28 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "damsid" BIGINT,
  "stateid" DOUBLE,
  "damname" VARCHAR,
  "nationalid" VARCHAR,
  "fercno" BIGINT,
  "latnad83" DOUBLE,
  "longnad83" DOUBLE,
  "town" VARCHAR,
  "stream" VARCHAR,
  "basinname" VARCHAR,
  "restype" VARCHAR,
  "surfacres" DOUBLE,
  "drainsqmi" DOUBLE,
  "normstoracft" DOUBLE,
  "maxstoracft" DOUBLE,
  "damstatus" VARCHAR,
  "purposes" VARCHAR,
  "damlenft" BIGINT,
  "damhtft" DOUBLE,
  "maxdiscfs" BIGINT,
  "yearbuilt" BIGINT,
  "origpurp" VARCHAR,
  "statereg" VARCHAR,
  "fedreg" VARCHAR,
  "hazardpotentialclassification" VARCHAR,
  "lastinspectiondate" TIMESTAMP
);