Name: STRUCTURE_CONDITION

Display Field: STRUCTURE_TYPE

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 32000

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_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field: GlobalID_2

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CROSSING_ID (type: esriFieldTypeInteger, alias: Crossing ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUCTURE_TYPE (type: esriFieldTypeString, alias: Structure Type , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Round Culvert: Round Culvert], [Elliptical Culvert: Elliptical Culvert], [Pipe Arch Culvert: Pipe Arch Culvert], ... 10 more ...)
• STRUCTURE_MATERIAL (type: esriFieldTypeString, alias: Structure Material , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Concrete: Concrete], [Stone: Stone], [Aluminum - Corrugated: Alluminum - Corrugated], ... 6 more ...)
• US_DIMENSION_A (type: esriFieldTypeDouble, alias: Upstream - Dimension A , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_DIMENSION_B_CB (type: esriFieldTypeDouble, alias: Upstream - Dimension B(CB) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_DIMENSION_B_LT (type: esriFieldTypeDouble, alias: Upstream - Dimension B (LT) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_DIMENSION_C (type: esriFieldTypeDouble, alias: Upstream - Dimension C , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_DIMENSION_D (type: esriFieldTypeDouble, alias: Upstream - Dimension D , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_LOW_TIDE_PERCH (type: esriFieldTypeDouble, alias: Upstream Low Tide Perch , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_HEADWALL_MATERIAL (type: esriFieldTypeString, alias: Upstream Headwall - Materials , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Metal: Metal], [Concrete: Concrete], [Masonry: Masonry], ... 5 more ...)
• US_HEADWALL_CONDITION (type: esriFieldTypeString, alias: Upstream Headwall - Condition , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• US_WINGWALL_MATERIAL (type: esriFieldTypeString, alias: Upstream Wingwall - Materials , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Metal: Metal], [Concrete: Concrete], [Masonry: Masonry], ... 5 more ...)
• US_WINGWALL_CONDITION (type: esriFieldTypeString, alias: Upstream Wingwall - Condition , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• US_STRUCTURE_SCOUR (type: esriFieldTypeString, alias: Scour at Structure - Upstream , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [None: None], [Footer: Footer], [Abutment: Abutment], ... 4 more ...)
• US_SCOUR_SEVERITY (type: esriFieldTypeString, alias: Severity of Scour - Upstream , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [None: None], [Low: Low], [Medium: Medium], ... 1 more ...)
• DS_DIMENSION_A (type: esriFieldTypeDouble, alias: Downstream - Dimension A , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_DIMENSION_B_CB (type: esriFieldTypeDouble, alias: Downstream - Dimension B(CB) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_DIMENSION_B_LT (type: esriFieldTypeDouble, alias: Downstream - Dimension B(LT) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_DIMENSION_C (type: esriFieldTypeDouble, alias: Downstream - Dimension C , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_DIMENSION_D (type: esriFieldTypeDouble, alias: Downstream - Dimension D , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_LOW_TIDE_PERCH (type: esriFieldTypeDouble, alias: Downstream Low Tide Perch , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_HIGH_TIDE_PERCH (type: esriFieldTypeDouble, alias: Downstream High Tide Perch , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_HEADWALL_MATERIAL (type: esriFieldTypeString, alias: Downstream Headwall - Materials , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Metal: Metal], [Concrete: Concrete], [Masonry: Masonry], ... 5 more ...)
• DS_HEADWALL_CONDITION (type: esriFieldTypeString, alias: Downstream Headwall - Condition , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• DS_WINGWALL_MATERIAL (type: esriFieldTypeString, alias: Downstream Wingwall - Materials , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DS_WINGWALL_CONDITION (type: esriFieldTypeString, alias: Downstream Wingwall - Condition , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DS_STRUCTURE_SCOUR (type: esriFieldTypeString, alias: Scour at Structure - Downstream , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [None: None], [Footer: Footer], [Abutment: Abutment], ... 4 more ...)
• DS_SCOUR_SEVERITY (type: esriFieldTypeString, alias: Severity of Scour - Downstream , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [None: None], [Low: Low], [Medium: Medium], ... 1 more ...)
• SCOUR_INSIDE (type: esriFieldTypeString, alias: Scour inside the Structure , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [None: None], [Footer: Footer], [Channel: Channel], ... 3 more ...)
• SCOUR_INSIDE_SEVERITY (type: esriFieldTypeString, alias: Severity of Scour inside Structure, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [None: None], [Low: Low], [Medium: Medium], ... 1 more ...)
• OVERALL_STRUCTURE_CONDITION (type: esriFieldTypeString, alias: Structure Condition - Overall , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• STRUCTURE_CONDITION_COMMENTS (type: esriFieldTypeString, alias: Structure Condition Comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: STRUCTURE_CONDITION
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• SITE_INFORMATION (6) -- Related To: Site Information (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/14/2019 5:15:46 PM

Schema Last Edit Date: 5/14/2019 5:15:46 PM

Data Last Edit Date: 5/14/2019 5:15:46 PM

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