{ "currentVersion": 10.91, "id": 23, "name": "Fleet", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NEW_NO", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FLEETID", "type": "esriFieldTypeInteger", "alias": "FLEET ID", "domain": null }, { "name": "NEW_NO", "type": "esriFieldTypeString", "alias": "Fleet ID", "length": 10, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 80, "domain": null }, { "name": "Serial_NO", "type": "esriFieldTypeString", "alias": "Serial_NO", "length": 30, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Purchase Year", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 40, "domain": { "type": "codedValue", "name": "Location", "description": "Location", "codedValues": [ { "name": "Alex Arena", "code": "AlexArena" }, { "name": "Bylaw", "code": "Bylaw" }, { "name": "Director - PS", "code": "DirectorPS" }, { "name": "Engineering", "code": "Engineering" }, { "name": "Facility", "code": "Facility" }, { "name": "Fire", "code": "Fire" }, { "name": "Fleet", "code": "Fleet" }, { "name": "LRC", "code": "LRC" }, { "name": "Parks", "code": "Parks" }, { "name": "Planning", "code": "Planning" }, { "name": "Roads", "code": "Roads" }, { "name": "Sp Trans", "code": "SpTrans" }, { "name": "Spare", "code": "Spare" }, { "name": "Utility", "code": "Utility" }, { "name": "Black Gold Arena", "code": "BlackGoldArena" }, { "name": "Transit", "code": "Transit" }, { "name": "Public Services Building", "code": "PSB" }, { "name": "Public Services Shop", "code": "PSS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Object_CL", "type": "esriFieldTypeDouble", "alias": "Object Class", "domain": { "type": "codedValue", "name": "Object Class", "description": "Object Class", "codedValues": [ { "name": "Equipment", "code": 1 }, { "name": "PSS", "code": 2 }, { "name": "Vehicle", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Supplier", "type": "esriFieldTypeString", "alias": "Supplier", "length": 40, "domain": { "type": "codedValue", "name": "Supplier", "description": "Fleet Supplier", "codedValues": [ { "name": "4-Way Equipment Rentals", "code": "FourWayEqu" }, { "name": "AR Williams", "code": "ARWilliams" }, { "name": "Alberta Traffic Supply Ltd.", "code": "ABTraffic" }, { "name": "Art Barry Ford", "code": "ArtBarryFord" }, { "name": "Big Foot Enterprises", "code": "BigFootE" }, { "name": "Brandt Tractor", "code": "Bandt" }, { "name": "Brett Young", "code": "BrettYoung" }, { "name": "Cadman Power Equipment", "code": "Cadman" }, { "name": "Capital Chrysler Jeep Dodge", "code": "CapitalChrysler" }, { "name": "Cars Automotive", "code": "CarsAutomotive" }, { "name": "Cervus Equipment", "code": "CervusEquipment" }, { "name": "Cochrane Dodge", "code": "CochraneDodge" }, { "name": "Commercial Truck Equipment", "code": "CommercialTruckEquipment" }, { "name": "Crestline Coach Ltd.", "code": "Crestline" }, { "name": "Cubex Limited", "code": "Cubex" }, { "name": "Cycle Works West", "code": "CycleWorksWest" }, { "name": "DK Ford", "code": "DKFord" }, { "name": "Demers Ambulance", "code": "DemersAmbulance" }, { "name": "Derrick Dodge", "code": "DerrickDodge" }, { "name": "Diamond International Trucks", "code": "Diamond" }, { "name": "Echo Cycle", "code": "EchoCycle" }, { "name": "Edmonton Bobcat", "code": "EdmontonBobcat" }, { "name": "Edmonton Motors Ltd.", "code": "EdmontonMotors" }, { "name": "Falcon Equipment", "code": "FalconEquipment" }, { "name": "Finning Canada", "code": "Finning" }, { "name": "First Truck Centre", "code": "FirstTruckCentre" }, { "name": "Flaman", "code": "Flaman" }, { "name": "Heartland Ford", "code": "HeartlandFord" }, { "name": "Hi Line Farm Equipment Ltd.", "code": "HiLine" }, { "name": "Industrial Machine Ltd.", "code": "IndustrialMachine" }, { "name": "Ja-Co Welding and Consulting Ltd", "code": "JaCo" }, { "name": "Joe Johnson Equipment", "code": "JoeJohnsonEquipment" }, { "name": "Key-Ag Ventures Ltd.", "code": "KeyAg" }, { "name": "Kromer Co. LLC", "code": "Kromer" }, { "name": "Lawnmower Hospital", "code": "LawnmowerHosp" }, { "name": "Leduc Chrysler", "code": "LeducChrysler" }, { "name": "Leduc County", "code": "LeducCounty" }, { "name": "Leduc Electric Ltd.", "code": "LeducElectric" }, { "name": "Martin Deerline", "code": "Martin Deerline" }, { "name": "Murray Chevrolet", "code": "MurrayChev" }, { "name": "New Flyer Industries Ltd.", "code": "NewFlyer" }, { "name": "New Rider", "code": "NewRider" }, { "name": "Nisku Ford", "code": "NiskuFord" }, { "name": "Oakcreek Golf & Turf", "code": "OakcreekGolf" }, { "name": "PJ Trailers", "code": "PJTrailers" }, { "name": "Polaris Industries", "code": "Polaris" }, { "name": "Prairie Hydraulic Equipment Ltd.", "code": "PraireHydraulic" }, { "name": "Praxair", "code": "Praxair" }, { "name": "Precision Hyundai", "code": "PrecisionHyundai" }, { "name": "Private purchase", "code": "Private" }, { "name": "Rainbow Marine Sales", "code": "RainbowMS" }, { "name": "Rockbox Structures Inc", "code": "Rockbox Structures Inc" }, { "name": "Romaniuk Chevrolet", "code": "RomaniukChev" }, { "name": "Russell Food Equipment Ltd.", "code": "RusellFood" }, { "name": "SMS Equipment Inc", "code": "SMS Equipment Inc" }, { "name": "SV of Sandy Beach", "code": "SVofSandyBeach" }, { "name": "Schwab Chevrolet Buick GMC", "code": "SchwabChev" }, { "name": "Sherwood Ford", "code": "SherwoodFord" }, { "name": "Sherwood Park Hyundai", "code": "SherwoodParkHyundai" }, { "name": "Street Legal ATV", "code": "Street Legal ATV" }, { "name": "Strongco Equipment", "code": "Stronco" }, { "name": "Superior Truck Equipment Inc.", "code": "Superior" }, { "name": "The Bus Centre", "code": "TheBusCentre" }, { "name": "The Rental House", "code": "TheRentalHouse" }, { "name": "Tower Chrysler Dodge Jeep", "code": "TowerChrysler" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Vermeer Canada", "code": "Vermer" }, { "name": "WFR Wholesale Fire & Rescue Ltd.", "code": "WFR" }, { "name": "Westgate Chevrolet Ltd.", "code": "Westgate Chevrolet" }, { "name": "Westvac Industrial Ltd.", "code": "Westvac" }, { "name": "Wholesale Trailers of Alberta", "code": "WholesaleTrailers" }, { "name": "Williamson Equipment", "code": "WilliamsonEq" }, { "name": "Woodridge Ford", "code": "WoodridgeFord" }, { "name": "Zender Ford", "code": "ZenderFord" }, { "name": "Weis Fire & Safety Equipment, LLC", "code": "WeisFire" }, { "name": "Rocky Mountain Equipment", "code": "RockyMountainEquipment" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "License", "type": "esriFieldTypeString", "alias": "License Number", "length": 30, "domain": null }, { "name": "GISID", "type": "esriFieldTypeString", "alias": "GISID", "length": 25, "domain": null }, { "name": "Expired", "type": "esriFieldTypeString", "alias": "Expired", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchasePrice", "type": "esriFieldTypeDouble", "alias": "Purchase Price", "domain": null }, { "name": "WarrantyEndDate", "type": "esriFieldTypeDate", "alias": "WarrantyEndDate", "length": 8, "domain": null }, { "name": "WarrantyEndKM", "type": "esriFieldTypeDouble", "alias": "WarrantyEndKM", "domain": null }, { "name": "WarrantyEndHrs", "type": "esriFieldTypeDouble", "alias": "WarrantyEndHrs", "domain": null }, { "name": "DriveTrainWarrantyEndDate", "type": "esriFieldTypeDate", "alias": "DriveTrainWarrantyEndDate", "length": 8, "domain": null }, { "name": "DriveTrainWarrantyEndKM", "type": "esriFieldTypeDouble", "alias": "DriveTrainWarrantyEndKM\n", "domain": null }, { "name": "DriveTrainWarrantyEndHrs", "type": "esriFieldTypeDouble", "alias": "DriveTrainWarrantyEndHrs", "domain": null }, { "name": "CurrentKMs", "type": "esriFieldTypeDouble", "alias": "CurrentKMs", "domain": null }, { "name": "CurrentHRs", "type": "esriFieldTypeDouble", "alias": "CurrentHRs", "domain": null }, { "name": "GL1Name", "type": "esriFieldTypeString", "alias": "GL1Name\n", "length": 50, "domain": null }, { "name": "GL1Percent", "type": "esriFieldTypeDouble", "alias": "GL1Percent\n", "domain": null }, { "name": "GL2Name", "type": "esriFieldTypeString", "alias": "GL2Name\n", "length": 50, "domain": null }, { "name": "GL2Percent", "type": "esriFieldTypeDouble", "alias": "GL2Percent\n", "domain": null }, { "name": "Lifespan", "type": "esriFieldTypeSmallInteger", "alias": "Lifespan", "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ACCEvaporatorFilter", "type": "esriFieldTypeString", "alias": "ACCEvaporatorFilter", "length": 25, "domain": null }, { "name": "AerialHydraulicFilterPressure", "type": "esriFieldTypeString", "alias": "Aerial Hydraulic Filter (Pressure)", "length": 25, "domain": null }, { "name": "AerialHydraulicFilterReturn", "type": "esriFieldTypeString", "alias": "Aerial Hydraulic Filter (Return)", "length": 25, "domain": null }, { "name": "AftertreatmentDieselExhaustFDUF", "type": "esriFieldTypeString", "alias": "Aftertreatment Diesel Exhaust Fluid Dosing Unit Filter", "length": 50, "domain": null }, { "name": "AirCompressorFilter", "type": "esriFieldTypeString", "alias": "Air Compressor Filter ", "length": 25, "domain": null }, { "name": "AirFilterPrimary", "type": "esriFieldTypeString", "alias": "Air Filter (Primary)", "length": 50, "domain": null }, { "name": "AirFilterSecondary", "type": "esriFieldTypeString", "alias": "Air Filter (Secondary)", "length": 25, "domain": null }, { "name": "AuxiliaryEngineAirFilterPrimary", "type": "esriFieldTypeString", "alias": "Auxiliary Engine Air Filter (Primary)", "length": 25, "domain": null }, { "name": "AuxiliaryEngineAirFilterSeconda", "type": "esriFieldTypeString", "alias": "Auxiliary Engine Air Filter (Secondary)", "length": 25, "domain": null }, { "name": "AuxiliaryEngineFuelFilter", "type": "esriFieldTypeString", "alias": "Auxiliary Engine Fuel Filter", "length": 70, "domain": null }, { "name": "AuxiliaryEngineOilFilter", "type": "esriFieldTypeString", "alias": "Auxiliary Engine Oil Filter", "length": 25, "domain": null }, { "name": "AxleOilFilters", "type": "esriFieldTypeString", "alias": "Axle Oil Filters", "length": 25, "domain": null }, { "name": "BlowerFilter", "type": "esriFieldTypeString", "alias": "Blower Filter", "length": 25, "domain": null }, { "name": "BurnerFuelFilter", "type": "esriFieldTypeString", "alias": "Burner Fuel Filter", "length": 25, "domain": null }, { "name": "CabinAirFilter", "type": "esriFieldTypeString", "alias": "Cabin Air Filter", "length": 50, "domain": null }, { "name": "CabinAirFilterInsideFilter", "type": "esriFieldTypeString", "alias": "Cabin Air Filter (Inside Filter)", "length": 25, "domain": null }, { "name": "CabinAirFilterOutsideFilter", "type": "esriFieldTypeString", "alias": "Cabin Air Filter (Outside Filter)", "length": 25, "domain": null }, { "name": "CabinFreshAirFilter", "type": "esriFieldTypeString", "alias": "Cabin Fresh Air Filter", "length": 25, "domain": null }, { "name": "CabinRecirculationFilter", "type": "esriFieldTypeString", "alias": "Cabin Recirculation Filter", "length": 25, "domain": null }, { "name": "CoolantFilter", "type": "esriFieldTypeString", "alias": "Coolant Filter", "length": 25, "domain": null }, { "name": "CrankcaseBreatherFilter", "type": "esriFieldTypeString", "alias": "Crankcase Breather Filter", "length": 25, "domain": null }, { "name": "EngineOilFilter", "type": "esriFieldTypeString", "alias": "Engine Oil Filter", "length": 50, "domain": null }, { "name": "FoamPro3012FoamSystemHydraulicF", "type": "esriFieldTypeString", "alias": "Foam Pro 3012 Foam System Hydraulic Filter", "length": 25, "domain": null }, { "name": "FuelBreatherFilter", "type": "esriFieldTypeString", "alias": "Fuel Breather Filter", "length": 50, "domain": null }, { "name": "FuelFilter", "type": "esriFieldTypeString", "alias": "Fuel Filter", "length": 50, "domain": null }, { "name": "FuelFilterFinal", "type": "esriFieldTypeString", "alias": "Fuel Filter (Final)", "length": 25, "domain": null }, { "name": "FuelFilterPrimary", "type": "esriFieldTypeString", "alias": "Fuel Filter (Primary)", "length": 25, "domain": null }, { "name": "FuelFilterSecondary", "type": "esriFieldTypeString", "alias": "Fuel Filter (Secondary)", "length": 25, "domain": null }, { "name": "FuelPumpScreenKit", "type": "esriFieldTypeString", "alias": "Fuel Pump Screen Kit", "length": 25, "domain": null }, { "name": "FuelTankBreatherFilter", "type": "esriFieldTypeString", "alias": "Fuel Tank Breather Filter", "length": 25, "domain": null }, { "name": "FuelWaterSeparator", "type": "esriFieldTypeString", "alias": "Fuel/Water Separator", "length": 50, "domain": null }, { "name": "HarrisonHydraulicGHF", "type": "esriFieldTypeString", "alias": "Harrison Hydraulic Generator Hydraulic Filter", "length": 25, "domain": null }, { "name": "Husky3FoamSystemHydraulicFilter", "type": "esriFieldTypeString", "alias": "Husky 3 Foam System Hydraulic Filter", "length": 25, "domain": null }, { "name": "HuskyFoamSystemHydraulicFilter", "type": "esriFieldTypeString", "alias": "Husky Foam System Hydraulic Filter", "length": 120, "domain": null }, { "name": "HydraulicBreatherFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Breather Filter", "length": 25, "domain": null }, { "name": "HydraulicCaseDrainFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Case Drain Filter", "length": 25, "domain": null }, { "name": "HydraulicChargeFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Charge Filter", "length": 50, "domain": null }, { "name": "HydraulicFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Filter", "length": 90, "domain": null }, { "name": "HydraulicFilterAccessory", "type": "esriFieldTypeString", "alias": "Hydraulic Filter (Accessory)", "length": 25, "domain": null }, { "name": "HydraulicFilterBreatherSet", "type": "esriFieldTypeString", "alias": "Hydraulic Filter & Breather Set", "length": 25, "domain": null }, { "name": "HydraulicFilterHydrostatic", "type": "esriFieldTypeString", "alias": "Hydraulic Filter (Hydrostatic)", "length": 25, "domain": null }, { "name": "HydraulicOilFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Oil Filter", "length": 60, "domain": null }, { "name": "HydraulicPowertrainOilFilter", "type": "esriFieldTypeString", "alias": "Hydraulic/ Powertrain Oil Filter", "length": 25, "domain": null }, { "name": "HydraulicPressureFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Pressure Filter", "length": 25, "domain": null }, { "name": "HydraulicReserviorBreatherFilte", "type": "esriFieldTypeString", "alias": "Hydraulic Reservior Breather Filter", "length": 25, "domain": null }, { "name": "HydraulicReturnFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Return Filter", "length": 25, "domain": null }, { "name": "HydraulicSuctionFilter", "type": "esriFieldTypeString", "alias": "Hydraulic Suction Filter", "length": 25, "domain": null }, { "name": "HydraulicSystemReturnFilter", "type": "esriFieldTypeString", "alias": "Hydraulic System Return Filter", "length": 25, "domain": null }, { "name": "PowerDividerFilter", "type": "esriFieldTypeString", "alias": "Power Divider Filter", "length": 25, "domain": null }, { "name": "PowerSteeringFilter", "type": "esriFieldTypeString", "alias": "Power Steering Filter", "length": 50, "domain": null }, { "name": "PowerSteeringFilter00", "type": "esriFieldTypeString", "alias": "Power Steering Filter00", "length": 50, "domain": null }, { "name": "PVCBreatherFilter", "type": "esriFieldTypeString", "alias": "PVC Breather Filter", "length": 25, "domain": null }, { "name": "RearAxleBreather", "type": "esriFieldTypeString", "alias": "Rear Axle Breather", "length": 25, "domain": null }, { "name": "SpherosFuelFilter", "type": "esriFieldTypeString", "alias": "Spheros Fuel Filter", "length": 25, "domain": null }, { "name": "TransmissionBreatherFilter", "type": "esriFieldTypeString", "alias": "Transmission Breather Filter", "length": 25, "domain": null }, { "name": "TransmissionFilterKit", "type": "esriFieldTypeString", "alias": "Transmission Filter Kit", "length": 25, "domain": null }, { "name": "TransmissionHydraulicOilFilter", "type": "esriFieldTypeString", "alias": "Transmission/Hydraulic Oil Filter", "length": 25, "domain": null }, { "name": "TransmissionOilFilter", "type": "esriFieldTypeString", "alias": "Transmission Oil Filter", "length": 25, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "length": 15, "domain": { "type": "codedValue", "name": "CWSTATUS", "description": "Cityworks Asset Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Retired", "code": "Retired" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LASTINSPHR", "type": "esriFieldTypeInteger", "alias": "Last inspection Hrs", "domain": null }, { "name": "LASTINSPKM", "type": "esriFieldTypeInteger", "alias": "Last inspection Kms", "domain": null }, { "name": "SERVINTHR", "type": "esriFieldTypeInteger", "alias": "Service interval Hrs", "domain": null }, { "name": "SERVINTKM", "type": "esriFieldTypeInteger", "alias": "Service interval Kms", "domain": null }, { "name": "UNITCOST", "type": "esriFieldTypeDouble", "alias": "UNITCOST", "domain": null } ], "indexes": [ { "name": "R13_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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 }