Name: 2017 Traffic Volumes

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

This dataset contains estimates of the average number of vehicles that used roads throughout the City of Detroit in 2017. Each record indicates the Annual Average Daily Traffic (AADT) and Commercial Annual Average Daily Traffic (CAADT) for a road segment, where the road segment is located, and other characteristics. This data is derived from Michigan Department of Transportation's (MDOT) Open Data Portal. SEMCOG was the source for speed limits and number of lanes.

The primary measure, Annual Average Daily Traffic (AADT), is the estimated mean daily traffic volume for all types of vehicles. Commercial Annual Average Daily Traffic (CAADT) is the estimated mean daily traffic volume for commercial vehicles, a subset of vehicles included in the AADT. The Route ID is an identifier for each road in Detroit (e.g., Woodward Ave). Routes are divided into segments by features such as cross streets, and Location ID's are used to uniquely identify those segments. Along with traffic volume, each record also states the number of lanes, the posted speed limit, and the type of road (e.g., Trunkline or Ramp) based on the Federal Highway Administration (FHWA) functional classification system.

According to MDOT's Traffic Monitoring Program a commercial vehicle would be anything Class 4 and up in the FHWA vehicle classification system. This includes vehicles such as buses, semi-trucks, and personal recreational vehicles (i.e., RVs or campers). Methods used to determine traffic volume vary by site, and may rely on continuous monitoring or estimates based on short-term studies. Approaches to vehicle classification similarly vary, depending on the equipment used at a site, and may consider factors such as vehicle weight and length between axles.

For more information, please visit MDOT Traffic Monitoring Program.

Note: The 2017 Traffic Volume year does not include two columns included in other years. The columns (NUM_COMBINED_UNIT_CAADT and .NUM_SINGLE_UNIT_CAADT) were missing from the source data.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9270788.82996285
YMin: 5200668.12712655
XMax: -9229588.48743914
YMax: 5228683.66516705
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• route_location_id (type: esriFieldTypeString, alias: Route Location ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• route_id (type: esriFieldTypeInteger, alias: Route ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• beginning_milepoint (type: esriFieldTypeSingle, alias: Beginning Milepoint, SQL Type: sqlTypeReal, nullable: true, editable: true)
• ending_milepoint (type: esriFieldTypeSingle, alias: Ending Milepoint, SQL Type: sqlTypeReal, nullable: true, editable: true)
• location_id (type: esriFieldTypeString, alias: Location ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• facility_type (type: esriFieldTypeString, alias: Route Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• program (type: esriFieldTypeString, alias: Traffic Program Identifier, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• num_aadt (type: esriFieldTypeInteger, alias: Annual Average Daily Traffic Count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• num_caadt (type: esriFieldTypeSmallInteger, alias: Annual Average Daily Commercial Traffic Count, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• from_description (type: esriFieldTypeString, alias: Start Point, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• to_description (type: esriFieldTypeString, alias: End Point, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• num_lanes (type: esriFieldTypeSmallInteger, alias: Total Number of Lanes, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• nfc_name (type: esriFieldTypeString, alias: NFC Classification, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• posted_speed (type: esriFieldTypeSmallInteger, alias: Posted Speed, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeFloat, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/1/2025 7:05:53 AM

Schema Last Edit Date: 1/1/2025 7:05:53 AM

Data Last Edit Date: 1/1/2025 7:05:53 AM

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