{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 12,
 "name": "COC_Equipment",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "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": 255,
   "domain": null
  },
  {
   "name": "CarmelID",
   "type": "esriFieldTypeString",
   "alias": "CarmelID",
   "length": 255,
   "domain": null
  },
  {
   "name": "Category",
   "type": "esriFieldTypeString",
   "alias": "Category",
   "length": 255,
   "domain": null
  },
  {
   "name": "Subcategory",
   "type": "esriFieldTypeString",
   "alias": "Subcategory",
   "length": 255,
   "domain": null
  },
  {
   "name": "UnitNumber",
   "type": "esriFieldTypeString",
   "alias": "Unit Number",
   "length": 255,
   "domain": null
  },
  {
   "name": "Year",
   "type": "esriFieldTypeInteger",
   "alias": "Year",
   "domain": null
  },
  {
   "name": "Make",
   "type": "esriFieldTypeString",
   "alias": "Make",
   "length": 255,
   "domain": null
  },
  {
   "name": "ModelDescription",
   "type": "esriFieldTypeString",
   "alias": "Model Description",
   "length": 255,
   "domain": null
  },
  {
   "name": "ModelNumber",
   "type": "esriFieldTypeString",
   "alias": "Model Number",
   "length": 255,
   "domain": null
  },
  {
   "name": "Color",
   "type": "esriFieldTypeString",
   "alias": "Color",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FleetEquip_Color",
    "description": "Color of fleet or equipment",
    "codedValues": [
     {
      "name": "Black",
      "code": "Black"
     },
     {
      "name": "Blue",
      "code": "Blue"
     },
     {
      "name": "Brown",
      "code": "Brown"
     },
     {
      "name": "Gray",
      "code": "Gray"
     },
     {
      "name": "Green",
      "code": "Green"
     },
     {
      "name": "Orange",
      "code": "Orange"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Red",
      "code": "Red"
     },
     {
      "name": "White",
      "code": "White"
     },
     {
      "name": "Yellow",
      "code": "Yellow"
     },
     {
      "name": "Purple",
      "code": "Purple"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CWEquipDesc",
   "type": "esriFieldTypeString",
   "alias": "CW Equipment Description",
   "length": 255,
   "domain": null
  },
  {
   "name": "CWEquipID",
   "type": "esriFieldTypeString",
   "alias": "CW Equipment ID",
   "length": 255,
   "domain": null
  },
  {
   "name": "Plate",
   "type": "esriFieldTypeString",
   "alias": "Plate",
   "length": 255,
   "domain": null
  },
  {
   "name": "Serial_VIN",
   "type": "esriFieldTypeString",
   "alias": "Serial_VIN",
   "length": 255,
   "domain": null
  },
  {
   "name": "FuelType",
   "type": "esriFieldTypeString",
   "alias": "FuelType",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FleetEquip_FuelType",
    "description": "Fleet and equipment fuel type",
    "codedValues": [
     {
      "name": "Biodiesel",
      "code": "Biodiesel"
     },
     {
      "name": "Diesel",
      "code": "Diesel"
     },
     {
      "name": "Electric",
      "code": "Electric"
     },
     {
      "name": "Gas",
      "code": "Gas"
     },
     {
      "name": "Hybrid",
      "code": "Hybrid"
     },
     {
      "name": "Natural Gas",
      "code": "Natural Gas"
     },
     {
      "name": "Propane",
      "code": "Propane"
     },
     {
      "name": "2-Cycle",
      "code": "2-Cycle"
     },
     {
      "name": "4-Cycle",
      "code": "4-Cycle"
     },
     {
      "name": "Flex / Fuel",
      "code": "Flex / Fuel"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SCFID",
   "type": "esriFieldTypeString",
   "alias": "SCFID",
   "length": 255,
   "domain": null
  },
  {
   "name": "FEMACode",
   "type": "esriFieldTypeString",
   "alias": "FEMA Code",
   "length": 255,
   "domain": null
  },
  {
   "name": "FEMARate",
   "type": "esriFieldTypeDouble",
   "alias": "FEMA Rate",
   "domain": null
  },
  {
   "name": "Department",
   "type": "esriFieldTypeString",
   "alias": "Department",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "aDomDepartment",
    "description": "CIty Departments",
    "codedValues": [
     {
      "name": "Engineering",
      "code": "Engineering"
     },
     {
      "name": "Street",
      "code": "Street"
     },
     {
      "name": "Utilities",
      "code": "Utilities"
     },
     {
      "name": "ICS",
      "code": "ICS"
     },
     {
      "name": "Police",
      "code": "Police"
     },
     {
      "name": "Fire",
      "code": "Fire"
     },
     {
      "name": "DOCS",
      "code": "DOCS"
     },
     {
      "name": "Administration",
      "code": "Administration"
     },
     {
      "name": "CRC",
      "code": "CRC"
     },
     {
      "name": "Brookshire",
      "code": "Brookshire"
     },
     {
      "name": "Law",
      "code": "Law"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "Division",
   "type": "esriFieldTypeString",
   "alias": "Division",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "aDomDivision",
    "description": "City Divisions",
    "codedValues": [
     {
      "name": "Wastewater",
      "code": "Wastewater"
     },
     {
      "name": "Water",
      "code": "Water"
     },
     {
      "name": "Locators",
      "code": "Locators"
     },
     {
      "name": "Meter Readers",
      "code": "Meter Readers"
     },
     {
      "name": "Utility Administration",
      "code": "Utility Administration"
     },
     {
      "name": "Fleet",
      "code": "Fleet"
     },
     {
      "name": "Events",
      "code": "Events"
     },
     {
      "name": "Signs & Lights",
      "code": "Signs & Lights"
     },
     {
      "name": "Drainage",
      "code": "Drainage"
     },
     {
      "name": "Trails & Curb",
      "code": "Trails & Curb"
     },
     {
      "name": "Street",
      "code": "Street"
     },
     {
      "name": "Landscaping",
      "code": "Landscaping"
     },
     {
      "name": "Trees",
      "code": "Trees"
     },
     {
      "name": "Fountains & Irrigation",
      "code": "Fountains & Irrigation"
     },
     {
      "name": "Pool Car",
      "code": "Pool Car"
     },
     {
      "name": "Communications",
      "code": "Communications"
     },
     {
      "name": "IT Administration",
      "code": "IT Administration"
     },
     {
      "name": "Street Administration",
      "code": "Street Administration"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "MaintLocation",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Location",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FleetEquipment_MaintenanceLocations",
    "description": "City fleet & equipment maintenance locations",
    "codedValues": [
     {
      "name": "Street Maintenance Shop",
      "code": "Street Maintenance Shop"
     },
     {
      "name": "Water Distribution",
      "code": "Water Distribution"
     },
     {
      "name": "WWTP",
      "code": "WWTP"
     },
     {
      "name": "Police Garage",
      "code": "Police Garage"
     },
     {
      "name": "Fire Garage",
      "code": "Fire Garage"
     },
     {
      "name": "Non-City Facility",
      "code": "Non-City Facility"
     },
     {
      "name": "Utilities Maintenance Shop",
      "code": "Utilities Maintenance Shop"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RelatedStructure",
   "type": "esriFieldTypeString",
   "alias": "Related Structure",
   "length": 255,
   "domain": null
  },
  {
   "name": "AssignedTo",
   "type": "esriFieldTypeString",
   "alias": "AssignedTo",
   "length": 255,
   "domain": null
  },
  {
   "name": "Operator",
   "type": "esriFieldTypeString",
   "alias": "Operator",
   "length": 255,
   "domain": null
  },
  {
   "name": "Filter",
   "type": "esriFieldTypeString",
   "alias": "Filter",
   "length": 255,
   "domain": null
  },
  {
   "name": "Fluid",
   "type": "esriFieldTypeString",
   "alias": "Fluid",
   "length": 255,
   "domain": null
  },
  {
   "name": "PMSchedule",
   "type": "esriFieldTypeString",
   "alias": "PM Schedule",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FleetEquip_PM",
    "description": "Fleet and equipment PM Schedules",
    "codedValues": [
     {
      "name": "Engine Oil Life",
      "code": "Engine Oil Life"
     },
     {
      "name": "Mileage",
      "code": "Mileage"
     },
     {
      "name": "Hours",
      "code": "Hours"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PMLSD",
   "type": "esriFieldTypeDate",
   "alias": "PM Last Service Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Mileage",
   "type": "esriFieldTypeDouble",
   "alias": "Mileage",
   "domain": null
  },
  {
   "name": "MIleageLS",
   "type": "esriFieldTypeDouble",
   "alias": "Last Serviced MIleage",
   "domain": null
  },
  {
   "name": "EngineHours",
   "type": "esriFieldTypeDouble",
   "alias": "Engine Hours",
   "domain": null
  },
  {
   "name": "EngineHoursLS",
   "type": "esriFieldTypeDouble",
   "alias": "Last Serviced Engine Hours",
   "domain": null
  },
  {
   "name": "AuxHours",
   "type": "esriFieldTypeDouble",
   "alias": "Auxillary Hours",
   "domain": null
  },
  {
   "name": "AuxHoursLS",
   "type": "esriFieldTypeDouble",
   "alias": "Last Serviced Aux Hours",
   "domain": null
  },
  {
   "name": "EOL",
   "type": "esriFieldTypeDouble",
   "alias": "Engine Oil Life",
   "domain": null
  },
  {
   "name": "OwnType",
   "type": "esriFieldTypeString",
   "alias": "OwnType",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FleetEquip_OwnType",
    "description": "Ownership type of fleet and equipment",
    "codedValues": [
     {
      "name": "Own",
      "code": "Own"
     },
     {
      "name": "Leased",
      "code": "Leased"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LLEndDate",
   "type": "esriFieldTypeDate",
   "alias": "Lease_Loan End Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "DOP",
   "type": "esriFieldTypeDate",
   "alias": "Purchase Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PP",
   "type": "esriFieldTypeDouble",
   "alias": "Purchase Price",
   "domain": null
  },
  {
   "name": "RC",
   "type": "esriFieldTypeDouble",
   "alias": "Replacement Cost",
   "domain": null
  },
  {
   "name": "TargetRPLYear",
   "type": "esriFieldTypeInteger",
   "alias": "Target Replacement Year",
   "domain": null
  },
  {
   "name": "WarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "WarrantyMileage",
   "type": "esriFieldTypeDouble",
   "alias": "Warranty Mileage",
   "domain": null
  },
  {
   "name": "COF",
   "type": "esriFieldTypeDouble",
   "alias": "Consequence of Failure",
   "domain": null
  },
  {
   "name": "POF",
   "type": "esriFieldTypeDouble",
   "alias": "Probability of Failure",
   "domain": null
  },
  {
   "name": "BRE",
   "type": "esriFieldTypeDouble",
   "alias": "Business Risk Exposure",
   "domain": null
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 255,
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "FleetEquip_Status",
    "description": "Status of fleet & equipment",
    "codedValues": [
     {
      "name": "Active",
      "code": "Active"
     },
     {
      "name": "Inactive",
      "code": "Inactive"
     },
     {
      "name": "Planned",
      "code": "Planned"
     },
     {
      "name": "Sold",
      "code": "Sold"
     },
     {
      "name": "Transferred",
      "code": "Transferred"
     },
     {
      "name": "Traded",
      "code": "Traded"
     },
     {
      "name": "Missing",
      "code": "Missing"
     },
     {
      "name": "Pending",
      "code": "Pending"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "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": "GlobalID_1",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID_1",
   "length": 38,
   "domain": null
  },
  {
   "name": "WOID",
   "type": "esriFieldTypeString",
   "alias": "WOID",
   "length": 255,
   "domain": null
  },
  {
   "name": "WOStatus",
   "type": "esriFieldTypeString",
   "alias": "WOStatus",
   "length": 255,
   "domain": null
  },
  {
   "name": "PMInspectDate",
   "type": "esriFieldTypeDate",
   "alias": "PM Inspect Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PMDueHrs",
   "type": "esriFieldTypeDouble",
   "alias": "PM Next Due Hours",
   "domain": null
  },
  {
   "name": "PMDueMiles",
   "type": "esriFieldTypeDouble",
   "alias": "PM Next Due Mileage",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R1115_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_1115",
   "fields": "GlobalID_1",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "COC_Equipment",
   "relatedTableId": 13,
   "role": "esriRelRoleDestination",
   "keyField": "MaintLocation",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{975E7334-F94A-4B45-A0EC-F1888A1063FD}"
  }
 ],
 "capabilities": "Query,Map,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,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "1e893fb3503945159249ca1a33dfb0d3"
}