Name: SpeedData

Display Field: LinkID

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• LinkID (type: esriFieldTypeInteger, alias: LinkID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lane (type: esriFieldTypeString, alias: Lane, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Direction (type: esriFieldTypeInteger, alias: Direction, SQL Type: sqlTypeOther, nullable: true, editable: true)
• StartDate (type: esriFieldTypeString, alias: StartDate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Interval (type: esriFieldTypeInteger, alias: Interval, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpeedBinLayout (type: esriFieldTypeInteger, alias: SpeedBinLayout, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NotUsed (type: esriFieldTypeString, alias: NotUsed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NotUsed_1 (type: esriFieldTypeString, alias: NotUsed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NotUsed_12 (type: esriFieldTypeString, alias: NotUsed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CountTotal (type: esriFieldTypeInteger, alias: CountTotal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_5_MPH (type: esriFieldTypeInteger, alias: <5 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_10_MPH (type: esriFieldTypeInteger, alias: <10 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_15_MPH (type: esriFieldTypeInteger, alias: <15 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_20_MPH (type: esriFieldTypeInteger, alias: <20 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_25_MPH (type: esriFieldTypeInteger, alias: <25 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_30_MPH (type: esriFieldTypeInteger, alias: <30 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_35_MPH (type: esriFieldTypeInteger, alias: <35 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_40_MPH (type: esriFieldTypeInteger, alias: <40 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_45_MPH (type: esriFieldTypeInteger, alias: <45 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_50_MPH (type: esriFieldTypeInteger, alias: <50 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_55_MPH (type: esriFieldTypeInteger, alias: <55 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_60_MPH (type: esriFieldTypeInteger, alias: <60 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_65_MPH (type: esriFieldTypeInteger, alias: <65 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_70_MPH (type: esriFieldTypeInteger, alias: <70 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_75_MPH (type: esriFieldTypeInteger, alias: <75 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_80_MPH (type: esriFieldTypeInteger, alias: <80 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_85_MPH (type: esriFieldTypeInteger, alias: <85 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_90_MPH (type: esriFieldTypeInteger, alias: <90 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_95_MPH (type: esriFieldTypeInteger, alias: <95 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_100_MPH (type: esriFieldTypeInteger, alias: <100 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F_147_MPH (type: esriFieldTypeInteger, alias: <147 MPH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpeedQuality (type: esriFieldTypeInteger, alias: SpeedQuality, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VDOTLinkID (type: esriFieldTypeString, alias: VDOT Link ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Direction_2 (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Northbound], [2: Eastbound], ... 6 more ...)
• StartDateTime (type: esriFieldTypeDate, alias: Start Date Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TopSpeedLimit (type: esriFieldTypeSmallInteger, alias: Top Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FunctionalClass (type: esriFieldTypeString, alias: FunctionalClass, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Unknown Functional Class], [1: Rural Interstate], [2: Rural Other Principal Arterial], ... 14 more ...)
• StartDateTime_Converted (type: esriFieldTypeString, alias: StartDateTime_Converted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TimeCollected (type: esriFieldTypeSmallInteger, alias: Time Collected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RouteAlias (type: esriFieldTypeString, alias: Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DirectionT (type: esriFieldTypeString, alias: Travel Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Northbound], [2: Eastbound], ... 6 more ...)
• RouteDescr (type: esriFieldTypeString, alias: Route Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: SpeedData
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• DirectionT:
• RouteDescr:
• LinkID: 0
• Lane:
• Direction: 0
• StartDate:
• Interval: 0
• SpeedBinLayout: 0
• NotUsed:
• NotUsed_1:
• NotUsed_12:
• CountTotal: 0
• F_5_MPH: 0
• F_10_MPH: 0
• F_15_MPH: 0
• F_20_MPH: 0
• F_25_MPH: 0
• F_30_MPH: 0
• F_35_MPH: 0
• F_40_MPH: 0
• F_45_MPH: 0
• F_50_MPH: 0
• F_55_MPH: 0
• F_60_MPH: 0
• F_65_MPH: 0
• F_70_MPH: 0
• F_75_MPH: 0
• F_80_MPH: 0
• F_85_MPH: 0
• F_90_MPH: 0
• F_95_MPH: 0
• F_100_MPH: 0
• F_147_MPH: 0
• SpeedQuality: 0
• VDOTLinkID:
• Direction_2:
• TopSpeedLimit: 0
• FunctionalClass:
• StartDateTime_Converted:
• TimeCollected: 0
• RouteAlias:

Relationships:

• (0) -- Related To: SpeedVolumeSegments_LinkID2 (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/10/2022 4:56:17 PM

Schema Last Edit Date: 5/10/2022 4:56:17 PM

Data Last Edit Date: 5/10/2022 4:56:17 PM

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