{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 7, "name": "Fleet_Transit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "UnitNo", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "UnitNo", "type": "esriFieldTypeString", "alias": "UnitNo", "length": 255, "domain": null }, { "name": "UnitDescription", "type": "esriFieldTypeString", "alias": "UnitDescription", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeInteger", "alias": "Year", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": { "type": "codedValue", "name": "ftmanufacturer", "description": "ftmanufacturer", "codedValues": [ { "name": "Aardvark", "code": "Aardvark" }, { "name": "Air-loc", "code": "Air-loc" }, { "name": "Airlift", "code": "Airlift" }, { "name": "Airway", "code": "Airway" }, { "name": "Alitec", "code": "Alitec" }, { "name": "Allianz", "code": "Allianz" }, { "name": "Argo", "code": "Argo" }, { "name": "Asten", "code": "Asten" }, { "name": "Astencook", "code": "Astencook" }, { "name": "Bandit", "code": "Bandit" }, { "name": "Bearcat", "code": "Bearcat" }, { "name": "Big Tex", "code": "Big Tex" }, { "name": "Bobcat", "code": "Bobcat" }, { "name": "Bomag", "code": "Bomag" }, { "name": "Boss", "code": "Boss" }, { "name": "Boston Whaler", "code": "Boston Whaler" }, { "name": "Cambio", "code": "Cambio" }, { "name": "Canadian Electric Vehicles", "code": "Canadian Electric Vehicles" }, { "name": "Carlton", "code": "Carlton" }, { "name": "Case", "code": "Case" }, { "name": "Case International", "code": "Case International" }, { "name": "Cat", "code": "Cat" }, { "name": "Caterpillar", "code": "Caterpillar" }, { "name": "CEC", "code": "CEC" }, { "name": "Century", "code": "Century" }, { "name": "Chevrolet", "code": "Chevrolet" }, { "name": "Club Car", "code": "Club Car" }, { "name": "Command", "code": "Command" }, { "name": "Contempra", "code": "Contempra" }, { "name": "Crafco", "code": "Crafco" }, { "name": "Cross Country", "code": "Cross Country" }, { "name": "Daemo", "code": "Daemo" }, { "name": "Daewoo", "code": "Daewoo" }, { "name": "Dakota", "code": "Dakota" }, { "name": "DEL", "code": "DEL" }, { "name": "Devair", "code": "Devair" }, { "name": "Dodge", "code": "Dodge" }, { "name": "Doosan", "code": "Doosan" }, { "name": "Dormel", "code": "Dormel" }, { "name": "Dressta", "code": "Dressta" }, { "name": "Dynasty", "code": "Dynasty" }, { "name": "Eagle", "code": "Eagle" }, { "name": "Epic", "code": "Epic" }, { "name": "Finn", "code": "Finn" }, { "name": "Fmc", "code": "Fmc" }, { "name": "Ford", "code": "Ford" }, { "name": "Fore", "code": "Fore" }, { "name": "Forest River Inc", "code": "Forest River Inc" }, { "name": "Fort Fabrication And Welding", "code": "Fort Fabrication And Welding" }, { "name": "Freightliner", "code": "Freightliner" }, { "name": "Frieghtliner", "code": "Frieghtliner" }, { "name": "Genie", "code": "Genie" }, { "name": "Giant", "code": "Giant" }, { "name": "GMC", "code": "GMC" }, { "name": "Goertzen", "code": "Goertzen" }, { "name": "Gorman", "code": "Gorman" }, { "name": "Graco", "code": "Graco" }, { "name": "Harper", "code": "Harper" }, { "name": "Haulmark", "code": "Haulmark" }, { "name": "Henderson", "code": "Henderson" }, { "name": "Highway", "code": "Highway" }, { "name": "Holder", "code": "Holder" }, { "name": "Honda", "code": "Honda" }, { "name": "Horizon", "code": "Horizon" }, { "name": "Husqvarna", "code": "Husqvarna" }, { "name": "Hyundai", "code": "Hyundai" }, { "name": "Ingersoll-Rand", "code": "Ingersoll-Rand" }, { "name": "International", "code": "International" }, { "name": "Interstate", "code": "Interstate" }, { "name": "JCB", "code": "JCB" }, { "name": "Jeep", "code": "Jeep" }, { "name": "JLG", "code": "JLG" }, { "name": "John Deere", "code": "John Deere" }, { "name": "Karavan", "code": "Karavan" }, { "name": "Kia", "code": "Kia" }, { "name": "KM T-2", "code": "KM T-2" }, { "name": "Komatsu", "code": "Komatsu" }, { "name": "Komptech", "code": "Komptech" }, { "name": "Kona", "code": "Kona" }, { "name": "Kromer", "code": "Kromer" }, { "name": "Kubota", "code": "Kubota" }, { "name": "Landa", "code": "Landa" }, { "name": "Leica", "code": "Leica" }, { "name": "Lonetrack", "code": "Lonetrack" }, { "name": "Magnum", "code": "Magnum" }, { "name": "Mazda", "code": "Mazda" }, { "name": "Mccloskey", "code": "Mccloskey" }, { "name": "Midland", "code": "Midland" }, { "name": "Mirage", "code": "Mirage" }, { "name": "Mitsubishi", "code": "Mitsubishi" }, { "name": "MMA Line Lazer", "code": "MMA Line Lazer" }, { "name": "Monroe", "code": "Monroe" }, { "name": "Multiquip", "code": "Multiquip" }, { "name": "Nahanni", "code": "Nahanni" }, { "name": "New Holland", "code": "New Holland" }, { "name": "Nissan", "code": "Nissan" }, { "name": "Norco", "code": "Norco" }, { "name": "Olympia", "code": "Olympia" }, { "name": "Opus", "code": "Opus" }, { "name": "Oshkosh", "code": "Oshkosh" }, { "name": "Pace", "code": "Pace" }, { "name": "Pacific Tek", "code": "Pacific Tek" }, { "name": "Pedego", "code": "Pedego" }, { "name": "Polaris", "code": "Polaris" }, { "name": "Power Curber", "code": "Power Curber" }, { "name": "Power Fist", "code": "Power Fist" }, { "name": "Rainbow", "code": "Rainbow" }, { "name": "Redex", "code": "Redex" }, { "name": "Redexim", "code": "Redexim" }, { "name": "Rogers", "code": "Rogers" }, { "name": "Rosen", "code": "Rosen" }, { "name": "RPM Tech", "code": "RPM Tech" }, { "name": "Ryan", "code": "Ryan" }, { "name": "Scarab", "code": "Scarab" }, { "name": "Shorerider", "code": "Shorerider" }, { "name": "Sicard", "code": "Sicard" }, { "name": "SMI", "code": "SMI" }, { "name": "Smithco", "code": "Smithco" }, { "name": "Snake River", "code": "Snake River" }, { "name": "Snowbear", "code": "Snowbear" }, { "name": "Spartan", "code": "Spartan" }, { "name": "Stanley", "code": "Stanley" }, { "name": "Steel Container Systems", "code": "Steel Container Systems" }, { "name": "Sterling", "code": "Sterling" }, { "name": "Stihl", "code": "Stihl" }, { "name": "Sullair", "code": "Sullair" }, { "name": "Sunstream", "code": "Sunstream" }, { "name": "Supreme", "code": "Supreme" }, { "name": "Suzuki", "code": "Suzuki" }, { "name": "Swenson", "code": "Swenson" }, { "name": "Tana", "code": "Tana" }, { "name": "Tennant", "code": "Tennant" }, { "name": "Terex", "code": "Terex" }, { "name": "Toro", "code": "Toro" }, { "name": "Toyota", "code": "Toyota" }, { "name": "Trackless", "code": "Trackless" }, { "name": "Trailtech", "code": "Trailtech" }, { "name": "Trek", "code": "Trek" }, { "name": "Triton", "code": "Triton" }, { "name": "Trommel", "code": "Trommel" }, { "name": "Ubuilt", "code": "Ubuilt" }, { "name": "Vermac", "code": "Vermac" }, { "name": "Vermeer", "code": "Vermeer" }, { "name": "Volkswagen", "code": "Volkswagen" }, { "name": "Volvo", "code": "Volvo" }, { "name": "Ward", "code": "Ward" }, { "name": "Wardhaul", "code": "Wardhaul" }, { "name": "Waypoint", "code": "Waypoint" }, { "name": "Wells Cargo", "code": "Wells Cargo" }, { "name": "Western", "code": "Western" }, { "name": "Western Star", "code": "Western Star" }, { "name": "Wildcat", "code": "Wildcat" }, { "name": "Yamaha", "code": "Yamaha" }, { "name": "Yanmar", "code": "Yanmar" }, { "name": "Zamboni", "code": "Zamboni" }, { "name": "New Flyer", "code": "New Flyer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNum", "type": "esriFieldTypeString", "alias": "SerialNum", "length": 255, "domain": null }, { "name": "CostCentre", "type": "esriFieldTypeString", "alias": "CostCentre", "length": 50, "domain": { "type": "codedValue", "name": "ftcostcentre", "description": "ftcostcentre", "codedValues": [ { "name": "100", "code": "100" }, { "name": "105", "code": "105" }, { "name": "111", "code": "111" }, { "name": "121", "code": "121" }, { "name": "129", "code": "129" }, { "name": "133", "code": "133" }, { "name": "134", "code": "134" }, { "name": "150", "code": "150" }, { "name": "151", "code": "151" }, { "name": "154", "code": "154" }, { "name": "156", "code": "156" }, { "name": "157", "code": "157" }, { "name": "159", "code": "159" }, { "name": "164", "code": "164" }, { "name": "165", "code": "165" }, { "name": "166", "code": "166" }, { "name": "167", "code": "167" }, { "name": "170", "code": "170" }, { "name": "172", "code": "172" }, { "name": "173", "code": "173" }, { "name": "174", "code": "174" }, { "name": "175", "code": "175" }, { "name": "176", "code": "176" }, { "name": "178", "code": "178" }, { "name": "183", "code": "183" }, { "name": "184", "code": "184" }, { "name": "188", "code": "188" }, { "name": "189", "code": "189" }, { "name": "190", "code": "190" }, { "name": "191", "code": "191" }, { "name": "193", "code": "193" }, { "name": "194", "code": "194" }, { "name": "195", "code": "195" }, { "name": "198", "code": "198" }, { "name": "200", "code": "200" }, { "name": "201", "code": "201" }, { "name": "214", "code": "214" }, { "name": "215", "code": "215" }, { "name": "219", "code": "219" }, { "name": "230", "code": "230" }, { "name": "231", "code": "231" }, { "name": "236", "code": "236" }, { "name": "237", "code": "237" }, { "name": "251", "code": "251" }, { "name": "252", "code": "252" }, { "name": "267", "code": "267" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": { "type": "codedValue", "name": "ftlocation", "description": "ftlocation", "codedValues": [ { "name": "Administration", "code": "Administration" }, { "name": "Airport", "code": "Airport" }, { "name": "Cemetery", "code": "Cemetery" }, { "name": "Cemetery - Parks Services", "code": "Cemetery - Parks Services" }, { "name": "Civic Operations - Parks Services - Urban Forestry", "code": "Civic Operations - Parks Services - Urban Forestry" }, { "name": "Civic Operations - Parks, Beaches & Sportsfields/Urban Forestry/Cemetery", "code": "Civic Operations - Parks, Beaches & Sportsfields/Urban Forestry/Cemetery" }, { "name": "Civic Operations - Traffic Operations", "code": "Civic Operations - Traffic Operations" }, { "name": "Civic Operations - Utility Services - Utility Operations", "code": "Civic Operations - Utility Services - Utility Operations" }, { "name": "Civic Operations - Utility Services - Wastewater Treatment", "code": "Civic Operations - Utility Services - Wastewater Treatment" }, { "name": "Community Services", "code": "Community Services" }, { "name": "Community Services - REBS - Arenas & Stadiums", "code": "Community Services - REBS - Arenas & Stadiums" }, { "name": "Community Services - Recreation, Parks & Cultural Serv", "code": "Community Services - Recreation, Parks & Cultural Serv" }, { "name": "Corporate Services - By-Law Services", "code": "Corporate Services - By-Law Services" }, { "name": "Corporate Services - Purchasing", "code": "Corporate Services - Purchasing" }, { "name": "Corporate Sustainability - Airport - Airside", "code": "Corporate Sustainability - Airport - Airside" }, { "name": "Corporate Sustainability - Airport - Groundside", "code": "Corporate Sustainability - Airport - Groundside" }, { "name": "Corporate Sustainability - Police Services", "code": "Corporate Sustainability - Police Services" }, { "name": "Crime Prevention", "code": "Crime Prevention" }, { "name": "Design & Const Services - Admin Support", "code": "Design & Const Services - Admin Support" }, { "name": "Design & Construction - Utilities Drainage Construction", "code": "Design & Construction - Utilities Drainage Construction" }, { "name": "Design & Construction - Utilities Sanitary Construction", "code": "Design & Construction - Utilities Sanitary Construction" }, { "name": "Design & Construction Services - Utilities Water Construction", "code": "Design & Construction Services - Utilities Water Construction" }, { "name": "Development Engineering", "code": "Development Engineering" }, { "name": "Development Services - Building & Permitting", "code": "Development Services - Building & Permitting" }, { "name": "Downtown Kel Assn", "code": "Downtown Kel Assn" }, { "name": "Facilities", "code": "Facilities" }, { "name": "Fire Department", "code": "Fire Department" }, { "name": "Fleet Services - Transportation Services", "code": "Fleet Services - Transportation Services" }, { "name": "Information Services", "code": "Information Services" }, { "name": "Infrastructure Delivery", "code": "Infrastructure Delivery" }, { "name": "Landfill - Utility Services", "code": "Landfill - Utility Services" }, { "name": "Parking Services (Rplcs CC157)", "code": "Parking Services (Rplcs CC157)" }, { "name": "REBS - Building Services/Maintenance Development", "code": "REBS - Building Services/Maintenance Development" }, { "name": "REBS - Property Management", "code": "REBS - Property Management" }, { "name": "Rec & Cult Services - Community & Neighbourhood Programs", "code": "Rec & Cult Services - Community & Neighbourhood Programs" }, { "name": "Recreation & Cultural Services - Cultural Services", "code": "Recreation & Cultural Services - Cultural Services" }, { "name": "Regional Services - Regional Programs Management", "code": "Regional Services - Regional Programs Management" }, { "name": "Roadways Construction - Design & Construction Services", "code": "Roadways Construction - Design & Construction Services" }, { "name": "Roadways Operations - Transportation Services", "code": "Roadways Operations - Transportation Services" }, { "name": "Solid Waste Organics - Utilities Services", "code": "Solid Waste Organics - Utilities Services" }, { "name": "Traffic Signals & Systems", "code": "Traffic Signals & Systems" }, { "name": "Utilities Maintenance - Utility Services", "code": "Utilities Maintenance - Utility Services" }, { "name": "Wastewater", "code": "Wastewater" }, { "name": "Water Quality & Customer Care", "code": "Water Quality & Customer Care" }, { "name": "Water Quality & Pumpstations - Utility Services", "code": "Water Quality & Pumpstations - Utility Services" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LicensePlate", "type": "esriFieldTypeString", "alias": "LicensePlate", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "ftstatus", "description": "ftstatus", "codedValues": [ { "name": "Operating", "code": "Operating" }, { "name": "Retain", "code": "Retain" }, { "name": "Sold", "code": "Sold" }, { "name": "Returned to Dealer", "code": "Retdlr" }, { "name": "Budget", "code": "Budget" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Ordered", "code": "Ordered" }, { "name": "ActiveDegraded", "code": "ActiveDegraded" }, { "name": "Fleet Garage", "code": "FTgarage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 255, "domain": null }, { "name": "DocumentationLink", "type": "esriFieldTypeString", "alias": "DocumentationLink", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": { "type": "codedValue", "name": "ftvendor", "description": "ftvendor", "codedValues": [ { "name": "0835688 Bc Ltd", "code": "0835688 Bc Ltd" }, { "name": "AB Contracting", "code": "AB Contracting" }, { "name": "Altec Industries", "code": "Altec Industries" }, { "name": "American Lafrance Of Bc", "code": "American Lafrance Of Bc" }, { "name": "AR Mower And Supply Ltd", "code": "AR Mower And Supply Ltd" }, { "name": "ATS Traffic", "code": "ATS Traffic" }, { "name": "Attica Equipment", "code": "Attica Equipment" }, { "name": "Avenue Machinery", "code": "Avenue Machinery" }, { "name": "Bannister Chevrolet", "code": "Bannister Chevrolet" }, { "name": "BC Cargo Trailers Ltd", "code": "BC Cargo Trailers Ltd" }, { "name": "BC Trailer", "code": "BC Trailer" }, { "name": "Bluestreak Equipment", "code": "Bluestreak Equipment" }, { "name": "Braby Motors", "code": "Braby Motors" }, { "name": "Brandt Tractor", "code": "Brandt Tractor" }, { "name": "Budget Car And Truck Rental", "code": "Budget Car And Truck Rental" }, { "name": "Butler Survey Equipment", "code": "Butler Survey Equipment" }, { "name": "Calgary Airport", "code": "Calgary Airport" }, { "name": "Canada Safety Systems", "code": "Canada Safety Systems" }, { "name": "Canadian Forestry Equipment", "code": "Canadian Forestry Equipment" }, { "name": "Canadian Petroleum Products", "code": "Canadian Petroleum Products" }, { "name": "Canadian Tire", "code": "Canadian Tire" }, { "name": "Cat Rental", "code": "Cat Rental" }, { "name": "Century", "code": "Century" }, { "name": "Commercial Truck", "code": "Commercial Truck" }, { "name": "Cookson Motors Ltd", "code": "Cookson Motors Ltd" }, { "name": "Cookson Motors Ltd.", "code": "Cookson Motors Ltd." }, { "name": "Crocker Equipment", "code": "Crocker Equipment" }, { "name": "Cyclepath - Kelowna", "code": "Cyclepath - Kelowna" }, { "name": "Danco Equipment", "code": "Danco Equipment" }, { "name": "Del Equipment", "code": "Del Equipment" }, { "name": "Don Folk Chevrolet", "code": "Don Folk Chevrolet" }, { "name": "Drive Products", "code": "Drive Products" }, { "name": "Dulux Paints", "code": "Dulux Paints" }, { "name": "Eagle Airfield", "code": "Eagle Airfield" }, { "name": "Electric Motor & Pump Service", "code": "Electric Motor & Pump Service" }, { "name": "Endisys", "code": "Endisys" }, { "name": "Falcon Equipment", "code": "Falcon Equipment" }, { "name": "Fallis Equipment", "code": "Fallis Equipment" }, { "name": "Farmco Sales Ltd.", "code": "Farmco Sales Ltd." }, { "name": "Finning", "code": "Finning" }, { "name": "Forman Equipment", "code": "Forman Equipment" }, { "name": "Fort Fabrication And Welding", "code": "Fort Fabrication And Welding" }, { "name": "Fort Garry Industries", "code": "Fort Garry Industries" }, { "name": "Gary Turner Display", "code": "Gary Turner Display" }, { "name": "Good Guys", "code": "Good Guys" }, { "name": "Great West Equipment", "code": "Great West Equipment" }, { "name": "Greenline Golf & Turf", "code": "Greenline Golf & Turf" }, { "name": "Hanley Agencies", "code": "Hanley Agencies" }, { "name": "Harmony Auto Sales", "code": "Harmony Auto Sales" }, { "name": "Hawker", "code": "Hawker" }, { "name": "HD Equipment", "code": "HD Equipment" }, { "name": "Home Depot", "code": "Home Depot" }, { "name": "Hub Fire Engine And Equipment", "code": "Hub Fire Engine And Equipment" }, { "name": "Humdinger Equipment", "code": "Humdinger Equipment" }, { "name": "ICI", "code": "ICI" }, { "name": "Industrial Machine", "code": "Industrial Machine" }, { "name": "Inprotect Systems Inc", "code": "Inprotect Systems Inc" }, { "name": "IRL International", "code": "IRL International" }, { "name": "Jacobsen Pontiac Buick", "code": "Jacobsen Pontiac Buick" }, { "name": "James Western Star Sterling", "code": "James Western Star Sterling" }, { "name": "Kelowna Automall Leasing", "code": "Kelowna Automall Leasing" }, { "name": "Kelowna Chrysler Dodge", "code": "Kelowna Chrysler Dodge" }, { "name": "Kelowna Motors", "code": "Kelowna Motors" }, { "name": "Kelowna Nissan Ltd", "code": "Kelowna Nissan Ltd" }, { "name": "Kelowna Princess Auto", "code": "Kelowna Princess Auto" }, { "name": "Kelowna Toyota", "code": "Kelowna Toyota" }, { "name": "Kendrick Equipment", "code": "Kendrick Equipment" }, { "name": "Klassen Diesel Sales", "code": "Klassen Diesel Sales" }, { "name": "Kromer Co. Llc", "code": "Kromer Co. Llc" }, { "name": "Lone Track Parts Inc", "code": "Lone Track Parts Inc" }, { "name": "M And M Performance", "code": "M And M Performance" }, { "name": "Masonlift", "code": "Masonlift" }, { "name": "Mertin Nissan", "code": "Mertin Nissan" }, { "name": "Metro Motors Ltd.", "code": "Metro Motors Ltd." }, { "name": "Nahanni Industries Ltd", "code": "Nahanni Industries Ltd" }, { "name": "Napa", "code": "Napa" }, { "name": "Noble Tractors", "code": "Noble Tractors" }, { "name": "Northland Chipper Sales", "code": "Northland Chipper Sales" }, { "name": "Oakcreek Golf And Turf Lp", "code": "Oakcreek Golf And Turf Lp" }, { "name": "Oconnor", "code": "Oconnor" }, { "name": "Okanagan Ag & Turf", "code": "Okanagan Ag & Turf" }, { "name": "Orchard Ford Sales", "code": "Orchard Ford Sales" }, { "name": "Oshkosh", "code": "Oshkosh" }, { "name": "Parker Pacific Equip Sales", "code": "Parker Pacific Equip Sales" }, { "name": "Penticton Toyota", "code": "Penticton Toyota" }, { "name": "Prairie Coast Equipment", "code": "Prairie Coast Equipment" }, { "name": "Praxair", "code": "Praxair" }, { "name": "Premium Truck And Trailer Inc.", "code": "Premium Truck And Trailer Inc." }, { "name": "Purves-Ritchie", "code": "Purves-Ritchie" }, { "name": "Raymax Equipment", "code": "Raymax Equipment" }, { "name": "Reactor Equipment", "code": "Reactor Equipment" }, { "name": "Roadways Traffic Products Ltd.", "code": "Roadways Traffic Products Ltd." }, { "name": "Rocky Mountain Fire", "code": "Rocky Mountain Fire" }, { "name": "Rocky Mountain Pheonix", "code": "Rocky Mountain Pheonix" }, { "name": "Rollins Machinery", "code": "Rollins Machinery" }, { "name": "RPM Tech", "code": "RPM Tech" }, { "name": "Savoy Equipment", "code": "Savoy Equipment" }, { "name": "Scarab Manufacturing", "code": "Scarab Manufacturing" }, { "name": "Screenquip Sales", "code": "Screenquip Sales" }, { "name": "Sealtec Industries", "code": "Sealtec Industries" }, { "name": "Sentes Chevrolet", "code": "Sentes Chevrolet" }, { "name": "Smeal Fire Apparatus Co", "code": "Smeal Fire Apparatus Co" }, { "name": "SMS Equipment", "code": "SMS Equipment" }, { "name": "Spatial Tech", "code": "Spatial Tech" }, { "name": "Steve Marshall Ford", "code": "Steve Marshall Ford" }, { "name": "Summit Tools", "code": "Summit Tools" }, { "name": "Sunrise Trailer Sales", "code": "Sunrise Trailer Sales" }, { "name": "Superior Emergency Vehicles", "code": "Superior Emergency Vehicles" }, { "name": "Surfwood Supply", "code": "Surfwood Supply" }, { "name": "Team Eagle Ltd.", "code": "Team Eagle Ltd." }, { "name": "Tennant Company", "code": "Tennant Company" }, { "name": "Toyota Credit Canada Inc.", "code": "Toyota Credit Canada Inc." }, { "name": "Trans Pacific Truck & Trailer", "code": "Trans Pacific Truck & Trailer" }, { "name": "Transform Compost", "code": "Transform Compost" }, { "name": "Turner Volkswagen", "code": "Turner Volkswagen" }, { "name": "Tyalta", "code": "Tyalta" }, { "name": "Valley Lift Truck", "code": "Valley Lift Truck" }, { "name": "Valley Moto Sport", "code": "Valley Moto Sport" }, { "name": "Van-Ed Distributors", "code": "Van-Ed Distributors" }, { "name": "Vernon Kia", "code": "Vernon Kia" }, { "name": "Vimar Equipment Ltd", "code": "Vimar Equipment Ltd" }, { "name": "Wajax Equipment", "code": "Wajax Equipment" }, { "name": "Water Blast Manufacturing Lp", "code": "Water Blast Manufacturing Lp" }, { "name": "Waypoint Truck & Road Maintenance", "code": "Waypoint Truck & Road Maintenance" }, { "name": "Westerra Equipment", "code": "Westerra Equipment" }, { "name": "Westside Sales And Rentals", "code": "Westside Sales And Rentals" }, { "name": "Westvac Industrial", "code": "Westvac Industrial" }, { "name": "Wholesale Fire And Rescue Ltd.", "code": "Wholesale Fire And Rescue Ltd." }, { "name": "Williams Machinery", "code": "Williams Machinery" }, { "name": "Winn Rentals Ltd", "code": "Winn Rentals Ltd" }, { "name": "Woodland Equipment", "code": "Woodland Equipment" }, { "name": "Work Truck West", "code": "Work Truck West" }, { "name": "Workfleets", "code": "Workfleets" }, { "name": "Zimmer Wheaton Gm", "code": "Zimmer Wheaton Gm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ReadingType", "type": "esriFieldTypeString", "alias": "ReadingType", "length": 255, "domain": { "type": "codedValue", "name": "ftreadingtype", "description": "ftreadingtype", "codedValues": [ { "name": "KM", "code": "KM" }, { "name": "HR", "code": "HR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurrentMeterReading", "type": "esriFieldTypeInteger", "alias": "CurrentMeterReading", "domain": null }, { "name": "PurchasePrice", "type": "esriFieldTypeDouble", "alias": "PurchasePrice", "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "EQType", "type": "esriFieldTypeString", "alias": "EQType", "length": 255, "domain": null }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 255, "domain": null }, { "name": "RentalRate", "type": "esriFieldTypeString", "alias": "RentalRate", "length": 255, "domain": null }, { "name": "GVW1", "type": "esriFieldTypeString", "alias": "GVW1", "length": 255, "domain": null }, { "name": "GVW2", "type": "esriFieldTypeString", "alias": "GVW2", "length": 255, "domain": null }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": { "type": "codedValue", "name": "ftcategory", "description": "ftcategory", "codedValues": [ { "name": "Equipment", "code": "Equipment" }, { "name": "Heavy Vehicles", "code": "Heavy Vehicles" }, { "name": "Light Vehicles", "code": "Light Vehicles" }, { "name": "Trailers", "code": "Trailers" }, { "name": "Miscellaneous", "code": "Miscellaneous" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Class ", "length": 255, "domain": { "type": "codedValue", "name": "ftclass", "description": "ftclass", "codedValues": [ { "name": "Heavy Duty Equipment", "code": "Heavy Duty Equipment" }, { "name": "Light Duty Equipment", "code": "Medium Duty Equipment" }, { "name": "Tandem Axle Truck", "code": "Tandem Axle Truck" }, { "name": "Single Axle Truck", "code": "Single Axle Truck" }, { "name": "Light Duty Truck", "code": "Light Duty Truck" }, { "name": "Van", "code": "Van" }, { "name": "SUV", "code": "SUV" }, { "name": "Car", "code": "Car" }, { "name": "Utility Vehicle", "code": "Utility Vehicle" }, { "name": "Trailer", "code": "Trailer" }, { "name": "Miscellaneous", "code": "Miscellaneous" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "fttype", "description": "fttype", "codedValues": [ { "name": "Tractor", "code": "Tractor" }, { "name": "Refuse Compactor", "code": "Refuse Compactor" }, { "name": "Processing Plant", "code": "Processing Plant" }, { "name": "Excavator", "code": "Excavator" }, { "name": "Loader", "code": "Loader" }, { "name": "Crawler", "code": "Crawler" }, { "name": "Snow Blower", "code": "Snow Blower" }, { "name": "Backhoe", "code": "Backhoe" }, { "name": "Grader", "code": "Grader" }, { "name": "Street Sweeper", "code": "Street Sweeper" }, { "name": "Roller", "code": "Roller" }, { "name": "Tractor - Municipal", "code": "Tractor - Municipal" }, { "name": "Chipper", "code": "Chipper" }, { "name": "Hydro Seeder", "code": "Hydro Seeder" }, { "name": "Asphalt Recycler", "code": "Asphalt Recycler" }, { "name": "Skid Steer", "code": "Skid Steer" }, { "name": "Ice Resurfacer", "code": "Ice Resurfacer" }, { "name": "Forklift", "code": "Forklift" }, { "name": "Field Equipment", "code": "Field Equipment" }, { "name": "Line Striper", "code": "Line Striper" }, { "name": "Mobile Pressure Washer", "code": "Mobile Pressure Washer" }, { "name": "Mobile Air Compressor", "code": "Mobile Air Compressor" }, { "name": "Top Dresser", "code": "Top Dresser" }, { "name": "Mower", "code": "Mower" }, { "name": "Sidewalk Sweeper", "code": "Sidewalk Sweeper" }, { "name": "Asphalt / Concrete Cutter", "code": "Asphalt / Concrete Cutter" }, { "name": "Hook Lift", "code": "Hook LIft" }, { "name": "Dump Truck", "code": "Dump Truck" }, { "name": "Fire Truck", "code": "Fire Truck" }, { "name": "Hydro Excavator / Rodder", "code": "Hydro Excavator / Rodder" }, { "name": "Fire Bush Truck", "code": "Fire Bush Truck" }, { "name": "Service Truck", "code": "Service Truck" }, { "name": "Line Painter", "code": "Line Painter" }, { "name": "Crane Truck", "code": "Crane Truck" }, { "name": "Bucket Truck", "code": "Bucket Truck" }, { "name": "Litter Truck", "code": "Litter Truck" }, { "name": "Flat Deck", "code": "Flat Deck" }, { "name": "1/2 Ton - 1 Ton", "code": "1/2 Ton - 1 Ton" }, { "name": "Economy", "code": "Economy" }, { "name": "Hybrid", "code": "Hybrid" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Conventional", "code": "Conventional" }, { "name": "EV", "code": "EV" }, { "name": "Golf Cart", "code": "Golf Cart" }, { "name": "Gator / Toro", "code": "Gator / Toro" }, { "name": "End Dump Trailer", "code": "End Dump Trailer" }, { "name": "Pup Trailer", "code": "Pup Trailer" }, { "name": "Utility Tilt Trailer", "code": "Utility Tilt Trailer" }, { "name": "Equipment Haul Trailer", "code": "Equipment Haul Trailer" }, { "name": "Utility Trailer", "code": "Utility Trailer" }, { "name": "Traffic Control Trailer", "code": "Traffic Control Trailer" }, { "name": "Survey Instrument", "code": "Survey Instrument" }, { "name": "Transfer Bin", "code": "Transfer Bin" }, { "name": "Bicycle", "code": "Bicycle" }, { "name": "Attachment", "code": "Attachment" }, { "name": "Water Tank", "code": "Water Tank" }, { "name": "NAPA Sale", "code": "NAPA Sale" }, { "name": "Sander", "code": "Sander" }, { "name": "Gravel Box", "code": "Gravel Box" }, { "name": "Bucket", "code": "Bucket" }, { "name": "Breaker / Hoe Pack", "code": "Breaker / Hoe Pack" }, { "name": "Shop Tool", "code": "Shop Tool" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "length": 50, "domain": { "type": "codedValue", "name": "ftfueltype", "description": "ftfueltype", "codedValues": [ { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "7", "code": "7" }, { "name": "8", "code": "8" }, { "name": "9", "code": "9" }, { "name": "10", "code": "10" }, { "name": "11", "code": "11" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image", "length": 100, "domain": null } ], "indexes": [ { "name": "R644_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2233UnitNo", "fields": "UnitNo", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "Fleet_Specification", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{193D1981-69C0-4C39-9A76-2FABA325ABE6}" }, { "id": 10, "name": "Fleet_Warranty", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D4522B48-8965-4F42-83D1-8D85E0E98E30}" } ], "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": "8746e12115aa4687babd720c9af0edcc" }