Name: Work Orders

Display Field: CallerName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 792ef0346a7c44a3ae8ebb45f6957aa5

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PRIORITY ( type: esriFieldTypeString, alias: Priority, length: 255 , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...1 more... )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 255 , Coded Values: [Branch Down: Branch Down] , [Clearance & Deadwood Pruning: Clearance & Deadwood Pruning] , [Emerald Ash Borer Treatment: Emerald Ash Borer Treatment] , ...11 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 255 , Coded Values: [Open: Open] , [Closed: Closed] )
• aNOTES ( type: esriFieldTypeString, alias: Notes, length: 265 )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• DateClosed ( type: esriFieldTypeDate, alias: DateClosed, length: 8 )
• CreateBy ( type: esriFieldTypeString, alias: CreateBy, length: 255 )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, length: 8 )
• EditBy ( type: esriFieldTypeString, alias: EditBy, length: 255 )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• CallerName ( type: esriFieldTypeString, alias: Caller Name, length: 255 )
• CallerPhone ( type: esriFieldTypeString, alias: Caller Phone, length: 255 )
• GUID_WO_A ( type: esriFieldTypeString, alias: GUID_WO_A, length: 255 )
• Address_WO_Table ( type: esriFieldTypeString, alias: Address WO Table, length: 255 )
• Pruning_Info ( type: esriFieldTypeString, alias: Pruning Info, length: 255 , Coded Values: [Pole Saw: Pole Saw] , [Big Bucket Truck Needed: Big Bucket Truck Needed] , [Wires Present: Wires Present] , ...1 more... )
• Removal_Info1 ( type: esriFieldTypeString, alias: Removal Info 1, length: 255 , 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, length: 255 , 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?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Inspection_Notes ( type: esriFieldTypeString, alias: Inspection Notes, length: 264 )
• Leaf_Status ( type: esriFieldTypeString, alias: When should this be completed?, length: 255 , Coded Values: [Leaf On: Leaf On] , [Leaf Off: Leaf Off] , [Contracted Out: Contracted Out] )
• Tree_ID ( type: esriFieldTypeString, alias: Tree_ID, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata