Name: Winter Storm Analysis - Past 48 Hours
Display Field: ROUTE_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: Winter_Storm_Analysis_48HR
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON
Use Standardized Queries: True
Extent:
XMin: -10757094.9899382
YMin: 4922099.11247505
XMax: -10036667.4266331
YMax: 5388545.28837523
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"MAP_SYMBOL","uniqueValueInfos":[{"value":"3","symbol":{"color":[72,85,102,255],"width":2.25,"type":"esriSLS","style":"esriSLSSolid"},"label":"High Resource Usage"},{"value":"2","symbol":{"color":[232,125,29,255],"width":2.25,"type":"esriSLS","style":"esriSLSSolid"},"label":"Average Resource Usage"},{"value":"1","symbol":{"color":[59,143,196,255],"width":2.25,"type":"esriSLS","style":"esriSLSSolid"},"label":"Low Resource Usage"}]},"transparency":0}
HasZ: true
HasM: true
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: MAP_SYMBOL
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- TOTAL_PASSES_WITH_MATERIAL (type: esriFieldTypeDouble, alias: Total Passes With Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LABOR_HOURS (type: esriFieldTypeDouble, alias: Labor Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_TOTAL_LM (type: esriFieldTypeDouble, alias: Total Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_OPERATIONS_LM (type: esriFieldTypeDouble, alias: Operations Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_LABOR_LM (type: esriFieldTypeDouble, alias: Labor Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_EQUIPMENT_LM (type: esriFieldTypeDouble, alias: Equipment Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_MATERIAL_LM (type: esriFieldTypeDouble, alias: Total Material Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_LIQUID_PREWET_LM (type: esriFieldTypeDouble, alias: Liquid & Brine Material Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_PREWET_LM (type: esriFieldTypeDouble, alias: Brine Material Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_LIQUID_LM (type: esriFieldTypeDouble, alias: Liquid Material Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_SOLID_LM (type: esriFieldTypeDouble, alias: Solid Material Cost Per Lane Mile ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAT_LIQUID_PREWET_LM (type: esriFieldTypeDouble, alias: Total Liquid & Brine Material Per Lane Mile (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAT_PREWET_LM (type: esriFieldTypeDouble, alias: Brine Material Per Lane Mile (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAT_LIQUID_LM (type: esriFieldTypeDouble, alias: Liquid Material Per Lane Mile (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAT_SOLID_LM (type: esriFieldTypeDouble, alias: Solid Material Per Lane Mile (Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
- LANE_MILES_PER_HOUR (type: esriFieldTypeDouble, alias: Lane Miles Per Hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_TOTAL_SEGMENT (type: esriFieldTypeDouble, alias: Total Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_OPERATIONS_SEGMENT (type: esriFieldTypeDouble, alias: Operations Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_LABOR_SEGMENT (type: esriFieldTypeDouble, alias: Labor Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_EQUIPMENT_SEGMENT (type: esriFieldTypeDouble, alias: Equipment Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_MATERIAL_SEGMENT (type: esriFieldTypeDouble, alias: Total Material Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_LIQUID_PREWET_SEGMENT (type: esriFieldTypeDouble, alias: Total Liquid & Brine Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_PREWET_SEGMENT (type: esriFieldTypeDouble, alias: Brine Material Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_LIQUID_SEGMENT (type: esriFieldTypeDouble, alias: Liquid Material Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COST_SOLID_SEGMENT (type: esriFieldTypeDouble, alias: Solid Material Cost Per Segment ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- QUANTITY_LIQUID_PREWET (type: esriFieldTypeDouble, alias: Total Brine & Liquid Material (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTAL_SALT_QUANTITY (type: esriFieldTypeDouble, alias: Total Salt Material Applied (Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREWET_SALT_QUANTITY (type: esriFieldTypeDouble, alias: Salt Used in Brine Material (Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
- LIQUID_SALT_QUANTITY (type: esriFieldTypeDouble, alias: Salt Used in Liquid Material (Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ID (type: esriFieldTypeDouble, alias: Segment ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COSTCENTER (type: esriFieldTypeString, alias: Cost Center, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- MAINTDISTRICT (type: esriFieldTypeSmallInteger, alias: DOT District, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ROUTE_NAME (type: esriFieldTypeString, alias: Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROUTE_DIRECTION (type: esriFieldTypeString, alias: Route Direction, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- OFFICIAL_NAME (type: esriFieldTypeString, alias: Official Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- FULL_NAME (type: esriFieldTypeString, alias: Full Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- COUNTY_NUMBER (type: esriFieldTypeSmallInteger, alias: County Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SEGMENT_LENGTH (type: esriFieldTypeDouble, alias: Segment Length (Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
- START_POST (type: esriFieldTypeString, alias: Start Reference Post, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- START_POST_OFFSET (type: esriFieldTypeDouble, alias: Start Reference Post Offset, SQL Type: sqlTypeOther, nullable: true, editable: true)
- END_POST (type: esriFieldTypeString, alias: End Reference Post, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- END_POST_OFFSET (type: esriFieldTypeDouble, alias: End Reference Post Offset, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NUMBER_PASSES (type: esriFieldTypeDouble, alias: Number of Passes on Segment, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SOLID_COUNT (type: esriFieldTypeDouble, alias: Number of Passes Solid Material Applied, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LIQUID_COUNT (type: esriFieldTypeDouble, alias: Number of Passes Liquid Material Applied, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PREWET_COUNT (type: esriFieldTypeDouble, alias: Number of Passes Brine Material Applied, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NO_MAT_COUNT (type: esriFieldTypeDouble, alias: Number of Passes Without Material Applied, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LAST_PASS (type: esriFieldTypeDate, alias: Last Pass on Segment (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- NUMBER_OF_PINGS (type: esriFieldTypeDouble, alias: Number of AVL Pings, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVERAGE_VELOCITY (type: esriFieldTypeDouble, alias: Average Velocity (MPH), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVERAGE_AIR_TEMP (type: esriFieldTypeDouble, alias: Average Air Temp (F), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVERAGE_ROAD_TEMP (type: esriFieldTypeDouble, alias: Average Road Temp (F), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVG_SOLID (type: esriFieldTypeDouble, alias: Average Solid Material (Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVG_LIQUID (type: esriFieldTypeDouble, alias: Average Liquid Material (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVG_PREWET (type: esriFieldTypeDouble, alias: Average Brine Material (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- QUANTITY_SOLID (type: esriFieldTypeDouble, alias: Total Solid Material Applied (Lbs), SQL Type: sqlTypeOther, nullable: true, editable: true)
- QUANTITY_LIQUID (type: esriFieldTypeDouble, alias: Total Liquid Material Applied (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- QUANTITY_PREWET (type: esriFieldTypeDouble, alias: Total Brine Material Applied (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
- LWP_MILES (type: esriFieldTypeDouble, alias: Leftwing Plow Distance (Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
- RWP_MILES (type: esriFieldTypeDouble, alias: Rightwing Plow Distance (Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
- FP_MILES (type: esriFieldTypeDouble, alias: Front Plow Distance (Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
- BP_MILES (type: esriFieldTypeDouble, alias: Belly Plow Distance (Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
- DISTANCE_TRAVELED (type: esriFieldTypeDouble, alias: Distance Traveled (Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- REST_UPDATED (type: esriFieldTypeDate, alias: REST Service Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- REST_UPDATE_UTC_OFFSET (type: esriFieldTypeString, alias: REST Service Last Updated UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- LAST_PASS_UTC_OFFSET (type: esriFieldTypeString, alias: Last Past UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- MAP_SYMBOL (type: esriFieldTypeSmallInteger, alias: Cost Symbology, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TIME_SOLID (type: esriFieldTypeDouble, alias: Time Spent Spreading Solid Material (Hours), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TIME_LIQUID (type: esriFieldTypeDouble, alias: Time Spent Spreading Liquid Material (Hours), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TIME_PREWET (type: esriFieldTypeDouble, alias: Time Spent Spreading Brine Material (Hours), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTAL_TIME_MATERIAL (type: esriFieldTypeDouble, alias: Total Time Spent Spreading Materials (Hours), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TIME_ON_SEGMENT (type: esriFieldTypeDouble, alias: Total Time On Segment (Hours), SQL Type: sqlTypeOther, nullable: true, editable: true)
- COMMON_ROUTE_NAME (type: esriFieldTypeString, alias: Common Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ROUTE_SYSTEM_CODE (type: esriFieldTypeSmallInteger, alias: Route System Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
Types:
ID: 3
Name: 3
Domains:
Templates:
Name: 3
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 2
Name: 2
Domains:
Templates:
Name: 2
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 1
Name: 1
Domains:
Templates:
Name: 1
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/29/2024 10:02:39 AM
Schema Last Edit Date: 3/29/2024 10:02:39 AM
Data Last Edit Date: 3/29/2024 10:02:39 AM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates