Name: Latest Tree Work Orders table

Display Field: MaintenanceBy

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 3ddc512a5c694ae3a9e68169666d36fd

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AssetID )
• MaintenanceBy ( type: esriFieldTypeString, alias: MaintenanceBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintenanceBy )
• MaintDate ( type: esriFieldTypeDate, alias: MaintDate, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: MaintDate )
• MaintType ( type: esriFieldTypeString, alias: MaintType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintType )
• Completed ( type: esriFieldTypeString, alias: Completed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Completed )
• Deferred ( type: esriFieldTypeString, alias: Deferred, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Deferred )
• CB_HouseDrop ( type: esriFieldTypeString, alias: CB_HouseDrop, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_HouseDrop )
• CB_SecWire ( type: esriFieldTypeString, alias: CB_SecWire, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_SecWire )
• WireClearance ( type: esriFieldTypeString, alias: WireClearance, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WireClearance )
• Deadwood ( type: esriFieldTypeString, alias: Deadwood, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Deadwood )
• LimbRemoval ( type: esriFieldTypeString, alias: LimbRemoval, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LimbRemoval )
• Stubs ( type: esriFieldTypeString, alias: Stubs, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Stubs )
• CB_Fence ( type: esriFieldTypeString, alias: CB_Fence, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_Fence )
• CB_House ( type: esriFieldTypeString, alias: CB_House, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_House )
• CB_lawn ( type: esriFieldTypeString, alias: CB_lawn, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_lawn )
• CB_Property ( type: esriFieldTypeString, alias: CB_Property, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_Property )
• CB_Roof ( type: esriFieldTypeString, alias: CB_Roof, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_Roof )
• CB_Tree ( type: esriFieldTypeString, alias: CB_Tree, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CB_Tree )
• Sucker ( type: esriFieldTypeString, alias: Sucker, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Sucker )
• ThinCrown ( type: esriFieldTypeString, alias: ThinCrown, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ThinCrown )
• UpBranch ( type: esriFieldTypeString, alias: UpBranch, editable: true, nullable: true, length: 3, defaultValue: null, modelName: UpBranch )
• MaintStatus ( type: esriFieldTypeString, alias: MaintStatus, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MaintStatus )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Notes )
• TreeGuid ( type: esriFieldTypeGUID, alias: TreeGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TreeGuid )
• TreeSpaceGuid ( type: esriFieldTypeGUID, alias: TreeSpaceGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TreeSpaceGuid )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Latest Tree Work Orders table
  Description:
  Prototype:
  GlobalID: {00000000-0000-0000-0000-000000000000}
  AssetID: null
  MaintenanceBy: null
  MaintDate: null
  MaintType: null
  Completed: null
  Deferred: null
  CB_HouseDrop: null
  CB_SecWire: null
  WireClearance: null
  Deadwood: null
  LimbRemoval: null
  Stubs: null
  CB_Fence: null
  CB_House: null
  CB_lawn: null
  CB_Property: null
  CB_Roof: null
  CB_Tree: null
  Sucker: null
  ThinCrown: null
  UpBranch: null
  MaintStatus: null
  Notes: null
  TreeGuid: null
  TreeSpaceGuid: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata