Name: Stream Crossing Rapid Assessment Protocol Surveys

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text: Alabama Rivers and Streams Network

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

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: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

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:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/14/2025 2:46:30 PM

Schema Last Edit Date: 11/10/2025 2:49:39 PM

Data Last Edit Date: 11/14/2025 2:46:30 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat