Name: Maintenance
Display Field:
Type: Table
Has Views: true
Source Schema Changes Allowed: true
Views
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:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- mainttype (type: esriFieldTypeString, alias: Maintenance type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Debris Removal: Debris Removal], [Hazard Removal: Hazard Removal], [Pest & Disease Treatment: Pest & Disease Treatment], ... 8 more ...)
- startdate (type: esriFieldTypeDate, alias: Start date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- maintdate (type: esriFieldTypeDate, alias: Date finished, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [In Progress: In Progress], [Completed: Completed], [Paused: Paused], ... 1 more ...)
- notes (type: esriFieldTypeString, alias: Maintenance notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- assetglobalid (type: esriFieldTypeGUID, alias: Tree GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Relationships:
- Trees_4 (0) -- Related To: Trees (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/20/2024 9:35:07 AM
Schema Last Edit Date: 11/11/2022 3:13:28 AM
Data Last Edit Date: 8/14/2024 7:01:10 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat