{
 "currentVersion": 11.1,
 "cimVersion": "3.1.0",
 "id": 844,
 "name": "FleetEquipment",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ASSETID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ASSETID",
   "type": "esriFieldTypeString",
   "alias": "ASSETID",
   "length": 12,
   "domain": null
  },
  {
   "name": "UNITNO",
   "type": "esriFieldTypeString",
   "alias": "UNITNO",
   "length": 12,
   "domain": null
  },
  {
   "name": "MAKE",
   "type": "esriFieldTypeString",
   "alias": "MAKE",
   "length": 30,
   "domain": null
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "MODEL",
   "length": 30,
   "domain": null
  },
  {
   "name": "MODELYEAR",
   "type": "esriFieldTypeString",
   "alias": "MODELYEAR",
   "length": 4,
   "domain": null
  },
  {
   "name": "VIN",
   "type": "esriFieldTypeString",
   "alias": "VIN",
   "length": 30,
   "domain": null
  },
  {
   "name": "DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "DESCRIPTION",
   "length": 50,
   "domain": null
  },
  {
   "name": "EQUIPMENTTYPE",
   "type": "esriFieldTypeString",
   "alias": "EQUIPMENTTYPE",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "Flt_EquipmentType",
    "description": "",
    "codedValues": [
     {
      "name": "Generator",
      "code": "GENERATOR"
     },
     {
      "name": "Passenger Vehicle",
      "code": "PASSENGER VEHICLE"
     },
     {
      "name": "Light Duty Truck/Van",
      "code": "LIGHT DUTY TRUCK/VAN"
     },
     {
      "name": "Medium Duty Truck",
      "code": "MEDIUM DUTY TRUCK"
     },
     {
      "name": "Heavy Duty Truck",
      "code": "HEAVY DUTY TRUCK"
     },
     {
      "name": "Construction Equipment",
      "code": "CONSTRUCTION EQUIPMENT"
     },
     {
      "name": "Parks/Facilities Equipment",
      "code": "PARKS/FACILITIES EQUIPMENT"
     },
     {
      "name": "Forklift",
      "code": "FORKLIFT"
     },
     {
      "name": "Trailer",
      "code": "TRAILER"
     },
     {
      "name": "Trailer With Attachment",
      "code": "TRAILER WITH ATTACHMENT"
     },
     {
      "name": "Attachment Streets/Utilities",
      "code": "ATTACHMENT STREETS/UTILITIES"
     },
     {
      "name": "Attachment Parks",
      "code": "ATTACHMENT PARKS"
     },
     {
      "name": "Miscellaneous",
      "code": "MISCELLANEOUS"
     },
     {
      "name": "KFR Equipment",
      "code": "KFR EQUIPMENT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FUELTYPE",
   "type": "esriFieldTypeString",
   "alias": "FUELTYPE",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "Flt_FuelType",
    "description": "",
    "codedValues": [
     {
      "name": "Gasoline",
      "code": "GASOLINE"
     },
     {
      "name": "Diesel",
      "code": "DIESEL"
     },
     {
      "name": "Propane",
      "code": "PROPANE"
     },
     {
      "name": "Electric",
      "code": "ELECTRIC"
     },
     {
      "name": "Compressed Natural Gas",
      "code": "CNG"
     },
     {
      "name": "Not Applicable",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "METERTYPE",
   "type": "esriFieldTypeString",
   "alias": "METERTYPE",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "Flt_MeterType",
    "description": "",
    "codedValues": [
     {
      "name": "Kilometers",
      "code": "KILOMETERS"
     },
     {
      "name": "Hours",
      "code": "HOURS"
     },
     {
      "name": "Not Applicable",
      "code": "N/A"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FLEETSTATUS",
   "type": "esriFieldTypeString",
   "alias": "FLEETSTATUS",
   "length": 30,
   "domain": null
  },
  {
   "name": "NSCCLASSIFICATION",
   "type": "esriFieldTypeString",
   "alias": "NSCCLASSIFICATION",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "Flt_NSCClass",
    "description": "",
    "codedValues": [
     {
      "name": "NSC",
      "code": "NSC"
     },
     {
      "name": "Non NSC",
      "code": "NON NSC"
     },
     {
      "name": "NSC CVIP",
      "code": "NSC CVIP"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LINKEDUNITNO",
   "type": "esriFieldTypeString",
   "alias": "LINKEDUNITNO",
   "length": 12,
   "domain": null
  },
  {
   "name": "AXELCOUNT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "AXELCOUNT",
   "domain": null
  },
  {
   "name": "LICENSEPLATE",
   "type": "esriFieldTypeString",
   "alias": "LICENSEPLATE",
   "length": 12,
   "domain": null
  },
  {
   "name": "GVW",
   "type": "esriFieldTypeInteger",
   "alias": "GVW",
   "domain": null
  },
  {
   "name": "LICENSEDGVW",
   "type": "esriFieldTypeInteger",
   "alias": "LICENSEDGVW",
   "domain": null
  },
  {
   "name": "ACQUIREDATE",
   "type": "esriFieldTypeDate",
   "alias": "ACQUIREDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ASSETSTATUS",
   "type": "esriFieldTypeString",
   "alias": "ASSETSTATUS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Ass_AssetStatus",
    "description": "",
    "codedValues": [
     {
      "name": "In Service",
      "code": "IN SERVICE"
     },
     {
      "name": "Out of Service",
      "code": "OUT OF SERVICE"
     },
     {
      "name": "Disposed",
      "code": "DISPOSED"
     },
     {
      "name": "Not Applicable",
      "code": "N/A"
     },
     {
      "name": "Merge",
      "code": "MERGE"
     },
     {
      "name": "Preliminary",
      "code": "PRELIMINARY"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "ACQUIRECOST",
   "type": "esriFieldTypeInteger",
   "alias": "ACQUIRECOST",
   "domain": null
  },
  {
   "name": "DEPARTMENT",
   "type": "esriFieldTypeString",
   "alias": "DEPARTMENT",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Flt_Department",
    "description": "",
    "codedValues": [
     {
      "name": "City Administration",
      "code": "CITY ADMINISTRATION"
     },
     {
      "name": "Civic Operations",
      "code": "CIVIC OPERATIONS"
     },
     {
      "name": "Community & Protective Services",
      "code": "COMMUNITY & PROTECTIVE SERVICES"
     },
     {
      "name": "Corporate Services",
      "code": "CORPORATE SERVICES"
     },
     {
      "name": "Development, Engineering & Sustainability",
      "code": "DEVELOPMENT, ENGINEERING & SUSTAINABILITY"
     },
     {
      "name": "Human Resources & Safety",
      "code": "HUMAN RESOURCES & SAFETY"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DIVISION",
   "type": "esriFieldTypeString",
   "alias": "DIVISION",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Flt_Division",
    "description": "",
    "codedValues": [
     {
      "name": "Administration",
      "code": "ADMINISTRATION"
     },
     {
      "name": "Capital Projects",
      "code": "CAPITAL PROJECTS"
     },
     {
      "name": "Community Services",
      "code": "COMMUNITY SERVICES"
     },
     {
      "name": "Engineering",
      "code": "ENGINEERING"
     },
     {
      "name": "Fleet",
      "code": "FLEET"
     },
     {
      "name": "Information Technology",
      "code": "INFORMATION TECHNOLOGY"
     },
     {
      "name": "KFR",
      "code": "KFR"
     },
     {
      "name": "Parks & Civic Facilities",
      "code": "PARKS & CIVIC FACILITIES"
     },
     {
      "name": "Planning & Development",
      "code": "PLANNING & DEVELOPMENT"
     },
     {
      "name": "Planning & Procurement",
      "code": "PLANNING & PROCUREMENT"
     },
     {
      "name": "RCMP Support Services",
      "code": "RCMP SUPPORT SERVICES"
     },
     {
      "name": "Safety",
      "code": "SAFETY"
     },
     {
      "name": "Streets & Environment",
      "code": "STREETS & ENVIRONMENT"
     },
     {
      "name": "Sustainability",
      "code": "SUSTAINABILITY"
     },
     {
      "name": "Trades",
      "code": "TRADES"
     },
     {
      "name": "Transportation",
      "code": "TRANSPORTATION"
     },
     {
      "name": "Utility Services",
      "code": "UTILITY SERVICES"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     },
     {
      "name": "Building & Engineering Development",
      "code": "BUILDING & ENGINEERING DEVELOPMENT"
     },
     {
      "name": "Civic Construction",
      "code": "CIVIC CONSTRUCTION"
     },
     {
      "name": "Protective Services",
      "code": "PROTECTIVE SERVICES"
     },
     {
      "name": "Community and Culture",
      "code": "COMMUNITY AND CULTURE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SUBDIVISION",
   "type": "esriFieldTypeString",
   "alias": "SUBDIVISION",
   "length": 60,
   "domain": {
    "type": "codedValue",
    "name": "Flt_Subdivision",
    "description": "",
    "codedValues": [
     {
      "name": "Arenas",
      "code": "ARENAS"
     },
     {
      "name": "Building Inspection",
      "code": "BUILDING INSPECTION"
     },
     {
      "name": "Carpentry",
      "code": "CARPENTRY"
     },
     {
      "name": "Cemetery",
      "code": "CEMETERY"
     },
     {
      "name": "Construction",
      "code": "CONSTRUCTION"
     },
     {
      "name": "Courier",
      "code": "COURIER"
     },
     {
      "name": "Electrical",
      "code": "ELECTRICAL"
     },
     {
      "name": "Engineering Development",
      "code": "ENGINEERING DEVELOPMENT"
     },
     {
      "name": "Environmental Services",
      "code": "ENVIRONMENTAL SERVICES"
     },
     {
      "name": "Facilities",
      "code": "FACILITIES"
     },
     {
      "name": "Generators",
      "code": "GENERATORS"
     },
     {
      "name": "Horticulture",
      "code": "HORTICULTURE"
     },
     {
      "name": "HVAC",
      "code": "HVAC"
     },
     {
      "name": "Inspection",
      "code": "INSPECTION"
     },
     {
      "name": "Irrigation",
      "code": "IRRIGATION"
     },
     {
      "name": "Maintenance",
      "code": "MAINTENANCE"
     },
     {
      "name": "Mechanical Loaner",
      "code": "MECHANICAL LOANER"
     },
     {
      "name": "Millwrights",
      "code": "MILLWRIGHTS"
     },
     {
      "name": "Natural Resources",
      "code": "NATURAL RESOURCES"
     },
     {
      "name": "Operations",
      "code": "OPERATIONS"
     },
     {
      "name": "Plumbing",
      "code": "PLUMBING"
     },
     {
      "name": "Pool Vehicles",
      "code": "POOL VEHICLES"
     },
     {
      "name": "Pools",
      "code": "POOLS"
     },
     {
      "name": "Sign Shop",
      "code": "SIGN SHOP"
     },
     {
      "name": "Solid Waste",
      "code": "SOLID WASTE"
     },
     {
      "name": "Stores",
      "code": "STORES"
     },
     {
      "name": "Streets",
      "code": "STREETS"
     },
     {
      "name": "Surveyor",
      "code": "SURVEYOR"
     },
     {
      "name": "Treatment",
      "code": "TREATMENT"
     },
     {
      "name": "Treatment - Waste Water",
      "code": "TREATMENT - WASTE WATER"
     },
     {
      "name": "Treatment - Water",
      "code": "TREATMENT - WATER"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     },
     {
      "name": "Water Pump Stations",
      "code": "WATER PUMP STATIONS"
     },
     {
      "name": "Sanitary Pump Stations",
      "code": "SANITARY PUMP STATIONS"
     },
     {
      "name": "Sanitary Waste Water Treatment",
      "code": "SANITARY WASTEWATER TREATMENT"
     },
     {
      "name": "Aboriculture",
      "code": "ABORICULTURE"
     },
     {
      "name": "Fire Hall 1",
      "code": "FIRE HALL 1"
     },
     {
      "name": "Fire Hall 2",
      "code": "FIRE HALL 2"
     },
     {
      "name": "Fire Hall 3",
      "code": "FIRE HALL 3"
     },
     {
      "name": "Fire Hall 4",
      "code": "FIRE HALL 4"
     },
     {
      "name": "Fire Hall 5",
      "code": "FIRE HALL 5"
     },
     {
      "name": "Fire Hall 6",
      "code": "FIRE HALL 6"
     },
     {
      "name": "Fire Hall 7",
      "code": "FIRE HALL 7"
     },
     {
      "name": "Fire Training Centre",
      "code": "FIRE TRAINING CENTRE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 50,
   "domain": null
  },
  {
   "name": "ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS",
   "length": 50,
   "domain": null
  },
  {
   "name": "WARRANTYDATE",
   "type": "esriFieldTypeDate",
   "alias": "WARRANTYDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "WARRANTYODOMETERHRS",
   "type": "esriFieldTypeInteger",
   "alias": "WARRANTYODOMETERHRS",
   "domain": null
  },
  {
   "name": "WARRANTYNOTES",
   "type": "esriFieldTypeString",
   "alias": "WARRANTYNOTES",
   "length": 255,
   "domain": null
  },
  {
   "name": "CONDITION",
   "type": "esriFieldTypeString",
   "alias": "CONDITION",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Flt_Condition",
    "description": "",
    "codedValues": [
     {
      "name": "Good",
      "code": "1"
     },
     {
      "name": "Satisfactory",
      "code": "2"
     },
     {
      "name": "Fair",
      "code": "3"
     },
     {
      "name": "Poor",
      "code": "4"
     },
     {
      "name": "Critical",
      "code": "5"
     },
     {
      "name": "Unknown",
      "code": "6"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CONDITIONDATE",
   "type": "esriFieldTypeDate",
   "alias": "CONDITIONDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "CONDITIONCOMMENT",
   "type": "esriFieldTypeString",
   "alias": "CONDITIONCOMMENT",
   "length": 255,
   "domain": null
  },
  {
   "name": "SECURELINK",
   "type": "esriFieldTypeString",
   "alias": "SECURELINK",
   "length": 255,
   "domain": null
  },
  {
   "name": "DOCUMENTATIONLINK",
   "type": "esriFieldTypeString",
   "alias": "DOCUMENTATIONLINK",
   "length": 255,
   "domain": null
  },
  {
   "name": "ODOMETER",
   "type": "esriFieldTypeInteger",
   "alias": "ODOMETER",
   "domain": null
  },
  {
   "name": "HOURSMETER",
   "type": "esriFieldTypeInteger",
   "alias": "HOURSMETER",
   "domain": null
  },
  {
   "name": "AGE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "AGE",
   "domain": null
  },
  {
   "name": "USEFULLIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "USEFULLIFE",
   "domain": null
  },
  {
   "name": "REMAININGLIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "REMAININGLIFE",
   "domain": null
  },
  {
   "name": "DISPOSALDATE",
   "type": "esriFieldTypeDate",
   "alias": "DISPOSALDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "DISPOSALVALUE",
   "type": "esriFieldTypeInteger",
   "alias": "DISPOSALVALUE",
   "domain": null
  },
  {
   "name": "CRC",
   "type": "esriFieldTypeInteger",
   "alias": "CRC",
   "domain": null
  },
  {
   "name": "DEPRECIATIONLIFE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "DEPRECIATIONLIFE",
   "domain": {
    "type": "codedValue",
    "name": "Flt_DepreciationLife",
    "description": "",
    "codedValues": [
     {
      "name": "2",
      "code": 2
     },
     {
      "name": "3",
      "code": 3
     },
     {
      "name": "4",
      "code": 4
     },
     {
      "name": "5",
      "code": 5
     },
     {
      "name": "6",
      "code": 6
     },
     {
      "name": "8",
      "code": 8
     },
     {
      "name": "10",
      "code": 10
     },
     {
      "name": "15",
      "code": 15
     },
     {
      "name": "20",
      "code": 20
     },
     {
      "name": "25",
      "code": 25
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "REPLACEMENTYEAR",
   "type": "esriFieldTypeSmallInteger",
   "alias": "REPLACEMENTYEAR",
   "domain": null
  },
  {
   "name": "CURRENTREPLACEMENTCOST",
   "type": "esriFieldTypeInteger",
   "alias": "CURRENTREPLACEMENTCOST",
   "domain": null
  },
  {
   "name": "SEASONFLAG",
   "type": "esriFieldTypeString",
   "alias": "SEASONFLAG",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Flt_SeasonFlag ",
    "description": "",
    "codedValues": [
     {
      "name": "Summer",
      "code": "SUMMER"
     },
     {
      "name": "Winter",
      "code": "WINTER"
     },
     {
      "name": "Unknown",
      "code": "UNKNOWN"
     },
     {
      "name": "Not Applicable",
      "code": "NOT APPLICABLE"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RATEGROUP",
   "type": "esriFieldTypeString",
   "alias": "RateGroup",
   "length": 120,
   "domain": null
  },
  {
   "name": "MONTHLYRATE",
   "type": "esriFieldTypeInteger",
   "alias": "MonthlyRate",
   "domain": null
  },
  {
   "name": "BUSINESSUNIT",
   "type": "esriFieldTypeString",
   "alias": "Business Unit",
   "length": 15,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R2177_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "4db373c9dff64965b529c616a48b21be"
}