About this Dataset

SGA Reach Breaks

The stream geomorphic assessment (SGA) is a physical assessment competed by geomorphologists to determine the condition and sensitivity of a stream. The SGA Reach Breaks are points that indicate where the Phase 1 SGA reach breaks are. They are based on changes in topography, slope and valley setting. Where there is a significant change in any of the above there is a reach break created.
Organization: Vermont Center for Geographic Information
Last updated: 2024-02-09T15:16:51.001800
Tags: deptdec, divwsm, isothemewater, nodevtanr, progrivers, subthemehydro, vt-anr-open-data

Tables

Table 1

@usgov.vcgi_org_sga_reach_breaks_3432d.table_1

2.11 MB
7,697 rows
101 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "tribid" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "objectid_12" BIGINT,
  "projectid" BIGINT,
  "rchid" VARCHAR,
  "sgat_id" VARCHAR,
  "globalid" VARCHAR,
  "reachpointid" VARCHAR,
  "downreachcode" VARCHAR,
  "upreachcode" VARCHAR,
  "vtid" VARCHAR,
  "huc10id" VARCHAR,
  "huc10ids" VARCHAR,
  "waterbodyid" VARCHAR,
  "isimpoundment" VARCHAR,
  "isnotassessed" VARCHAR,
  "stateplaneeasting" DOUBLE,
  "stateplanenorthing" DOUBLE,
  "streamname" VARCHAR,
  "reachdescription" VARCHAR,
  "towns" VARCHAR,
  "topos" VARCHAR,
  "orthos" VARCHAR,
  "sgatnotes" VARCHAR,
  "elevationupstream" DOUBLE,
  "elevationdownstream" DOUBLE,
  "iselevgradientgentle" VARCHAR,
  "valleylength" DOUBLE,
  "channellength" DOUBLE,
  "valleywidth" DOUBLE,
  "channelwidth" DOUBLE,
  "watershedarea" DOUBLE,
  "reachwatershedarea" DOUBLE,
  "corridorwatershedarea" DOUBLE,
  "confinementtype" VARCHAR,
  "bedform" VARCHAR,
  "bedform2" VARCHAR,
  "referencestreamtype" VARCHAR,
  "referencestreamtype2" VARCHAR,
  "alluvialfan" VARCHAR,
  "gradecontrol" VARCHAR,
  "rightvalleyslope" VARCHAR,
  "leftvalleyslope" VARCHAR,
  "watershedpastlandcover" VARCHAR,
  "corridorpastlandcover" VARCHAR,
  "isnotevalbufferwidths" VARCHAR,
  "groundwaterinputs" VARCHAR,
  "flowregulation" VARCHAR,
  "bridgesculvertsnumber" DOUBLE,
  "bridgesculvertslength" DOUBLE,
  "databridgesculverts" VARCHAR,
  "armoringlength" DOUBLE,
  "armoringlengthleft" DOUBLE,
  "armoringlengthright" DOUBLE,
  "dataarmoring" VARCHAR,
  "straighteninglength" DOUBLE,
  "datastraightening" VARCHAR,
  "dredginghistory" VARCHAR,
  "bermsroadslength1side" DOUBLE,
  "bermsroadslength2side" DOUBLE,
  "databermsroads" VARCHAR,
  "corridordevlength1side" DOUBLE,
  "corridordevlength2side" DOUBLE,
  "datacorridordev" VARCHAR,
  "depositionalfeatures" VARCHAR,
  "meandermigration" VARCHAR,
  "ismeanderwidthna" VARCHAR,
  "meanderwidth" DOUBLE,
  "ismeanderwavelengthna" VARCHAR,
  "meanderwavelength" DOUBLE,
  "bedmaterial" VARCHAR,
  "subclassslope" VARCHAR,
  "ismodrefstreamtype" VARCHAR,
  "bankerosion" VARCHAR,
  "bankheight" VARCHAR,
  "icejampotential" VARCHAR,
  "comments" VARCHAR,
  "phase2updatedate" TIMESTAMP,
  "dateedited" TIMESTAMP,
  "bermlength1side" DOUBLE,
  "bermlength2side" DOUBLE,
  "roadlength1side" DOUBLE,
  "roadlength2side" DOUBLE,
  "rrlength1side" DOUBLE,
  "rrlength2side" DOUBLE,
  "pathlength1side" DOUBLE,
  "pathlength2side" DOUBLE,
  "flowregtype" VARCHAR,
  "flowreguse" VARCHAR,
  "erosionlengthnumber" DOUBLE,
  "erosionheightnumber" DOUBLE,
  "phase1check" DOUBLE,
  "reachesrid" BIGINT,
  "uoe" VARCHAR,
  "doe" TIMESTAMP,
  "uoc" VARCHAR,
  "doc" TIMESTAMP
);