{
 "currentVersion": 10.91,
 "id": 1,
 "name": "flFleet",
 "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": 20,
   "domain": null
  },
  {
   "name": "FEATURETYPE",
   "type": "esriFieldTypeString",
   "alias": "VEHICLECLASS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "flFleetType",
    "description": "Fleet asset type",
    "codedValues": [
     {
      "name": "Boat",
      "code": "Boat"
     },
     {
      "name": "Boat Engine",
      "code": "Boat Engine"
     },
     {
      "name": "Bus",
      "code": "Bus"
     },
     {
      "name": "Fire Apparatus",
      "code": "Fire Apparatus"
     },
     {
      "name": "Fire Rescue",
      "code": "Fire Rescue"
     },
     {
      "name": "Fire Truck",
      "code": "Fire Truck"
     },
     {
      "name": "Forklift",
      "code": "Forklift"
     },
     {
      "name": "Heavy Duty Truck",
      "code": "Heavy Duty Truck"
     },
     {
      "name": "Heavy Equipment",
      "code": "Heavy Equipment"
     },
     {
      "name": "Misc Equipment",
      "code": "Misc Equipment"
     },
     {
      "name": "Mower",
      "code": "Mower"
     },
     {
      "name": "Passenger Car",
      "code": "Passenger Car"
     },
     {
      "name": "Pickup Truck",
      "code": "Pickup Truck"
     },
     {
      "name": "Police Sedan",
      "code": "Police Sedan"
     },
     {
      "name": "Small Tractor",
      "code": "Small Tractor"
     },
     {
      "name": "SUV",
      "code": "SUV"
     },
     {
      "name": "Trailer",
      "code": "Trailer"
     },
     {
      "name": "Utility Vehicle",
      "code": "Utility Vehicle"
     },
     {
      "name": "Van",
      "code": "Van"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FEATURESTATUS",
   "type": "esriFieldTypeString",
   "alias": "FEATURESTATUS",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "flFltStatus",
    "description": "Fleet asset status",
    "codedValues": [
     {
      "name": "Active",
      "code": "Active"
     },
     {
      "name": "Active- NIF",
      "code": "Active- NIF"
     },
     {
      "name": "Sold",
      "code": "Sold"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "EQDESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "EQDESCRIPTION",
   "length": 100,
   "domain": null
  },
  {
   "name": "VEHICLE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "VEHICLE",
   "domain": {
    "type": "codedValue",
    "name": "EnabledDomain",
    "description": "",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "VEHICLECLASS",
   "type": "esriFieldTypeString",
   "alias": "VEHICLECLASS",
   "length": 50,
   "domain": null
  },
  {
   "name": "FINANCESTATUS",
   "type": "esriFieldTypeString",
   "alias": "FINANCESTATUS",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "flFinanceStatus",
    "description": "Two letter code for finance",
    "codedValues": [
     {
      "name": "E",
      "code": "E"
     },
     {
      "name": "ER",
      "code": "ER"
     },
     {
      "name": "EX",
      "code": "EX"
     },
     {
      "name": "V",
      "code": "V"
     },
     {
      "name": "VR",
      "code": "VR"
     },
     {
      "name": "VX",
      "code": "VX"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DEPARTMENT",
   "type": "esriFieldTypeString",
   "alias": "DEPARTMENT",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "flDepartmentUse",
    "description": "Department which uses equipment",
    "codedValues": [
     {
      "name": "ROW Team",
      "code": "ROW Team"
     },
     {
      "name": "Water Utility",
      "code": "Water Utility"
     },
     {
      "name": "Sewer Utility",
      "code": "Sewer Utility"
     },
     {
      "name": "Storm Utility",
      "code": "Storm Utility"
     },
     {
      "name": "Parks Maintenance",
      "code": "Parks Maintenance"
     },
     {
      "name": "Parks and Recreation",
      "code": "Parks and Recreation"
     },
     {
      "name": "Police Department",
      "code": "Police Department"
     },
     {
      "name": "Marine Patrol",
      "code": "Marine Patrol"
     },
     {
      "name": "Fire Department",
      "code": "Fire Department"
     },
     {
      "name": "Finance",
      "code": "Finance"
     },
     {
      "name": "Youth & Family Services",
      "code": "Youth & Family Services"
     },
     {
      "name": "General Fund",
      "code": "General Fund"
     },
     {
      "name": "Support Services",
      "code": "Support Services"
     },
     {
      "name": "Community Planning & Development",
      "code": "Community Planning & Development"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "EMPLOYEE",
   "type": "esriFieldTypeString",
   "alias": "EMPLOYEE",
   "length": 100,
   "domain": null
  },
  {
   "name": "MANUFACTURER",
   "type": "esriFieldTypeString",
   "alias": "MANUFACTURER",
   "length": 25,
   "domain": null
  },
  {
   "name": "LICENSEPLATENO",
   "type": "esriFieldTypeString",
   "alias": "LICENSEPLATENO",
   "length": 50,
   "domain": null
  },
  {
   "name": "MODELNUM",
   "type": "esriFieldTypeString",
   "alias": "MODELNUM",
   "length": 50,
   "domain": null
  },
  {
   "name": "VEHICLEYEAR",
   "type": "esriFieldTypeString",
   "alias": "VEHICLEYEAR",
   "length": 15,
   "domain": null
  },
  {
   "name": "DRIVETRAIN",
   "type": "esriFieldTypeString",
   "alias": "DRIVETRAIN",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "flDriveTrain",
    "description": "Type of vehicle drive train",
    "codedValues": [
     {
      "name": "4x4",
      "code": "4x4"
     },
     {
      "name": "All Wheel Drive (AWD)",
      "code": "All Wheel Drive (AWD)"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "2x4",
      "code": "2x4"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SERIALVIN",
   "type": "esriFieldTypeString",
   "alias": "SERIALVIN",
   "length": 25,
   "domain": null
  },
  {
   "name": "FUELTYPE",
   "type": "esriFieldTypeString",
   "alias": "FUELTYPE",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "flFuel",
    "description": "Type of fuel used",
    "codedValues": [
     {
      "name": "Unleaded",
      "code": "Unleaded"
     },
     {
      "name": "Diesel",
      "code": "Diesel"
     },
     {
      "name": "Natural Gas",
      "code": "Natural Gas"
     },
     {
      "name": "Marine",
      "code": "Marine"
     },
     {
      "name": "Electric",
      "code": "Electric"
     },
     {
      "name": "Hybrid",
      "code": "Hybrid"
     },
     {
      "name": "Propane",
      "code": "Propane"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "NA",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CHIPKEYNO",
   "type": "esriFieldTypeString",
   "alias": "CHIPKEYNO",
   "length": 30,
   "domain": null
  },
  {
   "name": "CHIPKEYPIN",
   "type": "esriFieldTypeString",
   "alias": "CHIPKEYPIN",
   "length": 30,
   "domain": null
  },
  {
   "name": "METERREADING",
   "type": "esriFieldTypeDouble",
   "alias": "METERREADING",
   "domain": null
  },
  {
   "name": "METERUNIT",
   "type": "esriFieldTypeString",
   "alias": "METERUNIT",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "flMeterUnit",
    "description": "Meter units of measure",
    "codedValues": [
     {
      "name": "Miles",
      "code": "Miles"
     },
     {
      "name": "Hours",
      "code": "Hours"
     },
     {
      "name": "NA",
      "code": "NA"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FUELSYSTEMMETERREAD",
   "type": "esriFieldTypeDouble",
   "alias": "FUELSYSTEMMETERREAD",
   "domain": null
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 255,
   "domain": null
  },
  {
   "name": "PURCHASEDATE",
   "type": "esriFieldTypeDate",
   "alias": "RECEIVEDDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "PURCHASEORDER",
   "type": "esriFieldTypeString",
   "alias": "PURCHASEORDER",
   "length": 25,
   "domain": null
  },
  {
   "name": "PURCHASEPRICE",
   "type": "esriFieldTypeDouble",
   "alias": "PURCHASEPRICE",
   "domain": null
  },
  {
   "name": "PURCHASEPRICEEQUIP",
   "type": "esriFieldTypeString",
   "alias": "PURCHASEPRICEEQUIP",
   "length": 25,
   "domain": null
  },
  {
   "name": "DRACCOUNT",
   "type": "esriFieldTypeString",
   "alias": "DRACCOUNT",
   "length": 20,
   "domain": null
  },
  {
   "name": "VENDOR",
   "type": "esriFieldTypeString",
   "alias": "VENDOR",
   "length": 100,
   "domain": null
  },
  {
   "name": "TOTALCOSTOFVEHICLE",
   "type": "esriFieldTypeString",
   "alias": "TOTALCOSTOFVEHICLE",
   "length": 25,
   "domain": null
  },
  {
   "name": "USEDATE",
   "type": "esriFieldTypeDate",
   "alias": "USEDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "SOLDDATE",
   "type": "esriFieldTypeDate",
   "alias": "SOLDDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "SOLDPRICE",
   "type": "esriFieldTypeString",
   "alias": "SOLDPRICE",
   "length": 20,
   "domain": null
  },
  {
   "name": "VEHICLEREPLACED",
   "type": "esriFieldTypeString",
   "alias": "VEHICLEREPLACED",
   "length": 25,
   "domain": null
  },
  {
   "name": "DATEREPLACED",
   "type": "esriFieldTypeDate",
   "alias": "DATEREPLACED",
   "length": 8,
   "domain": null
  },
  {
   "name": "ESTIMATEREPLYEAR",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ESTIMATEREPLYEAR",
   "domain": null
  },
  {
   "name": "ACTUALREPLYEAR",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ACTUALREPLYEAR",
   "domain": null
  },
  {
   "name": "DEPRECIATIONVALUE",
   "type": "esriFieldTypeString",
   "alias": "DEPRECIATIONVALUE",
   "length": 50,
   "domain": null
  },
  {
   "name": "CHARGERATE",
   "type": "esriFieldTypeDouble",
   "alias": "CHARGERATE",
   "domain": null
  },
  {
   "name": "LIFEEXPECTANCY",
   "type": "esriFieldTypeSmallInteger",
   "alias": "LIFEEXPECTANCY",
   "domain": null
  },
  {
   "name": "FINANCERATECLASS",
   "type": "esriFieldTypeString",
   "alias": "FINANCERATECLASS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "flWebworkClass",
    "description": "Outdated vehicle classes from Webwork",
    "codedValues": [
     {
      "name": "010- Class 1: Passenger Cars",
      "code": "010- Class 1: Passenger Cars"
     },
     {
      "name": "011- Class 1: Passenger Vans",
      "code": "011- Class 1: Passenger Vans"
     },
     {
      "name": "012- Class 1: Passenger SUVs",
      "code": "012- Class 1: Passenger SUVs"
     },
     {
      "name": "013- Class 1: Passenger HOVs",
      "code": "013- Class 1: Passenger HOVs"
     },
     {
      "name": "210- Rate Classification: Police Sedan",
      "code": "210- Rate Classification: Police Sedan"
     },
     {
      "name": "540- Rate Classification: Sweeper",
      "code": "540- Rate Classification: Sweeper"
     },
     {
      "name": "340- Rate Classification: 1T Truck",
      "code": "340- Rate Classification: 1T Truck"
     },
     {
      "name": "341- Rate Classification: 1T Truck 4x4",
      "code": "341- Rate Classification: 1T Truck 4x4"
     },
     {
      "name": "342- Rate Classification: Boom Truck",
      "code": "342- Rate Classification: Boom Truck"
     },
     {
      "name": "810- Rate Classification: Trailer",
      "code": "810- Rate Classification: Trailer"
     },
     {
      "name": "710- Rate Classification: Fire Utility",
      "code": "710- Rate Classification: Fire Utility"
     },
     {
      "name": "120- Rate Classification: Fullsize Sedan",
      "code": "120- Rate Classification: Fullsize Sedan"
     },
     {
      "name": "021- Class 2: Pickups compact",
      "code": "021- Class 2: Pickups compact"
     },
     {
      "name": "020- Class 2: Pickups under 1 ton",
      "code": "020- Class 2: Pickups under 1 ton"
     },
     {
      "name": "130- Rate Classification: Van, 6-8 Passengers",
      "code": "130- Rate Classification: Van, 6-8 Passengers"
     },
     {
      "name": "410- Rate Classification: Large SUV",
      "code": "410- Rate Classification: Large SUV"
     },
     {
      "name": "411- Rate Classification: Medium SUV",
      "code": "411- Rate Classification: Medium SUV"
     },
     {
      "name": "531- Rate Classification: Backhoe",
      "code": "531- Rate Classification: Backhoe"
     },
     {
      "name": "530- Rate Classification: Backhoe",
      "code": "530- Rate Classification: Backhoe"
     },
     {
      "name": "312- Rate Classification: Escapes",
      "code": "312- Rate Classification: Escapes"
     },
     {
      "name": "311- Rate Classification: Hybrids",
      "code": "311- Rate Classification: Hybrids"
     },
     {
      "name": "310- Rate Classification: Compact Pickup 4x4",
      "code": "310- Rate Classification: Compact Pickup 4x4"
     },
     {
      "name": "111- Rate Classification: Midsize Sedan",
      "code": "111- Rate Classification: Midsize Sedan"
     },
     {
      "name": "110- Rate Classification: Midsize Sedan",
      "code": "110- Rate Classification: Midsize Sedan"
     },
     {
      "name": "030- Class 3: Police Sedans",
      "code": "030- Class 3: Police Sedans"
     },
     {
      "name": "050- Class 5: Misc Equipment",
      "code": "050- Class 5: Misc Equipment"
     },
     {
      "name": "520- Rate Classification: Loader",
      "code": "520- Rate Classification: Loader"
     },
     {
      "name": "360- Rate Classification: Service Truck",
      "code": "360- Rate Classification: Service Truck"
     },
     {
      "name": "300- Rate Classification: Compact Pickup",
      "code": "300- Rate Classification: Compact Pickup"
     },
     {
      "name": "040- Class 4: Fire Dept Pumper Units",
      "code": "040- Class 4: Fire Dept Pumper Units"
     },
     {
      "name": "900- Rate Classification: Miscellaneous",
      "code": "900- Rate Classification: Miscellaneous"
     },
     {
      "name": "510- Rate Classification: Grader",
      "code": "510- Rate Classification: Grader"
     },
     {
      "name": "430- Rate Classification: HOV",
      "code": "430- Rate Classification: HOV"
     },
     {
      "name": "431- Rate Classification: HOV",
      "code": "431- Rate Classification: HOV"
     },
     {
      "name": "620- Rate Classification: Marine Equipment",
      "code": "620- Rate Classification: Marine Equipment"
     },
     {
      "name": "331- Rate Classification: 3/4T Pickup 4x4",
      "code": "331- Rate Classification: 3/4T Pickup 4x4"
     },
     {
      "name": "330- Rate Classification: 3/4T Pickup",
      "code": "330- Rate Classification: 3/4T Pickup"
     },
     {
      "name": "058- Class 5: Fire Aid Units",
      "code": "058- Class 5: Fire Aid Units"
     },
     {
      "name": "054- Class 5: Heavy Trucks",
      "code": "054- Class 5: Heavy Trucks"
     },
     {
      "name": "056- Class 5: Utility Vehicles",
      "code": "056- Class 5: Utility Vehicles"
     },
     {
      "name": "057- Class 5: Marine Equipment",
      "code": "057- Class 5: Marine Equipment"
     },
     {
      "name": "051- Class 5: Heavy Equipment",
      "code": "051- Class 5: Heavy Equipment"
     },
     {
      "name": "052- Class 5: Utility Trailers",
      "code": "052- Class 5: Utility Trailers"
     },
     {
      "name": "053- Class 5: Tractor/Mowers",
      "code": "053- Class 5: Tractor/Mowers"
     },
     {
      "name": "720- Rate Classification: Fire Truck",
      "code": "720- Rate Classification: Fire Truck"
     },
     {
      "name": "721- Rate Classification: Fire Rescue",
      "code": "721- Rate Classification: Fire Rescue"
     },
     {
      "name": "551- Rate Classification: Jet Truck",
      "code": "551- Rate Classification: Jet Truck"
     },
     {
      "name": "550- Rate Classification: Hydro",
      "code": "550- Rate Classification: Hydro"
     },
     {
      "name": "320- Rate Classification: 1/2T Pickup",
      "code": "320- Rate Classification: 1/2T Pickup"
     },
     {
      "name": "321- Rate Classification: 1/2T Pickup 4x4",
      "code": "321- Rate Classification: 1/2T Pickup 4x4"
     },
     {
      "name": "140- Rate Classification: Van, 9+ Passengers",
      "code": "140- Rate Classification: Van, 9+ Passengers"
     },
     {
      "name": "612- Rate Classification: Marine Equipment",
      "code": "612- Rate Classification: Marine Equipment"
     },
     {
      "name": "610- Rate Classification: Marine Equipment",
      "code": "610- Rate Classification: Marine Equipment"
     },
     {
      "name": "611- Rate Classification: Marine Equipment",
      "code": "611- Rate Classification: Marine Equipment"
     },
     {
      "name": "352- Rate Classification: Dump Truck 7 YD",
      "code": "352- Rate Classification: Dump Truck 7 YD"
     },
     {
      "name": "351- Rate Classification: Dump Truck 4x4",
      "code": "351- Rate Classification: Dump Truck 4x4"
     },
     {
      "name": "350- Rate Classification: Dump Truck 5 YD",
      "code": "350- Rate Classification: Dump Truck 5 YD"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NAFACODE",
   "type": "esriFieldTypeString",
   "alias": "NAFACODE",
   "length": 30,
   "domain": null
  },
  {
   "name": "COF",
   "type": "esriFieldTypeSmallInteger",
   "alias": "COF",
   "domain": null
  },
  {
   "name": "POF",
   "type": "esriFieldTypeSmallInteger",
   "alias": "POF",
   "domain": null
  },
  {
   "name": "BRE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "BRE",
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 255,
   "domain": null
  },
  {
   "name": "UPDATESOURCE",
   "type": "esriFieldTypeString",
   "alias": "UPDATESOURCE",
   "length": 255,
   "domain": null
  },
  {
   "name": "UPDATEBY",
   "type": "esriFieldTypeString",
   "alias": "UPDATEBY",
   "length": 20,
   "domain": null
  },
  {
   "name": "UPDATEDATE",
   "type": "esriFieldTypeDate",
   "alias": "UPDATEDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "PHOTOLINK",
   "type": "esriFieldTypeString",
   "alias": "PHOTOLINK",
   "length": 255,
   "domain": null
  },
  {
   "name": "RECEIVEDDATE",
   "type": "esriFieldTypeDate",
   "alias": "RECEIVEDDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ASSETWEIGHT",
   "type": "esriFieldTypeInteger",
   "alias": "ASSETWEIGHT",
   "domain": null
  },
  {
   "name": "ASSETGVWR",
   "type": "esriFieldTypeString",
   "alias": "ASSETGVWR",
   "length": 100,
   "domain": null
  },
  {
   "name": "ECOLOGYBODYTYPE",
   "type": "esriFieldTypeString",
   "alias": "ECOLOGYBODYTYPE",
   "length": 255,
   "domain": null
  },
  {
   "name": "ECOLOGYWEIGHTBIN",
   "type": "esriFieldTypeString",
   "alias": "ECOLOGYWEIGHTBIN",
   "length": 255,
   "domain": null
  },
  {
   "name": "GPS",
   "type": "esriFieldTypeString",
   "alias": "GPS",
   "length": 255,
   "domain": null
  },
  {
   "name": "TOW",
   "type": "esriFieldTypeString",
   "alias": "TOW",
   "length": 255,
   "domain": null
  },
  {
   "name": "SHORTID",
   "type": "esriFieldTypeString",
   "alias": "SHORTID",
   "length": 10,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R750_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 50000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}