Name: MCEHistoricEvents_PT

Display Field: MCESegmentName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e379e0a5845b4207b47631a18a2bc54d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2257866.1929426747
YMin: 1202730.8770000003
XMax: 2738585.8877717163
YMax: 1905625.2848000005
Spatial Reference: 102605  (8826)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [33, 137, 94, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MCESegmentName ( type: esriFieldTypeString, alias: MCE Segment Name, length: 40 )
• RWISStationName ( type: esriFieldTypeString, alias: RWIS Station Name, length: 30 )
• EventID ( type: esriFieldTypeSmallInteger, alias: Storm Event ID )
• EventSortOrder ( type: esriFieldTypeSmallInteger, alias: MCE Event Sort Order )
• TechnicalEventStartDateTimeUTC ( type: esriFieldTypeDate, alias: Event Technically Start Date-Time (UTC), length: 8 )
• EventStartDateTimeUTC ( type: esriFieldTypeDate, alias: Event Start Date-Time (UTC), length: 8 )
• EventStartDateTimeUTCOffset ( type: esriFieldTypeString, alias: Event Start Date-Time UTC Offset, length: 6 )
• EventEndDateTimeUTC ( type: esriFieldTypeDate, alias: Event End Date-Time (UTC), length: 8 )
• EventEndDateTimeUTCOffset ( type: esriFieldTypeString, alias: Event End Date-Time UTC Offset, length: 6 )
• EventStartDateText ( type: esriFieldTypeString, alias: Event Start Date (Text), length: 10 )
• EventStartTimeText ( type: esriFieldTypeString, alias: Event Start Time (Text), length: 5 )
• EventEndDateText ( type: esriFieldTypeString, alias: Event End Date (Text), length: 10 )
• EventEndTimeText ( type: esriFieldTypeString, alias: Event End Time (Text), length: 5 )
• EventDurationHours ( type: esriFieldTypeDouble, alias: Event Duration (Hours) )
• EventPollingCount ( type: esriFieldTypeInteger, alias: Polling Count for Storm Event )
• EventPollingCount_CriteriaMet ( type: esriFieldTypeInteger, alias: Polling Count for Storm Event (Criteria Met Only) )
• EventDurationHours_CriteriaMet ( type: esriFieldTypeDouble, alias: Event Duration - Criteria Met Only (Hours) )
• EventPollingCount_MCE ( type: esriFieldTypeInteger, alias: Polling Count for MCE Event )
• MaxWindSpeedRangeMPH ( type: esriFieldTypeString, alias: Event Max Wind Speed Range (MPH), length: 15 )
• PrecipitationHoursPollingCount ( type: esriFieldTypeInteger, alias: Polling Count for Precipitation Hours )
• PrecipitationHours ( type: esriFieldTypeDouble, alias: Event Precipitation Total Hours )
• MinRoadTempF ( type: esriFieldTypeDouble, alias: Event Minimum Road Temp (F) )
• MaxRoadTempF ( type: esriFieldTypeDouble, alias: Event Maximum Road Temp (F) )
• TargetLaneMilePercent ( type: esriFieldTypeDouble, alias: Target Lane Mile Percentage )
• MCEEvent ( type: esriFieldTypeString, alias: MCE Event (Yes/No), length: 3 )
• MCEIndex ( type: esriFieldTypeDouble, alias: MCE Index )
• MCEReduction ( type: esriFieldTypeDouble, alias: MCE Reduction )
• MCEScoreType ( type: esriFieldTypeString, alias: MCE Score Type, length: 10 )
• MCEScore ( type: esriFieldTypeDouble, alias: MCE Score )
• AchievementCategory ( type: esriFieldTypeString, alias: Event Achievement Category, length: 33 )
• MobilityHours ( type: esriFieldTypeDouble, alias: Mobility Hours )
• MobilityCounter ( type: esriFieldTypeSmallInteger, alias: Mobility Counter )
• MobilityPercentage ( type: esriFieldTypeDouble, alias: Mobility Percentage )
• WPICounter ( type: esriFieldTypeSmallInteger, alias: WPI Counter )
• WPIHours ( type: esriFieldTypeDouble, alias: WPI Hours )
• WPIPercentage ( type: esriFieldTypeDouble, alias: WPI Percentage )
• RWISStationID ( type: esriFieldTypeInteger, alias: RWIS Station ID )
• RWISCycleLastDateTimeUTC ( type: esriFieldTypeDate, alias: RWIS Sensor Last Date-Time (UTC), length: 8 )
• RWISDownTimeHours ( type: esriFieldTypeDouble, alias: RWIS Down Time Hours )
• RWISDownTimeCounter ( type: esriFieldTypeInteger, alias: RWIS Down Time Counter )
• RWISIssue ( type: esriFieldTypeString, alias: RWIS Issue (Yes/No), length: 3 )
• DualCarriage ( type: esriFieldTypeSmallInteger, alias: Dual Carriage MCE Segment )
• TravelDirection ( type: esriFieldTypeString, alias: Travel Direction, length: 10 )
• RouteID ( type: esriFieldTypeString, alias: Route ID, length: 12 )
• CommonRouteName ( type: esriFieldTypeString, alias: Common Route Name, length: 120 )
• FromMeasure ( type: esriFieldTypeDouble, alias: MCE Segment From Measure )
• ToMeasure ( type: esriFieldTypeDouble, alias: MCE Segment To Measure )
• DOT_DistrictNumber ( type: esriFieldTypeSmallInteger, alias: ITD District Number )
• DOT_MaintDistrictNumber ( type: esriFieldTypeSmallInteger, alias: ITD Maintenance District Number )
• DOT_ForemanArea ( type: esriFieldTypeSmallInteger, alias: ITD Foreman Area )
• LatitudeDD_RWIS ( type: esriFieldTypeDouble, alias: RWIS Station Latitude (WGS84 - DD) )
• LongitudeDD_RWIS ( type: esriFieldTypeDouble, alias: RWIS Station Longitude (WGS84 -DD) )
• RWISAltitudeFeet ( type: esriFieldTypeDouble, alias: RWIS Station Altitude (Feet) )
• RWISMeasure ( type: esriFieldTypeDouble, alias: RWIS Station Measure )
• MCEYear ( type: esriFieldTypeSmallInteger, alias: MCE Segment Year )
• CountyName ( type: esriFieldTypeString, alias: County Name, length: 10 )
• CountyFIPS ( type: esriFieldTypeString, alias: County FIPS, length: 3 )
• SegmentLengthMile ( type: esriFieldTypeDouble, alias: Segment Length (Mile - UTM83-ITD) )
• LaneMiles ( type: esriFieldTypeDouble, alias: Lane Miles )
• MaterialQuantityTotal_Solid ( type: esriFieldTypeDouble, alias: Event Total Solid Material Applied (Tons) )
• MaterialQuantityTotal_Liquid ( type: esriFieldTypeDouble, alias: Event Total Liquid Material Applied (Gal) )
• MaterialQuantityTotal_PreWet ( type: esriFieldTypeDouble, alias: Event Total PreWet Material Applied (Gal) )
• MaterialSolid_Salt_SPIDS ( type: esriFieldTypeString, alias: List of Salt Stockpile IDs, length: 150 )
• MaterialSolid_Salt_Usage ( type: esriFieldTypeDouble, alias: Event Salt Usage (Tons) )
• MaterialSolid_IceSlicer_SPIDS ( type: esriFieldTypeString, alias: List of Ice Slicer Stockpile IDs, length: 150 )
• MaterialSolid_IceSlicer_Usage ( type: esriFieldTypeDouble, alias: Event Ice Slicer Usage (Tons) )
• MaterialSolid_SaltSand21_SPIDS ( type: esriFieldTypeString, alias: List of Salt/Sand 2:1 Stockpile IDs, length: 150 )
• MaterialSolid_SaltSand21_Usage ( type: esriFieldTypeDouble, alias: Event Salt/Sand 2:1 Usage (Tons) )
• MaterialSolid_SaltSand31_SPIDS ( type: esriFieldTypeString, alias: List of Salt/Sand 3:1 Stockpile IDs, length: 150 )
• MaterialSolid_SaltSand31_Usage ( type: esriFieldTypeDouble, alias: Event Salt/Sand 3:1 Usage (Tons) )
• MaterialSolid_SandSalt11_SPIDS ( type: esriFieldTypeString, alias: List of Sand/Salt 1:1 Stockpile IDs, length: 150 )
• MaterialSolid_SandSalt11_Usage ( type: esriFieldTypeDouble, alias: Event Sand/Salt 1:1 Usage (Tons) )
• MaterialSolid_SandSalt21_SPIDS ( type: esriFieldTypeString, alias: List of Sand/Salt 2:1 Stockpile IDs, length: 150 )
• MaterialSolid_SandSalt21_Usage ( type: esriFieldTypeDouble, alias: Event Sand/Salt 2:1 Usage (Tons) )
• MaterialSolid_SandSalt31_SPIDS ( type: esriFieldTypeString, alias: List of Sand/Salt 3:1 Stockpile IDs, length: 150 )
• MaterialSolid_SandSalt31_Usage ( type: esriFieldTypeDouble, alias: Event Sand/Salt 3:1 Usage (Tons) )
• MaterialSolid_SandSalt41_SPIDS ( type: esriFieldTypeString, alias: List of Sand/Salt 4:1 Stockpile IDs, length: 150 )
• MaterialSolid_SandSalt41_Usage ( type: esriFieldTypeDouble, alias: Event Sand/Salt 4:1 Usage (Tons) )
• MaterialSolid_IceKicker_SPIDS ( type: esriFieldTypeString, alias: List of Ice Kicker Stockpile IDs, length: 150 )
• MaterialSolid_IceKicker_Usage ( type: esriFieldTypeDouble, alias: Event Ice Kicker Usage (Tons) )
• MaterialSolid_Sand_SPIDS ( type: esriFieldTypeString, alias: List of Sand Stockpile IDs, length: 150 )
• MaterialSolid_Sand_Usage ( type: esriFieldTypeDouble, alias: Event Sand Usage (Tons) )
• MaterialPreWet_Brine_SPIDS ( type: esriFieldTypeString, alias: List of PreWet Brine Stockpile IDs, length: 150 )
• MaterialPreWet_Brine_Usage ( type: esriFieldTypeDouble, alias: Event PreWet Brine Usage (Gal) )
• MaterialPreWet_MgCl_SPIDS ( type: esriFieldTypeString, alias: List of PreWet MgCl Stockpile IDs, length: 150 )
• MaterialPreWet_MgCl_Usage ( type: esriFieldTypeDouble, alias: Event PreWet MgCl Usage (Gal) )
• MaterialPreWet_CaCl_SPIDS ( type: esriFieldTypeString, alias: List of PreWet CaCl Stockpile IDs, length: 150 )
• MaterialPreWet_CaCl_Usage ( type: esriFieldTypeDouble, alias: Event PreWet CaCl Usage (Gal) )
• MaterialPreWet_BoostBrine_SPIDS ( type: esriFieldTypeString, alias: List of PreWet Boost Brine Stockpile IDs, length: 150 )
• MaterialPreWet_BoostBrine_Usage ( type: esriFieldTypeDouble, alias: Event PreWet Boost Brine Usage (Gal) )
• MaterialPreWet_GeoBrine_SPIDS ( type: esriFieldTypeString, alias: List of PreWet Geomelt Brine Stockpile IDs, length: 150 )
• MaterialPreWet_GeoBrine_Usage ( type: esriFieldTypeDouble, alias: Event PreWet Geomelt Brine Usage (Gal) )
• MaterialLiquid_BrineDeIce_SPIDS ( type: esriFieldTypeString, alias: List of Liquid Brine/De-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_BrineDeIce_Usage ( type: esriFieldTypeDouble, alias: Event Liquid Brine/De-Icing Usage (Gal) )
• MaterialLiquid_MgClDeIce_SPIDS ( type: esriFieldTypeString, alias: List of Liquid MgCl/De-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_MgClDeIce_Usage ( type: esriFieldTypeDouble, alias: Event Liquid MgCl/De-Icing Usage (Gal) )
• MaterialLiquid_BoostDeIce_SPIDS ( type: esriFieldTypeString, alias: List of Liquid Boost Brine/De-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_BoostDeIce_Usage ( type: esriFieldTypeDouble, alias: Event Liquid Boost Brine/De-Icing Usage (Gal) )
• MaterialLiquid_GeoDeIce_SPIDS ( type: esriFieldTypeString, alias: List of Liquid Geomelt Brine/De-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_GeoDeIce_Usage ( type: esriFieldTypeDouble, alias: Event Liquid Geomelt Brine/De-Icing Usage (Gal) )
• MaterialLiquid_BrineAnti_SPIDS ( type: esriFieldTypeString, alias: List of Liquid Brine/Anti-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_BrineAnti_Usage ( type: esriFieldTypeDouble, alias: Event Liquid Brine/Anti-Icing Usage (Gal) )
• MaterialLiquid_MgClAnti_SPIDS ( type: esriFieldTypeString, alias: List of Liquid MgCL/Anti-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_MgClAnti_Usage ( type: esriFieldTypeDouble, alias: Event Liquid MgCl/Anti-Icing Usage (Gal) )
• MaterialLiquid_BoostAnti_SPIDS ( type: esriFieldTypeString, alias: List of Liquid Boost Brine/Anti-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_BoostAnti_Usage ( type: esriFieldTypeDouble, alias: Event Liquid Boost Brine/Anti-Icing Usage (Gal) )
• MaterialLiquid_GeoAnti_SPIDS ( type: esriFieldTypeString, alias: List of Liquid Geomelt Brine/Anti-Icing Stockpile IDs, length: 150 )
• MaterialLiquid_GeoAnti_Usage ( type: esriFieldTypeDouble, alias: Event Liquid Geomelt Brine/Anti-Icing Usage (Gal) )
• TruckIDList ( type: esriFieldTypeString, alias: List of Trucks Used During Event, length: 200 )
• OperatorIDList ( type: esriFieldTypeString, alias: List of Operators Used During Event, length: 200 )
• TargetMaterial_Solid_Usage ( type: esriFieldTypeDouble, alias: Target Material Solid Usage (Tons) )
• TargetMaterial_Liquid_Usage ( type: esriFieldTypeDouble, alias: Target Material Liquid Usage (Gal) )
• TargetMaterial_PreWet_Usage ( type: esriFieldTypeDouble, alias: Target Material PreWet Usage (Gal) )
• LaborHours_Actual ( type: esriFieldTypeDouble, alias: Labor Hours - Actual )
• LaborHours_Target ( type: esriFieldTypeDouble, alias: Labor Hours - Target )
• EquipmentMiles_Actual ( type: esriFieldTypeDouble, alias: Equipment Miles - Actual )
• EquipmentMiles_Target ( type: esriFieldTypeDouble, alias: Equipment Miles - Target )
• NumberPasses ( type: esriFieldTypeSmallInteger, alias: Number of Passes on Segment )
• AVLDataAvailable ( type: esriFieldTypeString, alias: AVL Data Available after 12 Hours, length: 3 )
• InvalidStockPileIDPresent ( type: esriFieldTypeString, alias: Invalid Stockpile IDs Present, length: 3 )
• EventNotes ( type: esriFieldTypeString, alias: Event Notes, length: 500 )
• FMECode ( type: esriFieldTypeSmallInteger, alias: FME Code Used for Calculations )
• ServiceLastUpdatedUTC ( type: esriFieldTypeDate, alias: Service Last Updated (UTC), length: 8 )
• ServiceLastUpdatedUTCOffset ( type: esriFieldTypeString, alias: Service Last Updated UTC Offset, length: 6 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• TargetCost ( type: esriFieldTypeDouble, alias: Target Cost ($) )
• ActualCost ( type: esriFieldTypeDouble, alias: Actual Cost ($) )
• MaterialSolid_Salt_Cost ( type: esriFieldTypeDouble, alias: Event Salt Cost ($) )
• MaterialSolid_IceSlicer_Cost ( type: esriFieldTypeDouble, alias: Event Ice Slicer Cost ($) )
• MaterialSolid_SaltSand21_Cost ( type: esriFieldTypeDouble, alias: Event Salt/Sand 2:1 Cost ($) )
• MaterialSolid_SaltSand31_Cost ( type: esriFieldTypeDouble, alias: Event Salt/Sand 3:1 Cost ($) )
• MaterialSolid_SandSalt11_Cost ( type: esriFieldTypeDouble, alias: Event Sand/Salt 1:1 Cost ($) )
• MaterialSolid_SandSalt21_Cost ( type: esriFieldTypeDouble, alias: Event Sand/Salt 2:1 Cost ($) )
• MaterialSolid_SandSalt31_Cost ( type: esriFieldTypeDouble, alias: Event Sand/Salt 3:1 Cost ($) )
• MaterialSolid_SandSalt41_Cost ( type: esriFieldTypeDouble, alias: Event Sand/Salt 4:1 Cost ($) )
• MaterialSolid_IceKicker_Cost ( type: esriFieldTypeDouble, alias: Event Ice Kicker Cost ($) )
• MaterialSolid_Sand_Cost ( type: esriFieldTypeDouble, alias: Event Sand Cost ($) )
• MaterialPreWet_Brine_Cost ( type: esriFieldTypeDouble, alias: Event PreWet Brine Cost ($) )
• MaterialPreWet_MgCl_Cost ( type: esriFieldTypeDouble, alias: Event PreWet MgCl Cost ($) )
• MaterialPreWet_CaCl_Cost ( type: esriFieldTypeDouble, alias: Event PreWet CaCl Cost ($) )
• MaterialPreWet_BoostBrine_Cost ( type: esriFieldTypeDouble, alias: Eent PreWet Boost Brine Cost ($) )
• MaterialPreWet_GeoBrine_Cost ( type: esriFieldTypeDouble, alias: Event PreWet Geomelt Brine Cost ($) )
• MaterialLiquid_BrineDeIce_Cost ( type: esriFieldTypeDouble, alias: Event Liquid Brine/De-Icing Cost ($) )
• MaterialLiquid_MgClDeIce_Cost ( type: esriFieldTypeDouble, alias: Event Liquid MgCl/De-Icing Cost ($) )
• MaterialLiquid_BoostDeIce_Cost ( type: esriFieldTypeDouble, alias: Event Liquid Boost Brine/De-Icing Cost ($) )
• MaterialLiquid_GeoDeIce_Cost ( type: esriFieldTypeDouble, alias: Event Liquid Geomelt Brine/De-Icing Cost ($) )
• MaterialLiquid_BrineAnti_Cost ( type: esriFieldTypeDouble, alias: Event Liquid Brine/Anti-Icing Cost ($) )
• MaterialLiquid_MgClAnti_Cost ( type: esriFieldTypeDouble, alias: Event Liquid MgCl/Anti-Icing Cost ($) )
• MaterialLiquid_BoostAnti_Cost ( type: esriFieldTypeDouble, alias: Event Liquid Boost Brine/Anti-Icing Cost ($) )
• MaterialLiquid_GeoAnti_Cost ( type: esriFieldTypeDouble, alias: Event Liquid Geomelt Brine/Anti-Icing Cost ($) )
• TargetMaterial_Solid_Cost ( type: esriFieldTypeDouble, alias: Target Material Solid Cost ($) )
• TargetMaterial_Liquid_Cost ( type: esriFieldTypeDouble, alias: Target Material Liquid Cost ($) )
• TargetMaterial_PreWet_Cost ( type: esriFieldTypeDouble, alias: Target Material PreWet Cost ($) )
• BackgroundColor ( type: esriFieldTypeString, alias: Background Color (Dashboard), length: 10 )
• TextColor ( type: esriFieldTypeString, alias: Text Color (Dashboard), length: 10 )
• StartDateTimeLocal ( type: esriFieldTypeDate, alias: StartDateTimeLocal, length: 8 )
• EndDateTimeLocal ( type: esriFieldTypeDate, alias: EndDateTimeLocal, length: 8 )
• FrostEvent ( type: esriFieldTypeString, alias: Frost Event, length: 3 )
• MCELiveOID ( type: esriFieldTypeInteger, alias: MCELive ObjectID )
• TotalMaterial_Solid_Cost ( type: esriFieldTypeDouble, alias: Event Total Solid Material Cost ($) )
• TotalMaterial_Liquid_Cost ( type: esriFieldTypeDouble, alias: Event Total Liquid Material Cost ($) )
• TotalMaterial_PreWet_Cost ( type: esriFieldTypeDouble, alias: Event Total PreWet Material Cost ($) )
• FrostPollingCount ( type: esriFieldTypeSmallInteger, alias: Frost Polling Count )

Relationships:

• Operations.GIS_WEBUSER.MCEHistoric_EventDetails (0) -- Related To: MCEHistoric_EventDetails (7)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata