Name: Work Orders

Display Field: CallerName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 75c9e3a803c64dc5b9a8eadb7491f814

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 255, defaultValue: Low, modelName: PRIORITY , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TYPE , Coded Values: [Elevating/Deadwood Pruning: Elevating/Deadwood Pruning] , [Removal: Removal] , [Ash Reduction: Ash Reduction] , ...13 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: Open, modelName: STATUS , Coded Values: [Open: Open] , [Closed: Closed] )
• aNOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 265, defaultValue: null, modelName: aNOTES )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• DateClosed ( type: esriFieldTypeDate, alias: DateClosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateClosed )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CreateBy )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• EditBy ( type: esriFieldTypeString, alias: EditBy, editable: false, nullable: true, length: 255, defaultValue: null, modelName: EditBy )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• CallerName ( type: esriFieldTypeString, alias: Caller Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CallerName )
• CallerPhone ( type: esriFieldTypeString, alias: Caller Phone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CallerPhone )
• GUID_WO_A ( type: esriFieldTypeString, alias: GUID_WO_A, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GUID_WO_A )
• Address_WO_Table ( type: esriFieldTypeString, alias: Address WO Table, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Address_WO_Table )
• Pruning_Info ( type: esriFieldTypeString, alias: Pruning Info, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Pruning_Info , Coded Values: [Pole Saw: Pole Saw] , [Big Bucket Truck Needed: Big Bucket Truck Needed] , [Wires Present: Wires Present] , ...2 more... )
• Removal_Info1 ( type: esriFieldTypeString, alias: Removal Info 1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Removal_Info1 , Coded Values: [Simple, Small, Quick Removal: Simple, Small, Quick Removal] , [Bucket Truck Needed: Bucket Truck Needed] , [Traffic Concerns: Traffic Concerns] , ...3 more... )
• Removal_Info2 ( type: esriFieldTypeString, alias: Removal Info 2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Removal_Info2 , Coded Values: [Simple, Small, Quick Removal: Simple, Small, Quick Removal] , [Bucket Truck Needed: Bucket Truck Needed] , [Traffic Concerns: Traffic Concerns] , ...3 more... )
• No_Parking_Posted ( type: esriFieldTypeString, alias: No Parking Posted?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: No_Parking_Posted , Coded Values: [Yes: Yes] , [No: No] )
• Inspection_Notes ( type: esriFieldTypeString, alias: Inspection Notes, editable: true, nullable: true, length: 264, defaultValue: null, modelName: Inspection_Notes )
• Leaf_Status ( type: esriFieldTypeString, alias: When should this be completed?, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Leaf_Status , Coded Values: [Leaf On: Leaf On] , [Leaf Off: Leaf Off] )
• Tree_ID ( type: esriFieldTypeString, alias: Tree_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Tree_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Work Orders
  Description:
  Prototype:
  Tree_ID: null
  Leaf_Status: null
  PRIORITY: Low
  TYPE: null
  STATUS: Open
  aNOTES: null
  Longitude: null
  Latitude: null
  DateClosed: null
  Inspection_Notes: null
  No_Parking_Posted: null
  Removal_Info2: null
  Removal_Info1: null
  CallerName: null
  CallerPhone: null
  GUID_WO_A: null
  Address_WO_Table: null
  Pruning_Info: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Tree (0) -- Related To: Tree (1)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreateDate
• Creator Field: CreateBy
• Edit Date Field: EditDate
• Editor Field: EditBy

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

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