All Layers and Tables (Stream_Crossing_Rapid_Assessment_Protocol_(SCA)

Layers:

Layer: Stream Crossing Rapid Assessment Protocol Surveys (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Stream Crossing Rapid Assessment Protocol (SCA)","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
CrossingID (type: esriFieldTypeString, alias: Crossing ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
surveydatetime (type: esriFieldTypeDate, alias: Survey Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gnis_name (type: esriFieldTypeString, alias: Stream Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
road_name (type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
surveytime (type: esriFieldTypeString, alias: Start Time, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
surveydate (type: esriFieldTypeString, alias: Survey Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
county_all (type: esriFieldTypeString, alias: County All, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
state_all (type: esriFieldTypeString, alias: State All, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
shu_all (type: esriFieldTypeString, alias: SHU All, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fips_all (type: esriFieldTypeString, alias: FIPS All, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Surveyors (type: esriFieldTypeString, alias: Surveyor(s), SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
FullSurveyPerformed (type: esriFieldTypeString, alias: Full Survey Performed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
FullSurveyWhyNot (type: esriFieldTypeString, alias: Why full survey was not performed, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [PrivateProperty: Private Property], [Dangerous/safety_concerns: Dangerous / safety conserns], [Ephemeral_stream: Ephemeral Stream], ... 3 more ...)
ThreatLivestock (type: esriFieldTypeString, alias: ThreatLivestock, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ThreatErosion (type: esriFieldTypeString, alias: ThreatErosion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ThreatBarrier (type: esriFieldTypeString, alias: ThreatBarrier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ThreatMaterial (type: esriFieldTypeString, alias: ThreatMaterial, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ThreatATV (type: esriFieldTypeString, alias: ThreatATV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ThreatCover (type: esriFieldTypeString, alias: ThreatCover, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ThreatOther (type: esriFieldTypeString, alias: Other Threats, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
RoadPaved (type: esriFieldTypeString, alias: Pave or Unpaved Road, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Paved: Paved], [Unpaved: Unpaved])
RoadPublic (type: esriFieldTypeString, alias: Public or Private Road, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private])
FlowConditionId (type: esriFieldTypeString, alias: Flow Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No Flow: No Flow], [High: High], [Moderate: Moderate], ... 3 more ...)
Restoration (type: esriFieldTypeString, alias: Restoration Project Possibility, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Maybe: Maybe])
OtherComments (type: esriFieldTypeString, alias: Baseline Comments, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
UpMorphologyID (type: esriFieldTypeString, alias: 1. Upstream Channel Morphology, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [least_impacted: Least Impacted - 5], [moderately_impacted: Moderately Impacted - 3], [most_impacted: Most Impacted - 1])
DownMorphologyID (type: esriFieldTypeString, alias: 2. Downstream Channel Morphology, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [least_impacted: Least Impacted - 5], [moderately_impacted: Moderately Impacted - 3], [most_impacted: Most Impacted - 1])
AlterationID (type: esriFieldTypeString, alias: 3. Downstream Channel Alteration, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [natural: Natural - 5], [minor_partial: Minor or Partial - 3], [high: High - 1])
CrossingTypeID (type: esriFieldTypeString, alias: Crossing Type ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [bridge: Bridge], [culvert: Culvert], [ford: Ford])
culvertnum (type: esriFieldTypeInteger, alias: Number of Culverts, SQL Type: sqlTypeOther, nullable: true, editable: true)
CulvertRound (type: esriFieldTypeString, alias: CulvertRound, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertPipe (type: esriFieldTypeString, alias: CulvertPipe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertArch (type: esriFieldTypeString, alias: CulvertArch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertOpenArch (type: esriFieldTypeString, alias: CulvertOpenArch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertBox (type: esriFieldTypeString, alias: CulvertBox, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertOpenBox (type: esriFieldTypeString, alias: CulvertOpenBox, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertWinged (type: esriFieldTypeString, alias: CulvertWinged, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CulvertOther (type: esriFieldTypeString, alias: Other Culvert Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
StructMetal (type: esriFieldTypeString, alias: StructMetal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructPVC (type: esriFieldTypeString, alias: StructPVC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructSynthetic (type: esriFieldTypeString, alias: StructSynthetic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructReinforced (type: esriFieldTypeString, alias: StructReinforced, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructWood (type: esriFieldTypeString, alias: StructWood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructOtherMetal (type: esriFieldTypeString, alias: StructOtherMetal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructNative (type: esriFieldTypeString, alias: StructNative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructClay (type: esriFieldTypeString, alias: StructClay, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructRock (type: esriFieldTypeString, alias: StructRock, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
StructOther (type: esriFieldTypeString, alias: Other Material, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
us_undermining (type: esriFieldTypeString, alias: us_undermining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ds_undermining (type: esriFieldTypeString, alias: ds_undermining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
bankfullwidth (type: esriFieldTypeDouble, alias: Bankfull Width (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
velocity (type: esriFieldTypeString, alias: Water Velocity Matches Stream, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no_faster: No - Faster], [no_slower: No - Slower], ... 3 more ...)
depthmatch (type: esriFieldTypeString, alias: Water Depth Matches Stream, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no_shallower: No - Shallower], [no_deeper: No - Deeper], ... 1 more ...)
substratematch (type: esriFieldTypeString, alias: Structure Substrate Matches Stream, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [none: None], [comparable: Comparable], [contrasting: Constrasting], ... 2 more ...)
substrate_coverage (type: esriFieldTypeString, alias: Structure Substrate Coverage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [none: None], [25: 25%], [50: 50%], ... 3 more ...)
bats (type: esriFieldTypeString, alias: Bats Present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CrossingLength (type: esriFieldTypeDouble, alias: Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
CrossingHeight (type: esriFieldTypeDouble, alias: Primary Culvert Height (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
crossingwidth (type: esriFieldTypeDouble, alias: Width - Bridge or Primary Culvert (ft) - If multiple culverts this is the culvert with dominate flow, SQL Type: sqlTypeOther, nullable: true, editable: true)
InletDropToStreamBottom (type: esriFieldTypeDouble, alias: Inlet Drop to Stream Bottom, SQL Type: sqlTypeOther, nullable: true, editable: true)
OutletDropToWaterSurface (type: esriFieldTypeDouble, alias: Outlet Drop to Water Surface, SQL Type: sqlTypeOther, nullable: true, editable: true)
OutletDropToStreamBottom (type: esriFieldTypeDouble, alias: Outlet Drop to Stream Bottom, SQL Type: sqlTypeOther, nullable: true, editable: true)
outletgrade (type: esriFieldTypeString, alias: Outlet Grade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [at_stream_grade: At Stream Grade], [free_fall: Free Fall], [cascade: Cascade], ... 3 more ...)
constrictionratio (type: esriFieldTypeString, alias: constrictionratio, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
constriction (type: esriFieldTypeString, alias: Constriction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [minor: Minor], [moderate: Moderate], [severe: Severe], ... 4 more ...)
SkewAngleID (type: esriFieldTypeString, alias: 4. Upstream Skew Angle, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [less_than_5: <5 Degrees - 5], [5_to_30: 5 to 30 Degrees - 3], [greater_than_30: >30 Degrees - 1])
FillConditionID (type: esriFieldTypeString, alias: 5. Crossing Fill Condition, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [good_vegetated: Good / Vegetated - 5], [fair_riprap: Fair / Riprap - 3], [poor_bare_soil: Poor / Bare Soil - 1])
InletOutletID (type: esriFieldTypeString, alias: 6. Crossing Inlet Outlet Condition, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [no_impairment: No Impairment - 5], [sediment_islands: Sediment Islands - 3], [scouring: Scouring - 3], ... 1 more ...)
CrossingComments (type: esriFieldTypeString, alias: Crossing Comments, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
Rlength_units (type: esriFieldTypeString, alias: Rlength_units, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Miles: Miles], [Meters: Meters], [Feet: Feet], ... 1 more ...)
Rlength_A (type: esriFieldTypeDouble, alias: Right Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
RightLength (type: esriFieldTypeString, alias: RightLength, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RightWidth (type: esriFieldTypeDouble, alias: Right Width (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
RightPrism (type: esriFieldTypeDouble, alias: Right Prism Fill (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
RSAVG (type: esriFieldTypeDouble, alias: Right Slope Avg - old, SQL Type: sqlTypeOther, nullable: true, editable: true)
RightSlope (type: esriFieldTypeDouble, alias: Right Slope %, SQL Type: sqlTypeOther, nullable: true, editable: true)
PEVRight (type: esriFieldTypeDouble, alias: Right Potential Eroded Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
Llength_units (type: esriFieldTypeString, alias: Llength_units, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Miles: Miles], [Meters: Meters], [Feet: Feet], ... 1 more ...)
Llength_A (type: esriFieldTypeDouble, alias: Left Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
LeftLength (type: esriFieldTypeDouble, alias: LeftLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
LeftWidth (type: esriFieldTypeDouble, alias: Left Width (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
LeftPrism (type: esriFieldTypeDouble, alias: Left Prism (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
LeftSlope (type: esriFieldTypeDouble, alias: Left Slope %, SQL Type: sqlTypeOther, nullable: true, editable: true)
PEVLeft (type: esriFieldTypeDouble, alias: Left Potential Eroded Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
ErodedVolume (type: esriFieldTypeDouble, alias: 7. Potential Eroded Volume Mean, SQL Type: sqlTypeOther, nullable: true, editable: true)
Erosivity (type: esriFieldTypeString, alias: 8. Surface Erosivity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Low: Low - 5], [Medium: Medium - 3], [High: High - 1])
Slope (type: esriFieldTypeDouble, alias: 9. Road Approach Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
SurfaceErodability (type: esriFieldTypeString, alias: 10. Surface Erodibility Factor, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Low: Low - 5], [Medium: Medium - 3], [High: High - 1])
ApproachULO (type: esriFieldTypeString, alias: Upstream Left Outlet, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [bedrock: Bedrock], [concrete: Concrete], ... 4 more ...)
ApproachURO (type: esriFieldTypeString, alias: Upstream Right Outlet, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [bedrock: Bedrock], [concrete: Concrete], ... 4 more ...)
ApproachULD (type: esriFieldTypeString, alias: Upstream Left Ditch, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [concrete: Concrete], [damaged: Damaged], ... 5 more ...)
ApproachURD (type: esriFieldTypeString, alias: Upstream Right Ditch, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [concrete: Concrete], [damaged: Damaged], ... 5 more ...)
ApproachDLO (type: esriFieldTypeString, alias: Downstream Left Outlet, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [bedrock: Bedrock], [concrete: Concrete], ... 4 more ...)
ApproachDRO (type: esriFieldTypeString, alias: Downstream Right Outlet, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [bedrock: Bedrock], [concrete: Concrete], ... 4 more ...)
ApproachDLD (type: esriFieldTypeString, alias: Downstream Left Ditch, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [concrete: Concrete], [damaged: Damaged], ... 5 more ...)
ApproachDRD (type: esriFieldTypeString, alias: Downstream Right Ditch, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [bare_soil: Bare Soil], [concrete: Concrete], [damaged: Damaged], ... 5 more ...)
Notes (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
SCATotalCal (type: esriFieldTypeString, alias: SCATotalCal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
flag (type: esriFieldTypeString, alias: Flag:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SurveyEnd1 (type: esriFieldTypeDate, alias: Survey End, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
latitude_all (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
longitude_all (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
SCATRanking (type: esriFieldTypeString, alias: SCATRanking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
usgs_crossing (type: esriFieldTypeString, alias: USGS Stream Crossing ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
totalcw (type: esriFieldTypeInteger, alias: Total width of Culverts, SQL Type: sqlTypeOther, nullable: true, editable: true)
rightlength2 (type: esriFieldTypeDouble, alias: Right Length Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
leftlength2 (type: esriFieldTypeDouble, alias: Left Length Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
note_totalcal (type: esriFieldTypeString, alias: note_totalcal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RSAVG1 (type: esriFieldTypeDouble, alias: Right Slope Avg (Degrees), SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Stream_Crossing_Rapid_Assessment_Protocol_(SCA)_Public)

Layers:

Layer: Stream Crossing Rapid Assessment Protocol Surveys (0)