{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 3,
 "name": "Work Order",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "project",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "project",
   "type": "esriFieldTypeString",
   "alias": "Project",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidProjectsTypeList",
    "description": "Project type",
    "codedValues": [
     {
      "name": "Contract Arborist",
      "code": "Contract Arborist"
     },
     {
      "name": "Executive Request",
      "code": "Executive Request"
     },
     {
      "name": "Grid Pruning",
      "code": "Grid Pruning"
     },
     {
      "name": "Service Request",
      "code": "Service Request"
     },
     {
      "name": "Storm Damage",
      "code": "Storm Damage"
     },
     {
      "name": "Weekly Assignment",
      "code": "Weekly Assignment"
     },
     {
      "name": "Work WCA Conversion 2017",
      "code": "Work WCA Conversion 2017"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "work_type",
   "type": "esriFieldTypeString",
   "alias": "Work Type",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidWorkTypesList",
    "description": "Work types",
    "codedValues": [
     {
      "name": "Chipping",
      "code": "Chipping"
     },
     {
      "name": "Complaint - Pest/Disease",
      "code": "Complaint - Pest/Disease"
     },
     {
      "name": "Complaint - Sewer Line",
      "code": "Complaint - Sewer Line"
     },
     {
      "name": "Complaint - Water Line",
      "code": "Complaint - Water Line"
     },
     {
      "name": "Concrete/Sidewalk issue",
      "code": "Concrete/Sidewalk issue"
     },
     {
      "name": "Damage From Roots",
      "code": "Damage From Roots"
     },
     {
      "name": "Damage Repair/Remove",
      "code": "Damage Repair/Remove"
     },
     {
      "name": "Evaluation For Removal",
      "code": "Evaluation For Removal"
     },
     {
      "name": "Hates Trees",
      "code": "Hates Trees"
     },
     {
      "name": "Inspect - Complaint",
      "code": "Inspect - Complaint"
     },
     {
      "name": "Inspect - Pest/Disease",
      "code": "Inspect - Pest/Disease"
     },
     {
      "name": "Inspect - Sidewalk Damage",
      "code": "Inspect - Sidewalk Damage"
     },
     {
      "name": "Limb Down - Broken",
      "code": "Limb Down - Broken"
     },
     {
      "name": "Limb Down - Hanging",
      "code": "Limb Down - Hanging"
     },
     {
      "name": "Maintenance - Tree Well",
      "code": "Maintenance - Tree Well"
     },
     {
      "name": "New Planting Service",
      "code": "New Planting Service"
     },
     {
      "name": "Ord. Violation 1165",
      "code": "Ord. Violation 1164"
     },
     {
      "name": "Pest/Disease - Spray",
      "code": "Pest/Disease - Spray"
     },
     {
      "name": "Plant Tree",
      "code": "Plant Tree"
     },
     {
      "name": "Prune",
      "code": "Prune"
     },
     {
      "name": "Prune - Clearance",
      "code": "Prune - Clearance"
     },
     {
      "name": "Prune - Clearance SndWall",
      "code": "Prune - Clearance SndWall"
     },
     {
      "name": "Prune - Clearance,Raise",
      "code": "Prune - Clearance,Raise"
     },
     {
      "name": "Prune - Full",
      "code": "Prune - Full"
     },
     {
      "name": "Prune - Grid",
      "code": "Prune - Grid"
     },
     {
      "name": "Prune - Root",
      "code": "Prune - Root"
     },
     {
      "name": "Prune - Structural",
      "code": "Prune - Structural"
     },
     {
      "name": "Prune - Thin/Shape",
      "code": "Prune - Thin/Shape"
     },
     {
      "name": "Prune - Weight Reduction",
      "code": "Prune - Weight Reduction"
     },
     {
      "name": "Removal - City Sidewalk Repair",
      "code": "Removal - City Sidewalk Repair"
     },
     {
      "name": "Removal - Ivy",
      "code": "Removal - Ivy"
     },
     {
      "name": "Removal - Permit",
      "code": "Removal - Permit"
     },
     {
      "name": "Removal - Stake",
      "code": "Removal - Stake"
     },
     {
      "name": "Removal - Stump Grind",
      "code": "Removal - Stump Grind"
     },
     {
      "name": "Removal - Stump Only",
      "code": "Removal - Stump Only"
     },
     {
      "name": "Removal - Suckers",
      "code": "Removal - Suckers"
     },
     {
      "name": "Removal - Tree",
      "code": "Removal - Tree"
     },
     {
      "name": "Removal - Tree & Stump",
      "code": "Removal - Tree & Stump"
     },
     {
      "name": "Removal - Tree Only",
      "code": "Removal - Tree Only"
     },
     {
      "name": "Replace/Stake",
      "code": "Replace/Stake"
     },
     {
      "name": "Restake",
      "code": "Restake"
     },
     {
      "name": "Retire/Restake",
      "code": "Retire/Restake"
     },
     {
      "name": "Root Problem",
      "code": "Root Problem"
     },
     {
      "name": "Service Call - Other",
      "code": "Service Call - Other"
     },
     {
      "name": "Service Request - Public",
      "code": "Service Request - Public"
     },
     {
      "name": "Storm Damage",
      "code": "Storm Damage"
     },
     {
      "name": "Storm Prune",
      "code": "Storm Prune"
     },
     {
      "name": "Storm Removal - Tree Only",
      "code": "Storm Removal - Tree Only"
     },
     {
      "name": "Tree Down",
      "code": "Tree Down"
     },
     {
      "name": "Vandalism",
      "code": "Vandalism"
     },
     {
      "name": "Vehicle Damage",
      "code": "Vehicle Damage"
     },
     {
      "name": "Water/Fertilize",
      "code": "Water/Fertilize"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "work_priority",
   "type": "esriFieldTypeString",
   "alias": "Work Priority",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidCallWorkPriorityList",
    "description": "Work priority",
    "codedValues": [
     {
      "name": "50/50 Program",
      "code": "50/50 Program"
     },
     {
      "name": "Broken/limb down",
      "code": "Broken/limb down"
     },
     {
      "name": "Complaint",
      "code": "Complaint"
     },
     {
      "name": "Concrete/Sidewalk issue",
      "code": "Concrete/Sidewalk issue"
     },
     {
      "name": "Dead tree",
      "code": "Dead tree"
     },
     {
      "name": "Emergency - STORM",
      "code": "Emergency - STORM"
     },
     {
      "name": "Emergency limb down",
      "code": "Emergency limb down"
     },
     {
      "name": "Emergency Tree down",
      "code": "Emergency Tree down"
     },
     {
      "name": "Emergency Trim",
      "code": "Emergency Trim"
     },
     {
      "name": "Grid Pruning",
      "code": "Grid Pruning"
     },
     {
      "name": "Hazardous Tree",
      "code": "Hazardous Tree"
     },
     {
      "name": "Pest/Disease",
      "code": "Pest/Disease"
     },
     {
      "name": "Rancho Cielo/City of Salinas",
      "code": "Rancho Cielo/City of Salinas"
     },
     {
      "name": "Replanted Site",
      "code": "Replanted Site"
     },
     {
      "name": "Root Problem",
      "code": "Root Problem"
     },
     {
      "name": "Routine",
      "code": "Routine"
     },
     {
      "name": "Routine Pruning",
      "code": "Routine Pruning"
     },
     {
      "name": "Sewer Line issue",
      "code": "Sewer Line issue"
     },
     {
      "name": "Stump Grind",
      "code": "Stump Grind"
     },
     {
      "name": "Tree down",
      "code": "Tree down"
     },
     {
      "name": "Tree removal",
      "code": "Tree removal"
     },
     {
      "name": "Trimming Request",
      "code": "Trimming Request"
     },
     {
      "name": "Water Line issue",
      "code": "Water Line issue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "wr_status",
   "type": "esriFieldTypeString",
   "alias": "WR Status",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidWR_Status",
    "description": "Work record status types",
    "codedValues": [
     {
      "name": "Completed",
      "code": "Completed"
     },
     {
      "name": "Deleted",
      "code": "Deleted"
     },
     {
      "name": "Requested",
      "code": "Requested"
     },
     {
      "name": "Requested - QAlert",
      "code": "Requested - QAlert"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "crew",
   "type": "esriFieldTypeString",
   "alias": "Crew",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidWorkCrewsList",
    "description": "List of current work crews",
    "codedValues": [
     {
      "name": "*Smith and Enright",
      "code": "*Smith and Enright"
     },
     {
      "name": "Stump Grinding Crew",
      "code": "Stump Grinding Crew"
     },
     {
      "name": "unknown",
      "code": "unknown"
     },
     {
      "name": "QAlert Pending",
      "code": "QAlert Pending"
     },
     {
      "name": "Forestry Crew 1",
      "code": "Forestry Crew 1"
     },
     {
      "name": "Forestry Crew 2",
      "code": "Forestry Crew 2"
     },
     {
      "name": "Forestry Crew 3",
      "code": "Forestry Crew 3"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "requested_date",
   "type": "esriFieldTypeDate",
   "alias": "Requested Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "scheduled_date",
   "type": "esriFieldTypeDate",
   "alias": "Scheduled Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "completed_date",
   "type": "esriFieldTypeDate",
   "alias": "Completed Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "work_comments",
   "type": "esriFieldTypeString",
   "alias": "Work Comments",
   "length": 1020,
   "domain": null
  },
  {
   "name": "post_work_comments",
   "type": "esriFieldTypeString",
   "alias": "Post Work Comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "call_reason",
   "type": "esriFieldTypeString",
   "alias": "Call Reason",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidCallReasonList",
    "description": "Reason for service call",
    "codedValues": [
     {
      "name": "Information",
      "code": "Information"
     },
     {
      "name": "Service Request",
      "code": "Service Request"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "call_priority",
   "type": "esriFieldTypeString",
   "alias": "Call Priority",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "tidCallWorkPriorityList",
    "description": "Work priority",
    "codedValues": [
     {
      "name": "50/50 Program",
      "code": "50/50 Program"
     },
     {
      "name": "Broken/limb down",
      "code": "Broken/limb down"
     },
     {
      "name": "Complaint",
      "code": "Complaint"
     },
     {
      "name": "Concrete/Sidewalk issue",
      "code": "Concrete/Sidewalk issue"
     },
     {
      "name": "Dead tree",
      "code": "Dead tree"
     },
     {
      "name": "Emergency - STORM",
      "code": "Emergency - STORM"
     },
     {
      "name": "Emergency limb down",
      "code": "Emergency limb down"
     },
     {
      "name": "Emergency Tree down",
      "code": "Emergency Tree down"
     },
     {
      "name": "Emergency Trim",
      "code": "Emergency Trim"
     },
     {
      "name": "Grid Pruning",
      "code": "Grid Pruning"
     },
     {
      "name": "Hazardous Tree",
      "code": "Hazardous Tree"
     },
     {
      "name": "Pest/Disease",
      "code": "Pest/Disease"
     },
     {
      "name": "Rancho Cielo/City of Salinas",
      "code": "Rancho Cielo/City of Salinas"
     },
     {
      "name": "Replanted Site",
      "code": "Replanted Site"
     },
     {
      "name": "Root Problem",
      "code": "Root Problem"
     },
     {
      "name": "Routine",
      "code": "Routine"
     },
     {
      "name": "Routine Pruning",
      "code": "Routine Pruning"
     },
     {
      "name": "Sewer Line issue",
      "code": "Sewer Line issue"
     },
     {
      "name": "Stump Grind",
      "code": "Stump Grind"
     },
     {
      "name": "Tree down",
      "code": "Tree down"
     },
     {
      "name": "Tree removal",
      "code": "Tree removal"
     },
     {
      "name": "Trimming Request",
      "code": "Trimming Request"
     },
     {
      "name": "Water Line issue",
      "code": "Water Line issue"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "workorderid",
   "type": "esriFieldTypeString",
   "alias": "workorderid",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "app_created_user",
   "type": "esriFieldTypeString",
   "alias": "app_created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "app_last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "app_last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "wo_time",
   "type": "esriFieldTypeDouble",
   "alias": "Work Order Time",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "QAlertReq",
   "type": "esriFieldTypeSmallInteger",
   "alias": "QAlertReq",
   "domain": {
    "type": "codedValue",
    "name": "BooleanDomain",
    "description": "A 0/1 boolean domain",
    "codedValues": [
     {
      "name": "True",
      "code": -1
     },
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "QAlertReqID",
   "type": "esriFieldTypeInteger",
   "alias": "QAlert Request ID",
   "domain": null
  },
  {
   "name": "QAlertReqClsd",
   "type": "esriFieldTypeSmallInteger",
   "alias": "QAlert Request Closed",
   "domain": {
    "type": "codedValue",
    "name": "BooleanDomain",
    "description": "A 0/1 boolean domain",
    "codedValues": [
     {
      "name": "True",
      "code": -1
     },
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  }
 ],
 "indexes": [
  {
   "name": "R103_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_103",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_OID_103",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "tiWorkRecords",
   "relatedTableId": 2,
   "role": "esriRelRoleOrigin",
   "keyField": "workorderid",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{BB028A65-2D15-4A6E-A757-2F16CFA19E3D}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Pacific Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "1d2464fa5b304c4c919c68c16a8ce835"
}