Name: Bridge Inspection

Display Field: BridgeID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• BridgeID ( type: esriFieldTypeInteger, alias: Bridge ID, editable: true, nullable: true, defaultValue: null, modelName: BridgeID )
• Agency ( type: esriFieldTypeString, alias: Responsible Agency, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Agency , Coded Values: [Caltrans: Caltrans] , [Irvine: Irvine] )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspector )
• Frequency_MO ( type: esriFieldTypeString, alias: Frequency (Months), editable: true, nullable: true, length: 30, defaultValue: null, modelName: Frequency_MO )
• LastInspection ( type: esriFieldTypeDate, alias: Last Inspection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastInspection )
• NotificationDate ( type: esriFieldTypeDate, alias: Notification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NotificationDate )
• StrElemCode ( type: esriFieldTypeSmallInteger, alias: Str. Elem. Code, editable: true, nullable: true, defaultValue: null, modelName: StrElemCode , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...6 more... )
• ConditionState ( type: esriFieldTypeString, alias: Condition State, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ConditionState , Coded Values: [CS-1: CS-1] , [CS-2: CS-2] , [CS-3: CS-3] , ...2 more... )
• CorrectionTargetDate ( type: esriFieldTypeDate, alias: Correction Target Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CorrectionTargetDate )
• Observations_Spalls ( type: esriFieldTypeString, alias: Observations - Spalls, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Spalls , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Scaling ( type: esriFieldTypeString, alias: Observations - Scaling, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Scaling , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Leakage ( type: esriFieldTypeString, alias: Observations - Leakage, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Leakage , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Corrosion ( type: esriFieldTypeString, alias: Observations - Corrosion, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Corrosion , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Delaination ( type: esriFieldTypeString, alias: Observations - Delaination, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Delaination , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Arasion ( type: esriFieldTypeString, alias: Observations - Arasion, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Arasion , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Vegetation ( type: esriFieldTypeString, alias: Observations - Vegetation, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Vegetation , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Silt ( type: esriFieldTypeString, alias: Observations - Silt Buildup, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Silt , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Cracks ( type: esriFieldTypeString, alias: Observations - Cracks, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Cracks , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Termite ( type: esriFieldTypeString, alias: Observations - Termite, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Termite , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Efflorescence ( type: esriFieldTypeString, alias: Observations - Efflorescence, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Efflorescence , Coded Values: [Yes: Yes] , [No: No] )
• Observations_Inaccessible ( type: esriFieldTypeString, alias: Observations - Site Inaccessible, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Observations_Inaccessible , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Spalls ( type: esriFieldTypeString, alias: Recommendations - Repair Spalls, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Spalls , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Methacrylate ( type: esriFieldTypeString, alias: Recommendations - Methacrylate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Recommendations_Methacrylate , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Signs ( type: esriFieldTypeString, alias: Recommendations - Replace Signs, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Signs , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Seal ( type: esriFieldTypeString, alias: Recommendations - Repair Joint Seal, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Seal , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Structure ( type: esriFieldTypeString, alias: Recommendations - Repair Structure, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Structure , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_StrElements ( type: esriFieldTypeString, alias: Recommendations - Repair Str. Elements, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_StrElements , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Concrete ( type: esriFieldTypeString, alias: Recommendations - Polyester Concrete, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Concrete , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Vegetation ( type: esriFieldTypeString, alias: Recommendations - Remove Vegetation, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Vegetation , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Silt ( type: esriFieldTypeString, alias: Recommendations - Remove Silt, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Silt , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Paint ( type: esriFieldTypeString, alias: Recommendations - Paint, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Paint , Coded Values: [Yes: Yes] , [No: No] )
• Recommendations_Pave ( type: esriFieldTypeString, alias: Recommendations - Pave, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Recommendations_Pave , Coded Values: [Yes: Yes] , [No: No] )
• InspectionReportLink ( type: esriFieldTypeString, alias: Inspection Report Link, editable: true, nullable: true, length: 900, defaultValue: null, modelName: InspectionReportLink )
• RepairMethod ( type: esriFieldTypeString, alias: Repair Method, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RepairMethod , Coded Values: [Maintenance: Maintenance] , [CIP CIP: CIP] )
• EstRepairCost ( type: esriFieldTypeString, alias: Estimated Repair Cost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EstRepairCost )
• RepairDate ( type: esriFieldTypeDate, alias: Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairDate )
• RepairCost ( type: esriFieldTypeString, alias: Repair Cost, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RepairCost )

Templates:

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

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata