Name: Bridge Routine Inspection

Display Field: AssetID

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

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• InspectedBy (type: esriFieldTypeString, alias: Routine Inspection By, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true, Coded Values: [City of STL: City of STL], [City of STL - Metro: City of STL - Metro], [City of STL - MoDOT - Metro: City of STL - MoDOT - Metro], ... 12 more ...)
• Insp_Date (type: esriFieldTypeDate, alias: Routine Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Deck_Rating (type: esriFieldTypeString, alias: Deck Rating, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 8 more ...)
• Super_Rating (type: esriFieldTypeString, alias: Superstructure Rating, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 8 more ...)
• Sub_Rating (type: esriFieldTypeString, alias: Substructure Rating, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 8 more ...)
• ChannelBanks_Rating (type: esriFieldTypeString, alias: Channel & Banks Rating, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 8 more ...)
• Deck_Repair (type: esriFieldTypeString, alias: Deck Repair Rating, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 6 more ...)
• Super_Repair (type: esriFieldTypeString, alias: Superstructure Repair Rating, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 6 more ...)
• Sub_Repair (type: esriFieldTypeString, alias: Substructure Repair Rating, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 6 more ...)
• ChannelBanks_Repair (type: esriFieldTypeString, alias: Channel & Banks Repair Rating, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 6 more ...)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ServerLocation (type: esriFieldTypeString, alias: Server Location, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• StructureFolder (type: esriFieldTypeString, alias: Structure Folder, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FullStructureFolderPath (type: esriFieldTypeString, alias: Structure Documents, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edit By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Templates:

Name: Bridge Routine Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ServerLocation: \\metroas02\gis substructures\app\INFO\BRIDGES\

Relationships:

• Bridge (2) -- Related To: Bridge (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/9/2024 3:28:32 PM

Schema Last Edit Date: 2/9/2024 3:28:32 PM

Data Last Edit Date: 2/9/2024 3:28:32 PM

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