Transportation Management in the City of Cambridge

1
Transportation Management in the City of Cambridge

• Colleen Shaver
• Matt Gage
• Josh West
• Kimberly Johnstone
• Sunday, September 06, 2009

2
Global Problems

• Growing population
• Increasing Traffic
• Limited city space

3
The Problem in Cambridge

• Recent developments altering traffic flow
• No standard for data collection
• Traffic data is not maintained in one single
  location

4
Project Objectives

• Evaluation of Current Traffic Management
  Practices
• Development of Standardized Formats
• Adaptation of Existing Data to New Standards
• Demonstration of Usefulness of System by
  Interpretation of Existing Data

5
Project Objectives
Evaluation of Current Traffic Management Practices
Development of Standardized Formats
Adaptation of Existing Data to New Standards
Interpretation of Existing Data
6
Sources of Data
Required Analysis -Trip Generation -Level of
Service -Lane Queues -Bicycles
Pedestrians -Residential Street Volumes CTPTD
can require other information
From constituent complaints Need for
roadwork Need for resignalization
From constituent complaints Need for
roadwork Need for resignalization Planning /
Zoning Studies
7
Standardized Data Collection Forms
8
Standardized Data Collection Forms
9
Study Area
10
Data Collection
11
Adaptation of Existing Data to New Standards

• Gathered previously existing and newly collected
  data
• Entered data into our new database

12
Relationships Within Database Structure

• Each table is linked to insure data integrity

13
Database Capabilities

• Allows standardized data to be entered easily
• Maintains accurate data
• Allows data manipulation

14
Traffic Count Form
15
Verification of Traffic Data Assumptions

• Inaccurate representations of traffic flow
• Monday and Friday
• 10 day-to-day variation of data
• Data need to be analyzed in an exact form

16
Data Usefulness

• Data collected on Monday and Friday does
  significantly skew weekly data

17
Day-to-Day Variation

• Volume information will vary no more than 10
  from day to day

10 Day-to-Day Variation
18
Rounding Traffic Data

• Rounding traffic data does not affect the outcome
  of a data analysis

19
Necco Fire Data Analysis
20
Interpretation of Existing Data

• Sample graphical output from database

21
Interpretation of Existing Data
22
Interpretation of Existing Data
23
Demonstration of Usefulness
24
Demonstration of Usefulness
25
Demonstration of Usefulness
26
Demonstration of Usefulness
27
Demonstration of Usefulness
28
Recommendations

• Advanced Functionality of Transportation
  Management Systems
• Increased Interactivity of GIS Layers
• Integration with Existing Databases
• Cross-departmental Applications

29
Recommendations

• Standardization of Consultant Reports
• Creation of Numbering System for Non-street
  Segments
• Backup and Recovery of Database

30
Questions?