About this Dataset

Stream Crossings

Physical measurements and attributes of stream crossing structures and adjacent stream reaches which are used to provide a relative rating of aquatic organism passage and geomorphic compatibility. Additional screening tools have been developed to identify the amount of habitat available above and below individual structures and the potential for retrofitting an existing structure for improved aquatic organism passage. Data can be used to identify And prioritize potential stream crossing replacements/retrofit projects to improve biological/stream processes and flood resiliency.
Organization: Vermont Center for Geographic Information
Last updated: 2024-02-09T15:17:15.291414
Tags: deptdec, divwsm, isothemeecologic, isothemefacilities, nodevtanr, progrivers, projectsgat, sgat, subthemeother, vermont, vt-anr-open-data

Tables

Table 1

@usgov.vcgi_org_stream_crossings_fb4fd.table_1

2.08 MB
18,698 rows
44 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "sgaid" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "upmainstemnetworklength" DOUBLE,
  "upnetworklength" DOUBLE,
  "struct_num" VARCHAR,
  "upstreambarriercount" DOUBLE,
  "dwstreambarriercount" DOUBLE,
  "channelwidthsource" VARCHAR,
  "sgaurl" VARCHAR,
  "structuresid" BIGINT,
  "structuretype" VARCHAR,
  "assessmentdate" VARCHAR,
  "town" VARCHAR,
  "location" VARCHAR,
  "gisroadname" VARCHAR,
  "otherroadname" VARCHAR,
  "streamname" VARCHAR,
  "channelwidth" DOUBLE,
  "structurelength" DOUBLE,
  "structureheight" DOUBLE,
  "structurewidth" DOUBLE,
  "structurecount" DOUBLE,
  "culvertinvertflowtype" VARCHAR,
  "culvertdropdistance" DOUBLE,
  "structurematerial" VARCHAR,
  "opennessratio" DOUBLE,
  "upstreamlength" DOUBLE,
  "culvertwaterdepth" DOUBLE,
  "backwaterlength" DOUBLE,
  "pooldepthstreamflow" DOUBLE,
  "pooldepthmax" DOUBLE,
  "aopcoursescreen" VARCHAR,
  "compatablitlysum" DOUBLE,
  "compatabilitycolor" VARCHAR,
  "retrofitpotential" VARCHAR,
  "bankfullwidth" DOUBLE,
  "upstreamphoto" VARCHAR,
  "inletphoto" VARCHAR,
  "outletphoto" VARCHAR,
  "downstreamphoto" VARCHAR,
  "esri_oid" BIGINT
);