{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "RollingStock", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 50, "domain": null }, { "name": "ASSETNAME", "type": "esriFieldTypeString", "alias": "Asset Name", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location Description", "length": 255, "domain": null }, { "name": "CONSEQUENCEOFFAILURE", "type": "esriFieldTypeDouble", "alias": "Consequence of Failure", "domain": null }, { "name": "LIKELIHOODOFFAILURE", "type": "esriFieldTypeDouble", "alias": "Likelihood of Failure", "domain": null }, { "name": "CRITICALITY", "type": "esriFieldTypeDouble", "alias": "Criticality", "domain": null }, { "name": "CRITICALITYDATE", "type": "esriFieldTypeDate", "alias": "Criticality Date", "length": 8, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "PURCHASEPRICE", "type": "esriFieldTypeInteger", "alias": "Purchase Price", "domain": null }, { "name": "PURCHASEDATE", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "CURRENTCONDITIONRATING", "type": "esriFieldTypeSmallInteger", "alias": "Current Condition Rating", "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "LIFEEXPECTANCY", "type": "esriFieldTypeSmallInteger", "alias": "Life Expectancy", "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "Lifecycle Status", "length": 50, "domain": null }, { "name": "REPLACEMENTCOST", "type": "esriFieldTypeInteger", "alias": "Replacement Cost", "domain": null }, { "name": "REMAININGUSEFULLIFE", "type": "esriFieldTypeInteger", "alias": "Remaining Useful Life", "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeString", "alias": "Owned By", "length": 50, "domain": null }, { "name": "MAINTAINEDBY", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 50, "domain": null }, { "name": "MAINTAINEDENTITY", "type": "esriFieldTypeString", "alias": "Maintained Entity", "length": 50, "domain": null }, { "name": "CONTACT_URL", "type": "esriFieldTypeString", "alias": "Contact Website URL", "length": 255, "domain": null }, { "name": "CONTACT_EMAIL", "type": "esriFieldTypeString", "alias": "Contact Email Address", "length": 255, "domain": null }, { "name": "CONTACT_NAME", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 50, "domain": null }, { "name": "CONTACT_PHONE", "type": "esriFieldTypeString", "alias": "Contact Phone Number", "length": 20, "domain": null }, { "name": "CONTACT_EXTENSION", "type": "esriFieldTypeString", "alias": "Contact Phone Extension", "length": 10, "domain": null }, { "name": "DATACOLLECTIONMETHOD", "type": "esriFieldTypeString", "alias": "Data Collection Method", "length": 50, "domain": null }, { "name": "SOURCE_NAME", "type": "esriFieldTypeString", "alias": "Source File Name", "length": 255, "domain": null }, { "name": "SOURCE_PATH", "type": "esriFieldTypeString", "alias": "Source File Location", "length": 255, "domain": null }, { "name": "SOURCE_TYPE", "type": "esriFieldTypeString", "alias": "Source File Type", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "Country", "length": 50, "domain": null }, { "name": "PROVINCE", "type": "esriFieldTypeString", "alias": "Province", "length": 50, "domain": null }, { "name": "POSTAL_CODE", "type": "esriFieldTypeString", "alias": "Postal Code", "length": 20, "domain": null }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "Address Unit/Suite", "length": 20, "domain": null }, { "name": "ATTACHMENT", "type": "esriFieldTypeString", "alias": "Attachment URL", "length": 50, "domain": null }, { "name": "GLOBAL_ID", "type": "esriFieldTypeGUID", "alias": "Global ID", "length": 38, "domain": null }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "Last Edited User", "length": 50, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "length": 8, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "SITENAME", "type": "esriFieldTypeString", "alias": "Site Name", "length": 255, "domain": null }, { "name": "SYSTEMNAME", "type": "esriFieldTypeString", "alias": "System Name", "length": 100, "domain": { "type": "codedValue", "name": "eamSystem", "description": "System Type", "codedValues": [ { "name": "01 Potable Water Source of Supply", "code": "01" }, { "name": "02 Sewer Collection", "code": "02" }, { "name": "03 Potable Water Treatment", "code": "03" }, { "name": "04 Potable Water Transmission", "code": "04" }, { "name": "05 Preliminary Treatment", "code": "05" }, { "name": "06 Primary Treatment", "code": "06" }, { "name": "07 Secondary Treatment", "code": "07" }, { "name": "08 Tertiary Treatment", "code": "08" }, { "name": "09 Wate Waster Disinfection", "code": "09" }, { "name": "10 Surface Water Discharge", "code": "10" }, { "name": "11 Reclaimed Water Storage and Pumping", "code": "11" }, { "name": "12 Facility Support", "code": "12" }, { "name": "13 Electrical", "code": "13" }, { "name": "14 Life Safety", "code": "14" }, { "name": "15 Material Processing", "code": "15" }, { "name": "16 Stormwater Treatment", "code": "16" }, { "name": "17 Air Quality", "code": "17" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUBSYSTEMNAME", "type": "esriFieldTypeString", "alias": "Subsystem Name", "length": 100, "domain": { "type": "codedValue", "name": "eamSubsystem", "description": "Subsystem Type", "codedValues": [ { "name": "01.01 Potable Interconnect", "code": "01.01" }, { "name": "01.02 Ground Water Production", "code": "01.02" }, { "name": "02.01 Sewer Interconnect", "code": "02.01" }, { "name": "03.01 Pre-Chlorination", "code": "03.01" }, { "name": "03.02 Post-Chlorination", "code": "03.02" }, { "name": "03.03 Polyphosphate", "code": "03.03" }, { "name": "03.04 Sodium Hydroxide", "code": "03.04" }, { "name": "03.05 Fluoride", "code": "03.05" }, { "name": "03.06 Ammonium Sulfate", "code": "03.06" }, { "name": "03.07 Storage", "code": "03.07" }, { "name": "03.08 Potable Treatment Instrumentation", "code": "03.08" }, { "name": "04.01 High Service Pumps", "code": "04.01" }, { "name": "05.01 Influent Pumping/Grinding", "code": "05.01" }, { "name": "05.02 Septage Receiving", "code": "05.02" }, { "name": "05.03 Vacuum Receiving", "code": "05.03" }, { "name": "05.04 Screenings Removal", "code": "05.04" }, { "name": "05.05 Grit Removal", "code": "05.05" }, { "name": "06.01 Primary Clarification", "code": "06.01" }, { "name": "06.02 Primary Sludge Pumping", "code": "06.02" }, { "name": "06.03 Primary Instrumentation", "code": "06.03" }, { "name": "07.01 WED Fermentation", "code": "07.01" }, { "name": "07.06 SCB Anoxic", "code": "07.06" }, { "name": "07.02 WED 1st Anoxic", "code": "07.02" }, { "name": "07.07 SCB Aeration", "code": "07.07" }, { "name": "07.03 WED Oxidation Reactor", "code": "07.03" }, { "name": "07.08 Secondary Clarification", "code": "07.08" }, { "name": "07.04 WED 2nd Anoxic", "code": "07.04" }, { "name": "07.09 Activated Sludge Pumping", "code": "07.09" }, { "name": "07.05 WED Reaeration", "code": "07.05" }, { "name": "07.10 Nalmet", "code": "07.10" }, { "name": "07.11 Aluminum Sulfate", "code": "07.11" }, { "name": "07.12 Secondary Instrumentation", "code": "07.12" }, { "name": "08.01 Filter Feed", "code": "08.01" }, { "name": "08.02 Denitrification", "code": "08.02" }, { "name": "08.03 Methanol", "code": "08.03" }, { "name": "08.04 Filtration", "code": "08.04" }, { "name": "08.05 Tertiary Instrumentation", "code": "08.05" }, { "name": "09.01 UV System", "code": "09.01" }, { "name": "09.02 Chlorine", "code": "09.02" }, { "name": "09.03 Bleach", "code": "09.03" }, { "name": "09.04 Disinfection Instrumentation", "code": "09.04" }, { "name": "10.01 Dechlorination", "code": "10.01" }, { "name": "10.02 Reaeration", "code": "10.02" }, { "name": "10.03 SWD Instrumentation", "code": "10.03" }, { "name": "11.01 Reject Storage", "code": "11.01" }, { "name": "11.02 Reclaimed Storage", "code": "11.02" }, { "name": "11.03 Reclaimed Pumping/Distribution", "code": "11.03" }, { "name": "11.05 Underground Injection", "code": "11.05" }, { "name": "11.06 In-Plant Reuse", "code": "11.06" }, { "name": "11.07 Reclaimed Interconnect", "code": "11.07" }, { "name": "11.09 Distribution Instrumentation", "code": "11.09" }, { "name": "11.10 Distribution Disinfection", "code": "11.10" }, { "name": "12.01 Security Access Control", "code": "12.01" }, { "name": "12.02 Irrigation", "code": "12.02" }, { "name": "12.03 HVAC", "code": "12.03" }, { "name": "12.04 Plumbing", "code": "12.04" }, { "name": "12.05 Building Electrical", "code": "12.05" }, { "name": "12.06 Building Structural Maintenance", "code": "12.06" }, { "name": "12.08 Grounds Maintenance", "code": "12.08" }, { "name": "13.01 Generation", "code": "13.01" }, { "name": "13.02 Transfer", "code": "13.02" }, { "name": "13.03 Distribution", "code": "13.03" }, { "name": "13.04 Grounding/Lightning Protection", "code": "13.04" }, { "name": "15.01 Bulky Waste Processing", "code": "15.01" }, { "name": "14.01 Fire Suppression", "code": "14.01" }, { "name": "15.02 Mulch Processing", "code": "15.02" }, { "name": "14.02 Personal Protection", "code": "14.02" }, { "name": "15.03 Containment", "code": "15.03" }, { "name": "14.03 Fire Alarm", "code": "14.03" }, { "name": "16.01 Alum", "code": "16.01" }, { "name": "17.01 Air Monitoring", "code": "17.01" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ROLLINGSTOCK_ID", "type": "esriFieldTypeString", "alias": "Rolling Stock ID", "length": 50, "domain": null }, { "name": "UNITDESC", "type": "esriFieldTypeString", "alias": "Unit Description", "length": 50, "domain": null }, { "name": "TITLENO", "type": "esriFieldTypeString", "alias": "Title Number", "length": 50, "domain": null }, { "name": "VEHUSERCLASSCODE", "type": "esriFieldTypeString", "alias": "Vehicle User Class Code", "length": 50, "domain": { "type": "codedValue", "name": "rsVehUserClassCode", "description": "Vehicle User Class Code", "codedValues": [ { "name": "SUBCOMPACT AUTOMOBILE", "code": "10" }, { "name": "INTERMEDIATE AUTOMOBILE", "code": "15" }, { "name": "FULL SIZE AUTOMOBILE", "code": "20" }, { "name": "HYBRID AUTOMOBILES", "code": "25" }, { "name": "ELECTRIC AUTOMOBILE", "code": "26" }, { "name": "TRUCK, COMPACT 4X2", "code": "100" }, { "name": "TRUCK, COMPACT 4X4", "code": "101" }, { "name": "TRUCK, 1/2 TON", "code": "105" }, { "name": "TRUCK, 1/2 TON 4X4", "code": "110" }, { "name": "TRUCK, 3/4 TON 4X2", "code": "120" }, { "name": "TRUCK, 3/4 TON 4X4", "code": "125" }, { "name": "TRUCK, 1 TON 4X2", "code": "141" }, { "name": "TRUCK, 1 TON 4X4", "code": "146" }, { "name": "TRUCK, 1.5 TON 4X2", "code": "147" }, { "name": "TRUCK, 1.5 TON 4X4", "code": "148" }, { "name": "UTILITY VEH, ECONOMY 4X2", "code": "150" }, { "name": "UTILITY VEH, ECONOMY 4X4", "code": "155" }, { "name": "UTILITY VEH, ECON HYBRID", "code": "156" }, { "name": "CROSSOVER VEHICLE", "code": "160" }, { "name": "UTILITY VEH, FULLSIZE 4X2", "code": "162" }, { "name": "UTILITY VEHICLE, 4X2", "code": "163" }, { "name": "UTILITY VEH, FULLSIZE 4X4", "code": "164" }, { "name": "UTILITY VEHICLE, 4X4", "code": "165" }, { "name": "UTILITY VEHICLE, HYBRID", "code": "166" }, { "name": "VAN, MINI CARGO", "code": "170" }, { "name": "VAN, MINI PASSENGER", "code": "171" }, { "name": "VAN, 1/2 TON CARGO", "code": "175" }, { "name": "VAN, 1/2 TON PASSENGER", "code": "176" }, { "name": "VAN, 3/4 TON CARGO", "code": "177" }, { "name": "VAN, 3/4 PASSENGER", "code": "178" }, { "name": "VAN, 1 TON CARGO", "code": "180" }, { "name": "VAN, 1 TON PASSENGER", "code": "181" }, { "name": "VAN, 1 TON WALK THRU", "code": "182" }, { "name": "VAN, 1 TON AERIAL BUCKET", "code": "183" }, { "name": "VAN, 1 TON STEP", "code": "186" }, { "name": "VAN, 1 1/2 TON STEP", "code": "190" }, { "name": "VAN, 1 1/2 TON WALK THRU", "code": "191" }, { "name": "TRUCK, HVY 19,501-26,000", "code": "207" }, { "name": "TRUCK, HVY 26,001-33,000", "code": "208" }, { "name": "TRUCK, HVY 33,001-80,000", "code": "209" }, { "name": "TRAILER JOCKEY, DSL", "code": "243" }, { "name": "BUS", "code": "250" }, { "name": "TRENCHER", "code": "300" }, { "name": "TRACTOR, LOADER/BACKHOE", "code": "305" }, { "name": "LOADER/BACKHOE, CRAWLER", "code": "306" }, { "name": "WHEEL LOADER", "code": "308" }, { "name": "LOADER, SKID STEER", "code": "309" }, { "name": "DOZER/TRACTOR, CRAWLER", "code": "310" }, { "name": "GRADER", "code": "315" }, { "name": "PAVING MACHINE", "code": "316" }, { "name": "HYD EXC, TRUCK MTD DSL", "code": "320" }, { "name": "HYD EXC, CRAWLER MTD", "code": "325" }, { "name": "SAWS, HAND HELD", "code": "400" }, { "name": "EDGER/TRIMMER, LIGHT", "code": "402" }, { "name": "BLOWER", "code": "403" }, { "name": "EDGER/TRIMMER, HEAVY", "code": "404" }, { "name": "MOWER, NON-RIDING LIGHT", "code": "406" }, { "name": "MOWER, NON-RIDING HEAVY", "code": "407" }, { "name": "MOWER, RIDING", "code": "408" }, { "name": "ATTACHMENTS, RIDING MOWER", "code": "409" }, { "name": "MOWER, TRACTOR MTD HYD", "code": "410" }, { "name": "MOWER, TRACTOR MTD PTO/BE", "code": "415" }, { "name": "SAW, CONCRETE HEAVY", "code": "422" }, { "name": "COMPACTOR, HAND VIBRATORY", "code": "426" }, { "name": "ROLLER, HAND", "code": "428" }, { "name": "ROLLER, RIDING GAS", "code": "430" }, { "name": "MIXER, CEMENT", "code": "432" }, { "name": "SWEEPER, LIGHT", "code": "434" }, { "name": "SWEEPER, HEAVY", "code": "436" }, { "name": "CHIPPER, BRUSH DSL", "code": "439" }, { "name": "CART, UTILITY, 4X2", "code": "440" }, { "name": "CART, UTILITY, 4X4", "code": "441" }, { "name": "STUMP CUTTER", "code": "448" }, { "name": "TRACTOR, LIGHT DSL", "code": "450" }, { "name": "TRACTOR, LIGHT GAS", "code": "451" }, { "name": "TRACTOR, MOWING DSL", "code": "452" }, { "name": "TRACTOR, MOWING GAS", "code": "453" }, { "name": "TRACTOR WITH IMPLEMENT", "code": "455" }, { "name": "SHAKER", "code": "459" }, { "name": "BEACH RAKE", "code": "460" }, { "name": "MISC. MAINT. EQUIPMENT", "code": "490" }, { "name": "CRANE/YARD, MOBILE", "code": "502" }, { "name": "LIFT TRUCK, LIGHT", "code": "505" }, { "name": "LIFT TRUCK, MEDIUM", "code": "511" }, { "name": "LIFT TRUCK, HEAVY", "code": "515" }, { "name": "LIFT, PLATFORM", "code": "520" }, { "name": "TRAILER, TRANSPORT", "code": "530" }, { "name": "TRAILER, LIGHT UTILITY", "code": "531" }, { "name": "TRAILER, BOX", "code": "535" }, { "name": "TRAILER, UTILITY", "code": "540" }, { "name": "TRAILER, TANK", "code": "545" }, { "name": "TRAILER, FLATBED", "code": "550" }, { "name": "TRAILER, MISC. SERVICE", "code": "555" }, { "name": "TRAILER, BOAT", "code": "560" }, { "name": "PUMP, CENTRIFUGAL, PORT", "code": "600" }, { "name": "PUMP, CENTRIFUGAL, TRAIL", "code": "601" }, { "name": "PUMP, DIAPHRAM, PORT", "code": "602" }, { "name": "PUMP, DIAPHRAM, TRAIL", "code": "603" }, { "name": "PUMP, SUBMERSIBLE", "code": "604" }, { "name": "PUMP, STATIONARY", "code": "606" }, { "name": "COMPRESSOR, AIR", "code": "615" }, { "name": "WELDER, MOBILE", "code": "630" }, { "name": "GENERATOR, MOBILE CART", "code": "631" }, { "name": "GENERATOR, MOBILE", "code": "632" }, { "name": "SPRAYER/FOGGER, LIGHT", "code": "650" }, { "name": "SEWER CLEAN/ROD, LIGHT", "code": "660" }, { "name": "SEWER CLEAN/ROD, HEAVY", "code": "665" }, { "name": "ENGINE, OUTBOARD MARINE", "code": "680" }, { "name": "BOAT", "code": "687" }, { "name": "BARGE", "code": "688" }, { "name": "MISC. NON-MOTORIZED", "code": "690" }, { "name": "TRUCK, CRASH", "code": "800" }, { "name": "FIRE TRUCK", "code": "805" }, { "name": "TRUCK, RESCUE/AMBULANCE", "code": "810" }, { "name": "LIGHT TOWER", "code": "9999" }, { "name": "SHREDDER", "code": "9998" }, { "name": "MATERIAL HANDLER", "code": "9997" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GENUSERCLASSCODE", "type": "esriFieldTypeString", "alias": "General User Class Code", "length": 50, "domain": { "type": "codedValue", "name": "rsGenUserClassCode", "description": "General User Class Code", "codedValues": [ { "name": "MyCodeName", "code": "MyCodedValue" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CATCLASSCODE", "type": "esriFieldTypeString", "alias": "Category Class Code", "length": 50, "domain": { "type": "codedValue", "name": "rsCatClassCode", "description": "Category Class Code", "codedValues": [ { "name": "CAR", "code": "CA" }, { "name": "DEPARTMENT", "code": "DE" }, { "name": "GENERATORS/MOBILE", "code": "GN" }, { "name": "HEAVY EQUIPMENT", "code": "HE" }, { "name": "LIGHT TRUCK (0 - 15,000)", "code": "LT" }, { "name": "MEDIUM TRUCK (15,001 - 19,500)", "code": "MT" }, { "name": "HEAVY TRUCK (19,501- higher)", "code": "HT" }, { "name": "MARINE EQUIPMENT", "code": "ME" }, { "name": "PUMPS/MOBILE", "code": "PP" }, { "name": "SPECIAL EQUIPMENT", "code": "SE" }, { "name": "TRAILER", "code": "TR" }, { "name": "FTD", "code": "FTD" }, { "name": "UTILITY CART", "code": "UC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TANK", "type": "esriFieldTypeString", "alias": "Tank?", "length": 3, "domain": { "type": "codedValue", "name": "glblBoolean", "description": "Global Boolean", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FUELTYPECLASSCODE", "type": "esriFieldTypeString", "alias": "Fuel Type Class Code", "length": 50, "domain": { "type": "codedValue", "name": "rsFuelTypeClassCode", "description": "Fuel Type Class Code", "codedValues": [ { "name": "AVIATION FUEL", "code": "AVF" }, { "name": "BIO-DIESEL", "code": "BIO" }, { "name": "85% ETHANOL", "code": "E85" }, { "name": "ELECTRONIC", "code": "ELE" }, { "name": "PROPANE", "code": "LPG" }, { "name": "OFF-ROAD DIESEL EQUIPMENT", "code": "OFF" }, { "name": "ON-ROAD DIESEL EQUIPMENT", "code": "ON" }, { "name": "UNLEADED", "code": "UNL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WEIGHTCLASSCODE", "type": "esriFieldTypeString", "alias": "Weight Class Clode", "length": 50, "domain": { "type": "codedValue", "name": "rsWeightClassCode", "description": "Weight Class Code", "codedValues": [ { "name": "8,500 OR LESS GVW", "code": "CL1" }, { "name": "8,501 TO 10,000 GVW", "code": "CL2" }, { "name": "10,001 TO 14,000 GVW", "code": "CL3" }, { "name": "14,001 TO 16,000 GVW", "code": "CL4" }, { "name": "16,001 TO 19,500 GVW", "code": "CL5" }, { "name": "19,501 TO 26,000 GVW", "code": "CL6" }, { "name": "26,001 TO 33,000 GVW", "code": "CL7" }, { "name": "33,001 AND OVER GVW", "code": "CL8" }, { "name": "TRAILER UP TO 2,000 LBS", "code": "TR1" }, { "name": "TRAILER 2,001-3,500 LBS", "code": "TR2" }, { "name": "TRAILER 3,501-5,000 LBS", "code": "TR3" }, { "name": "TRAILER 5,001-12,000 LBS", "code": "TR4" }, { "name": "TRAILER 12,001 LBS AND UP", "code": "TR5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BODYTYPECLASSCODE", "type": "esriFieldTypeString", "alias": "Body Type Class Code", "length": 50, "domain": { "type": "codedValue", "name": "rsBodyTypeClassCode", "description": "Body Type Class Code", "codedValues": [ { "name": "ANIMAL BODY", "code": "AB" }, { "name": "AERIAL DEVICE", "code": "AD" }, { "name": "CRANE BODY", "code": "CB" }, { "name": "CROSS BODY FUEL TANK", "code": "CBFT" }, { "name": "CABLE LIFT BODY", "code": "CLB" }, { "name": "CONCRETE MIXER", "code": "CONC" }, { "name": "CUBE BODY", "code": "CUBE" }, { "name": "DUMP BODY LIFT GATE", "code": "DBLG" }, { "name": "DUMP BODY", "code": "DMP" }, { "name": "FLAT BED", "code": "FB" }, { "name": "FLAT BED WITH CRANE", "code": "FBC" }, { "name": "FLAT BED DUMP", "code": "FBD" }, { "name": "FLAT BED LIFT GATE", "code": "FBLG" }, { "name": "FREIGHT BODY", "code": "FRT" }, { "name": "FUEL TANKER", "code": "FTNK" }, { "name": "GARBAGE PACKER", "code": "GARB" }, { "name": "HAZ MAT", "code": "HZMT" }, { "name": "PLATFORM LIFT", "code": "PLLT" }, { "name": "PATCH BODY", "code": "PTCH" }, { "name": "PICKUP", "code": "PU" }, { "name": "SEWER CLEANER", "code": "SEW" }, { "name": "SLIDE BED", "code": "SLBD" }, { "name": "SPADE ATTACHMENT", "code": "SPAD" }, { "name": "STRIPER BODY", "code": "STR" }, { "name": "SWEEPER BODY", "code": "SWP" }, { "name": "TRACTOR", "code": "TR" }, { "name": "UTILITY BODY", "code": "UB" }, { "name": "VACUUM BODY", "code": "VAC" }, { "name": "VAN BODY", "code": "VAN" }, { "name": "WATER TANK", "code": "WT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FEMACLASSCODE1", "type": "esriFieldTypeString", "alias": "FEMA Class Code 1", "length": 50, "domain": null }, { "name": "FEMACLASSCODE2", "type": "esriFieldTypeString", "alias": "FEMA Class Code 2", "length": 50, "domain": null }, { "name": "FEMACLASSCODE3", "type": "esriFieldTypeString", "alias": "FEMA Class Code 3", "length": 50, "domain": null }, { "name": "FEMACLASSCODE4", "type": "esriFieldTypeString", "alias": "FEMA Class Code 4", "length": 50, "domain": null }, { "name": "MAINTCLASSCODE", "type": "esriFieldTypeString", "alias": "Maintenance Class Code", "length": 50, "domain": { "type": "codedValue", "name": "rsMaintClassCode", "description": "Maintenenace Class Code", "codedValues": [ { "name": "Quarterly", "code": "QUARTERLY" }, { "name": "Annually", "code": "ANNUALLY" }, { "name": "Semi-Annually", "code": "SEMIANNUALLY" }, { "name": "Triannually", "code": "TRIANNUALLY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTLOCCODE", "type": "esriFieldTypeString", "alias": "Maintenance Location Code", "length": 50, "domain": { "type": "codedValue", "name": "rsMaintLocCode", "description": "Maintenance Location Code", "codedValues": [ { "name": "142nd Sub Shop", "code": "142" }, { "name": "US 19 Sub Shop", "code": "19" }, { "name": "46th Street Sub Shop", "code": "46" }, { "name": "Central Garage", "code": "CG" }, { "name": "Central Garage Fuel Department", "code": "CGF" }, { "name": "Central Garage Generator Shop", "code": "GP" }, { "name": "Mobile Fuel Shop", "code": "MOB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "GPS", "type": "esriFieldTypeString", "alias": "GPS?", "length": 3, "domain": { "type": "codedValue", "name": "glblBoolean", "description": "Global Boolean", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VRP", "type": "esriFieldTypeString", "alias": "VRP", "length": 3, "domain": { "type": "codedValue", "name": "glblBoolean", "description": "Global Boolean", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNDEPTCODE", "type": "esriFieldTypeString", "alias": "Owner Department Code", "length": 50, "domain": null }, { "name": "USERDEPTCODE1", "type": "esriFieldTypeString", "alias": "Using Department Code 1", "length": 50, "domain": null }, { "name": "USERDEPTCODE2", "type": "esriFieldTypeString", "alias": "Using Department Code 2", "length": 50, "domain": null }, { "name": "USERDEPTCODE3", "type": "esriFieldTypeString", "alias": "Using Department Code 3", "length": 50, "domain": null }, { "name": "WARRANTYHELDBY", "type": "esriFieldTypeString", "alias": "Warranty Held By", "length": 50, "domain": null }, { "name": "PRIMARYMETER", "type": "esriFieldTypeString", "alias": "Primary Meter", "length": 50, "domain": null }, { "name": "PRIMMETERMEASURE", "type": "esriFieldTypeString", "alias": "Primary Meter Measurement", "length": 2, "domain": { "type": "codedValue", "name": "rsUsageMeasure", "description": "Roling Stock Usage Measurement", "codedValues": [ { "name": "Hours", "code": "H" }, { "name": "Mileage", "code": "M" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRIMARYMETERDATE", "type": "esriFieldTypeDate", "alias": "Primary Meter Date", "length": 8, "domain": null }, { "name": "PRIMMETERLTDUSAGE", "type": "esriFieldTypeString", "alias": "Primary Meter LTD Usage", "length": 50, "domain": null }, { "name": "SECONDMETER", "type": "esriFieldTypeDouble", "alias": "Secondary Meter", "domain": null }, { "name": "SECMETERMEASURE", "type": "esriFieldTypeString", "alias": "Secondary Meter Measurement", "length": 2, "domain": { "type": "codedValue", "name": "rsUsageMeasure", "description": "Roling Stock Usage Measurement", "codedValues": [ { "name": "Hours", "code": "H" }, { "name": "Mileage", "code": "M" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SECMETERDATE", "type": "esriFieldTypeDate", "alias": "Secondary Meter Date", "length": 8, "domain": null }, { "name": "SECMETERLTDUSAGE", "type": "esriFieldTypeString", "alias": "Secondary Meter LTD Usage", "length": 50, "domain": null }, { "name": "PRIMINSERVMETER", "type": "esriFieldTypeString", "alias": "Primary In-Service Meter", "length": 50, "domain": null }, { "name": "PRIMINSERVMETERMEASURE", "type": "esriFieldTypeString", "alias": "Primary In-Service Meter Measurement", "length": 2, "domain": { "type": "codedValue", "name": "rsUsageMeasure", "description": "Roling Stock Usage Measurement", "codedValues": [ { "name": "Hours", "code": "H" }, { "name": "Mileage", "code": "M" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SECINSERVMETER", "type": "esriFieldTypeString", "alias": "Secondary In-Service Meter", "length": 50, "domain": null }, { "name": "SECMINSERVMETERMEASURE", "type": "esriFieldTypeString", "alias": "Secondary In-Service Meter Measurement", "length": 2, "domain": { "type": "codedValue", "name": "rsUsageMeasure", "description": "Roling Stock Usage Measurement", "codedValues": [ { "name": "Hours", "code": "H" }, { "name": "Mileage", "code": "M" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRIMACQMETER", "type": "esriFieldTypeString", "alias": "Primary Acquisition Meter", "length": 50, "domain": null }, { "name": "PRIMACQMETERMEASURE", "type": "esriFieldTypeString", "alias": "Primary Acquisition Meter Measurement", "length": 2, "domain": { "type": "codedValue", "name": "rsUsageMeasure", "description": "Roling Stock Usage Measurement", "codedValues": [ { "name": "Hours", "code": "H" }, { "name": "Mileage", "code": "M" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SECACQMETER", "type": "esriFieldTypeString", "alias": "Secondary Acquisition Meter", "length": 50, "domain": null }, { "name": "SECACQMETERMEASURE", "type": "esriFieldTypeString", "alias": "Secondary Acquisition Meter Measurement", "length": 2, "domain": { "type": "codedValue", "name": "rsUsageMeasure", "description": "Roling Stock Usage Measurement", "codedValues": [ { "name": "Hours", "code": "H" }, { "name": "Mileage", "code": "M" }, { "name": "Not Applicable", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WARRANTYMILEAGE", "type": "esriFieldTypeDouble", "alias": "Warranty Mileage", "domain": null }, { "name": "DEPTERM", "type": "esriFieldTypeSmallInteger", "alias": "Depreciation Term (Number of Months)", "domain": null }, { "name": "FUSALVAGERATE", "type": "esriFieldTypeDouble", "alias": "Future Salvage Rate", "domain": null }, { "name": "SALVAGECOST", "type": "esriFieldTypeInteger", "alias": "Salvage Cost", "domain": null }, { "name": "SALEPRICE", "type": "esriFieldTypeInteger", "alias": "Sale Price", "domain": null }, { "name": "YEAR", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "VIN", "type": "esriFieldTypeString", "alias": "VIN", "length": 50, "domain": null }, { "name": "LICENSEPLATENUM", "type": "esriFieldTypeString", "alias": "License Plate Number", "length": 50, "domain": null }, { "name": "REPLACESUNITNUM", "type": "esriFieldTypeString", "alias": "Replaces Unit Number", "length": 50, "domain": null } ], "indexes": [ { "name": "R15_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G576ROLLINGSTOCK", "fields": "ROLLINGSTOCK_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "4e92b9041e6848ea8a331939f063cf03" }