About this Dataset

SGA Phase 2 Reach Segment Breaks

The stream geomorphic assessment (SGA) is a physical assessment competed by geomorphologists to determine the condition and sensitivity of a stream. The SGA Phase 2 Segment Breaks are points that indicate where the Phase 1 SGA reach was "segmented" into smaller Phase 2 segments. These segments are determined in the field and are based on changes in topography, slope and valley setting that were not found in phase 1, and on changes in condition found in the field. Where there found in the field a significant change in any of the above there is a segment break created.
Organization: Vermont Center for Geographic Information
Last updated: 2024-02-09T15:19:07.633547
Tags: deptdec, divwsm, isothemewater, nodevtanr, progrivers, subthemehydro, vt-anr-open-data

Tables

Table 1

@usgov.vcgi_org_sga_phase_2_reach_segment_breaks_b0799.table_1

582.34 kB
893 rows
131 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid_12" BIGINT,
  "projectid" BIGINT,
  "rchid" VARCHAR,
  "segid" VARCHAR,
  "sgat_id" VARCHAR,
  "globalid" VARCHAR,
  "projectname" VARCHAR,
  "organizationid" DOUBLE,
  "observers" VARCHAR,
  "isnotassessed" BIGINT,
  "whynotassessed" VARCHAR,
  "isadminjudgement" BIGINT,
  "adminjudgemententity" VARCHAR,
  "adminstreamtypedeparture" VARCHAR,
  "segmentlocation" VARCHAR,
  "segmentlength" DOUBLE,
  "completiondate" TIMESTAMP,
  "sevendayrain" VARCHAR,
  "weather" VARCHAR,
  "knownfloodhistory" VARCHAR,
  "sketchdone" VARCHAR,
  "photologdone" VARCHAR,
  "watershedzone" VARCHAR,
  "segmentation" VARCHAR,
  "segmentationcomment" VARCHAR,
  "alluvialfan" VARCHAR,
  "confinementtype" VARCHAR,
  "valleywidth" DOUBLE,
  "valleywidthdetermination" VARCHAR,
  "inrockgorge" VARCHAR,
  "humanchangedwidth" VARCHAR,
  "isnogradecontrol" BIGINT,
  "bankfullwidth" DOUBLE,
  "maximumdepth" DOUBLE,
  "meandepth" DOUBLE,
  "floodpronewidth" DOUBLE,
  "recentlyabandonedfloodplain" DOUBLE,
  "sinuositytype" VARCHAR,
  "rifflestype" VARCHAR,
  "rifflespacingdistance" DOUBLE,
  "isrifflespacingdistancena" DOUBLE,
  "siltclaypresent" VARCHAR,
  "detrituspercent" DOUBLE,
  "woodydebrisnumber" DOUBLE,
  "largestbedparticle" DOUBLE,
  "largestbarparticle" DOUBLE,
  "straighteninglength" DOUBLE,
  "particleunits" VARCHAR,
  "streamtype" VARCHAR,
  "bedform" VARCHAR,
  "bedmaterial" VARCHAR,
  "subclassslope" VARCHAR,
  "referencestreamtype" VARCHAR,
  "referencebedform" VARCHAR,
  "referencebedmaterial" VARCHAR,
  "referencesubclassslope" VARCHAR,
  "typicalbankslope" VARCHAR,
  "materialtypelower" VARCHAR,
  "materialtypeupper" VARCHAR,
  "consistencylower" VARCHAR,
  "consistencyupper" VARCHAR,
  "channelcanopy" VARCHAR,
  "massfailures" VARCHAR,
  "failuremeanheight" DOUBLE,
  "gullies" VARCHAR,
  "gullymeanheight" DOUBLE,
  "springseep" VARCHAR,
  "adjacentwetland" VARCHAR,
  "flowstatus" VARCHAR,
  "debrisjamsnumber" DOUBLE,
  "impoundments" VARCHAR,
  "impoundmentlocation" VARCHAR,
  "stormwaterinputsnumber" DOUBLE,
  "upstreamflowregulation" VARCHAR,
  "isnochannelconstriction" BIGINT,
  "bridgeculvertassessment" VARCHAR,
  "beaverdamsnumber" DOUBLE,
  "beaverdamaffectedlength" DOUBLE,
  "barmidnumber" DOUBLE,
  "barpointnumber" DOUBLE,
  "barsidenumber" DOUBLE,
  "bardiagonalnumber" DOUBLE,
  "bardeltanumber" DOUBLE,
  "barislandnumber" DOUBLE,
  "floodchutesnumber" DOUBLE,
  "neckcutoffsnumber" DOUBLE,
  "channelavulsionsnumber" DOUBLE,
  "braidingnumber" DOUBLE,
  "steeprifflesnumber" DOUBLE,
  "headcutsnumber" DOUBLE,
  "tributaryrejuvenation" VARCHAR,
  "streamford" VARCHAR,
  "straightening" VARCHAR,
  "dredging" VARCHAR,
  "comments" VARCHAR,
  "habassessstreamtype" VARCHAR,
  "habassesscondition" VARCHAR,
  "geoassessconfinement" VARCHAR
);