Name: Structures

Display Field: Structure_Number

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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: sqlTypeOther, 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)
• OutletStructureTypeId (type: esriFieldTypeString, alias: Outlet Shape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ArmoringId (type: esriFieldTypeString, alias: Outlet Armoring, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OutletGradeId (type: esriFieldTypeString, alias: Outlet Grade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OutletUndermining (type: esriFieldTypeString, alias: Outlet Undermining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• InletTypeId (type: esriFieldTypeString, alias: Inlet Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InletArmoringId (type: esriFieldTypeString, alias: Inlet Armoring, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InletGradeId (type: esriFieldTypeString, alias: Inlet Grade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InletUndermining (type: esriFieldTypeString, alias: Inlet Undermining, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• 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)
• SubstrateTypeId (type: esriFieldTypeString, alias: Structure Substrate Type (select one), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubstrateContinuousId (type: esriFieldTypeString, alias: Structure Subtrate Coverage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• WaterDepthId (type: esriFieldTypeString, alias: Water Depth Matches Stream?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WaterVelocityId (type: esriFieldTypeString, alias: Water Velocity Matches Stream?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DryPassageId (type: esriFieldTypeString, alias: Dry Passage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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)
• 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: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• OriginalSetNoAndParentGUID (type: esriFieldTypeString, alias: OriginalSetNoAndParentGUID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CONSTRICTIONPULL (type: esriFieldTypeString, alias: CONSTRICTIONPULL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NewParentGUID (type: esriFieldTypeGUID, alias: NewParentGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)

Templates:

Name: Structures
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• SARP_Merged_2022 (0) -- Related To: SARP_Merged_2022 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/4/2025 11:01:35 PM

Schema Last Edit Date: 3/4/2025 11:01:35 PM

Data Last Edit Date: 10/31/2024 5:05:41 PM

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