{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 5,
 "name": "GIS.GISADMIN.finFLEET",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "FLEETID",
 "typeIdField": "SUBTYPE",
 "subtypeFieldName": "SUBTYPE",
 "subtypeField": "SUBTYPE",
 "defaultSubtypeCode": 1,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "EQUIPFUNCTION",
   "type": "esriFieldTypeString",
   "alias": "Equipment Function",
   "length": 250,
   "domain": null
  },
  {
   "name": "REPLACEYR",
   "type": "esriFieldTypeString",
   "alias": "Replacement Year",
   "length": 4,
   "domain": null
  },
  {
   "name": "FLEETID",
   "type": "esriFieldTypeString",
   "alias": "FLEETID",
   "length": 20,
   "domain": null
  },
  {
   "name": "DEPTNO",
   "type": "esriFieldTypeString",
   "alias": "DEPTNO",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "d_finDeptNoOnly",
    "description": "",
    "codedValues": [
     {
      "name": "1000",
      "code": "1000"
     },
     {
      "name": "1100",
      "code": "1100"
     },
     {
      "name": "2110",
      "code": "2110"
     },
     {
      "name": "2113",
      "code": "2113"
     },
     {
      "name": "2130",
      "code": "2130"
     },
     {
      "name": "3100",
      "code": "3100"
     },
     {
      "name": "3200",
      "code": "3200"
     },
     {
      "name": "4000",
      "code": "4000"
     },
     {
      "name": "5000",
      "code": "5000"
     },
     {
      "name": "5500",
      "code": "5500"
     },
     {
      "name": "6210",
      "code": "6210"
     },
     {
      "name": "6230",
      "code": "6230"
     },
     {
      "name": "6300",
      "code": "6300"
     },
     {
      "name": "6410",
      "code": "6410"
     },
     {
      "name": "6420",
      "code": "6420"
     },
     {
      "name": "6430",
      "code": "6430"
     },
     {
      "name": "6441",
      "code": "6441"
     },
     {
      "name": "6445",
      "code": "6445"
     },
     {
      "name": "6510",
      "code": "6510"
     },
     {
      "name": "6521",
      "code": "6521"
     },
     {
      "name": "6522",
      "code": "6522"
     },
     {
      "name": "6621",
      "code": "6621"
     },
     {
      "name": "6622",
      "code": "6622"
     },
     {
      "name": "6710",
      "code": "6710"
     },
     {
      "name": "6720",
      "code": "6720"
     },
     {
      "name": "7100",
      "code": "7100"
     },
     {
      "name": "8200",
      "code": "8200"
     },
     {
      "name": "8300",
      "code": "8300"
     },
     {
      "name": "8120",
      "code": "8120"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ACCT",
   "type": "esriFieldTypeString",
   "alias": "ACCT",
   "length": 20,
   "domain": null
  },
  {
   "name": "DEPTNAME",
   "type": "esriFieldTypeString",
   "alias": "DEPTNAME",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "d_DeptNoTxt",
    "description": "Finance Dept Nos",
    "codedValues": [
     {
      "name": "Planning",
      "code": "1000"
     },
     {
      "name": "Legislation",
      "code": "1100"
     },
     {
      "name": "Manager Administration",
      "code": "2110"
     },
     {
      "name": "Economic Development",
      "code": "2113"
     },
     {
      "name": "Service",
      "code": "2130"
     },
     {
      "name": "Finance",
      "code": "3100"
     },
     {
      "name": "Tax",
      "code": "3200"
     },
     {
      "name": "Law",
      "code": "4000"
     },
     {
      "name": "Municipal Court",
      "code": "5000"
     },
     {
      "name": "Probation",
      "code": "5500"
     },
     {
      "name": "Parks",
      "code": "6210"
     },
     {
      "name": "Cemetery",
      "code": "6230"
     },
     {
      "name": "Street",
      "code": "6300"
     },
     {
      "name": "Electric Administration",
      "code": "6410"
     },
     {
      "name": "Electric Meter Reading",
      "code": "6420"
     },
     {
      "name": "Electric Operations",
      "code": "6430"
     },
     {
      "name": "Electric Production",
      "code": "6441"
     },
     {
      "name": "Telecommunication",
      "code": "6445"
     },
     {
      "name": "Water Administration",
      "code": "6510"
     },
     {
      "name": "Water System Maintenance",
      "code": "6521"
     },
     {
      "name": "Water Treatment",
      "code": "6522"
     },
     {
      "name": "Auto Maintenance",
      "code": "6710"
     },
     {
      "name": "Construction & Maintenance",
      "code": "6720"
     },
     {
      "name": "Engineering",
      "code": "7100"
     },
     {
      "name": "Police Department",
      "code": "8200"
     },
     {
      "name": "Information Technology",
      "code": "8300"
     },
     {
      "name": "Sewer System Maintenance",
      "code": "6622"
     },
     {
      "name": "Wastewater System Maintenance",
      "code": "6621"
     },
     {
      "name": "Fire Department",
      "code": "8120"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LOCATION",
   "type": "esriFieldTypeString",
   "alias": "LOCATION",
   "length": 50,
   "domain": null
  },
  {
   "name": "MODYR",
   "type": "esriFieldTypeString",
   "alias": "MODYR",
   "length": 4,
   "domain": null
  },
  {
   "name": "MAKE",
   "type": "esriFieldTypeString",
   "alias": "MAKE",
   "length": 50,
   "domain": null
  },
  {
   "name": "MODEL",
   "type": "esriFieldTypeString",
   "alias": "MODEL",
   "length": 50,
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "COMMENTS",
   "length": 250,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "SUBTYPE",
   "type": "esriFieldTypeInteger",
   "alias": "SUBTYPE",
   "domain": null
  },
  {
   "name": "REL_GLOBALID",
   "type": "esriFieldTypeGUID",
   "alias": "REL_GLOBALID",
   "length": 38,
   "domain": null
  },
  {
   "name": "DUPKEY",
   "type": "esriFieldTypeString",
   "alias": "DUPKEY",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Yes or No",
    "description": "Yes or No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ACQDATE",
   "type": "esriFieldTypeDate",
   "alias": "ACQDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "RETDATE",
   "type": "esriFieldTypeDate",
   "alias": "RETDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "FUELCARD",
   "type": "esriFieldTypeString",
   "alias": "FUELCARD",
   "length": 5,
   "domain": null
  },
  {
   "name": "FUELTYPE",
   "type": "esriFieldTypeString",
   "alias": "FUELTYPE",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "d_finFuelType",
    "description": "",
    "codedValues": [
     {
      "name": "Gas",
      "code": "G"
     },
     {
      "name": "Diesel",
      "code": "D"
     },
     {
      "name": "Both",
      "code": "B"
     },
     {
      "name": "None",
      "code": "N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "INSURED",
   "type": "esriFieldTypeString",
   "alias": "INSURED",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "Yes or No",
    "description": "Yes or No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LPLATE",
   "type": "esriFieldTypeString",
   "alias": "LPLATE",
   "length": 10,
   "domain": null
  },
  {
   "name": "PURCHPRICE",
   "type": "esriFieldTypeDouble",
   "alias": "PURCHPRICE",
   "domain": null
  },
  {
   "name": "FEMACODE",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Fema Code",
   "domain": null
  },
  {
   "name": "FEMACOST",
   "type": "esriFieldTypeDouble",
   "alias": "Fema Cost",
   "domain": null
  },
  {
   "name": "UNITCOST",
   "type": "esriFieldTypeDouble",
   "alias": "Unit City Cost",
   "domain": null
  },
  {
   "name": "HOURS",
   "type": "esriFieldTypeString",
   "alias": "HOURS",
   "length": 10,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R14881_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_14881",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_20524_REL_GL",
   "fields": "REL_GLOBALID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_14881",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "types": [
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "id": 1,
   "name": "Dump Truck"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "id": 2,
   "name": "Equipment"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "id": 3,
   "name": "Fire"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "id": 4,
   "name": "Passenger"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "id": 5,
   "name": "Rescue/Ambulance"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "id": 6,
   "name": "Trucks/Vans"
  }
 ],
 "subtypes": [
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "defaultValues": {
    "FLEETID": null,
    "VIN": null,
    "FUND": null,
    "DEPTNO": null,
    "ACCT": null,
    "DEPTNAME": null,
    "LOCATION": null,
    "MODYR": null,
    "MAKE": null,
    "MODEL": null,
    "COND": null,
    "MILEAGE": null,
    "COMMENTS": null,
    "GlobalID": null,
    "created_user": null,
    "created_date": null,
    "last_edited_user": null,
    "last_edited_date": null,
    "SUBTYPE": null,
    "EQUIPFUNCTION": null,
    "REPLACEYR": null,
    "SOLDTRADEVALUE": null,
    "SOLDTRADEDATE": null,
    "REL_GLOBALID": null,
    "DUPKEY": "No",
    "ACQDATE": null,
    "RETDATE": null,
    "FUELCARD": "0000",
    "FUELTYPE": "D",
    "INSURED": "No",
    "LPLATE": null,
    "PURCHPRICE": null,
    "FEMACODE": null,
    "FEMACOST": null,
    "UNITCOST": null,
    "HOURS": null
   },
   "code": 1,
   "name": "Dump Truck"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "defaultValues": {
    "FLEETID": null,
    "VIN": null,
    "FUND": null,
    "DEPTNO": null,
    "ACCT": null,
    "DEPTNAME": null,
    "LOCATION": null,
    "MODYR": null,
    "MAKE": null,
    "MODEL": null,
    "COND": null,
    "MILEAGE": null,
    "COMMENTS": null,
    "GlobalID": null,
    "created_user": null,
    "created_date": null,
    "last_edited_user": null,
    "last_edited_date": null,
    "SUBTYPE": null,
    "EQUIPFUNCTION": null,
    "REPLACEYR": null,
    "SOLDTRADEVALUE": null,
    "SOLDTRADEDATE": null,
    "REL_GLOBALID": null,
    "DUPKEY": "No",
    "ACQDATE": null,
    "RETDATE": null,
    "FUELCARD": "0000",
    "FUELTYPE": "N",
    "INSURED": "No",
    "LPLATE": null,
    "PURCHPRICE": null,
    "FEMACODE": null,
    "FEMACOST": null,
    "UNITCOST": null,
    "HOURS": null
   },
   "code": 2,
   "name": "Equipment"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "defaultValues": {
    "FLEETID": null,
    "VIN": null,
    "FUND": "213",
    "DEPTNO": "8120",
    "ACCT": "213-8120",
    "DEPTNAME": "8120",
    "LOCATION": null,
    "MODYR": null,
    "MAKE": null,
    "MODEL": null,
    "COND": null,
    "MILEAGE": null,
    "COMMENTS": null,
    "GlobalID": null,
    "created_user": null,
    "created_date": null,
    "last_edited_user": null,
    "last_edited_date": null,
    "SUBTYPE": null,
    "EQUIPFUNCTION": null,
    "REPLACEYR": null,
    "SOLDTRADEVALUE": null,
    "SOLDTRADEDATE": null,
    "REL_GLOBALID": null,
    "DUPKEY": "No",
    "ACQDATE": null,
    "RETDATE": null,
    "FUELCARD": "0000",
    "FUELTYPE": "N",
    "INSURED": "No",
    "LPLATE": null,
    "PURCHPRICE": null,
    "FEMACODE": null,
    "FEMACOST": null,
    "UNITCOST": null,
    "HOURS": null
   },
   "code": 3,
   "name": "Fire"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "defaultValues": {
    "FLEETID": null,
    "VIN": null,
    "FUND": null,
    "DEPTNO": null,
    "ACCT": null,
    "DEPTNAME": null,
    "LOCATION": null,
    "MODYR": null,
    "MAKE": null,
    "MODEL": null,
    "COND": null,
    "MILEAGE": null,
    "COMMENTS": null,
    "GlobalID": null,
    "created_user": null,
    "created_date": null,
    "last_edited_user": null,
    "last_edited_date": null,
    "SUBTYPE": null,
    "EQUIPFUNCTION": null,
    "REPLACEYR": null,
    "SOLDTRADEVALUE": null,
    "SOLDTRADEDATE": null,
    "REL_GLOBALID": null,
    "DUPKEY": "No",
    "ACQDATE": null,
    "RETDATE": null,
    "FUELCARD": "0000",
    "FUELTYPE": "G",
    "INSURED": "No",
    "LPLATE": null,
    "PURCHPRICE": null,
    "FEMACODE": null,
    "FEMACOST": null,
    "UNITCOST": null,
    "HOURS": null
   },
   "code": 4,
   "name": "Passenger"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "defaultValues": {
    "FLEETID": null,
    "VIN": null,
    "FUND": "213",
    "DEPTNO": "8120",
    "ACCT": "213-8120",
    "DEPTNAME": "8120",
    "LOCATION": null,
    "MODYR": null,
    "MAKE": null,
    "MODEL": null,
    "COND": null,
    "MILEAGE": null,
    "COMMENTS": null,
    "GlobalID": null,
    "created_user": null,
    "created_date": null,
    "last_edited_user": null,
    "last_edited_date": null,
    "SUBTYPE": null,
    "EQUIPFUNCTION": null,
    "REPLACEYR": null,
    "SOLDTRADEVALUE": null,
    "SOLDTRADEDATE": null,
    "REL_GLOBALID": null,
    "DUPKEY": "No",
    "ACQDATE": null,
    "RETDATE": null,
    "FUELCARD": "0000",
    "FUELTYPE": "N",
    "INSURED": "No",
    "LPLATE": null,
    "PURCHPRICE": null,
    "FEMACODE": null,
    "FEMACOST": null,
    "UNITCOST": null,
    "HOURS": null
   },
   "code": 5,
   "name": "Rescue/Ambulance"
  },
  {
   "domains": {
    "FUND": {"type": "inherited"},
    "DEPTNO": {"type": "inherited"},
    "DEPTNAME": {"type": "inherited"},
    "COND": {"type": "inherited"},
    "DUPKEY": {"type": "inherited"},
    "FUELTYPE": {"type": "inherited"},
    "INSURED": {"type": "inherited"}
   },
   "defaultValues": {
    "FLEETID": null,
    "VIN": null,
    "FUND": null,
    "DEPTNO": null,
    "ACCT": null,
    "DEPTNAME": null,
    "LOCATION": null,
    "MODYR": null,
    "MAKE": null,
    "MODEL": null,
    "COND": null,
    "MILEAGE": null,
    "COMMENTS": null,
    "GlobalID": null,
    "created_user": null,
    "created_date": null,
    "last_edited_user": null,
    "last_edited_date": null,
    "SUBTYPE": null,
    "EQUIPFUNCTION": null,
    "REPLACEYR": null,
    "SOLDTRADEVALUE": null,
    "SOLDTRADEDATE": null,
    "REL_GLOBALID": null,
    "DUPKEY": "No",
    "ACQDATE": null,
    "RETDATE": null,
    "FUELCARD": "0000",
    "FUELTYPE": "N",
    "INSURED": "No",
    "LPLATE": null,
    "PURCHPRICE": null,
    "FEMACODE": null,
    "FEMACOST": null,
    "UNITCOST": null,
    "HOURS": null
   },
   "code": 6,
   "name": "Trucks/Vans"
  }
 ],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 10000,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}