{ "layers": [], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "Fleet_Unit", "type": "Table", "description": null, "hasAttachments": true, "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": "ParentId", "type": "esriFieldTypeInteger", "alias": "ParentId", "domain": null }, { "name": "ParentDesc", "type": "esriFieldTypeString", "alias": "ParentDesc", "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": "RadioChannels", "type": "esriFieldTypeString", "alias": "RadioChannels", "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": "Mobility", "type": "esriFieldTypeString", "alias": "Mobility", "length": 255, "domain": { "type": "codedValue", "name": "ftmobility", "description": "ftmobility", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Fixed", "code": "Fixed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GLString", "type": "esriFieldTypeString", "alias": "GLString", "length": 255, "domain": null }, { "name": "POMisc", "type": "esriFieldTypeString", "alias": "POMisc", "length": 255, "domain": null }, { "name": "Miscellaneous1", "type": "esriFieldTypeString", "alias": "Miscellaneous1", "length": 800, "domain": null }, { "name": "Miscellaneous2", "type": "esriFieldTypeString", "alias": "Miscellaneous2", "length": 800, "domain": null }, { "name": "Warranty_Notes", "type": "esriFieldTypeString", "alias": "Warranty_Notes", "length": 255, "domain": null }, { "name": "Warranty_Notes2", "type": "esriFieldTypeString", "alias": "Warranty_Notes2", "length": 255, "domain": null }, { "name": "SalvageValue", "type": "esriFieldTypeInteger", "alias": "SalvageValue", "domain": null }, { "name": "UsefulLife", "type": "esriFieldTypeInteger", "alias": "UsefulLife", "domain": null }, { "name": "DeprecMethod", "type": "esriFieldTypeInteger", "alias": "DeprecMethod", "domain": null }, { "name": "DeprecFactor", "type": "esriFieldTypeInteger", "alias": "DeprecFactor", "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": "DataValidated", "type": "esriFieldTypeString", "alias": "DataValidated", "length": 3, "domain": null }, { "name": "SecureLink", "type": "esriFieldTypeString", "alias": "SecureLink", "length": 256, "domain": null }, { "name": "AID", "type": "esriFieldTypeString", "alias": "AID", "length": 11, "domain": null }, { "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": "RateDesc", "type": "esriFieldTypeString", "alias": "RateDesc", "length": 25, "domain": { "type": "codedValue", "name": "ftratedesc", "description": "Rate Description", "codedValues": [ { "name": "Actual Costs", "code": "Actual Costs" }, { "name": "Hourly Rate", "code": "Hourly Rate" }, { "name": "Insurance Only", "code": "Insurance Only" }, { "name": "Monthly Rate", "code": "Monthly Rate" }, { "name": "Monthly Rate *SPLIT*", "code": "Monthly Rate *SPLIT*" }, { "name": "No Rental Rate", "code": "No Rental Rate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IMAGE", "type": "esriFieldTypeString", "alias": "IMAGE", "length": 100, "domain": null }, { "name": "ReplacementDate", "type": "esriFieldTypeDate", "alias": "ReplacementDate", "length": 8, "domain": null }, { "name": "ReplacementYear", "type": "esriFieldTypeSmallInteger", "alias": "ReplacementYear", "domain": null } ], "indexes": [ { "name": "R634_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2223UnitNo", "fields": "UnitNo", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2223UnitNo", "fields": "UnitNo", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2223UnitDescrip", "fields": "UnitDescription", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2223AID", "fields": "AID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2223Manufacture", "fields": "Manufacturer", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2223Model", "fields": "Model", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I2223Status", "fields": "Status", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "FT_Accessories", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{07B56F4E-6554-413F-845B-108BC819A9B9}" }, { "id": 3, "name": "Warranty", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{537E9003-4D54-47DA-B654-1D02CB8E0148}" }, { "id": 2, "name": "Specifications", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6FBA995F-C374-4319-80E3-2158F88F8F39}" }, { "id": 7, "name": "Fleet_Engine", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BBEA81E9-D810-4A35-8408-248AE374279D}" }, { "id": 1, "name": "Fleet_Blades", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9494F59-7252-4237-B2DE-2ED6CB23E847}" }, { "id": 0, "name": "Fleet_Tires", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2B171380-EC0F-4FC7-9852-5046098D21D1}" }, { "id": 8, "name": "FleetSpecs", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{63DEC51A-EA79-4A74-AE8B-6B6ABD50F8E4}" }, { "id": 6, "name": "FleetComponents", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "UnitNo", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3BA883FC-40B7-47E6-B18F-85CDF55F3B5B}" } ], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "Fleet_Blades", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BladeId", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BladeId", "type": "esriFieldTypeString", "alias": "BladeId", "length": 50, "domain": null }, { "name": "VehicleId", "type": "esriFieldTypeString", "alias": "VehicleId", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "AssembledDepth_inches", "type": "esriFieldTypeInteger", "alias": "Assembled Depth (in inches)", "domain": null }, { "name": "AssembledHeight_inches", "type": "esriFieldTypeInteger", "alias": "Assembled Height (in nches)", "domain": null }, { "name": "AssembledWidth_inches", "type": "esriFieldTypeInteger", "alias": "Assembled Width (in inches)", "domain": null }, { "name": "AssembledWeight_kg", "type": "esriFieldTypeInteger", "alias": "Assembled Weight (in kg)", "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image", "length": 50, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "LifecycleStatus_2", "description": "Asset Lifecycle Status", "codedValues": [ { "name": "Abandoned", "code": "ABND" }, { "name": "Proposed", "code": "PROP" }, { "name": "Active", "code": "ACT" }, { "name": "Disposed", "code": "DISP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R640_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2229VehicleId", "fields": "VehicleId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Fleet_Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "VehicleId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9494F59-7252-4237-B2DE-2ED6CB23E847}" } ], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "Fleet_Engine", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EngineId", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EngineId", "type": "esriFieldTypeString", "alias": "EngineId", "length": 50, "domain": null }, { "name": "VehicleId", "type": "esriFieldTypeString", "alias": "VehicleId", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "Horsepower", "type": "esriFieldTypeInteger", "alias": "Horsepower", "domain": null }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "FuelType", "length": 50, "domain": null }, { "name": "Cylinders", "type": "esriFieldTypeInteger", "alias": "Cylinders", "domain": null }, { "name": "EngineSize", "type": "esriFieldTypeInteger", "alias": "EngineSize", "domain": null }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image", "length": 100, "domain": null } ], "indexes": [ { "name": "R638_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2227VehicleId", "fields": "VehicleId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Fleet_Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "VehicleId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BBEA81E9-D810-4A35-8408-248AE374279D}" } ], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "Fleet_Specification", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LinkId", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LinkId", "type": "esriFieldTypeString", "alias": "LinkId", "length": 60, "domain": null }, { "name": "Counter", "type": "esriFieldTypeOID", "alias": "Counter", "domain": null }, { "name": "EntityID", "type": "esriFieldTypeString", "alias": "EntityID", "length": 50, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "Value", "type": "esriFieldTypeString", "alias": "Value", "length": 255, "domain": null }, { "name": "AID", "type": "esriFieldTypeString", "alias": "AID", "length": 11, "domain": null } ], "indexes": [ { "name": "R635_SDE_ROWID_UK", "fields": "Counter", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2224LinkId", "fields": "LinkId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "LinkId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6FBA995F-C374-4319-80E3-2158F88F8F39}" }, { "id": 9, "name": "Fleet_Transit", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "LinkId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{193D1981-69C0-4C39-9A76-2FABA325ABE6}" } ], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 6, "name": "Fleet_Tires", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TireId", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TireId", "type": "esriFieldTypeString", "alias": "TireId", "length": 50, "domain": null }, { "name": "VehicleId", "type": "esriFieldTypeString", "alias": "VehicleId", "length": 50, "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "MaxPSI", "type": "esriFieldTypeInteger", "alias": "MaxPSI", "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 50, "domain": null }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image", "length": 100, "domain": null } ], "indexes": [ { "name": "R637_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2226VehicleId", "fields": "VehicleId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Fleet_Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "VehicleId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2B171380-EC0F-4FC7-9852-5046098D21D1}" } ], "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" }, { "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 8, "name": "Fleet_Unit__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_OBJECTID", "type": "esriFieldTypeInteger", "alias": "REL_OBJECTID", "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null } ], "indexes": [ { "name": "R643_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2232REL_OBJECTI", "fields": "REL_OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "Fleet_Warranty", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EntityID", "type": "esriFieldTypeString", "alias": "EntityID", "length": 50, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "length": 8, "domain": null }, { "name": "EndKM", "type": "esriFieldTypeInteger", "alias": "EndKM", "domain": null }, { "name": "DocumentLink", "type": "esriFieldTypeString", "alias": "DocumentLink", "length": 100, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "ParentID", "length": 50, "domain": null }, { "name": "AID", "type": "esriFieldTypeString", "alias": "AID", "length": 11, "domain": null } ], "indexes": [ { "name": "R636_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2225ParentID", "fields": "ParentID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2225EntityID", "fields": "EntityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "FleetComponents", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "EntityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8C0CF68C-9656-4194-9846-62D52C55C837}" }, { "id": 3, "name": "Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "ParentID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{537E9003-4D54-47DA-B654-1D02CB8E0148}" }, { "id": 10, "name": "Fleet_Transit", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ParentID", "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 10, "name": "FleetComponents", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Description", "typeIdField": "System", "subtypeFieldName": "System", "subtypeField": "System", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "parentFleetID", "type": "esriFieldTypeString", "alias": "parentFleetID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeSmallInteger", "alias": "System", "domain": null }, { "name": "Component", "type": "esriFieldTypeSmallInteger", "alias": "Component", "domain": null }, { "name": "VMRS_Full", "type": "esriFieldTypeString", "alias": "VMRS Code", "length": 50, "domain": null }, { "name": "Warranty", "type": "esriFieldTypeString", "alias": "Warranty", "length": 50, "domain": null }, { "name": "ComponentID", "type": "esriFieldTypeString", "alias": "ComponentID", "length": 50, "domain": null }, { "name": "Assembly", "type": "esriFieldTypeInteger", "alias": "Assembly", "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "AMStatus", "description": "", "codedValues": [ { "name": "IN SERVICE", "code": "IN" }, { "name": "OUT OF SERVICE/ ABANDONED", "code": "OUT" }, { "name": "REMOVED", "code": "REMOVED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ExpectedUsefulLife", "type": "esriFieldTypeSmallInteger", "alias": "ExpectedUsefulLife", "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "InstallationDate", "type": "esriFieldTypeDate", "alias": "InstallationDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "ResidualLife", "type": "esriFieldTypeSmallInteger", "alias": "ResidualLife", "domain": null } ], "indexes": [ { "name": "R641_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2230parentFleet", "fields": "parentFleetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2230Warranty", "fields": "Warranty", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": {}, "id": 164, "name": "Blowing" }, { "domains": {}, "id": 25, "name": "Transfer Case 026 Transmission\u2014Main, Manual" }, { "domains": {}, "id": 27, "name": "Transmission\u2014Main, Automatic" }, { "domains": {}, "id": 21, "name": "Axle Driven\u2014Front Steering" }, { "domains": {}, "id": 22, "name": "Axle Driven\u2014Rear" }, { "domains": {}, "id": 23, "name": "Clutch 024 Drive Shaft(s)" }, { "domains": {}, "id": 28, "name": "Transmission\u2014Auxiliary and Transfer Case" }, { "domains": {}, "id": 29, "name": "Auxiliary Section (Transmission\u2014 Main, Manual)" }, { "domains": {}, "id": 94, "name": "Engine, Auxiliary (for power units, trailers, etc.)" }, { "domains": {}, "id": 4, "name": "Aerodynamic Devices" }, { "domains": {}, "id": 263, "name": "Hammering" }, { "domains": {}, "id": 262, "name": "Breaking" }, { "domains": {}, "id": 261, "name": "Raking" }, { "domains": {}, "id": 267, "name": "Drilling and Boring" }, { "domains": {}, "id": 265, "name": "Magnetic" }, { "domains": {}, "id": 264, "name": "Grappling" }, { "domains": {}, "id": 269, "name": "Dust & Debris Collecting" }, { "domains": {}, "id": 268, "name": "Pulling" }, { "domains": {}, "id": 59, "name": "Vehicle Coupling" }, { "domains": {}, "id": 58, "name": "Winch (for power units, trailers, etc.)" }, { "domains": {}, "id": 55, "name": "Cargo Handling, Restraints and Lift Systems (for power units, trailers, etc.)" }, { "domains": {}, "id": 54, "name": "Horns and Mounting and Reverse Signal Alarms" }, { "domains": {}, "id": 57, "name": "Spare Wheel Mounting" }, { "domains": {}, "id": 56, "name": "Power Take Off" }, { "domains": {}, "id": 51, "name": "General Accessories (for power units, trailers, etc.)" }, { "domains": {}, "id": 53, "name": "Expendable Items (for power units, trailers, etc.)" }, { "domains": {}, "id": 52, "name": "Electrical Accessories (for power units, trailers, etc.)" }, { "domains": {}, "id": 191, "name": "Batch Mobile Processing Plant" }, { "domains": {}, "id": 192, "name": "Conveying Systems" }, { "domains": {}, "id": 111, "name": "Undercarriage" }, { "domains": {}, "id": 112, "name": "Stabilization" }, { "domains": {}, "id": 82, "name": "Refrigeration, Mechanical (for power units, trailers, etc.)" }, { "domains": {}, "id": 83, "name": "Refrigeration, Nitrogen (for power units, trailers, etc.)" }, { "domains": {}, "id": 81, "name": "Heating Unit (for power units, trailers, etc.)" }, { "domains": {}, "id": 84, "name": "Refrigeration, Holdover Plate (for power units, trailers, etc.)" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly003", "description": "FLT_VMRS_Assembly003", "codedValues": [ { "name": "Gauges & Warning Devices", "code": 1 }, { "name": "Speedometer", "code": 2 }, { "name": "Shutdown Devices", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 3, "name": "Instruments, Gauges (All), and Meters" }, { "domains": {}, "id": 167, "name": "Tilling" }, { "domains": {}, "id": 33, "name": "Ignition System" }, { "domains": {}, "id": 32, "name": "Cranking System" }, { "domains": {}, "id": 31, "name": "Charging System" }, { "domains": {}, "id": 34, "name": "Lighting System" }, { "domains": {}, "id": 61, "name": "Terminal Equipment Systems and Accessories" }, { "domains": {}, "id": 63, "name": "Satellite Communications Systems" }, { "domains": {}, "id": 97, "name": "Pump (for power units, trailers, etc.)" }, { "domains": {}, "id": 65, "name": "Hydraulic Systems, Multifunctional" }, { "domains": {}, "id": 66, "name": "Scrapping" }, { "domains": {}, "id": 67, "name": "Buckets" }, { "domains": {}, "id": 68, "name": "Lifting" }, { "domains": {}, "id": 69, "name": "Conveyance" }, { "domains": {}, "id": 173, "name": "Tilt Bodies" }, { "domains": {}, "id": 172, "name": "Compaction Bodies" }, { "domains": {}, "id": 171, "name": "Mixers" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly002A", "description": "FLT_VMRS_Assembly002A", "codedValues": [ { "name": "Air Conditioning Assembly - Complete", "code": 1 }, { "name": "Heating & Ventilating", "code": 2 }, { "name": "Auxiliary Fan \u2013 Defroster", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 2, "name": "Cab and Sheet Metal" }, { "domains": {}, "id": 99, "name": "Safety Devices, Instruments and Gauges (for power units, trailers, etc.)" }, { "domains": {}, "id": 98, "name": "Valves and Controls (for power units, trailers, etc.)" }, { "domains": {}, "id": 168, "name": "Mowing" }, { "domains": {}, "id": 169, "name": "Ripping" }, { "domains": {}, "id": 91, "name": "Blowers, Conveyors, and Vibrators (for power units, trailers, etc.)" }, { "domains": {}, "id": 165, "name": "Vacuuming" }, { "domains": {}, "id": 166, "name": "Trenching" }, { "domains": {}, "id": 92, "name": "Compressor, Bulk Product Systems (for power units, trailers, etc.)" }, { "domains": {}, "id": 95, "name": "Manifold (for power units, trailers, etc.) 096 Power Shaft (for power units, trailers, etc.)" }, { "domains": {}, "id": 161, "name": "Sweeping" }, { "domains": {}, "id": 162, "name": "Spreading" }, { "domains": {}, "id": 163, "name": "Chipping" }, { "domains": {}, "id": 11, "name": "Axles Front\u2014Non-Driven" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly013", "description": "FLT_VMRS_Assembly013", "codedValues": [ { "name": "Front Brakes & Drums", "code": 1 }, { "name": "Rear Brakes & Drums", "code": 2 }, { "name": "Parking Brakes", "code": 3 }, { "name": "Spring Parking Brake (separate or Combination w/ service brake)", "code": 4 }, { "name": "Pedal Assembly \u2013 Service Brake", "code": 5 }, { "name": "Brake Master Cylinder", "code": 6 }, { "name": "Brake Lines & Fittings \u2013 Hydraulic & Air", "code": 7 }, { "name": "Air Compressor", "code": 9 }, { "name": "Air Type Power Brakes", "code": 10 }, { "name": "BS, Anti-lock system", "code": 11 }, { "name": "ir Disc Brakes", "code": 13 }, { "name": "ir Brake Monitoring System", "code": 15 }, { "name": "Hydraulic Motor Brake System", "code": 16 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 13, "name": "Brakes" }, { "domains": {}, "id": 12, "name": "Axles Rear\u2014Non-Driven" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly015", "description": "FLT_VMRS_Assembly015", "codedValues": [ { "name": "Steering Shaft Support", "code": 2 }, { "name": "Steering Gear", "code": 3 }, { "name": "Steering Linkage", "code": 4 }, { "name": "Power Steering Pump", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 15, "name": "Steering" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly014", "description": "FLT_VMRS_Assembly014", "codedValues": [ { "name": "Frame Assembly Components", "code": 1 }, { "name": "Bumpers & Attaching Parts", "code": 2 }, { "name": "Engine Mountings", "code": 3 }, { "name": "ab & Body Mountings", "code": 4 }, { "name": "attery Support", "code": 5 }, { "name": "uel Tank Support", "code": 6 }, { "name": "License Carrier (Plate holder)", "code": 7 }, { "name": "Attaching Devices \u2013 Hoses, Lines, Tubes & Wire", "code": 8 }, { "name": "Mud Flaps \u2013 rear wheel", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 14, "name": "Frame" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly017", "description": "FLT_VMRS_Assembly017", "codedValues": [ { "name": "Tire \u2013 Pneumatic", "code": 1 }, { "name": "Inner Tube \u2013 Pneumatic Tire", "code": 4 }, { "name": "Liner (Flap) \u2013 Pneumatic Tire", "code": 6 }, { "name": "Valve Assembly Tire", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 17, "name": "Tires" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly016", "description": "FLT_VMRS_Assembly016", "codedValues": [ { "name": "Front Springs", "code": 2 }, { "name": "Front Shock Absorbers", "code": 3 }, { "name": "Front Stabilizer", "code": 4 }, { "name": "Suspension \u2013 Rear (non-air)", "code": 5 }, { "name": "Shock Absorber \u2013 Rear", "code": 6 }, { "name": "Stabilizer \u2013 Rear", "code": 7 }, { "name": "Air Ride Suspension", "code": 8 }, { "name": "Air Leaf Suspension", "code": 9 }, { "name": "Hendrickson Suspension", "code": 12 }, { "name": "Locking Device \u2013 Ride Height", "code": 19 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 16, "name": "Suspension" }, { "domains": {}, "id": 19, "name": "Automatic/Manual Chassis Lubricator" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly018", "description": "FLT_VMRS_Assembly018", "codedValues": [ { "name": "Front Steer Axle Wheel End Components", "code": 1 }, { "name": "Drive Axle Wheel End Components", "code": 2 }, { "name": "Wheels", "code": 3 }, { "name": "Bearings \u2013 General", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 18, "name": "Wheels, Rim, Hubs, and Bearings" }, { "domains": {}, "id": 46, "name": "Electric Propulsion System" }, { "domains": {}, "id": 47, "name": "Filter Kits (Multi-Piece)" }, { "domains": {}, "id": 44, "name": "Fuel System" }, { "domains": {}, "id": 45, "name": "Power Plant" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly042", "description": "FLT_VMRS_Assembly042", "codedValues": [ { "name": "Shutters", "code": 1 }, { "name": "Radiator", "code": 2 }, { "name": "Fan \u2013 Engine Cooling", "code": 3 }, { "name": "Water Pump", "code": 4 }, { "name": "Thermostat \u2013 Engine Cooling System", "code": 6 }, { "name": "Coolant Filter", "code": 7 }, { "name": "Coolant Pre-Heater (In Block) \u2013 External Electric Power Supply", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 42, "name": "Cooling System" }, { "domains": {}, "id": 43, "name": "Exhaust System" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly041", "description": "FLT_VMRS_Assembly041", "codedValues": [ { "name": "Air Cleaner", "code": 1 }, { "name": "Intake Manifold", "code": 2 }, { "name": "Intercooler", "code": 4 }, { "name": "Ether Injector Assembly", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 41, "name": "Air Intake System" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly001", "description": "FLT_VMRS_Assembly001", "codedValues": [ { "name": "Air Conditioning Assembly - Complete", "code": 1 }, { "name": "Heating & Ventilating", "code": 2 }, { "name": "Auxiliary Fan \u2013 Defroster", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 1, "name": "Air Conditioning, Heating, and Ventilating System" }, { "domains": {}, "id": 77, "name": "Trailer Frame and Support" }, { "domains": {}, "id": 76, "name": "Rings and Bolsters" }, { "domains": {}, "id": 75, "name": "Manholes" }, { "domains": {}, "id": 74, "name": "Tank Vessel, outer jacket" }, { "domains": {}, "id": 73, "name": "Tank Vessel, inner shell" }, { "domains": {}, "id": 72, "name": "Rear Wall and Door" }, { "domains": {}, "id": 71, "name": "Body (except bulk carrier body)" }, { "domains": {}, "id": 79, "name": "Safety Devices" }, { "domains": {}, "id": 78, "name": "Trim and Miscellaneous Hardware" } ], "subtypes": [ { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 164, "name": "Blowing" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 25, "name": "Transfer Case 026 Transmission\u2014Main, Manual" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 27, "name": "Transmission\u2014Main, Automatic" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 21, "name": "Axle Driven\u2014Front Steering" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 22, "name": "Axle Driven\u2014Rear" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 23, "name": "Clutch 024 Drive Shaft(s)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 28, "name": "Transmission\u2014Auxiliary and Transfer Case" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 29, "name": "Auxiliary Section (Transmission\u2014 Main, Manual)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 94, "name": "Engine, Auxiliary (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 4, "name": "Aerodynamic Devices" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 263, "name": "Hammering" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 262, "name": "Breaking" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 261, "name": "Raking" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 267, "name": "Drilling and Boring" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 265, "name": "Magnetic" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 264, "name": "Grappling" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 269, "name": "Dust & Debris Collecting" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 268, "name": "Pulling" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 59, "name": "Vehicle Coupling" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 58, "name": "Winch (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 55, "name": "Cargo Handling, Restraints and Lift Systems (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 54, "name": "Horns and Mounting and Reverse Signal Alarms" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 57, "name": "Spare Wheel Mounting" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 56, "name": "Power Take Off" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 51, "name": "General Accessories (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 53, "name": "Expendable Items (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 52, "name": "Electrical Accessories (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 191, "name": "Batch Mobile Processing Plant" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 192, "name": "Conveying Systems" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 111, "name": "Undercarriage" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 112, "name": "Stabilization" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 82, "name": "Refrigeration, Mechanical (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 83, "name": "Refrigeration, Nitrogen (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 81, "name": "Heating Unit (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 84, "name": "Refrigeration, Holdover Plate (for power units, trailers, etc.)" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly003", "description": "FLT_VMRS_Assembly003", "codedValues": [ { "name": "Gauges & Warning Devices", "code": 1 }, { "name": "Speedometer", "code": 2 }, { "name": "Shutdown Devices", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 3, "name": "Instruments, Gauges (All), and Meters" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 167, "name": "Tilling" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 33, "name": "Ignition System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 32, "name": "Cranking System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 31, "name": "Charging System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 34, "name": "Lighting System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 61, "name": "Terminal Equipment Systems and Accessories" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 63, "name": "Satellite Communications Systems" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 97, "name": "Pump (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 65, "name": "Hydraulic Systems, Multifunctional" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 66, "name": "Scrapping" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 67, "name": "Buckets" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 68, "name": "Lifting" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 69, "name": "Conveyance" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 173, "name": "Tilt Bodies" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 172, "name": "Compaction Bodies" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 171, "name": "Mixers" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly002A", "description": "FLT_VMRS_Assembly002A", "codedValues": [ { "name": "Air Conditioning Assembly - Complete", "code": 1 }, { "name": "Heating & Ventilating", "code": 2 }, { "name": "Auxiliary Fan \u2013 Defroster", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 2, "name": "Cab and Sheet Metal" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 99, "name": "Safety Devices, Instruments and Gauges (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 98, "name": "Valves and Controls (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 168, "name": "Mowing" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 169, "name": "Ripping" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 91, "name": "Blowers, Conveyors, and Vibrators (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 165, "name": "Vacuuming" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 166, "name": "Trenching" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 92, "name": "Compressor, Bulk Product Systems (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 95, "name": "Manifold (for power units, trailers, etc.) 096 Power Shaft (for power units, trailers, etc.)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 161, "name": "Sweeping" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 162, "name": "Spreading" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 163, "name": "Chipping" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 11, "name": "Axles Front\u2014Non-Driven" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly013", "description": "FLT_VMRS_Assembly013", "codedValues": [ { "name": "Front Brakes & Drums", "code": 1 }, { "name": "Rear Brakes & Drums", "code": 2 }, { "name": "Parking Brakes", "code": 3 }, { "name": "Spring Parking Brake (separate or Combination w/ service brake)", "code": 4 }, { "name": "Pedal Assembly \u2013 Service Brake", "code": 5 }, { "name": "Brake Master Cylinder", "code": 6 }, { "name": "Brake Lines & Fittings \u2013 Hydraulic & Air", "code": 7 }, { "name": "Air Compressor", "code": 9 }, { "name": "Air Type Power Brakes", "code": 10 }, { "name": "BS, Anti-lock system", "code": 11 }, { "name": "ir Disc Brakes", "code": 13 }, { "name": "ir Brake Monitoring System", "code": 15 }, { "name": "Hydraulic Motor Brake System", "code": 16 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 13, "name": "Brakes" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 12, "name": "Axles Rear\u2014Non-Driven" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly015", "description": "FLT_VMRS_Assembly015", "codedValues": [ { "name": "Steering Shaft Support", "code": 2 }, { "name": "Steering Gear", "code": 3 }, { "name": "Steering Linkage", "code": 4 }, { "name": "Power Steering Pump", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 15, "name": "Steering" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly014", "description": "FLT_VMRS_Assembly014", "codedValues": [ { "name": "Frame Assembly Components", "code": 1 }, { "name": "Bumpers & Attaching Parts", "code": 2 }, { "name": "Engine Mountings", "code": 3 }, { "name": "ab & Body Mountings", "code": 4 }, { "name": "attery Support", "code": 5 }, { "name": "uel Tank Support", "code": 6 }, { "name": "License Carrier (Plate holder)", "code": 7 }, { "name": "Attaching Devices \u2013 Hoses, Lines, Tubes & Wire", "code": 8 }, { "name": "Mud Flaps \u2013 rear wheel", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 14, "name": "Frame" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly017", "description": "FLT_VMRS_Assembly017", "codedValues": [ { "name": "Tire \u2013 Pneumatic", "code": 1 }, { "name": "Inner Tube \u2013 Pneumatic Tire", "code": 4 }, { "name": "Liner (Flap) \u2013 Pneumatic Tire", "code": 6 }, { "name": "Valve Assembly Tire", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 17, "name": "Tires" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly016", "description": "FLT_VMRS_Assembly016", "codedValues": [ { "name": "Front Springs", "code": 2 }, { "name": "Front Shock Absorbers", "code": 3 }, { "name": "Front Stabilizer", "code": 4 }, { "name": "Suspension \u2013 Rear (non-air)", "code": 5 }, { "name": "Shock Absorber \u2013 Rear", "code": 6 }, { "name": "Stabilizer \u2013 Rear", "code": 7 }, { "name": "Air Ride Suspension", "code": 8 }, { "name": "Air Leaf Suspension", "code": 9 }, { "name": "Hendrickson Suspension", "code": 12 }, { "name": "Locking Device \u2013 Ride Height", "code": 19 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 16, "name": "Suspension" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 19, "name": "Automatic/Manual Chassis Lubricator" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly018", "description": "FLT_VMRS_Assembly018", "codedValues": [ { "name": "Front Steer Axle Wheel End Components", "code": 1 }, { "name": "Drive Axle Wheel End Components", "code": 2 }, { "name": "Wheels", "code": 3 }, { "name": "Bearings \u2013 General", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 18, "name": "Wheels, Rim, Hubs, and Bearings" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 46, "name": "Electric Propulsion System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 47, "name": "Filter Kits (Multi-Piece)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 44, "name": "Fuel System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 45, "name": "Power Plant" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly042", "description": "FLT_VMRS_Assembly042", "codedValues": [ { "name": "Shutters", "code": 1 }, { "name": "Radiator", "code": 2 }, { "name": "Fan \u2013 Engine Cooling", "code": 3 }, { "name": "Water Pump", "code": 4 }, { "name": "Thermostat \u2013 Engine Cooling System", "code": 6 }, { "name": "Coolant Filter", "code": 7 }, { "name": "Coolant Pre-Heater (In Block) \u2013 External Electric Power Supply", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 42, "name": "Cooling System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 43, "name": "Exhaust System" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly041", "description": "FLT_VMRS_Assembly041", "codedValues": [ { "name": "Air Cleaner", "code": 1 }, { "name": "Intake Manifold", "code": 2 }, { "name": "Intercooler", "code": 4 }, { "name": "Ether Injector Assembly", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 41, "name": "Air Intake System" }, { "domains": { "Assembly": { "type": "codedValue", "name": "FLT_VMRS_Assembly001", "description": "FLT_VMRS_Assembly001", "codedValues": [ { "name": "Air Conditioning Assembly - Complete", "code": 1 }, { "name": "Heating & Ventilating", "code": 2 }, { "name": "Auxiliary Fan \u2013 Defroster", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 1, "name": "Air Conditioning, Heating, and Ventilating System" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 77, "name": "Trailer Frame and Support" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 76, "name": "Rings and Bolsters" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 75, "name": "Manholes" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 74, "name": "Tank Vessel, outer jacket" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 73, "name": "Tank Vessel, inner shell" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 72, "name": "Rear Wall and Door" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 71, "name": "Body (except bulk carrier body)" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 79, "name": "Safety Devices" }, { "domains": {}, "defaultValues": { "Description": null, "parentFleetID": null, "System": null, "Component": null, "VMRS_Full": null, "Warranty": null, "ComponentID": null, "Assembly": null, "CreateDate": null, "LifecycleStatus": null, "ExpectedUsefulLife": null, "WarrantyDate": null, "InstallationDate": null, "Condition": null, "ConditionDate": null, "ResidualLife": null }, "code": 78, "name": "Trim and Miscellaneous Hardware" } ], "relationships": [ { "id": 11, "name": "Fleet_Warranty", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "Warranty", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8C0CF68C-9656-4194-9846-62D52C55C837}" }, { "id": 6, "name": "Fleet_Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "parentFleetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3BA883FC-40B7-47E6-B18F-85CDF55F3B5B}" } ], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "Fleet_Specs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "parentFleetUnit", "typeIdField": "Type", "subtypeFieldName": "Type", "subtypeField": "Type", "defaultSubtypeCode": 0, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "parentFleetUnit", "type": "esriFieldTypeString", "alias": "parentFleetUnit", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "WheelSize", "type": "esriFieldTypeString", "alias": "Wheel Size", "length": 50, "domain": { "type": "codedValue", "name": "FLT_WheelSize", "description": "Fleet Wheel Size", "codedValues": [ { "name": "275/65R18", "code": "275/65R18" }, { "name": "R15", "code": "R15" }, { "name": "R16", "code": "R16" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FuelEconomy", "type": "esriFieldTypeString", "alias": "Fuel Economy", "length": 50, "domain": null }, { "name": "DriveType", "type": "esriFieldTypeString", "alias": "Drive Type", "length": 50, "domain": { "type": "codedValue", "name": "FLT_DriveType", "description": "Fleet Drive Type", "codedValues": [ { "name": "Front-wheel drive", "code": "FWD" }, { "name": "Four-wheel drive", "code": "4WD" }, { "name": "All-wheel drive", "code": "AWD" }, { "name": "Rear-wheel drive", "code": "RWD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FuelType", "type": "esriFieldTypeString", "alias": "Fuel Type", "length": 50, "domain": { "type": "codedValue", "name": "FLT_FuelType", "description": "Fleet Fuel Type", "codedValues": [ { "name": "Regular Unleaded", "code": "RegularUnleaded" }, { "name": "Premium Unleaded", "code": "PremiumUnleaded" }, { "name": "Diesel", "code": "Diesel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WheelBase", "type": "esriFieldTypeString", "alias": "Wheel Base (cm)", "length": 50, "domain": null }, { "name": "OverallLength", "type": "esriFieldTypeDouble", "alias": "Overall Length (cm)", "domain": null }, { "name": "OverallWidth", "type": "esriFieldTypeDouble", "alias": "Overall Width (cm)", "domain": null }, { "name": "OverallHeight", "type": "esriFieldTypeDouble", "alias": "Overall Height (cm)", "domain": null }, { "name": "CurbWeight", "type": "esriFieldTypeDouble", "alias": "Curb Weight (kg)", "domain": null }, { "name": "Type", "type": "esriFieldTypeSmallInteger", "alias": "Component", "domain": null }, { "name": "SpecID", "type": "esriFieldTypeString", "alias": "SpecID", "length": 50, "domain": null } ], "indexes": [ { "name": "R642_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2231parentFleet", "fields": "parentFleetUnit", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "WheelSize": {"type": "inherited"}, "DriveType": {"type": "inherited"}, "FuelType": {"type": "inherited"} }, "id": 0, "name": "Ford 250 4X4" }, { "domains": { "WheelSize": {"type": "inherited"}, "DriveType": {"type": "inherited"}, "FuelType": {"type": "inherited"} }, "id": 1, "name": "GMC SIerra 1500" } ], "subtypes": [ { "domains": { "WheelSize": {"type": "inherited"}, "DriveType": {"type": "inherited"}, "FuelType": {"type": "inherited"} }, "defaultValues": { "parentFleetUnit": null, "Description": null, "WheelSize": null, "FuelEconomy": null, "DriveType": null, "FuelType": null, "WheelBase": null, "OverallLength": 613, "OverallWidth": 203, "OverallHeight": 205, "CurbWeight": 2728, "Type": null, "SpecID": null }, "code": 0, "name": "Ford 250 4X4" }, { "domains": { "WheelSize": {"type": "inherited"}, "DriveType": {"type": "inherited"}, "FuelType": {"type": "inherited"} }, "defaultValues": { "parentFleetUnit": null, "Description": null, "WheelSize": null, "FuelEconomy": null, "DriveType": null, "FuelType": null, "WheelBase": null, "OverallLength": null, "OverallWidth": null, "OverallHeight": null, "CurbWeight": null, "Type": null, "SpecID": null }, "code": 1, "name": "GMC SIerra 1500" } ], "relationships": [ { "id": 8, "name": "Fleet_Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "parentFleetUnit", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{63DEC51A-EA79-4A74-AE8B-6B6ABD50F8E4}" } ], "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" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 12, "name": "FT_Accessories", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "vehicleId", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "vehicleId", "type": "esriFieldTypeString", "alias": "vehicleId", "length": 50, "domain": null }, { "name": "aid", "type": "esriFieldTypeString", "alias": "aid", "length": 50, "domain": null }, { "name": "AccessoryType", "type": "esriFieldTypeString", "alias": "AccessoryType", "length": 50, "domain": null }, { "name": "Details", "type": "esriFieldTypeString", "alias": "Details", "length": 50, "domain": null } ], "indexes": [ { "name": "R639_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2228vehicleId", "fields": "vehicleId", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Fleet_Unit", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "vehicleId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{07B56F4E-6554-413F-845B-108BC819A9B9}" } ], "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" } ] }