{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "MCEHistoricEvents_PT", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 33, 137, 94, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2257866.1929426747, "ymin": 1202730.8770000003, "xmax": 2738585.8877717163, "ymax": 1905625.2848000005, "spatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MCESegmentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MCESegmentName", "type": "esriFieldTypeString", "alias": "MCE Segment Name", "length": 40, "domain": null }, { "name": "RWISStationName", "type": "esriFieldTypeString", "alias": "RWIS Station Name", "length": 30, "domain": null }, { "name": "EventID", "type": "esriFieldTypeSmallInteger", "alias": "Storm Event ID", "domain": null }, { "name": "EventSortOrder", "type": "esriFieldTypeSmallInteger", "alias": "MCE Event Sort Order", "domain": null }, { "name": "TechnicalEventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Event Technically Start Date-Time (UTC)", "length": 8, "domain": null }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Event Start Date-Time (UTC)", "length": 8, "domain": null }, { "name": "EventStartDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "Event Start Date-Time UTC Offset", "length": 6, "domain": null }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Event End Date-Time (UTC)", "length": 8, "domain": null }, { "name": "EventEndDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "Event End Date-Time UTC Offset", "length": 6, "domain": null }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "Event Start Date (Text)", "length": 10, "domain": null }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "Event Start Time (Text)", "length": 5, "domain": null }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "Event End Date (Text)", "length": 10, "domain": null }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "Event End Time (Text)", "length": 5, "domain": null }, { "name": "EventDurationHours", "type": "esriFieldTypeDouble", "alias": "Event Duration (Hours)", "domain": null }, { "name": "EventPollingCount", "type": "esriFieldTypeInteger", "alias": "Polling Count for Storm Event", "domain": null }, { "name": "EventPollingCount_CriteriaMet", "type": "esriFieldTypeInteger", "alias": "Polling Count for Storm Event (Criteria Met Only)", "domain": null }, { "name": "EventDurationHours_CriteriaMet", "type": "esriFieldTypeDouble", "alias": "Event Duration - Criteria Met Only (Hours)", "domain": null }, { "name": "EventPollingCount_MCE", "type": "esriFieldTypeInteger", "alias": "Polling Count for MCE Event", "domain": null }, { "name": "MaxWindSpeedRangeMPH", "type": "esriFieldTypeString", "alias": "Event Max Wind Speed Range (MPH)", "length": 15, "domain": null }, { "name": "PrecipitationHoursPollingCount", "type": "esriFieldTypeInteger", "alias": "Polling Count for Precipitation Hours", "domain": null }, { "name": "PrecipitationHours", "type": "esriFieldTypeDouble", "alias": "Event Precipitation Total Hours", "domain": null }, { "name": "MinRoadTempF", "type": "esriFieldTypeDouble", "alias": "Event Minimum Road Temp (F)", "domain": null }, { "name": "MaxRoadTempF", "type": "esriFieldTypeDouble", "alias": "Event Maximum Road Temp (F)", "domain": null }, { "name": "TargetLaneMilePercent", "type": "esriFieldTypeDouble", "alias": "Target Lane Mile Percentage", "domain": null }, { "name": "MCEEvent", "type": "esriFieldTypeString", "alias": "MCE Event (Yes/No)", "length": 3, "domain": null }, { "name": "MCEIndex", "type": "esriFieldTypeDouble", "alias": "MCE Index", "domain": null }, { "name": "MCEReduction", "type": "esriFieldTypeDouble", "alias": "MCE Reduction", "domain": null }, { "name": "MCEScoreType", "type": "esriFieldTypeString", "alias": "MCE Score Type", "length": 10, "domain": null }, { "name": "MCEScore", "type": "esriFieldTypeDouble", "alias": "MCE Score", "domain": null }, { "name": "AchievementCategory", "type": "esriFieldTypeString", "alias": "Event Achievement Category", "length": 33, "domain": null }, { "name": "MobilityHours", "type": "esriFieldTypeDouble", "alias": "Mobility Hours", "domain": null }, { "name": "MobilityCounter", "type": "esriFieldTypeSmallInteger", "alias": "Mobility Counter", "domain": null }, { "name": "MobilityPercentage", "type": "esriFieldTypeDouble", "alias": "Mobility Percentage", "domain": null }, { "name": "WPICounter", "type": "esriFieldTypeSmallInteger", "alias": "WPI Counter", "domain": null }, { "name": "WPIHours", "type": "esriFieldTypeDouble", "alias": "WPI Hours", "domain": null }, { "name": "WPIPercentage", "type": "esriFieldTypeDouble", "alias": "WPI Percentage", "domain": null }, { "name": "RWISStationID", "type": "esriFieldTypeInteger", "alias": "RWIS Station ID", "domain": null }, { "name": "RWISCycleLastDateTimeUTC", "type": "esriFieldTypeDate", "alias": "RWIS Sensor Last Date-Time (UTC)", "length": 8, "domain": null }, { "name": "RWISDownTimeHours", "type": "esriFieldTypeDouble", "alias": "RWIS Down Time Hours", "domain": null }, { "name": "RWISDownTimeCounter", "type": "esriFieldTypeInteger", "alias": "RWIS Down Time Counter", "domain": null }, { "name": "RWISIssue", "type": "esriFieldTypeString", "alias": "RWIS Issue (Yes/No)", "length": 3, "domain": null }, { "name": "DualCarriage", "type": "esriFieldTypeSmallInteger", "alias": "Dual Carriage MCE Segment", "domain": null }, { "name": "TravelDirection", "type": "esriFieldTypeString", "alias": "Travel Direction", "length": 10, "domain": null }, { "name": "RouteID", "type": "esriFieldTypeString", "alias": "Route ID", "length": 12, "domain": null }, { "name": "CommonRouteName", "type": "esriFieldTypeString", "alias": "Common Route Name", "length": 120, "domain": null }, { "name": "FromMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment From Measure", "domain": null }, { "name": "ToMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment To Measure", "domain": null }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null }, { "name": "DOT_MaintDistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD Maintenance District Number", "domain": null }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "ITD Foreman Area", "domain": null }, { "name": "LatitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Latitude (WGS84 - DD)", "domain": null }, { "name": "LongitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Longitude (WGS84 -DD)", "domain": null }, { "name": "RWISAltitudeFeet", "type": "esriFieldTypeDouble", "alias": "RWIS Station Altitude (Feet)", "domain": null }, { "name": "RWISMeasure", "type": "esriFieldTypeDouble", "alias": "RWIS Station Measure", "domain": null }, { "name": "MCEYear", "type": "esriFieldTypeSmallInteger", "alias": "MCE Segment Year", "domain": null }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "County Name", "length": 10, "domain": null }, { "name": "CountyFIPS", "type": "esriFieldTypeString", "alias": "County FIPS", "length": 3, "domain": null }, { "name": "SegmentLengthMile", "type": "esriFieldTypeDouble", "alias": "Segment Length (Mile - UTM83-ITD)", "domain": null }, { "name": "LaneMiles", "type": "esriFieldTypeDouble", "alias": "Lane Miles", "domain": null }, { "name": "MaterialQuantityTotal_Solid", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Applied (Tons)", "domain": null }, { "name": "MaterialQuantityTotal_Liquid", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Applied (Gal)", "domain": null }, { "name": "MaterialQuantityTotal_PreWet", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Applied (Gal)", "domain": null }, { "name": "MaterialSolid_Salt_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_Salt_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt Usage (Tons)", "domain": null }, { "name": "MaterialSolid_IceSlicer_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Slicer Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_IceSlicer_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SaltSand21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 2:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SaltSand21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SaltSand31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 3:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SaltSand31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt11_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 1:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt11_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 2:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 3:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt41_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 4:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt41_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_IceKicker_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Kicker Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_IceKicker_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Usage (Tons)", "domain": null }, { "name": "MaterialSolid_Sand_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_Sand_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand Usage (Tons)", "domain": null }, { "name": "MaterialPreWet_Brine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Brine Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_Brine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_MgCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet MgCl Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_MgCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_CaCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet CaCl Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_CaCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_BoostBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Boost Brine Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_BoostBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Boost Brine Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_GeoBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Geomelt Brine Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_GeoBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BrineDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BrineDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_MgClDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCl/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_MgClDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BoostDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BoostDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_GeoDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_GeoDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BrineAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BrineAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_MgClAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCL/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_MgClAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BoostAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BoostAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_GeoAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_GeoAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Usage (Gal)", "domain": null }, { "name": "TruckIDList", "type": "esriFieldTypeString", "alias": "List of Trucks Used During Event", "length": 200, "domain": null }, { "name": "OperatorIDList", "type": "esriFieldTypeString", "alias": "List of Operators Used During Event", "length": 200, "domain": null }, { "name": "TargetMaterial_Solid_Usage", "type": "esriFieldTypeDouble", "alias": "Target Material Solid Usage (Tons)", "domain": null }, { "name": "TargetMaterial_Liquid_Usage", "type": "esriFieldTypeDouble", "alias": "Target Material Liquid Usage (Gal)", "domain": null }, { "name": "TargetMaterial_PreWet_Usage", "type": "esriFieldTypeDouble", "alias": "Target Material PreWet Usage (Gal)", "domain": null }, { "name": "LaborHours_Actual", "type": "esriFieldTypeDouble", "alias": "Labor Hours - Actual", "domain": null }, { "name": "LaborHours_Target", "type": "esriFieldTypeDouble", "alias": "Labor Hours - Target", "domain": null }, { "name": "EquipmentMiles_Actual", "type": "esriFieldTypeDouble", "alias": "Equipment Miles - Actual", "domain": null }, { "name": "EquipmentMiles_Target", "type": "esriFieldTypeDouble", "alias": "Equipment Miles - Target", "domain": null }, { "name": "NumberPasses", "type": "esriFieldTypeSmallInteger", "alias": "Number of Passes on Segment", "domain": null }, { "name": "AVLDataAvailable", "type": "esriFieldTypeString", "alias": "AVL Data Available after 12 Hours", "length": 3, "domain": null }, { "name": "InvalidStockPileIDPresent", "type": "esriFieldTypeString", "alias": "Invalid Stockpile IDs Present", "length": 3, "domain": null }, { "name": "EventNotes", "type": "esriFieldTypeString", "alias": "Event Notes", "length": 500, "domain": null }, { "name": "FMECode", "type": "esriFieldTypeSmallInteger", "alias": "FME Code Used for Calculations", "domain": null }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "Service Last Updated (UTC)", "length": 8, "domain": null }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "Service Last Updated UTC Offset", "length": 6, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "TargetCost", "type": "esriFieldTypeDouble", "alias": "Target Cost ($)", "domain": null }, { "name": "ActualCost", "type": "esriFieldTypeDouble", "alias": "Actual Cost ($)", "domain": null }, { "name": "MaterialSolid_Salt_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt Cost ($)", "domain": null }, { "name": "MaterialSolid_IceSlicer_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Cost ($)", "domain": null }, { "name": "MaterialSolid_SaltSand21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SaltSand31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt11_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt41_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_IceKicker_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Cost ($)", "domain": null }, { "name": "MaterialSolid_Sand_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand Cost ($)", "domain": null }, { "name": "MaterialPreWet_Brine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Cost ($)", "domain": null }, { "name": "MaterialPreWet_MgCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Cost ($)", "domain": null }, { "name": "MaterialPreWet_CaCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Cost ($)", "domain": null }, { "name": "MaterialPreWet_BoostBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Eent PreWet Boost Brine Cost ($)", "domain": null }, { "name": "MaterialPreWet_GeoBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Cost ($)", "domain": null }, { "name": "MaterialLiquid_BrineDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_MgClDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_BoostDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_GeoDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_BrineAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_MgClAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_BoostAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_GeoAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Cost ($)", "domain": null }, { "name": "TargetMaterial_Solid_Cost", "type": "esriFieldTypeDouble", "alias": "Target Material Solid Cost ($)", "domain": null }, { "name": "TargetMaterial_Liquid_Cost", "type": "esriFieldTypeDouble", "alias": "Target Material Liquid Cost ($)", "domain": null }, { "name": "TargetMaterial_PreWet_Cost", "type": "esriFieldTypeDouble", "alias": "Target Material PreWet Cost ($)", "domain": null }, { "name": "BackgroundColor", "type": "esriFieldTypeString", "alias": "Background Color (Dashboard)", "length": 10, "domain": null }, { "name": "TextColor", "type": "esriFieldTypeString", "alias": "Text Color (Dashboard)", "length": 10, "domain": null }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "length": 8, "domain": null }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "length": 8, "domain": null }, { "name": "FrostEvent", "type": "esriFieldTypeString", "alias": "Frost Event", "length": 3, "domain": null }, { "name": "MCELiveOID", "type": "esriFieldTypeInteger", "alias": "MCELive ObjectID", "domain": null }, { "name": "TotalMaterial_Solid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Cost ($)", "domain": null }, { "name": "TotalMaterial_Liquid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Cost ($)", "domain": null }, { "name": "TotalMaterial_PreWet_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Cost ($)", "domain": null }, { "name": "FrostPollingCount", "type": "esriFieldTypeSmallInteger", "alias": "Frost Polling Count", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R48_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S30_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Operations.GIS_WEBUSER.MCEHistoric_EventDetails", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "MCELiveOID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6D6999BE-0AC9-4B5A-8DAE-DE40CFCDEC28}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "e379e0a5845b4207b47631a18a2bc54d" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "MCESegments", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 150, 136, 45, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2257333.2592, "ymin": 1200974.2594000008, "xmax": 2739825.7802, "ymax": 1972821.6764000002, "spatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MCESegmentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MCESegmentName", "type": "esriFieldTypeString", "alias": "MCE Segment Name", "length": 40, "domain": null }, { "name": "RWISStationName", "type": "esriFieldTypeString", "alias": "RWIS Station Name", "length": 30, "domain": null }, { "name": "RWISStationID", "type": "esriFieldTypeInteger", "alias": "RWIS Station ID", "domain": null }, { "name": "TravelDirection", "type": "esriFieldTypeString", "alias": "Travel Direction", "length": 10, "domain": null }, { "name": "RouteID", "type": "esriFieldTypeString", "alias": "Route ID", "length": 12, "domain": null }, { "name": "CommonRouteName", "type": "esriFieldTypeString", "alias": "Common Route Name", "length": 120, "domain": null }, { "name": "FromMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment From Measure", "domain": null }, { "name": "ToMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment To Measure", "domain": null }, { "name": "DOT_MaintDistrictNumber", "type": "esriFieldTypeInteger", "alias": "ITD Maintenance District Number", "domain": null }, { "name": "LatitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Latitude (WGS84 - DD)", "domain": null }, { "name": "LongitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Longitude (WGS84 -DD)", "domain": null }, { "name": "RWISAltitudeFeet", "type": "esriFieldTypeDouble", "alias": "RWIS Station Altitude (Feet)", "domain": null }, { "name": "RWISMeasure", "type": "esriFieldTypeDouble", "alias": "RWIS Station Measure", "domain": null }, { "name": "MCEYear", "type": "esriFieldTypeInteger", "alias": "MCE Segment Year", "domain": null }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "County Name", "length": 10, "domain": null }, { "name": "CountyFIPS", "type": "esriFieldTypeString", "alias": "County FIPS", "length": 3, "domain": null }, { "name": "SegmentLengthMile", "type": "esriFieldTypeDouble", "alias": "Segment Length (Mile - UTM83-ITD)", "domain": null }, { "name": "LaneMiles", "type": "esriFieldTypeDouble", "alias": "Lane Miles", "domain": null }, { "name": "DualCarriage", "type": "esriFieldTypeSmallInteger", "alias": "Dual Carriage MCE Segment", "domain": null }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "ITD Foreman Area", "domain": null }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "Service Last Updated (UTC)", "length": 8, "domain": null }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "Service Last Updated UTC Offset", "length": 6, "domain": null }, { "name": "MCESegmentType", "type": "esriFieldTypeString", "alias": "MCE Segment Type", "length": 15, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R19_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S8_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "e379e0a5845b4207b47631a18a2bc54d" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "SnowRoutes_HistoricEvents_PT", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 71, 150, 37, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2257866.2380999997, "ymin": 1202730.8770000003, "xmax": 2738585.8329999996, "ymax": 1905625.2848000005, "spatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Segment511Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RWIS_Storm_Key", "type": "esriFieldTypeString", "alias": "RWIS_Storm_Key", "length": 200, "domain": null }, { "name": "Segment511Number", "type": "esriFieldTypeDouble", "alias": "Segment511Number", "domain": null }, { "name": "Segment511Name", "type": "esriFieldTypeString", "alias": "Segment511Name", "length": 45, "domain": null }, { "name": "Segment511RouteId", "type": "esriFieldTypeString", "alias": "Segment511RouteId", "length": 12, "domain": null }, { "name": "Segment511CommonRouteName", "type": "esriFieldTypeString", "alias": "Segment511CommonRouteName", "length": 7, "domain": null }, { "name": "Segment511FromMeasure", "type": "esriFieldTypeDouble", "alias": "Segment511FromMeasure", "domain": null }, { "name": "Segment511ToMeasure", "type": "esriFieldTypeDouble", "alias": "Segment511ToMeasure", "domain": null }, { "name": "StormObjectID", "type": "esriFieldTypeInteger", "alias": "StormObjectID", "domain": null }, { "name": "StormEventID", "type": "esriFieldTypeSmallInteger", "alias": "StormEventID", "domain": null }, { "name": "TechnicalEventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "TechnicalEventStartDateTimeUTC", "length": 8, "domain": null }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventStartDateTimeUTC", "length": 8, "domain": null }, { "name": "EventStartDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "EventStartDateTimeUTCOffset", "length": 6, "domain": null }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventEndDateTimeUTC", "length": 8, "domain": null }, { "name": "EventEndDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "EventEndDateTimeUTCOffset", "length": 6, "domain": null }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "EventStartDateText", "length": 10, "domain": null }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "EventStartTimeText", "length": 5, "domain": null }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "EventEndDateText", "length": 10, "domain": null }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "EventEndTimeText", "length": 5, "domain": null }, { "name": "EventDurationHours", "type": "esriFieldTypeDouble", "alias": "EventDurationHours", "domain": null }, { "name": "EventPollingCount", "type": "esriFieldTypeInteger", "alias": "EventPollingCount", "domain": null }, { "name": "EventPollingCount_CriteriaMet", "type": "esriFieldTypeInteger", "alias": "EventPollingCount_CriteriaMet", "domain": null }, { "name": "EventDurationHours_CriteriaMet", "type": "esriFieldTypeDouble", "alias": "EventDurationHours_CriteriaMet", "domain": null }, { "name": "MaxWindSpeedRangeMPH", "type": "esriFieldTypeString", "alias": "MaxWindSpeedRangeMPH", "length": 15, "domain": null }, { "name": "PrecipitationHoursPollingCount", "type": "esriFieldTypeInteger", "alias": "PrecipitationHoursPollingCount", "domain": null }, { "name": "PrecipitationHours", "type": "esriFieldTypeDouble", "alias": "PrecipitationHours", "domain": null }, { "name": "MinRoadTempF", "type": "esriFieldTypeDouble", "alias": "MinRoadTempF", "domain": null }, { "name": "MaxRoadTempF", "type": "esriFieldTypeDouble", "alias": "MaxRoadTempF", "domain": null }, { "name": "MCEEvent", "type": "esriFieldTypeString", "alias": "MCEEvent", "length": 3, "domain": null }, { "name": "RWISStationID", "type": "esriFieldTypeInteger", "alias": "RWISStationID", "domain": null }, { "name": "RWISStationName", "type": "esriFieldTypeString", "alias": "RWISStationName", "length": 30, "domain": null }, { "name": "RWISCycleLastDateTimeUTC", "type": "esriFieldTypeDate", "alias": "RWISCycleLastDateTimeUTC", "length": 8, "domain": null }, { "name": "RWISDownTimeHours", "type": "esriFieldTypeDouble", "alias": "RWISDownTimeHours", "domain": null }, { "name": "RWISDownTimeCounter", "type": "esriFieldTypeInteger", "alias": "RWISDownTimeCounter", "domain": null }, { "name": "RWISIssue", "type": "esriFieldTypeString", "alias": "RWISIssue", "length": 3, "domain": null }, { "name": "LatitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "LatitudeDD_RWIS", "domain": null }, { "name": "LongitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "LongitudeDD_RWIS", "domain": null }, { "name": "RWISAltitudeFeet", "type": "esriFieldTypeDouble", "alias": "RWISAltitudeFeet", "domain": null }, { "name": "SegmentYear", "type": "esriFieldTypeSmallInteger", "alias": "SegmentYear", "domain": null }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "CountyName", "length": 10, "domain": null }, { "name": "CountyFIPS", "type": "esriFieldTypeString", "alias": "CountyFIPS", "length": 3, "domain": null }, { "name": "SegmentLength", "type": "esriFieldTypeString", "alias": "SegmentLength", "length": 200, "domain": null }, { "name": "LaneMiles", "type": "esriFieldTypeString", "alias": "LaneMiles", "length": 200, "domain": null }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "DOT_ForemanArea", "domain": null }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeDouble", "alias": "DOT_DistrictNumber", "domain": null }, { "name": "LaborHours_Actual", "type": "esriFieldTypeDouble", "alias": "LaborHours_Actual", "domain": null }, { "name": "EquipmentMiles_Actual", "type": "esriFieldTypeDouble", "alias": "EquipmentMiles_Actual", "domain": null }, { "name": "NumberPasses", "type": "esriFieldTypeSmallInteger", "alias": "NumberPasses", "domain": null }, { "name": "AVLDataAvailable", "type": "esriFieldTypeString", "alias": "AVLDataAvailable", "length": 3, "domain": null }, { "name": "EventNotes", "type": "esriFieldTypeString", "alias": "EventNotes", "length": 500, "domain": null }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "length": 8, "domain": null }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "length": 8, "domain": null }, { "name": "FrostEvent", "type": "esriFieldTypeString", "alias": "FrostEvent", "length": 3, "domain": null }, { "name": "FMECode", "type": "esriFieldTypeSmallInteger", "alias": "FMECode", "domain": null }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "ServiceLastUpdatedUTC", "length": 8, "domain": null }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "ServiceLastUpdatedUTCOffset", "length": 6, "domain": null }, { "name": "BackgroundColor", "type": "esriFieldTypeString", "alias": "BackgroundColor", "length": 10, "domain": null }, { "name": "TextColor", "type": "esriFieldTypeString", "alias": "TextColor", "length": 10, "domain": null }, { "name": "DOT_MaintDistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD Maintenance District Number", "domain": null }, { "name": "RWISMeasure", "type": "esriFieldTypeDouble", "alias": "RWIS Station Measure", "domain": null }, { "name": "MaterialQuantityTotal_Solid", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Applied (Tons)", "domain": null }, { "name": "MaterialQuantityTotal_Liquid", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Applied (Gal)", "domain": null }, { "name": "MaterialQuantityTotal_PreWet", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Applied (Gal)", "domain": null }, { "name": "MaterialSolid_Salt_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_Salt_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt Usage (Tons)", "domain": null }, { "name": "MaterialSolid_IceSlicer_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Slicer Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_IceSlicer_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SaltSand21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 2:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SaltSand21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SaltSand31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 3:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SaltSand31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt11_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 1:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt11_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 2:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 3:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_SandSalt41_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 4:1 Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_SandSalt41_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Usage (Tons)", "domain": null }, { "name": "MaterialSolid_IceKicker_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Kicker Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_IceKicker_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Usage (Tons)", "domain": null }, { "name": "MaterialSolid_Sand_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialSolid_Sand_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand Usage (Tons)", "domain": null }, { "name": "MaterialPreWet_Brine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Brine Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_Brine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_MgCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet MgCl Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_MgCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_CaCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet CaCl Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_CaCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_BoostBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Boost Brine Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_BoostBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Boost Brine Usage (Gal)", "domain": null }, { "name": "MaterialPreWet_GeoBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Geomelt Brine Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialPreWet_GeoBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BrineDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BrineDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_MgClDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCl/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_MgClDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BoostDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BoostDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_GeoDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/De-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_GeoDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BrineAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BrineAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_MgClAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCL/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_MgClAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_BoostAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_BoostAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Usage (Gal)", "domain": null }, { "name": "MaterialLiquid_GeoAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/Anti-Icing Stockpile IDs", "length": 150, "domain": null }, { "name": "MaterialLiquid_GeoAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Usage (Gal)", "domain": null }, { "name": "ActualCost", "type": "esriFieldTypeDouble", "alias": "Actual Cost ($)", "domain": null }, { "name": "MaterialSolid_Salt_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt Cost ($)", "domain": null }, { "name": "MaterialSolid_IceSlicer_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Cost ($)", "domain": null }, { "name": "MaterialSolid_SaltSand21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SaltSand31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt11_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_SandSalt41_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Cost ($)", "domain": null }, { "name": "MaterialSolid_IceKicker_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Cost ($)", "domain": null }, { "name": "MaterialSolid_Sand_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand Cost ($)", "domain": null }, { "name": "MaterialPreWet_Brine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Cost ($)", "domain": null }, { "name": "MaterialPreWet_MgCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Cost ($)", "domain": null }, { "name": "MaterialPreWet_CaCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Cost ($)", "domain": null }, { "name": "MaterialPreWet_BoostBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Boost Brine Cost ($)", "domain": null }, { "name": "MaterialPreWet_GeoBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Cost ($)", "domain": null }, { "name": "MaterialLiquid_BrineDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_MgClDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_BoostDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_GeoDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_BrineAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_MgClAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_BoostAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Cost ($)", "domain": null }, { "name": "MaterialLiquid_GeoAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Cost ($)", "domain": null }, { "name": "TotalMaterial_Solid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Cost ($)", "domain": null }, { "name": "TotalMaterial_Liquid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Cost ($)", "domain": null }, { "name": "TotalMaterial_PreWet_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Cost ($)", "domain": null }, { "name": "AVLProcessed", "type": "esriFieldTypeSmallInteger", "alias": "AVLProcessed", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R70_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4128_RWIS_St", "fields": "RWIS_Storm_Key", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S46_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Operations.GIS_WEBUSER.SnowRoutes_EventDetails", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "RWIS_Storm_Key", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DED3FE54-9594-4F84-8BA7-28767345C3A6}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "e379e0a5845b4207b47631a18a2bc54d" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Materials_Costs", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StockpileName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "STOCK_ID", "type": "esriFieldTypeDouble", "alias": "STOCK_ID", "domain": null }, { "name": "StockpileName", "type": "esriFieldTypeString", "alias": "StockpileName", "length": 255, "domain": null }, { "name": "COMMON_NAME", "type": "esriFieldTypeString", "alias": "COMMON_NAME", "length": 255, "domain": null }, { "name": "CURR_AMOUNT", "type": "esriFieldTypeDouble", "alias": "CURR_AMOUNT", "domain": null }, { "name": "MASTER_CODE_ID", "type": "esriFieldTypeDouble", "alias": "MASTER_CODE_ID", "domain": null }, { "name": "TOTAL_COST", "type": "esriFieldTypeDouble", "alias": "TOTAL_COST", "domain": null }, { "name": "UNIT_ID", "type": "esriFieldTypeDouble", "alias": "UNIT_ID", "domain": null }, { "name": "UNIT_COST", "type": "esriFieldTypeDouble", "alias": "UNIT_COST", "domain": null }, { "name": "MASTER_CODE_NAME", "type": "esriFieldTypeString", "alias": "MASTER_CODE_NAME", "length": 255, "domain": null }, { "name": "FinalUnitCost", "type": "esriFieldTypeDouble", "alias": "FinalUnitCost", "domain": null } ], "indexes": [ { "name": "R80_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "mci_idx", "fields": "MASTER_CODE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "stk_idx", "fields": "STOCK_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "cn_idx", "fields": "COMMON_NAME", "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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": "e379e0a5845b4207b47631a18a2bc54d" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "MCE_DefaultMaterialCost", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MaterialName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MCEYear", "type": "esriFieldTypeSmallInteger", "alias": "MCEYear", "domain": null }, { "name": "MaterialSubType", "type": "esriFieldTypeString", "alias": "MaterialSubType", "length": 10, "domain": null }, { "name": "MaterialName", "type": "esriFieldTypeString", "alias": "MaterialName", "length": 25, "domain": null }, { "name": "CPSMaterialName", "type": "esriFieldTypeString", "alias": "CPSMaterialName", "length": 15, "domain": null }, { "name": "UnitType", "type": "esriFieldTypeString", "alias": "UnitType", "length": 3, "domain": null }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null }, { "name": "MaterialUnitCost", "type": "esriFieldTypeDouble", "alias": "MaterialUnitCost", "domain": null }, { "name": "TableLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "TableLastUpdated", "length": 8, "domain": null }, { "name": "TableLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "TableLastUpdatedUTCOffset", "length": 6, "domain": null } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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": "e379e0a5845b4207b47631a18a2bc54d" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "RWIS_HistoricData", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StationName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StationID", "type": "esriFieldTypeInteger", "alias": "Station ID", "domain": null }, { "name": "StationName", "type": "esriFieldTypeString", "alias": "Station Name", "length": 30, "domain": null }, { "name": "SensorValueDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Sensor Value Date-Time (UTC)", "length": 8, "domain": null }, { "name": "SensorValueDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "Sensor Value Date-Time UTC Offset", "length": 6, "domain": null }, { "name": "SensorValueDateTimeLocal", "type": "esriFieldTypeDate", "alias": "Sensor Value Date-Time (Local)", "length": 8, "domain": null }, { "name": "SensorValueDateTimeLocalZone", "type": "esriFieldTypeString", "alias": "Sensor Value Date-Time Local Timezone", "length": 3, "domain": null }, { "name": "GeneralStatusCode", "type": "esriFieldTypeInteger", "alias": "General Status Code", "domain": null }, { "name": "GeneralStatusDesc", "type": "esriFieldTypeString", "alias": "General Status Description", "length": 11, "domain": null }, { "name": "AirTempF", "type": "esriFieldTypeDouble", "alias": "Air Temperature (F)", "domain": null }, { "name": "AirTempC", "type": "esriFieldTypeDouble", "alias": "Air Temperature (C)", "domain": null }, { "name": "DewTempF", "type": "esriFieldTypeDouble", "alias": "Dew Temperature (F)", "domain": null }, { "name": "DewTempC", "type": "esriFieldTypeDouble", "alias": "Dew Temperature (C)", "domain": null }, { "name": "BaseTempF", "type": "esriFieldTypeDouble", "alias": "Base Temperature (F)", "domain": null }, { "name": "BaseTempC", "type": "esriFieldTypeDouble", "alias": "Base Temperature (C)", "domain": null }, { "name": "PressureINHg", "type": "esriFieldTypeDouble", "alias": "Pressure (IN Hg)", "domain": null }, { "name": "RelativeHumidity", "type": "esriFieldTypeDouble", "alias": "Relative Humidity (%)", "domain": null }, { "name": "IceLayer1IN", "type": "esriFieldTypeDouble", "alias": "Ice Layer 1 (Inch)", "domain": null }, { "name": "IceLayer2IN", "type": "esriFieldTypeDouble", "alias": "Ice Layer 2 (Inch)", "domain": null }, { "name": "GripLevelPercent1", "type": "esriFieldTypeDouble", "alias": "Grip Level Percentage (1)", "domain": null }, { "name": "GripLevelPercent2", "type": "esriFieldTypeDouble", "alias": "Grip Level Percentage (2)", "domain": null }, { "name": "PresentWeatherCode", "type": "esriFieldTypeInteger", "alias": "Present Weather Code", "domain": null }, { "name": "PresentWeatherDesc", "type": "esriFieldTypeString", "alias": "Present Weather Description", "length": 150, "domain": null }, { "name": "RainPresentCode", "type": "esriFieldTypeInteger", "alias": "Rain Present Code", "domain": null }, { "name": "RainPresentDesc", "type": "esriFieldTypeString", "alias": "Rain Present Description", "length": 20, "domain": null }, { "name": "RainIntensityIN_HR", "type": "esriFieldTypeDouble", "alias": "Rain Intensity (Inches/Hour)", "domain": null }, { "name": "RainStateCode", "type": "esriFieldTypeInteger", "alias": "Rain State Code", "domain": null }, { "name": "RainStateDesc", "type": "esriFieldTypeString", "alias": "Rain State Description", "length": 40, "domain": null }, { "name": "EventPrecipTotalIN", "type": "esriFieldTypeDouble", "alias": "Event Precipitation Total (Inches)", "domain": null }, { "name": "PrecipTotalIN_1HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 1 Hour (Inches)", "domain": null }, { "name": "PrecipTotalIN_3HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 3 Hours (Inches)", "domain": null }, { "name": "PrecipTotalIN_6HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 6 Hours (Inches)", "domain": null }, { "name": "PrecipTotalIN_12HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 12 Hours (Inches)", "domain": null }, { "name": "PrecipTotalIN_24HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 24 Hours (Inches)", "domain": null }, { "name": "SnowHeightIN", "type": "esriFieldTypeDouble", "alias": "Snow Height Off Roadway (Inches)", "domain": null }, { "name": "SnowLayerIN1", "type": "esriFieldTypeDouble", "alias": "Snow Layer 1 (Inch)", "domain": null }, { "name": "SnowLayerIN2", "type": "esriFieldTypeDouble", "alias": "Snow Layer 2 (Inch)", "domain": null }, { "name": "SurfaceTempF", "type": "esriFieldTypeDouble", "alias": "Surface Temperature (F)", "domain": null }, { "name": "SurfaceTempC", "type": "esriFieldTypeDouble", "alias": "Surface Temperature (C)", "domain": null }, { "name": "SurfaceStateCode1", "type": "esriFieldTypeInteger", "alias": "Surface State Code (1)", "domain": null }, { "name": "SurfaceStateDesc1", "type": "esriFieldTypeString", "alias": "Surface State Description (1)", "length": 40, "domain": null }, { "name": "SurfaceStateCode2", "type": "esriFieldTypeInteger", "alias": "Surface State Code (2)", "domain": null }, { "name": "SurfaceStateDesc2", "type": "esriFieldTypeString", "alias": "Surface State Description (2)", "length": 40, "domain": null }, { "name": "SurfaceFriction", "type": "esriFieldTypeString", "alias": "Surface Friction", "length": 20, "domain": null }, { "name": "SubSurfaceTempF", "type": "esriFieldTypeDouble", "alias": "Sub-Surface Temp (F)", "domain": null }, { "name": "VisibilityMile", "type": "esriFieldTypeDouble", "alias": "Visibility (Miles)", "domain": null }, { "name": "WindDirectionDeg", "type": "esriFieldTypeDouble", "alias": "Wind Direction Degree (Average)", "domain": null }, { "name": "MaxWindDirectionDeg", "type": "esriFieldTypeDouble", "alias": "Wind Direction Degree (Gust)", "domain": null }, { "name": "WindSpeedMPH", "type": "esriFieldTypeDouble", "alias": "Average Wind Speed (MPH)", "domain": null }, { "name": "MaxWindSpeedMPH", "type": "esriFieldTypeDouble", "alias": "Wind Speed (Gust) (MPH)", "domain": null }, { "name": "CloudStatusCode", "type": "esriFieldTypeInteger", "alias": "Cloud Status Code", "domain": null }, { "name": "CloudStatusDesc", "type": "esriFieldTypeString", "alias": "Cloud Status Description", "length": 25, "domain": null }, { "name": "WaterLayerIN1", "type": "esriFieldTypeDouble", "alias": "Water Layer (Inches) (1)", "domain": null }, { "name": "WaterLayerIN2", "type": "esriFieldTypeDouble", "alias": "Water Layer (Inches) (2)", "domain": null }, { "name": "WaterThicknessIN", "type": "esriFieldTypeDouble", "alias": "Water Thickness (Inches)", "domain": null }, { "name": "ImageURL_1", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 1", "length": 254, "domain": null }, { "name": "ImagePosition_1", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 1 Position", "length": 20, "domain": null }, { "name": "ImageURL_2", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 2", "length": 254, "domain": null }, { "name": "ImagePosition_2", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 2 Position", "length": 20, "domain": null }, { "name": "ImageURL_3", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 3", "length": 254, "domain": null }, { "name": "ImagePosition_3", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 3 Position", "length": 20, "domain": null }, { "name": "ImageURL_4", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 4", "length": 254, "domain": null }, { "name": "ImagePosition_4", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 4 Position", "length": 20, "domain": null }, { "name": "ImageURL_5", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 5", "length": 254, "domain": null }, { "name": "ImagePosition_5", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 5 Position", "length": 20, "domain": null }, { "name": "AlarmStatusCode1", "type": "esriFieldTypeInteger", "alias": "Alarm Status Code (1)", "domain": null }, { "name": "AlarmStatusDesc1", "type": "esriFieldTypeString", "alias": "Alarm Status Description (1)", "length": 15, "domain": null }, { "name": "AlarmStatusCode2", "type": "esriFieldTypeInteger", "alias": "Alarm Status Code (2)", "domain": null }, { "name": "AlarmStatusDesc2", "type": "esriFieldTypeString", "alias": "Alarm Status Description (2)", "length": 15, "domain": null }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "Feature Service Last Updated (UTC)", "length": 8, "domain": null }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "Feature Service Last UpdatedOffset", "length": 6, "domain": null } ], "indexes": [ { "name": "R25_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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": "e379e0a5845b4207b47631a18a2bc54d" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "SnowRoutes_EventDetails", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Segment511CommonRouteName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Truck", "type": "esriFieldTypeString", "alias": "Truck", "length": 255, "domain": null }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 255, "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "domain": null }, { "name": "EventCost", "type": "esriFieldTypeDouble", "alias": "EventCost", "domain": null }, { "name": "StockPileID", "type": "esriFieldTypeString", "alias": "StockPileID", "length": 255, "domain": null }, { "name": "EventObjectID", "type": "esriFieldTypeInteger", "alias": "EventObjectID", "domain": null }, { "name": "EventUsage", "type": "esriFieldTypeDouble", "alias": "EventUsage", "domain": null }, { "name": "RWIS_StormID", "type": "esriFieldTypeString", "alias": "RWIS_StormID", "length": 255, "domain": null }, { "name": "MaterialCategory", "type": "esriFieldTypeString", "alias": "Material Type", "length": 255, "domain": null }, { "name": "MaterialUnits", "type": "esriFieldTypeString", "alias": "Material Units", "length": 15, "domain": null }, { "name": "Segment511CommonRouteName", "type": "esriFieldTypeString", "alias": "Segment511CommonRouteName", "length": 7, "domain": null }, { "name": "Segment511Name", "type": "esriFieldTypeString", "alias": "Segment511Name", "length": 45, "domain": null }, { "name": "Segment511Number", "type": "esriFieldTypeDouble", "alias": "Segment511Number", "domain": null }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "EventStartDateText", "length": 10, "domain": null }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "EventStartTimeText", "length": 5, "domain": null }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "EventEndDateText", "length": 10, "domain": null }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "EventEndTimeText", "length": 5, "domain": null }, { "name": "StormEventID", "type": "esriFieldTypeSmallInteger", "alias": "StormEventID", "domain": null }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "length": 8, "domain": null }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "length": 8, "domain": null }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventStartDateTimeUTC", "length": 8, "domain": null }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventEndDateTimeUTC", "length": 8, "domain": null }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "DOT_ForemanArea", "domain": null }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeDouble", "alias": "DOT_DistrictNumber", "domain": null }, { "name": "SegmentYear", "type": "esriFieldTypeSmallInteger", "alias": "SegmentYear", "domain": null } ], "indexes": [ { "name": "R69_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4127_RWIS_St", "fields": "RWIS_StormID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Operations.GIS_WEBUSER.SnowRoutes_HistoricEvents_PT", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "RWIS_StormID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DED3FE54-9594-4F84-8BA7-28767345C3A6}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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": "e379e0a5845b4207b47631a18a2bc54d" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "MCEHistoric_EventDetails", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MCESegmentName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Truck", "type": "esriFieldTypeString", "alias": "Truck", "length": 255, "domain": null }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "length": 255, "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 255, "domain": null }, { "name": "StockPileID", "type": "esriFieldTypeString", "alias": "StockPileID", "length": 255, "domain": null }, { "name": "EventObjectID", "type": "esriFieldTypeInteger", "alias": "EventObjectID", "domain": null }, { "name": "MaterialCategory", "type": "esriFieldTypeString", "alias": "MaterialCategory", "length": 255, "domain": null }, { "name": "MaterialUnits", "type": "esriFieldTypeString", "alias": "MaterialUnits", "length": 15, "domain": null }, { "name": "MCESegmentName", "type": "esriFieldTypeString", "alias": "MCESegmentName", "length": 40, "domain": null }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "EventStartDateText", "length": 10, "domain": null }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "EventStartTimeText", "length": 5, "domain": null }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "EventEndDateText", "length": 10, "domain": null }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "EventEndTimeText", "length": 5, "domain": null }, { "name": "EventCost", "type": "esriFieldTypeDouble", "alias": "EventCost", "domain": null }, { "name": "EventUsage", "type": "esriFieldTypeDouble", "alias": "EventUsage", "domain": null }, { "name": "EventID", "type": "esriFieldTypeSmallInteger", "alias": "EventID", "domain": null }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "length": 8, "domain": null }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "length": 8, "domain": null }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventStartDateTimeUTC", "length": 8, "domain": null }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventEndDateTimeUTC", "length": 8, "domain": null }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "ITD Foreman Area", "domain": null }, { "name": "MCEYear", "type": "esriFieldTypeSmallInteger", "alias": "MCE Segment Year", "domain": null } ], "indexes": [ { "name": "R75_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4134_EventOb", "fields": "EventObjectID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Operations.GIS_WEBUSER.MCEHistoricEvents_PT", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "EventObjectID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6D6999BE-0AC9-4B5A-8DAE-DE40CFCDEC28}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": 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": "e379e0a5845b4207b47631a18a2bc54d" } ] }