Name: lisleedit.GIS.WorkOrder_History_10_27_16

Display Field: SPECIES

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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 )
• TREE_ID ( type: esriFieldTypeInteger , alias: TREE_ID , editable: true , nullable: true )
• SPECIES ( type: esriFieldTypeString , alias: SPECIES , editable: true , nullable: true , length: 75 , Coded Values: [AILANTHUS: AILANTHUS] , [ALDER-SPP: ALDER-SPP] , [AMERICAN HORNBEAM: AMERICAN HORNBEAM] , ...156 more... )
• DBH ( type: esriFieldTypeInteger , alias: DBH , editable: true , nullable: true )
• CONDITION ( type: esriFieldTypeInteger , alias: CONDITION , editable: true , nullable: true , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...3 more... )
• X ( type: esriFieldTypeDouble , alias: X , editable: true , nullable: true )
• Y ( type: esriFieldTypeDouble , alias: Y , editable: true , nullable: true )
• INV_DATE ( type: esriFieldTypeDate , alias: INV_DATE , editable: true , nullable: true , length: 8 )
• PLANT_DATE ( type: esriFieldTypeDate , alias: PLANT_DATE , editable: true , nullable: true , length: 8 )
• REMOVE_DATE ( type: esriFieldTypeDate , alias: REMOVE_DATE , editable: true , nullable: true , length: 8 )
• WORK_ORDER ( type: esriFieldTypeString , alias: WORK_ORDER , editable: true , nullable: true , length: 50 , Coded Values: [INSPECT: INSPECT] , [REMOVE: REMOVE] , [PRUNE: PRUNE] , ...13 more... )
• WORK_REASON ( type: esriFieldTypeString , alias: WORK_REASON , editable: true , nullable: true , length: 50 , Coded Values: [STUMP ON PARKWAY: STUMP ON PARKWAY] , [RESIDENT REQUEST: RESIDENT REQUEST] , [ADDISON REQUEST: ADDISON REQUEST] , ...15 more... )
• DESCRIPTION ( type: esriFieldTypeString , alias: DESCRIPTION , editable: true , nullable: true , length: 100 )
• OPENED_BY ( type: esriFieldTypeString , alias: OPENED_BY , editable: true , nullable: true , length: 50 , Coded Values: [STEVE LANE: STEVE LANE] , [JEREMY LAKE: JEREMY LAKE] , [CRYSTALYN DELACRUZ: CRYSTALYN DELACRUZ] , ...4 more... )
• OPENED_ON ( type: esriFieldTypeDate , alias: OPENED_ON , editable: true , nullable: true , length: 8 )
• CLOSED_BY ( type: esriFieldTypeString , alias: CLOSED_BY , editable: true , nullable: true , length: 50 , Coded Values: [STEVE LANE: STEVE LANE] , [JEREMY LAKE: JEREMY LAKE] , [CRYSTALYN DELACRUZ: CRYSTALYN DELACRUZ] , ...4 more... )
• CLOSED_ON ( type: esriFieldTypeDate , alias: CLOSED_ON , editable: true , nullable: true , length: 8 )
• CONTRACTOR ( type: esriFieldTypeString , alias: CONTRACTOR , editable: true , nullable: true , length: 50 )
• WORK_NOTES ( type: esriFieldTypeString , alias: WORK_NOTES , editable: true , nullable: true , length: 100 )
• FOLLOWUP ( type: esriFieldTypeString , alias: FOLLOWUP , editable: true , nullable: true , length: 50 , Coded Values: [INSPECT: INSPECT] , [REMOVE: REMOVE] , [PRUNE: PRUNE] , ...13 more... )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• created_user ( type: esriFieldTypeString , alias: created_user , editable: false , nullable: true , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , editable: false , nullable: true , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , editable: false , nullable: true , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , editable: false , nullable: true , length: 8 )

Templates:

• Name: lisleedit.GIS.WorkOrder_History_10_27_16
  Description:
  Prototype:
  FOLLOWUP: null
  WORK_NOTES: null
  TREE_ID: null
  SPECIES: null
  DBH: null
  CONDITION: null
  X: null
  Y: null
  INV_DATE: null
  PLANT_DATE: null
  REMOVE_DATE: null
  WORK_ORDER: null
  WORK_REASON: null
  DESCRIPTION: null
  OPENED_BY: null
  OPENED_ON: null
  CLOSED_BY: null
  CLOSED_ON: null
  CONTRACTOR: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Lisle_Tree_Inventory_10_27_16 (0) -- Related To: Trees (0)

Capabilities: Create,Query,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: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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