Name: fpfgis.SDE.tblBridgeConditionAppraisal_1

Display Field: Item113

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• Item8 ( type: esriFieldTypeInteger , alias: Structure No. )
• Item58R ( type: esriFieldTypeInteger , alias: Deck Condition Rating , Coded Values: [9: Excellent Condition] , [8: Very Good Condition] , [7: Good Condition] , ...8 more... )
• Item59R ( type: esriFieldTypeInteger , alias: Superstructure Condition Rating , Coded Values: [9: Excellent Condition] , [8: Very Good Condition] , [7: Good Condition] , ...8 more... )
• Item60R ( type: esriFieldTypeInteger , alias: Substructure Condition Rating , Coded Values: [9: Excellent Condition] , [8: Very Good Condition] , [7: Good Condition] , ...8 more... )
• Item61R ( type: esriFieldTypeInteger , alias: Channel and Channel Protection Rating , Coded Values: [9: Excellent Condition] , [8: Very Good Condition] , [7: Good Condition] , ...8 more... )
• Item62R ( type: esriFieldTypeInteger , alias: Culvert Condition Rating , Coded Values: [9: Excellent Condition] , [8: Very Good Condition] , [7: Good Condition] , ...8 more... )
• Item113 ( type: esriFieldTypeString , alias: Scour Critical Bridges , length: 1 , Coded Values: [N: Bridge not over waterway.] , [9: Bridge Foundations (Including Piles) well above flood waters.] , [8: Bridge Foundations determined to be stable for calculated scour conditions.] , ...8 more... )
• Item71 ( type: esriFieldTypeString , alias: Waterway Adequacy , length: 1 , Coded Values: [N: Bridge not over a waterway.] , [8: Bridge deck above roadway approaches. Slight chance of overtopping roadway approaches.] , [5: Bridge deck above roadway appoaches. Occasional overtopping of roadway approaches with significant traffic delays.] , ...5 more... )
• Item67 ( type: esriFieldTypeInteger , alias: Structure Evaluation , Coded Values: [9: Superior to present desirable criteria.] , [8: Equal to present desirable criteria.] , [7: Better than present minimum criteria.] , ...6 more... )
• Item68 ( type: esriFieldTypeInteger , alias: Deck Geometry , Coded Values: [9: Superior to present desirable criteria.] , [8: Equal to present desirable criteria.] , [7: Better than present minimum criteria.] , ...6 more... )
• Item69 ( type: esriFieldTypeInteger , alias: Underclearances, Vert & Horizontal , Coded Values: [9: Superior to present desirable criteria.] , [8: Equal to present desirable criteria.] , [7: Better than present minimum criteria.] , ...6 more... )
• Item72 ( type: esriFieldTypeInteger , alias: Approach Rdwy Alignment , Coded Values: [8: Equal to present desirable criteria.] , [6: Equal to present minimum criteria.] , [3: Basically intolerable requiring high priority of corrective action.] )
• SufficiencyRating ( type: esriFieldTypeDouble , alias: Sufficiency Rating )
• Deficiency ( type: esriFieldTypeString , alias: Deficiency , length: 50 , Coded Values: [0: Not Deficient] , [1: Structurally Deficient] , [-1: Functionally Obsolete] )
• Item58Com ( type: esriFieldTypeString , alias: Deck Comments , length: 500 )
• Item59Com ( type: esriFieldTypeString , alias: Superstructure Comments , length: 500 )
• Item60Com ( type: esriFieldTypeString , alias: Substructure Comments , length: 500 )
• Item61Com ( type: esriFieldTypeString , alias: Channel Comments , length: 500 )
• Item62Com ( type: esriFieldTypeString , alias: Culvert Comments , length: 500 )
• Item113Com ( type: esriFieldTypeString , alias: Scour Comments , length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )

Relationships:

• BridgeIdentification (14) -- Related To: fpfgis.SDE.BridgeIdentification (1)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates