Name: structure

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• Structure_Number (type: esriFieldTypeString, alias: Structure Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MaterialId (type: esriFieldTypeString, alias: Structure Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Metal: Metal], [Concrete: Concrete], [Plastic: Plastic], ... 6 more ...)
• OutletStructureTypeId (type: esriFieldTypeString, alias: Outlet Shape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Round Culvert: 1. Round Culvert], [Pipe Arch/Elliptical Culvert: 2. Pipe Arch/Elliptical Culvert], [Open Bottom Arch/Bridge/Culvert: 3. Open Bottom Arch/Bridge/Culvert], ... 6 more ...)
• ArmoringId (type: esriFieldTypeString, alias: Outlet Armoring, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Not Extensive: Not Extensive - <50% stream width coverage], [Extensive: Extensive - >50% stream width coverage])
• OutletGradeId (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 ...)
• OutletUndermining (type: esriFieldTypeString, alias: Outlet Undermining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• OutletADimension (type: esriFieldTypeDouble, alias: Outlet A. Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletBDimension (type: esriFieldTypeDouble, alias: Outlet B. Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletCDimension (type: esriFieldTypeDouble, alias: Outlet C. Substrate/Water Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutletDDimension (type: esriFieldTypeDouble, alias: Outlet D. Water Depth, 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)
• AbutmentHeight (type: esriFieldTypeDouble, alias: E. Abutment Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StructureLength (type: esriFieldTypeDouble, alias: L. Structure Length Top of Structure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StructureLengthBottom (type: esriFieldTypeDouble, alias: L. Structure Length Bottom of Structure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletStructureTypeId (type: esriFieldTypeString, alias: Inlet Shape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Round Culvert: 1. Round Culvert], [Pipe Arch/Elliptical Culvert: 2. Pipe Arch/Elliptical Culvert], [Open Bottom Arch/Bridge/Culvert: 3. Open Bottom Arch/Bridge/Culvert], ... 6 more ...)
• InletTypeId (type: esriFieldTypeString, alias: Inlet Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Projecting: Projecting], [Headwall: Headwall], [Wingwalls: Wingwalls], ... 4 more ...)
• InletArmoringId (type: esriFieldTypeString, alias: Inlet Armoring, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Not Extensive: Not Extensive - <50% stream width coverage], [Extensive: Extensive - >50% stream width coverage])
• InletGradeId (type: esriFieldTypeString, alias: Inlet Grade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [At Stream Grade: At Stream Grade], [Inlet Drop: Inlet Drop], [Perched: Perched], ... 2 more ...)
• InletUndermining (type: esriFieldTypeString, alias: Inlet Undermining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• InletADimension (type: esriFieldTypeDouble, alias: Inlet A. Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletBDimension (type: esriFieldTypeDouble, alias: Inlet B. Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletCDimension (type: esriFieldTypeDouble, alias: Inlet C. Substrate/Water Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletDDimension (type: esriFieldTypeDouble, alias: Inlet D. Water Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InletDropToStreamBottom (type: esriFieldTypeDouble, alias: Inlet Drop to Stream Bottom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• slope (type: esriFieldTypeDouble, alias: Slope (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Slope_Confidence (type: esriFieldTypeString, alias: Slope Confidence, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [High: High], [Low: Low])
• InternalStructureId (type: esriFieldTypeString, alias: Internal Structures?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubstrateMatchId (type: esriFieldTypeString, alias: Structure Substrate Matches Stream?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Comparable: Comparable - similar in size to natural stream channel], [Contrasting: Contrasting - different in size from natural channel], ... 2 more ...)
• SubstrateTypeId (type: esriFieldTypeString, alias: Structure Substrate Type (select one), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Silt: Silt], [Sand: Sand], ... 6 more ...)
• SubstrateContinuousId (type: esriFieldTypeString, alias: Structure Subtrate Coverage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [25%: 25%], [50%: 50%], ... 3 more ...)
• PhysicalBarrierTypeId (type: esriFieldTypeString, alias: Physical Barriers (pick all that apply)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BarrierSeverityId (type: esriFieldTypeString, alias: Physical Barrier Severity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Minor: Minor - < 10% open area of structure blocked], [Moderate: Moderate - 10-50% open area of structure blocked], ... 1 more ...)
• WaterDepthId (type: esriFieldTypeString, alias: Water Depth Matches Stream?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Dry: Dry (stream also dry)], [Dry (stream wet): Dry (stream wet)], ... 3 more ...)
• WaterVelocityId (type: esriFieldTypeString, alias: Water Velocity Matches Stream?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Dry (stream wet): Dry (stream wet)], [Dry: Dry (stream also dry)], ... 3 more ...)
• DryPassageId (type: esriFieldTypeString, alias: Dry Passage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
• PassageHeight (type: esriFieldTypeDouble, alias: Height Above Dry Passage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bats (type: esriFieldTypeString, alias: Bats Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Did not search: Did not search], [No signs observed: No signs observed], [Some: Some (< 10)], ... 1 more ...)
• StructureComment (type: esriFieldTypeString, alias: Structure Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WETDROP (type: esriFieldTypeString, alias: WETDROP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DRYDROP (type: esriFieldTypeString, alias: DRYDROP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DROPSCORE (type: esriFieldTypeString, alias: DROPSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HEIGHTSCORE (type: esriFieldTypeString, alias: HEIGHTSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLETROUND (type: esriFieldTypeString, alias: OPENINLETROUND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLETEMBEDROUND (type: esriFieldTypeString, alias: OPENINLETEMBEDROUND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENROUNDFINAL (type: esriFieldTypeString, alias: OPENROUNDFINAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLEllIPTICAL (type: esriFieldTypeString, alias: OPENINLEllIPTICAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINELLIPTICALEMB (type: esriFieldTypeString, alias: OPENINELLIPTICALEMB, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLELLIPTFINAL (type: esriFieldTypeString, alias: OPENINLELLIPTFINAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLETARCH (type: esriFieldTypeString, alias: OPENINLETARCH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLBOX (type: esriFieldTypeString, alias: OPENINLBOX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINLBOXSLOPES (type: esriFieldTypeString, alias: OPENINLBOXSLOPES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINBOXABUT (type: esriFieldTypeString, alias: OPENINBOXABUT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENINBOXBOTH (type: esriFieldTypeString, alias: OPENINBOXBOTH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTLETROUND (type: esriFieldTypeString, alias: OPENOUTLETROUND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTLETEMBEDROUND (type: esriFieldTypeString, alias: OPENOUTLETEMBEDROUND, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTROUNDFINAL (type: esriFieldTypeString, alias: OPENOUTROUNDFINAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTLETEllIPTICAL (type: esriFieldTypeString, alias: OPENOUTLETEllIPTICAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTELLIPTICALEMB (type: esriFieldTypeString, alias: OPENOUTELLIPTICALEMB, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTELLIPTFINAL (type: esriFieldTypeString, alias: OPENOUTELLIPTFINAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTARCH (type: esriFieldTypeString, alias: OPENOUTARCH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTBOX (type: esriFieldTypeString, alias: OPENOUTBOX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTBOXSLOPES (type: esriFieldTypeString, alias: OPENOUTBOXSLOPES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTBOXABUT (type: esriFieldTypeString, alias: OPENOUTBOXABUT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENOUTBOXBOTH (type: esriFieldTypeString, alias: OPENOUTBOXBOTH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENNESSIN (type: esriFieldTypeString, alias: OPENNESSIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENNESSOUT (type: esriFieldTypeString, alias: OPENNESSOUT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENNESS (type: esriFieldTypeString, alias: OPENNESS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OPENNESSSCORE (type: esriFieldTypeString, alias: OPENNESSSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PHYSBARRSCORE (type: esriFieldTypeString, alias: PHYSBARRSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CONSTRICTIONSCORE (type: esriFieldTypeString, alias: CONSTRICTIONSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INLETGRADESCORE (type: esriFieldTypeString, alias: INLETGRADESCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DEPTHSCORE (type: esriFieldTypeString, alias: DEPTHSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VELOCITYSCORE (type: esriFieldTypeString, alias: VELOCITYSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SCOURSCORE (type: esriFieldTypeString, alias: SCOURSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SUBMATCHSCORE (type: esriFieldTypeString, alias: SUBMATCHSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SUBCOVERSCORE (type: esriFieldTypeString, alias: SUBCOVERSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OUTARMORSCORE (type: esriFieldTypeString, alias: OUTARMORSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INTSTRUCSCORE (type: esriFieldTypeString, alias: INTSTRUCSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMPOSITESCORE (type: esriFieldTypeString, alias: COMPOSITESCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PASSSCORE (type: esriFieldTypeString, alias: PASSSCORE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• InVelocity (type: esriFieldTypeDouble, alias: Inlet Velocity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OutVelocity (type: esriFieldTypeDouble, alias: Outlet Velocity, SQL Type: sqlTypeOther, nullable: true, editable: true)

Relationships:

• Western_SARP_AOP_Stream_Crossing_Survey_Form_structure (1) -- Related To: Western_SARP_AOP_Stream_Crossing_Survey_Form (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/31/2025 5:38:59 PM

Schema Last Edit Date: 10/31/2025 5:38:59 PM

Data Last Edit Date: 10/31/2025 5:38:59 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat