Name: TrafficCountAssignments_ExportTable

Display Field: Date

Type: Table

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: GlobalID

Type ID Field:

Fields:

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

Templates:

Name: TrafficCountAssignments_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/17/2024 3:25:36 PM

Schema Last Edit Date: 10/17/2024 3:25:36 PM

Data Last Edit Date: 10/17/2024 3:25:36 PM

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