{ "currentVersion": 10.71, "id": 3, "name": "Vehicles and Equipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 255, "domain": null }, { "name": "Year", "type": "esriFieldTypeDouble", "alias": "Year", "domain": null }, { "name": "Make", "type": "esriFieldTypeString", "alias": "Make", "length": 255, "domain": { "type": "codedValue", "name": "Make", "description": "Make", "codedValues": [ { "name": "APPLE", "code": "APPLE" }, { "name": "BANDIT CHIPPER", "code": "BANDIT CHIPPER" }, { "name": "BOBCAT", "code": "BOBCAT" }, { "name": "CHALLENGER", "code": "CHALLENGER" }, { "name": "CHEVROLET", "code": "CHEVROLET" }, { "name": "CONTINENTAL CARGO", "code": "CONTINENTAL CARGO" }, { "name": "DAEWOO", "code": "DAEWOO" }, { "name": "DIAMOND", "code": "DIAMOND" }, { "name": "DIETZ", "code": "DIETZ" }, { "name": "DMS", "code": "DMS" }, { "name": "DR", "code": "DR" }, { "name": "DR POWER EQUIPMENT ", "code": "DR POWER EQUIPMENT " }, { "name": "EFFICIENCY", "code": "EFFICIENCY" }, { "name": "ERSKINE", "code": "ERSKINE" }, { "name": "EZ DRILL", "code": "EZ DRILL" }, { "name": "FELLING", "code": "FELLING" }, { "name": "FORD", "code": "FORD" }, { "name": "FREIGHTLINER", "code": "FREIGHTLINER" }, { "name": "GENERAC", "code": "GENERAC" }, { "name": "GMC", "code": "GMC" }, { "name": "GME", "code": "GME" }, { "name": "GODWIN", "code": "GODWIN" }, { "name": "GREEN CLIMBER", "code": "GREEN CLIMBER" }, { "name": "HONDA", "code": "HONDA" }, { "name": "HUSQVARNA", "code": "HUSQVARNA" }, { "name": "IBAK", "code": "IBAK" }, { "name": "INGER RAND", "code": "INGER RAND" }, { "name": "JLG", "code": "JLG" }, { "name": "JOHN DEERE", "code": "JOHN DEERE" }, { "name": "K AND K MANUFACTURING", "code": "K AND K MANUFACTURING" }, { "name": "KAGE", "code": "KAGE" }, { "name": "KARAVAN", "code": "KARAVAN" }, { "name": "KNAPHEIDE", "code": "KNAPHEIDE" }, { "name": "KUT KWICK", "code": "KUT KWICK" }, { "name": "KWIK WAY", "code": "KWIK WAY" }, { "name": "LINCOLN", "code": "LINCOLN" }, { "name": "MELECIO", "code": "MELECIO" }, { "name": "MIFI", "code": "MIFI" }, { "name": "MILLER", "code": "MILLER" }, { "name": "MOBILE TRAILER CONEX BOX", "code": "MOBILE TRAILER CONEX BOX" }, { "name": "MOBILE TRAILER CONTAINER", "code": "MOBILE TRAILER CONTAINER" }, { "name": "MOBILE TRAILER OFFICE", "code": "MOBILE TRAILER OFFICE" }, { "name": "MONROE", "code": "MONROE" }, { "name": "MOTOROLA", "code": "MOTOROLA" }, { "name": "MQ", "code": "MQ" }, { "name": "MULTIQUIP", "code": "MULTIQUIP" }, { "name": "NISSAN", "code": "NISSAN" }, { "name": "OLYMPIAN", "code": "OLYMPIAN" }, { "name": "OLYMPIC", "code": "OLYMPIC" }, { "name": "ONAN", "code": "ONAN" }, { "name": "POLARIS", "code": "POLARIS" }, { "name": "RC TRAILERS", "code": "RC TRAILERS" }, { "name": "RHINO", "code": "RHINO" }, { "name": "ROGERS", "code": "ROGERS" }, { "name": "SALSCO", "code": "SALSCO" }, { "name": "SAMSUNG", "code": "SAMSUNG" }, { "name": "SCAG", "code": "SCAG" }, { "name": "SEAHAWK", "code": "SEAHAWK" }, { "name": "SKYJACK LEGACY", "code": "SKYJACK LEGACY" }, { "name": "SKYTRAC", "code": "SKYTRAC" }, { "name": "SKYTRAC LEGACY", "code": "SKYTRAC LEGACY" }, { "name": "SNOW-EX", "code": "SNOW-EX" }, { "name": "SPORTSMAN", "code": "SPORTSMAN" }, { "name": "SRECO-FLEXIBLE", "code": "SRECO-FLEXIBLE" }, { "name": "STANLEY", "code": "STANLEY" }, { "name": "STEPP", "code": "STEPP" }, { "name": "STERTIL KONI", "code": "STERTIL KONI" }, { "name": "STIHL", "code": "STIHL" }, { "name": "STORM HAWK", "code": "STORM HAWK" }, { "name": "SWENSON", "code": "SWENSON" }, { "name": "TCL", "code": "TCL" }, { "name": "TENNANT", "code": "TENNANT" }, { "name": "TITAN", "code": "TITAN" }, { "name": "TORO", "code": "TORO" }, { "name": "TRACKLESS", "code": "TRACKLESS" }, { "name": "TRAFCON", "code": "TRAFCON" }, { "name": "TRIMBLE", "code": "TRIMBLE" }, { "name": "TRUCK WORLD INC", "code": "TRUCK WORLD INC" }, { "name": "VENTRAC", "code": "VENTRAC" }, { "name": "VERMEER", "code": "VERMEER" }, { "name": "VOLVO", "code": "VOLVO" }, { "name": "WACKER", "code": "WACKER" }, { "name": "WANCO", "code": "WANCO" }, { "name": "WESTERN", "code": "WESTERN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "Status_Vehicle", "description": "Vehicle/Equip Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" }, { "name": "On Order", "code": "On Order" }, { "name": "Pending Retirement", "code": "Pending Retirement" }, { "name": "Waiting Auction", "code": "Waiting Auction" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "length": 255, "domain": { "type": "codedValue", "name": "Section", "description": "Eng Section", "codedValues": [ { "name": "Construction Inspection", "code": "ConsInsp" }, { "name": "Administration", "code": "Admin" }, { "name": "Custodial", "code": "Custodial" }, { "name": "Facilities Maintenance", "code": "FacMaint" }, { "name": "Facilities Management", "code": "FacManage" }, { "name": "Landfill", "code": "Landfill" }, { "name": "Operations", "code": "Operations" }, { "name": "Stormwater", "code": "Stormwater" }, { "name": "Survey", "code": "Survey" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 255, "domain": null }, { "name": "MadMaps.DATA_ADM.Vehicles_Equipment.Entity", "type": "esriFieldTypeString", "alias": "MadMaps.DATA_ADM.Vehicles_Equipment.Entity", "length": 255, "domain": null }, { "name": "Faster_ID", "type": "esriFieldTypeString", "alias": "Faster_ID", "length": 255, "domain": null }, { "name": "EquipmentID", "type": "esriFieldTypeString", "alias": "EquipmentID", "length": 255, "domain": null }, { "name": "ParentID", "type": "esriFieldTypeString", "alias": "ParentID", "length": 255, "domain": null }, { "name": "Primary_Op_Crew", "type": "esriFieldTypeString", "alias": "Primary_Op_Crew", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": { "type": "codedValue", "name": "Location", "description": "Location", "codedValues": [ { "name": "EMIL", "code": "EMIL" }, { "name": "SYCAMORE", "code": "SYCAMORE" }, { "name": "CCB", "code": "CCB" }, { "name": "ToM", "code": "ToM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "length": 255, "domain": { "type": "codedValue", "name": "Vehicle_Category", "description": "Vehicle_Category", "codedValues": [ { "name": "Arrow Board", "code": "Arrow Board" }, { "name": "Asphalt Heater", "code": "Asphalt Heater" }, { "name": "Asphalt Roller", "code": "Asphalt Roller" }, { "name": "ATV", "code": "ATV" }, { "name": "Auto, Electric", "code": "Auto, Electric" }, { "name": "Auto, Gas", "code": "Auto, Gas" }, { "name": "Backhoe", "code": "Backhoe" }, { "name": "CCTV Truck", "code": "CCTV Truck" }, { "name": "CCTV Truck, Pano", "code": "CCTV Truck, Pano" }, { "name": "Chipper", "code": "Chipper" }, { "name": "Compressor", "code": "Compressor" }, { "name": "Dozer, Crawler", "code": "Dozer, Crawler" }, { "name": "Excavator, Track", "code": "Excavator, Track" }, { "name": "Excavator, Track Mini", "code": "Excavator, Track Mini" }, { "name": "Excavator, Vacuum Trailer Mounted", "code": "Excavator, Vacuum Trailer Mounted" }, { "name": "Excavator, Wheel", "code": "Excavator, Wheel" }, { "name": "Generator", "code": "Generator" }, { "name": "Generator/Welder", "code": "Generator/Welder" }, { "name": "Horizontal Directional Drill", "code": "Horizontal Directional Drill" }, { "name": "Jetter", "code": "Jetter" }, { "name": "Lift", "code": "Lift" }, { "name": "Loader", "code": "Loader" }, { "name": "Mower", "code": "Mower" }, { "name": "Plow", "code": "Plow" }, { "name": "Spreader", "code": "Spreader" }, { "name": "SUV or Xover, Electric", "code": "SUV or Xover, Electric" }, { "name": "SUV or Xover, Gas", "code": "SUV or Xover, Gas" }, { "name": "Sweeper, Riding", "code": "Sweeper, Riding" }, { "name": "Toolcat", "code": "Toolcat" }, { "name": "Tractor", "code": "Tractor" }, { "name": "Trailer", "code": "Trailer" }, { "name": "Truck, 1 1/2 Ton Dump", "code": "Truck, 1 1/2 Ton Dump" }, { "name": "Truck, 1 1/2 Ton Utility Body", "code": "Truck, 1 1/2 Ton Utility Body" }, { "name": "Truck, 1 Ton Utility Body", "code": "Truck, 1 Ton Utility Body" }, { "name": "Truck, 1-Ton Dump", "code": "Truck, 1-Ton Dump" }, { "name": "Truck, 2 Ton Dump", "code": "Truck, 2 Ton Dump" }, { "name": "Truck, Pickup 1/2 Ton Electric", "code": "Truck, Pickup 1/2 Ton Electric" }, { "name": "Truck, Pickup 1/2 Ton Gas", "code": "Truck, Pickup 1/2 Ton Gas" }, { "name": "Truck, Pickup 1/4 Ton Gas", "code": "Truck, Pickup 1/4 Ton Gas" }, { "name": "Truck, Pickup 1/4 Ton Hybrid", "code": "Truck, Pickup 1/4 Ton Hybrid" }, { "name": "Truck, Pickup 3/4 Ton Gas", "code": "Truck, Pickup 3/4 Ton Gas" }, { "name": "Truck, Tandem Dump", "code": "Truck, Tandem Dump" }, { "name": "Truck, Tandem w/Stake Bed Dump Body", "code": "Truck, Tandem w/Stake Bed Dump Body" }, { "name": "Truck, Tri-axle Dump", "code": "Truck, Tri-axle Dump" }, { "name": "UTV", "code": "UTV" }, { "name": "Vactor", "code": "Vactor" }, { "name": "Van, 1 Ton Cargo Electric", "code": "Van, 1 Ton Cargo Electric" }, { "name": "Van, Cargo 1 Ton Gas", "code": "Van, Cargo 1 Ton Gas" }, { "name": "Van, Cargo, 1/4 Ton Gas", "code": "Van, Cargo, 1/4 Ton Gas" }, { "name": "Van, Cutaway with Box", "code": "Van, Cutaway with Box" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R20044_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }