Name: AVL Direct

Display Field: ROUTE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: AVL_DIRECT

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1500

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10687874.3596487
YMin: 4961950.75674412
XMax: -10094001.0472333
YMax: 5355978.26111845
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[132,95,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• LABEL (type: esriFieldTypeString, alias: Truck Label (A-Name), SQL Type: sqlTypeOther, length: 45, nullable: true, editable: true)
• XPOSITION (type: esriFieldTypeDouble, alias: X Coordinate (LL84), SQL Type: sqlTypeOther, nullable: true, editable: true)
• YPOSITION (type: esriFieldTypeDouble, alias: Y Coordinate (LL84), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HEADING (type: esriFieldTypeDouble, alias: Heading, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 360])
• VELOCITY (type: esriFieldTypeDouble, alias: Velocity (MPH), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [3 - 80])
• ROADTEMP (type: esriFieldTypeDouble, alias: Road Temp (F), SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIRTEMP (type: esriFieldTypeDouble, alias: Air Temp (F), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOLIDMATERIAL (type: esriFieldTypeString, alias: Solid Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LIQUIDMATERIAL (type: esriFieldTypeString, alias: Liquid Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PREWETMATERIAL (type: esriFieldTypeDouble, alias: Prewet Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOLIDRATE (type: esriFieldTypeDouble, alias: Solid Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIQUIDRATE (type: esriFieldTypeDouble, alias: Liquid Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREWETRATE (type: esriFieldTypeDouble, alias: Prewet Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FRONTPLOWSTATE (type: esriFieldTypeDouble, alias: Front Plow State, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RIGHTWINGPLOWSTATE (type: esriFieldTypeDouble, alias: Right Wing Plow State, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEFTWINGPLOWSTATE (type: esriFieldTypeDouble, alias: Left Wing Plow State, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNDERBELLYPLOWSTATE (type: esriFieldTypeDouble, alias: Underbelly Plow State, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOLIDRUNTOTAL (type: esriFieldTypeDouble, alias: Solid Run Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIQUIDRUNTOTAL (type: esriFieldTypeDouble, alias: Liquid Run Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREWETRUNTOTAL (type: esriFieldTypeDouble, alias: Prewet Run Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOLIDSETRATE (type: esriFieldTypeDouble, alias: Solid Set Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIQUIDSETRATE (type: esriFieldTypeDouble, alias: Liquid Set Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PREWETSETRATE (type: esriFieldTypeDouble, alias: Prewet Set Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLASTMODE (type: esriFieldTypeSmallInteger, alias: Blast Mode (Over 500lbs/Mile), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_TRUCK_COUNT (type: esriFieldTypeInteger, alias: Total Active Trucks, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 900])
• ACTIVE_MATERIAL (type: esriFieldTypeString, alias: Active Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROUTE_NAME (type: esriFieldTypeString, alias: Route Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LOGDT (type: esriFieldTypeDate, alias: AVL Ping Date-Time (Local - Iowa), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODIFIEDDT (type: esriFieldTypeDate, alias: AVL Ping Date-Time (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODIFIEDDT_UTC_OFFSET (type: esriFieldTypeString, alias: Ping DateTime UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• REST_UPDATED (type: esriFieldTypeDate, alias: REST Service Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• REST_UPDATED_UTC_OFFSET (type: esriFieldTypeString, alias: REST Service Last Updated UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• COST_CENTER (type: esriFieldTypeString, alias: Cost Center, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• MAINT_DISTRICT (type: esriFieldTypeInteger, alias: Maintenance District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GARAGE_NAME (type: esriFieldTypeString, alias: Garage Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: AVL Direct
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/14/2026 7:27:34 PM

Schema Last Edit Date: 4/14/2026 7:27:34 PM

Data Last Edit Date: 4/14/2026 7:27:34 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat