Name: Traffic Count Assignments

Display Field: Date

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Date ( type: esriFieldTypeDate, alias: Assigned Date, length: 8 )
• LocationID ( type: esriFieldTypeGUID, alias: LocationID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Type ( type: esriFieldTypeString, alias: Assignment Type, length: 255 , Coded Values: [APPROACH: APPROACH] , [LOCAL STREET ADT: LOCAL STREET ADT] , [MAJOR THOROUGHFARE ADT: MAJOR THOROUGHFARE ADT] , ...4 more... )
• Status ( type: esriFieldTypeString, alias: Assignment Status, length: 255 , Coded Values: [Deployed: Deployed] , [Retrieved: Retrieved] , [Processing: Processing] , ...3 more... )
• ADT ( type: esriFieldTypeDouble, alias: ADT )
• Outcome ( type: esriFieldTypeString, alias: Outcome, length: 255 , Coded Values: [Fail - No Connection: Fail - No Connection] , [Fail - Construction: Fail - Construction] , [Fail - Counter: Fail - Counter] , ...7 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• PercentileSpeed85 ( type: esriFieldTypeDouble, alias: 85th Percentile Speed )
• TruckTrafficPercent ( type: esriFieldTypeDouble, alias: Percentage Truck Traffic )
• ADTChange1 ( type: esriFieldTypeDouble, alias: ADT Change 1 )
• ADTChange2 ( type: esriFieldTypeDouble, alias: ADT Change 2 )
• ADTChange3 ( type: esriFieldTypeDouble, alias: ADT Change 3 )
• Intersection ( type: esriFieldTypeString, alias: Intersection, length: 255 )
• Direction ( type: esriFieldTypeString, alias: Direction, length: 255 , Coded Values: [North Bound: North Bound] , [South Bound: South Bound] , [East Bound: East Bound] , ...1 more... )
• PercentileSpeed50 ( type: esriFieldTypeDouble, alias: 50th Percentile Speed )
• TrafficStudy_Date ( type: esriFieldTypeDate, alias: Traffic Study Date, length: 8 )
• TrafficStudy_Weekday ( type: esriFieldTypeString, alias: Traffic Study Weekday, length: 255 )
• MorningPeakTime_NorthOrEast ( type: esriFieldTypeString, alias: Morning Peak Time (North or East), length: 255 )
• MorningPeakVolume_NorthOrEast ( type: esriFieldTypeInteger, alias: Morning Peak Volume (North or East) )
• MorningPeakTime_SouthOrWest ( type: esriFieldTypeString, alias: Morning Peak Time (South or West), length: 255 )
• MorningPeakVolume_SouthOrWest ( type: esriFieldTypeInteger, alias: Morning Peak Volume (South or West) )
• AfternoonPeakTime_NorthOrEast ( type: esriFieldTypeString, alias: Afternoon Peak Time (North or East), length: 255 )
• AfternoonPeakVolume_NorthOrEast ( type: esriFieldTypeInteger, alias: Afternoon Peak Volume (North or East) )
• AfternoonPeakTime_SouthOrWest ( type: esriFieldTypeString, alias: Afternoon Peak Time (South or West), length: 255 )
• AfternoonPeakVolume_SouthOrWest ( type: esriFieldTypeInteger, alias: Afternoon Peak Volume (South or West) )
• SpeedLimit ( type: esriFieldTypeSmallInteger, alias: Speed Limit )
• CountExceedingSpeedLimit ( type: esriFieldTypeInteger, alias: Count Exceeding Speed Limit )
• PercentageExceedingSpeedLimit ( type: esriFieldTypeDouble, alias: % Exceeding Speed Limit )
• NeedsToBeProcessed ( type: esriFieldTypeSmallInteger, alias: Should Python script process? , Coded Values: [0: False] , [1: True] )

Relationships:

• HPWGDB_Staging.TDO.TrafficCount_Deployments (18) -- Related To: Traffic Count Deployments (23)
• HPWGDB_Staging.TDO.DropLocations (0) -- Related To: Major Thoroughfare ADT (4)
• HPWGDB_Staging.TDO.DropLocations (2) -- Related To: Local Street ADT (5)
• HPWGDB_Staging.TDO.DropLocations (4) -- Related To: Approach (6)
• HPWGDB_Staging.TDO.DropLocations (6) -- Related To: Railroad (7)
• HPWGDB_Staging.TDO.DropLocations (8) -- Related To: Speed (8)
• HPWGDB_Staging.TDO.DropLocations (10) -- Related To: Classification (9)
• HPWGDB_Staging.TDO.DropLocations (12) -- Related To: Special (10)
• HPWGDB_Staging.TDO.DropLocations (14) -- Related To: Pre Speed Study (16)
• HPWGDB_Staging.TDO.DropLocations (16) -- Related To: Post Speed Study (17)

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

  Iteminfo   Thumbnail   Metadata