City of Cambridge

Close
Author
Josh Wolff
Description
This dataset contains the Average Daily Traffic counts and AM and PM peak hour Traffic counts measured on various road segments in the City of Cambridge from 1972 to 2017. The counts in this data set reflect only vehicle counts. An Average Daily Count measures the number of vehicles for an entire day, or an average of several days. Automatic Traffic Recorders (ATRs) log every vehicle that passes in each direction and this data is used to calculate Average Daily Traffic volumes and AM and PM Peak Hour Traffic Volumes for the street. The Peak Hour is average highest number of vehicles recorded during the morning and evening peak hour. Not all streets have the same peak hour. For example, the peak hour for one street could be 5 pm to 6 pm, whereas a peak hour for another street could be from 5:15 pm to 6:15 pm. The peak hour for a street can also change from day to day. When counts are done for several days, the Peak Hour count is the average of the highest peak hour over those days. Automatic Traffic Recorders (ATR’s) are rubber hoses temporarily affixed to the street. When a vehicle passes, a pulse of air passes through the hose and triggers an air switch in a recording device on the roadside. The recorder device is a small steel box powered by a battery. Air switch triggers are stored on board and later downloaded to a computer. Note: Traditional and older ATRs were not able to record bicycles, however, more recent ATR’s (past 5 to 10 years) have been able to record bicycles that pass over the recorder.
Category
Traffic, Parking, and Transportation
Tags
city of cambridge, traffic counts, adt, peak hour counts, cordon counts, traffic parking and transportation department, tp&t, tpt counts, vision zero
Rating
Current value: 0 out of 5
Data Provided By
City of Cambridge Traffic and Parking
Source Link
https://www.cambridgema.gov/traffic
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ID
id
PrimaryStreet
primarystreet
Location
location
Latitude
latitude
Longitude
longitude
Source
source
1972
_1972
1981
_1981
1987
_1987
1989
_1989
1994
_1994
1995
_1995
1996
_1996
1997
_1997
1998
_1998
1999
_1999
2000
_2000
2001
_2001
2002
_2002
2003
_2003
2004
_2004
2005
_2005
2006
_2006
2007
_2007
2008
_2008
2009
_2009
2010
_2010
2011
_2011
2012
_2012
2013
_2013
2014
_2014
2015
_2015
2016
_2016
2017
_2017
AMPeak1972
ampeak1972
AMPeak1981
ampeak1981
AMPeak1987
ampeak1987
AMPeak1989
ampeak1989
AMPeak1994
ampeak1994
AMPeak1995
ampeak1995
AMPeak1996
ampeak1996
AMPeak1997
ampeak1997
AMPeak1998
ampeak1998
AMPeak1999
ampeak1999
AMPeak2000
ampeak2000
AMPeak2001
ampeak2001
AMPeak2002
ampeak2002
AMPeak2003
ampeak2003
AMPeak2004
ampeak2004
AMPeak2005
ampeak2005
AMPeak2006
ampeak2006
AMPeak2007
ampeak2007
AMPeak2008
ampeak2008
AMPeak2009
ampeak2009
AMPeak2010
ampeak2010
AMPeak2011
ampeak2011
AMPeak2012
ampeak2012
AMPeak2013
ampeak2013
AMPeak2014
ampeak2014
AM Peak 2015
am_peak_2015
AM Peak 2016
am_peak_2016
AM Peak 2017
am_peak_2017
PMPeak1972
pmpeak1972
PMPeak1981
pmpeak1981
PMPeak1987
pmpeak1987
PMPeak1989
pmpeak1989
PMPeak1994
pmpeak1994
PMPeak1995
pmpeak1995
PMPeak1996
pmpeak1996
PMPeak1997
pmpeak1997
PMPeak1998
pmpeak1998
PMPeak1999
pmpeak1999
PMPeak2000
pmpeak2000
PMPeak2001
pmpeak2001
PMPeak2002
pmpeak2002
PMPeak2003
pmpeak2003
PMPeak2004
pmpeak2004
PMPeak2005
pmpeak2005
PMPeak2006
pmpeak2006
PMPeak2007
pmpeak2007
PMPeak2008
pmpeak2008
PMPeak2009
pmpeak2009
PMPeak2010
pmpeak2010
PMPeak2011
pmpeak2011
PMPeak2012
pmpeak2012
PMPeak2013
pmpeak2013
PMPeak2014
pmpeak2014
PM Peak 2015
pm_peak_2015
PM Peak 2016
pm_peak_2016
PM Peak 2017
pm_peak_2017
Classification Counts
classification_counts
cambridge_zipcodes
:@computed_region_rcj3_ccgu
Police Neighborhood Regions
:@computed_region_guic_hr4a
Police Response Districts
:@computed_region_v7jj_366k
cambridge_neighborhoods
:@computed_region_rffn_qbt6
cambridge_cdd_zoning
:@computed_region_swkg_bavi

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.