| ApproachAngle | this field must have a value.
this field can only have the values of: Sharp Bend, Mild Bend, Naturally Straight or Channelized Straight | SGA/datasets/structures/data/sStep3.aspx | Upstream - Angle of stream flow approaching structure | ApproachAngle |
| AssessmentDate | this field's value must be inclusively between 1/1/2000 and the date that the record is entered into the database | SGA/datasets/structures/data/sStep1.aspx | Assessment Data - Assessment Date | AssessmentDate |
| AvulsionDistance | if field ChannelAvulsion has a value of Follow Road then this field must have a value in it. | SGA/datasets/structures/data/sStep3.aspx | Upstream - Estimated Distance avulsion would follow road | AvulsionDistance |
| BackwaterLength | | SGA/datasets/structures/data/sStep3.aspx | Upstream - Backwater Length (measured from outlet) | BackwaterLength |
| ChannelAvulsion | this field must have a value.
this field can only have the values of: Cross Road, Follow Road, Unsure | SGA/datasets/structures/data/sStep3.aspx | Upstream - if channel avulses, stream will | ChannelAvulsion |
| ChannelWidth | If the ChannelWidthSource field is filled in, this field must also not be blank | SGA/datasets/structures/data/sStep2.aspx | Stream Data - Channel Width | ChannelWidth |
| ChannelWidthSource | if the ChannelWidth field is filled in, this field must also be populated.
this field can only have the values of: Curve, Measured | SGA/datasets/structures/data/sStep2.aspx | Stream Data - Channel Width Source | ChannelWidthSource |
| Comments | | SGA/datasets/structures/data/sStep5.aspx | Other Information - Comments | Comments |
| CulvertDropDistance | this field must have a value >0 if the StructureType field has a value of Culvert
| SGA/datasets/structures/data/sStep3.aspx | Upstream - Outlet drop (invert to water surface) | CulvertDropDistance |
| CulvertInvertFlowType | this field must have a value if the StructureType field has a value of Culvert.
this field can only have the values of: At Grade, Cascade, Free Fall, Entirely Backwatered, Partially Backwatered | SGA/datasets/structures/data/sStep3.aspx | Upstream - culvert outlet invert | CulvertInvertFlowType |
| CulvertOverflowPipe | this field can only have the values of: Yes, No and blank | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Overflow Pipe? | CulvertOverflowPipe |
| CulvertSlope | this field must have a value
this field can only have the values of: Higher, Lower, Same and blank | SGA/datasets/structures/data/sStep3.aspx | General - Culvert slope as compared with channel slope is significant | CulvertSlope |
| CulvertWaterDepth | | SGA/datasets/structures/data/sStep3.aspx | Upstream - Water depth in culvert (at outlet) | CulvertWaterDepth |
| DatasetName | this field must have a value
the value must be a valid Dataset name from the Datasets table of the SGA database
| SGA/datasets/structures/data/add.asp | | DatasetID |
| DnBankArmoring | this field can only have the values of: Intact, Failing, None, Unknown | SGA/datasets/structures/data/sStep4.aspx | Downstream - Hard Bank Armoring | DnBankArmoring |
| DnBankErosion | this field can only have the values of: High, Low, None | SGA/datasets/structures/data/sStep4.aspx | Downstream - Bank Erosion | DnBankErosion |
| DnBeaverDam | this field can only have the values of: Yes, No or blank | SGA/datasets/structures/data/sStep4.aspx | Downstream - Beaver dam near structure | DnBeaverDam |
| DnBeaverDamDistance | this field value must be greater than or equal to 0 and less then or equal to 5000 | SGA/datasets/structures/data/sStep4.aspx | Downstream - Beaver Dam distance | DnBeaverDamDistance |
| DnBedMaterial | this field can only have the values of: Bedrock, Boulder, Cobble, Gravel, Sand, Unknown | SGA/datasets/structures/data/sStep4.aspx | Downstream - Dominant Bed Material | DnBedMaterial |
| DnBedrockPresent | this field can only have the values of: Yes, No | SGA/datasets/structures/data/sStep4.aspx | Downstream - Bedrock Present | DnBedrockPresent |
| DnBedScours | this field can be blank or have a value of None or if the StructureType for the Structure is Culvert it can have combinations of the values Culvert, Footers, Wingwalls or if the StructureType for the Structure is Arch or Bridge it ccan have combinations of the values Arch,Abutments, Footers and Wingwalls. | SGA/datasets/structures/data/sStep4.aspx | Downstream - Stream bed scour causing undermining around or under structure | Parameter |
| DnDeposits | this field can be blank or have a value of None or
it can have combinations of the values Delta, Point,
Side, Mid-channel | SGA/datasets/structures/data/sStep4.aspx | Downstream - Sediment Deposit Types | Parameter |
| DnDepositsElevation | this field can only have the values: Yes, No | SGA/datasets/structures/data/sStep4.aspx | Downstream - Elevation of sediment deposits >= 1/2 bankfull | DnDeposits |
| DnLeftDomVeg | this field can only have the values of: Coniferous Forest, Deciduous Forest, Mixed Forest, Shrub/Sapling, Herbaceous/Grass, Bare, Road Embankment or blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Downstream - Left - Dominant Vegetation Type | DnLtDominantVegetation |
| DnLeftVegWidth | this field can only have the values of: Yes, No or blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Downstream - Left - Does a band of shrub/forest vegetation 50 ft. wide start within 25 ft. of the structure and extend at least 500 ft. upstream or downstream | DnLtVegetationBand |
| DnRightDomVeg | this field can only have the values of Coniferous Forest, Deciduous Forest, Mixed Forest, Shrub/Sapling, Herbaceous/Grass, Bare, Road Embankment or blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Downstream - Right - Dominant Vegetation Type | DnRtDominantVegetation |
| DnRightVegWidth | this field can only have the values of: Yes, No or blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Downstream - Right - Does a band of shrub/forest vegetation 50 ft. wide start within 25 ft. of the structure and extend at least 500 ft. upstream or downstream | DnRtVegetationBand |
| DownstreamPool | this field can only have the values of: Yes, No | SGA/datasets/structures/data/sStep3.aspx | Upstream - pool present immediately downstream of structure | DownstreamPool |
| FloodPlainFill | this field can only have the values of: Entirely, Partially, Not Significant | SGA/datasets/structures/data/sStep3.aspx | General - Floodplain filled by roadway approaches | FloodPlainFill |
| GisRoadName | if this field has a value in it, the value must be present in the Roadname field in the Roads table in the SGA database.
If this field is filled in, the OtherRoadName field can not be filled in. | SGA/datasets/structures/data/sStep2.aspx | Road Data - Road Name (droplist) | GisRoadName |
| GUID2014 | field is required. Must be a valid uniqueidentifier from VT Culverts. | SGA/datasets/structures/data/add.aspx and GA/datasets/structures/data/aStep5.aspx | GUID (2014 Standard) | GUID2014 |
| HighDownstreamBanks | this field can only have the values of: Yes, No | SGA/datasets/structures/data/sStep3.aspx | Upstream - downstream banks heights are substantially higher than upstream bank heights | HighDownstreamBanks |
| HighFlowStage | this field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep2.aspx | Stream Data - High Flow Stage | HighFlowStage |
| HighwayNumber | this field must have a value in it. 0000 is acceptable in place of the field being blank | SGA/datasets/structures/data/add.asp | Highway Number | None - Used To Create SGAID |
| InBedMaterial | this field can only have the values of: Bedrock, Boulder, Cobble, Gravel, Sand, Unknown, None | SGA/datasets/structures/data/sStep4.aspx | In Structure - Dominant Bed Material | InBedMaterial |
| InBedMaterialThroughout | this field can only have the values of: Yes, No | SGA/datasets/structures/data/sStep4.aspx | In Structure - Material Thoughout | InBedMaterialThroughout |
| InDeposits | this field can be blank or have a value of None or
it can have combinations of the values Delta, Point,
Side, Mid-channel | SGA/datasets/structures/data/sStep4.aspx | In Structure - Sediment Deposit Types | Parameter |
| InDepositsElevation | this field can only have the values of: Yes, No | SGA/datasets/structures/data/sStep4.aspx | In Structure - Elevation of sediment deposits >= 1/2 bankfull | InDeposits |
| InSpecies | | SGA/datasets/structures/data/sStep6.aspx | Wildlife - Inside Structure - Species use near structure | Species |
| Latitude | this field's value must be greater than or equal to 42.7 and less than or equal to 45.1 or it must be 0 | SGA/datasets/structures/data/sStep1.aspx | Location Data - Latitude | Latitude |
| LocalID | | SGA/datasets/structures/data/ sStep1.aspx through aStep6.aspx in the title bar at the top | LocalID | LocalID |
| Location | The length of this field's value must be less than 250 characters if it is entered | SGA/datasets/structures/data/sStep1.aspx | Location Data - Location | Location |
| LocMeth | it is required that this field contain a value whenever the struct_num field has a value in it
if entered, this field must have a value drawn from the following list
(the value in the field is followed after the = by the displayed description of what that value means - which is generally what the user sees in the user interface)
1 = 1 Digitized from 1:5000 orthophoto
2 = 2 Captured using mileage info and dynamic segmentation
3 = 3 Intersection of 1:5000 roads and 1:100 000 surface waters
4 = 4 Intersection of 1:5000 roads and 1:24 000 surface waters
5 = 5 Intersection of 1:5000 roads and 1:5 000 surface waters
6 = 6 Latitude/Longitude derived from 1:24 000 USGS paper maps
7 = 7 Collected in the field using GPS (center of span and road)
8 = 8 Collected in the field using GPS (either end of span)
9 = 9 Collected in the field using GPS (edge of structure at center of span)
10 = 10 VTrans Highway Mapping System bridge data
11 = 11 Address geocoded using VT E911 road centerline data
12 = 12 GPSed in the field then moved to match 5K digital ortho and/or road centerline
13 = 13 Located in the field by marking location on 5K orthophoto basemap, then digitized with 5K | SGA/datasets/structures/data/sStep1.aspx | struct_num Information - Location Method | LocMeth |
| Longitude | this field's value must be greater than or equal to -73.4 and less than or equal to -71.5 or it must be 0 | SGA/datasets/structures/data/sStep1.aspx | Location Data - Longitude | Longitude |
| Observers | | SGA/datasets/structures/data/sStep1.aspx | Assessment Data - Observers | Observers |
| Obstructions | this field can be blank or have a value of None or
it can have combinations of the values Wood Debris, Sediment
Deformation | SGA/datasets/structures/data/sStep3.aspx | Upstream - Obstructions at structure opening | Parameter |
| OtherRoadName | If this field is filled in, the GISRoadName field can not be filled in. | SGA/datasets/structures/data/sStep2.aspx | Road Data - Road Name (free form entry) | OtherRoadName |
| OutSpecies | | SGA/datasets/structures/data/sStep6.aspx | Wildlife - Outside Structure - Species use near structure | Species |
| OwnerSize | this field must have a value in it
The value must be drawn from this list
(the value in the field is followed after the = by the displayed description of what that value means - which is generally what the user sees in the user interface)
99 = Unknown
70 = Private
00 = Other State
10 = Town - Structure Length >= 20 feet
40 = Town - 6 feet <= structure length < 20 feet
60 = Town - structure length < 6 feet
20 = State - Structure Length >= 20 feet
30 = State - 6 feet <= structure length < 20 feet
50 = State - structure length < 6 feet | SGA/datasets/structures/data/add.asp | Owner/Size | None - Used To Create SGAID |
| Photos | this field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep5.aspx | Other Information - Photos Taken? | Photos |
| PoolDepthMax | if the field StructureType has a value of Culvert and the field DownStreamPool has a value of Yes, this field must have a value | SGA/datasets/structures/data/sStep3.aspx | Upstream - Maximum pool depth | PoolDepthMax |
| PoolDepthStreamFlow | if the field StructureType has a value of Culvert and the field DownStreamPool has a value of Yes, this field must have a value | SGA/datasets/structures/data/sStep3.aspx | Upstream - pool depth at point of entry | PoolDepthStreamFlow |
| ProjectName | if this field has a value, that value must match one drawn from the ProjectName field of the Projects table in the SGA database. | SGA/datasets/structures/data/sStep1.aspx | Assessment Data - Phase 1 Project | ProjectID |
| ReachPointID | if this field has a value, that value must match one drawn from the ReachPointID field of the Reaches table in the SGA database.
| SGA/datasets/structures/data/sStep2.aspx | Phase 1 Reach - ReachID | ReachPointID |
| RoadKillSpecies | this field can be blank or have a value of None or combinations of the values
Amphibians, Bear, Beaver, Bobcat, Coyote, Deer, Fisher, Fox,
Large Bird, Mink, Moose, Otter, Small Mammal, Turtle, Unsure | SGA/datasets/structures/data/sStep6.aspx | Wildlife - Road-killed species within 1/4 mi. of structure | Species |
| RoadType | this field can only have the values of: Railroad, Trail, Paved, Gravel or be blank | SGA/datasets/structures/data/sStep2.aspx | Road Data - Road Type | RoadType |
| SpatialDataGPS | this field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep5.aspx | Other Information - Spatial location data collected with GPS? | SpatialDataGPS |
| SrcOrg | it is required that this field contain a value whenever the struct_num field has a value
the field's value must be drawn from the following list
(the value in the field is followed after the = by the displayed description of what that value means - which is generally what the user sees in the user interface)
4 = 4 ANR
1 = 1 VCGI
2 = 2 VTrans
3 = 3 Town/Municipality
5 = 5 Other State Agency
10 = 10 Addison County RPC
11 = 11 Bennington County RC
12 = 12 Central VT RPC
13 = 13 Chittenden County RPC
14 = 14 Northwest RPC
15 = 15 Lamoille County PC
16 = 16 Northeast VT Development Assoc.
17 = 17 Rutland RPC
18 = 18 Southern Windsor RPC
19 = 19 Two Rivers Ottauquechee RPDC
20 = 20 Upper Valley Lake Sunapee RPC
21 = 21 Windham RPC
99 = 99 Contractor/Consultant | SGA/datasets/structures/data/sStep1.aspx | struct_num Information - Source Organization | SrcOrg |
| SteepRiffle | this field can only have the values of: Yes, No | SGA/datasets/structures/data/sStep3.aspx | Upstream - Steep riffle present immediately upstream of the structure | SteepRiffle |
| StreamName | | SGA/datasets/structures/data/sStep2.aspx | Stream Data - Stream Name | StreamName |
| struct_num | if the field has a value in it, the value must be a match for an entry in the STRUCT_NUM field in the VOBCITReporting table in the SGA database | SGA/datasets/structures/data/sStep1.aspx | struct_num Information - VOBCIT struct_num | struct_num |
| StructureCount | this field's value must be greater than or equal to 0 and less than or equal to 20 | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Number Of Culverts | StructureCount |
| StructureHeight | this field's value must be greater than 0 or blank | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Culvert Height | StructureHeight |
| StructureLength | this field's value must be greater than 0 or blank | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Culvert Length | StructureLength |
| StructureMaterial | this field's value must be in the StructureMaterial field of the StructureMaterials table in the SGA database where the matching Structure field of the StructureMaterials table is equal to the value of StructureType. | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Culvert Material | StructureMaterialID |
| StructureSkewed | this field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Structure Skewed To Roadway? | StructureSkewed |
| StructureType | Must Have a Value Of Arch, Bridge or Culvert | SGA/datasets/structures/data/sStep1.aspx | Basic Structure Data - Structure Type | StructureType |
| StructureWidth | this field's value must be greater than 0 if entered | SGA/datasets/structures/data/sStep2.aspx | Detail Structure Data - Culvert Width | StructureWidth |
| Town | if entered, the value in the field must be from the Town column of the Towns table in the SGA database
| SGA/datasets/structures/data/sStep1.aspx | Location Data - Town | Town |
| TownForSGAID | drawn from COMMNAME field in Lookup_FIPS6 which is used to form the dropdown list | SGA/datasets/structures/data/add.asp | County/Town | Town |
| TransportationSystem | this field must have a value in it. This field must have a value drawn from the following list
(the value in the field is followed after the = by the displayed description of what that value means - which is generally what the user sees in the user interface)
1 = Town
2 = State
3 = Private | SGA/datasets/structures/data/add.asp | Transportation System | None - Used To Create SGAID |
| UpBankArmoring | the value in the field must be from the list: Intact, Failing, None, Unknown | SGA/datasets/structures/data/sStep4.aspx | Upstream - Hard Bank Armoring | UpBankArmoring |
| UpBankErosion | the value in the field must be from the list: High, Low, None | SGA/datasets/structures/data/sStep4.aspx | Upstream - Bank Erosion | UpBankErosion |
| UpBeaverDam | this field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep4.aspx | Upstream - Beaver dam near structure | UpBeaverDam |
| UpBeaverDamDistance | this field's value must be greater than or equal to 0 and less than or equal to 5000 | SGA/datasets/structures/data/sStep4.aspx | Upstream - Beaver Dam distance | UpBeaverDamDistance |
| UpBedMaterial | the value in the field must be from the list: Bedrock, Boulder, Cobble, Gravel, Sand, Unknown | SGA/datasets/structures/data/sStep4.aspx | Upstream - Dominant Bed Material | UpBedMaterial |
| UpBedrockPresent | the value of the field must be from this list: Yes, No | SGA/datasets/structures/data/sStep4.aspx | Upstream - Bedrock Present | UpBedrockPresent |
| UpBedScours | this field can be blank or have a value of None or if the
StructureType for the Structure is Culvert it can have
combinations of the values Culvert, Footers, Wingwalls or
if the StructureType for the Structure is Arch or Bridge
it ccan have combinations of the values Arch,Abutments,
Fototers and Wingwalls. | SGA/datasets/structures/data/sStep4.aspx | Upstream - Stream bed scour causing undermining around or under structure | Parameter |
| UpDeposits | this field can be blank or have a value of None or
it can have combinations of the values Delta, Point,
Side, Mid-channel | SGA/datasets/structures/data/sStep4.aspx | Upstream - Sediment Deposit Types | Parameter |
| UpDepositsElevation | the value in the field must be from this list: Yes, No | SGA/datasets/structures/data/sStep4.aspx | Upstream - Elevation of sediment deposits >= 1/2 bankfull | UpDeposits |
| UpLeftDomVeg | this value in the field must be in this list: Coniferous Forest, Deciduous Forest, Mixed Forest, Shrub/Sapling, Herbaceous/Grass, Bare, Road Embankment or be blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Upstream - Left - Dominant Vegetation Type | UpLtDominantVegetation |
| UpLeftVegWidth | this field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Upstream - Left - Does a band of shrub/forest vegetation 50 ft. wide start within 25 ft. of the structure and extend at least 500 ft. upstream or downstream | UpLtVegetationBand |
| UpRightDomVeg | the value in the field must be in the list : Coniferous Forest, Deciduous Forest, Mixed Forest, Shrub/Sapling, Herbaceous/Grass, Bare, Road Embankment or be blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Upstream - Right - Dominant Vegetation Type | UpRtDominantVegetation |
| UpRightVegWidth | his field can only have the values of: Yes, No or be blank | SGA/datasets/structures/data/sStep5.aspx | Vegetation - Upstream - Right - Does a band of shrub/forest vegetation 50 ft. wide start within 25 ft. of the structure and extend at least 500 ft. upstream or downstream | UpRtVegetationBand |
| ValleySlopeBreak | this field can only have the values of: Yes, No, Unsure | SGA/datasets/structures/data/sStep3.aspx | General - Structure is located at significant break in valley slope | ValleySlopeBreak |
