Export Phase 1 & 2 Combined Data

Caution: Selecting all the Columns and all the Projects will exceed the limitations of the software.

dbfexcelaccess
Phase 1 Columns Select All | Select None 0.101 - Project name 0.102 - Reach Point ID (from SGAT) 0.103 - Reach ID (a number) 0.104 - Reach Wide Condition 0.105 - State Wide Condition 0.106 - Main stem HUC 10 0.107 - Name of stream 0.109 - Waterbody ID 1.1 - Reach description 1.2 - Reach towns 1.3a - Downstream reach break latitude 1.3b - Downstream reach break longitude 1.3c - Reach USGS topographic maps 1.3d - Reach Orthophoto maps 1.3e - State plane coordinate - Easting 1.3f - State plane coordinate - Northing 2.01a - Elevation at the upstream end of reach break 2.01b - Elevation at the downstream end of reach break 2.01c - Does the reach have a gentle gradient? 2.02 - Valley length (ft.) 2.03 - Valley slope 2.04 - Channel length (ft.) 2.05 - Channel slope 2.06 - Sinuosity 2.07 - Reach watershed size (square miles) 2.08 - Channel width (ft.) 2.09 - Valley width (ft.) 2.10a - Confinement ratio 2.10b - Confinement type 2.11a - Reference stream type 2.11b - Is modified reference stream type 2.11c - Sub-class slope category 2.11d - Dominant bed form 2.11e - Dominant bed material 3.1 - Alluvial fan 3.2 - Grade control 3.3a - Dominant geologic material in corridor 3.3b - % dominant geologic material in corridor 3.3c - Sub-dominant geologic material in corridor 3.3d - % sub-dominant geologic material in corridor 3.4l - Left valley slope 3.4r - Right valley slope 3.5a - Dominant hydrologic group in corridor 3.5b - % dominant hydrologic group in corridor 3.5c - Dominant flooding condition in corridor 3.5d - % dominant flooding condition in corridor 3.5e - Dominant deep water table in corridor 3.5f - % dominant deep water table in corridor 3.5g - Dominant shallow water table in corridor 3.5h - % dominant shallow water table in corridor 3.5i - Dominant erodibility in corridor 3.5j - % dominant erodibility in corridor 3.5k - Percent of Non Hydric material 3.5l - Percent of Hydric material 4.1a - Historic land use in watershed 4.1b - Dominant current land use in watershed 4.1c - % dominant current land use in watershed 4.1d - Sub-dominant current land use in watershed 4.1e - % sub-dominant current land use in watershed 4.1f - % urban land use in watershed 4.1g - % crop land use in watershed 4.1h - Watershed land cover impact 4.2a - Historic land use in corridor 4.2b - Dominant current land use in corridor 4.2c - % dominant current land use in corridor 4.2d - Sub-dominant current land use in corridor 4.2e - % sub-dominant current land use in corridor 4.2f - % urban land use in corridor 4.2g - % crop land use in corridor 4.2h - Corridor land cover impact 4.3al - Left bank dominant buffer width 4.3ar - Right bank dominant buffer width 4.3bl - Left bank sub-dominant buffer width 4.3br - Right bank sub-dominant buffer width 4.3cl - Length of left bank with riparian buffer between 0 and 25 ft. 4.3cr - Length of right bank with riparian buffer between 0 and 25 ft. 4.3d - Riparian buffer impact 4.4 - Ground water inputs 5.1a - Flow Regulation type 5.1b - Flow Regulation use 5.1c - (Legacy) Flow Regulation 5.1d - Flow regulation impact 5.2a - Number of bridges and culverts 5.2b - Length of reach impacted by bridges and culverts 5.2c - Percent of reach impacted by bridges and culverts 5.2d - Bridge and culvert impact 5.3al - Bank Armoring Length Left 5.3ar - Bank Armoring Length Right 5.3b - Percent of reach impacted by bank armoring 5.3c - Length of reach impacted by bank armoring 5.3d - Bank armoring impact 5.4a - Channel Straightening Length 5.4b - Length of reach impacted by channel straightening 5.4c - Percent of reach impacted by channel straightening 5.4d - Channel straightening impact 5.5a - Dredging or gravel mining 5.5b - Dredging or gravel mining impact 6.1a - Length of reach impacted by berms and roads 6.1b - Percent of reach impacted by berms and roads 6.1c - Berms and roads impact 6.2a - Length of reach impacted by corridor development 6.2b - Percent of reach impacted by corridor development 6.2c - Corridor development impact 6.3a - Depositional features 6.3b - Depositional features impact 6.4a - Meander migration 6.4b - Meander migration impact 6.5a - Average belt width 6.5b - Meander width ratio 6.5c - Meander width impact 6.6a - Wave length 6.6b - Wave length ratio 6.6c - Wave length impact 7.1a - Bank Erosion length (in feet) 7.1b - Bank Erosion height (in feet) 7.1c - (Legacy) Bank Erosion 7.1d - (legacy) Bank height 7.1e - Bank erosion and height impact 7.2a - Ice or debris jams 7.2b - Ice and debris jam impacts 8.1 - Total impact 8.2 - SGAT Phase 1 Project Identifier For GIS	Phase 2 Columns Select All | Select None 0.104 - Combination of Reach Point ID and Segment ID 0.105 - Segment ID 0.106 - Length of the segment (ft.) 0.110 - Is segment in a sub-reach? 1.1a - Type of segmentation 1.3a1 - Length of berms running parallel or nearly parallel to stream in river corridor - 1 side (ft.) 1.3a2 - Length of berms running parallel or nearly parallel to stream in river corridor - 2 sides (ft.) 1.3al - Left - Length of berms running parallel or nearly parallel to stream in river corridor (ft.) 1.3ar - Right - Length of berms running parallel or nearly parallel to stream in river corridor (ft.) 1.3b1 - Length of roads running parallel or nearly parallel to stream in river corridor - 1 side (ft.) 1.3b2 - Length of roads running parallel or nearly parallel to stream in river corridor - 2 sides (ft.) 1.3bl - Left - Length of roads running parallel or nearly parallel to stream in river corridor (ft.) 1.3br - Right - Length of roads running parallel or nearly parallel to stream in river corridor (ft.) 1.3c1 - Length of railroads running parallel or nearly parallel to stream in river corridor - 1 side (ft.) 1.3c2 - Length of railroads running parallel or nearly parallel to stream in river corridor - 2 sides (ft.) 1.3cl - Left - Length of railroads running parallel or nearly parallel to stream in river corridor (ft.) 1.3cr - Right - Length of railroads running parallel or nearly parallel to stream in river corridor (ft.) 1.3d1 - Length of improved paths running parallel to stream in river corridor - 1 side (ft.) 1.3d2 - Length of improved paths running parallel to stream in river corridor - 2 sides (ft.) 1.3dl - Left - Length of improved paths running parallel to stream in river corridor (ft.) 1.3dr - Right - Length of improved paths running parallel to stream in river corridor (ft.) 1.3e1 - Length of development running parallel to stream in river corridor - 1 side(ft.) 1.3e2 - Length of development running parallel to stream in river corridor - 2 sides (ft.) 1.3el - Left - Length of development running parallel to stream in river corridor (ft.) 1.3er - Right - Length of development running parallel to stream in river corridor (ft.) 1.4al - Left - Slope of hillside 1.4ar - Right - Slope of hillside 1.4bl - Left - Is hillside continuous with riverbank? 1.4br - Right - Is hillside continuous with riverbank? 1.4cl - Left - Is hillside within 1 bankfull width? 1.4cr - Right - Is hillside within 1 bankfull width? 1.4dl - Left - Dominant texture of exposed materials in lower half of the slope 1.4dr - Right - Dominant texture of exposed materials in lower half of the slope 1.5a - Valley width (ft.) 1.5b - Valley Width Determination 1.5c - Confinement type for segment 1.5d - Is segment in a rock gorge? 1.5e - Has there been a human-caused change in the valley width? 2.01 - Bankfull width (ft.) 2.02 - Maximum depth (ft.) 2.03 - Mean depth (ft.) 2.04 - Floodprone width (ft.) 2.05a - Recently abandoned floodplain height (ft.) 2.05b - Human Elevated Floodplain 2.06 - Width to depth ratio 2.07 - Entrenchment ratio 2.08a - Incision ratio 2.08b - Incision Ratio - Human Elevated FloodPlain 2.09 - Type of sinuosity 2.10 - Type of riffles 2.11 - Average distance between riffles or steps 2.12a - Bedrock Substrate Composition Percent 2.12b - Boulder Substrate Composition Percent 2.12c - Cobble Substrate Composition Percent 2.12d - Course Gravel Substrate Composition Percent 2.12e - Fine Gravel Substrate Composition Percent 2.12f - Sand Substrate Composition Percent 2.12g - Silt or Smaller Substrate Composition Percent 2.12h - Is Silt or Clay found in the riverbed? 2.12i - Detritus Percent 2.12j - Count of large woody debris 2.14a - Stream type 2.14b - Type of bed material 2.14c - Subclass slope 2.14d - Type of bed form 2.14e - P2 SubDominate Bed Form 2.14f - P2 Field Measured Slope 2.14g - Reference different from Phase 1 - Stream type 2.14h - Reference different from Phase 1 - Type of bed material 2.14i - Reference different from Phase 1 - Subclass slope 2.14j - Reference different from Phase 1 - Type of bed form 3.1 - Typical slope of the stream bank 3.1a - Material type in the upper 1/3 portion of the bank 3.1al - Left - Material type in the upper 1/3 portion of the bank 3.1ar - Right - Material type in the upper 1/3 portion of the bank 3.1b - Material type in the lower 2/3 portion of the bank 3.1bl - Left - Material type in the lower 2/3 portion of the bank 3.1br - Right - Material type in the lower 2/3 portion of the bank 3.1c - Consistency of the upper 1/3 portion of the bank 3.1cl - Left - Consistency of the upper 1/3 portion of the bank 3.1cr - Right - Consistency of the upper 1/3 portion of the bank 3.1d - Consistency of lower 2/3 portion of the bank 3.1dl - Left - Consistency of lower 2/3 portion of the bank 3.1dr - Right - Consistency of lower 2/3 portion of the bank 3.1el - Left - Average length of eroding banks (ft.) 3.1er - Right - Average length of eroding banks (ft.) 3.1fl - Left - Average height of eroding banks (ft.) 3.1fr - Right - Average height of eroding banks (ft.) 3.1gl - Left - Type of bank revetment 3.1gr - Right - Type of bank revetment 3.1hl - Left - Length of bank with revetments in segment (ft.) 3.1hr - Right - Length of bank with revetments in segment (ft.) 3.1il - Left - Dominant bank vegetation type 3.1ir - Right - Dominant bank vegetation type 3.1jl - Left - Sub-dominant bank vegetation type 3.1jr - Right - Sub-dominant bank vegetation type 3.1k - Canopy while standing in the middle of the channel 3.1kl - Left - Category of average percent canopy 3.1kr - Right - Category of average percent canopy 3.2al - Left - Dominant buffer category of average buffer width (ft.) 3.2ar - Right - Dominant buffer category of average buffer width (ft.) 3.2bl - Left - Sub-dominant buffer category of average buffer width (ft.) 3.2br - Right - Sub-dominant buffer category of average buffer width (ft.) 3.2dl - Left - Dominant buffer vegetation type 3.2dr - Right - Dominant buffer vegetation type 3.2el - Left - Sub-dominant buffer vegetation type 3.2er - Right - Sub-dominant buffer vegetation type 3.3al - Left - Dominant corridor land use 3.3ar - Right - Dominant corridor land use 3.3bl - Left - Sub-dominant corridor land use 3.3br - Right - Sub-dominant corridor land use 3.3c - Relative abundance of mass failures 3.3d - Average height of mass failures (ft.) 3.3e - Relative abundance of gullies 3.3f - Average height of gullies (ft.) 4.1 - Abundance of springs and seeps 4.2 - Abundance of adjacent wetlands 4.3 - Flow Status 4.4 - Number of debris jams 4.5c - Impoundment information 4.5d - Location of any impoundments 4.6a - Up/Down Stream Flow Reg and Withdrawals 4.6b - Upstream flow regulation 4.7 - Number of stormwater inputs to the segment 4.8 - Is No Channel Constriction 4.9a - Number of beaver dams in segment 4.9b - Length of segment affected by beaver dams (ft.) 5.1a - Number of mid-channel bars 5.1b - Number of point bars 5.1c - Number of side bars 5.1d - Number of diagonal bars 5.1e - Number of delta bars 5.1f - Number of island bars 5.2a - Number of flood chutes 5.2b - Number of neck cut-offs 5.2c - Number of channel avulsions 5.2d - Number of braiding 5.3a - Number of steep riffles 5.3b - Number of head cuts 5.3c - Has there been tributary rejuvenation? 5.4 - Is there a stream form or animal crossing? 5.5a - Has the channel been straightened? 5.5b - The total of straightening length, this Segement. 5.5c - Types of dredging found 6.01 - Available Cover 6.02 - Pool Substrate 6.03 - Rapid habitat assessment pool variability score 6.04 - Sediment Deposition 6.05 - Channel Flow Status 6.06 - Channel Alteration 6.07 - Channel Sinuosity 6.08l - Bank Stability Left 6.08r - Bank Stability Right 6.09l - Bank Vegetation Protection Left 6.09r - Bank Vegetation Protection Right 6.10 - Rapid habitat assessment condition 6.10a - Rapid habitat assessment stream gradient type 6.10b - Legacy habitat assessment score 6.10c - Rapid habitat assessment rating 6.10d - Habitat assessment score 7.0 - Rapid geomorphic assessment confinement type 7.1a - RGA degradation score 7.1b - RGA historic degradation 7.1c - RGA degradation STD 7.2a - RGA aggradation score 7.2b - RGA aggradation STD 7.2c - RGA historic aggradation 7.3a - RGA widening score 7.3b - RGA Widening Standard 7.3c - RGA widening historic? 7.4a - RGA change in planform score 7.4b - RGA Widening Channel STD 7.4c - RGA change in planform historic? 7.4d - RGA rating 7.4e - RGA condition 7.5a - Channel evolution model 7.5b - Channel evolution stage 7.6 - Geomorphic Stream Condition 7.7 - RGA sensitivity 8.1 - SGAT Phase 2 Project Identifier For GIS	Projects Select All | Select None Aaron testing new FIT Alder Brook Allen Brook Ball Mountain Brook Bartlett Brook Barton River Battenkill - White Creek Battenkill River Black Black Creek Head Black Creek Mouth Black River Blood Brook Bolter Brook Brewster River Browns River Browns River Tribs Castleton River Centennial Brook Centerville Brook Clyde Crosby Brook Deer Brook Deerfield - North Branch Deerfield River Direct Drain to Lake Champlain Dishmill Brook Dog River East Branch Passumpsic East Creek Elmore Branch Elmore Pond Brook Englesby Brook Foote Brook Gihon Green River Green River LC Hoosic Hoosic Tribs Hubbard Brook Hungerford Brook Huntington River Indian Brook Jericho Research Forest Jewett Brook Johnnie Brook Johns River Judevine Brook Keyer Brook Kingsbury Branch L Winooski - Champlain to Alder Lamoille CCRPC Lamoille LCRPC Lamoille LCRPC HUC2 Lamoille NRPC Laplatte Leach Stream Lemon Fair Lewis Creek Little Otter Creek Little River Lower Otter Creek Lower Passumpsic Mad River Malletts Creek Mettowee - Indian River Mettowee River Middlebury River Mill Brook Mill Brook - Basin 13 Mill River Millers Run Missisquoi - BlackCrk to Trout Missisquoi - BlackHungerford Missisquoi - Canada to Trout Missisquoi Mouth Moose River Morehouse Brook Mudd Creek Muddy Brook Munroe Brook Neshobe New Haven River New Haven Tribs NH: Exeter River NH: Piscataqua River North Branch Lamoille North Branch Winooski North River - Conn Nulhegan Ompompanoosuc Ottauquechee Ottauquechee - Roaring Brook Otter Creek - Cold River Otter Creek - East Creek Trib Otter Creek - Mill River Otter Creek - Moon Brook Otter Creek Tributaries Passumpsic Pike River Pond Brook Potash brook Poultney - Hubbardton River Poultney Tribs Richmond tribs RMP Test Project Rock River Rodman Brook Rugg Brook Saxtons Saxtons TEST Seymour River Smith Creek Southern VT Stevens Branch Stevens Brook Stevens River Stonebridge Brook Sucker Brook Sucker Brook Tribs Sunderland Brook Test SGAT 10 Trout Brook Trout River Head Trout River Mouth Tyler Branch Upper Lamoille Upper Missisquoi Upper Otter Creek Waits Walloomsac Walloomsac Woodford Wells River West Branch Little River West Branch Ompompanosuc West Branch Passumpsic West Mountain WMA West River West River - Rock River Whetstone White River - Middle White River - First Branch White River - Mainstem White River - Second Branch White River - Third Branch White River - Upper Wild Branch Willard Stream Williams River Winooski - Cabot Winooski - Montpelier to Cabot Winooski Lower - LC up to Alder Winooski Mid, Alder to Montp Winooski, Mouth to Alder Brook