Name: Maintenance

Display Field: MaintDate

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• MaintDate (type: esriFieldTypeDate, alias: MaintDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Maint_Type (type: esriFieldTypeString, alias: Maint_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Clean: Clean], [Seal: Seal], [Clean Around: Clean Around], ... 8 more ...)
• PerformedBy (type: esriFieldTypeString, alias: PerformedBy, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: Maintenance_GUID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• MaintenanceSchedule (type: esriFieldTypeString, alias: MaintenanceCycle, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Daily: Daily], [Monthly: Monthly], [Weekly: Weekly], ... 6 more ...)
• NextMaintenanceDate (type: esriFieldTypeDate, alias: NextMaintenanceDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RecommendedMaintenance (type: esriFieldTypeString, alias: Recommended Maintenance, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Total_Maintenance_Cost (type: esriFieldTypeDouble, alias: Total_Maintenance_Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LocationID (type: esriFieldTypeInteger, alias: Display Location ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MaintenanceSubtype (type: esriFieldTypeInteger, alias: MaintenanceSubtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ArtPAC_ID (type: esriFieldTypeString, alias: ArtPAC_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ArtLocation_GlobalID (type: esriFieldTypeGUID, alias: ArtLocation_GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Artwork_GUID (type: esriFieldTypeGUID, alias: Artwork_GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)

Types:

ID: 0
Name: Inspection
Domains:

• Field Name: Maint_Type
  Inherited
  
• Field Name: MaintenanceSchedule
  Inherited
  
Templates:

Name: Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceSubtype: 0

---

ID: 1
Name: Cleaning
Domains:

• Field Name: Maint_Type
  Inherited
  
• Field Name: MaintenanceSchedule
  Inherited
  
Templates:

Name: Cleaning
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceSubtype: 1

---

ID: 2
Name: Secure
Domains:

• Field Name: Maint_Type
  Inherited
  
• Field Name: MaintenanceSchedule
  Inherited
  
Templates:

Name: Secure
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceSubtype: 2

---

ID: 3
Name: Paint
Domains:

• Field Name: Maint_Type
  Inherited
  
• Field Name: MaintenanceSchedule
  Inherited
  
Templates:

Name: Paint
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceSubtype: 3

---

ID: 4
Name: Repair
Domains:

• Field Name: Maint_Type
  Inherited
  
• Field Name: MaintenanceSchedule
  Inherited
  
Templates:

Name: Repair
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceSubtype: 4

---

ID: 5
Name: Other
Domains:

• Field Name: Maint_Type
  Inherited
  
• Field Name: MaintenanceSchedule
  Inherited
  
Templates:

Name: Other
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceSubtype: 5

---

Relationships:

• Display Location (6) -- Related To: Display Location (3)
• Artwork (3) -- Related To: Artwork (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/23/2026 1:53:24 PM

Schema Last Edit Date: 6/23/2026 1:53:24 PM

Data Last Edit Date: 6/23/2026 1:53:24 PM

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