CE 573 Transportation Planning - Fall 2001

Administration Course materials Other links
week 1 week 2 week 3 week 4
week 5 week 6 week 7 week 8
week 9 week 10 week 11 week 12
week 13 week 14 week 15

Assignment  15

The purpose of this assignment is to prepare a data base with the network characteristics and the trip generation data.

Please complete the following tasks by Monday, November 5th.  You should use an Excel spreadsheet for this exercise, with each of the problems below on separate worksheets.

1. Prepare a trip generation data base with zonal data, household data, and employment data for the area that is represented by the nine zone system. Use the trip generation production equations given in Table 6 (page 34) of your notes on "Travel Estimation Techniques" for urban areas 50,000 to 199,999 (weighted average household size). Use the trip attraction equations given on page 36 (Table 7). Only use the CBD equation, not the non-CBD equations. Also, use all three trip purposes: home-based work, home-based other, and non-home based.

Zone Households Retail Employment Service Employment Other Employment
1  300 5000 10000 1500
2 100 2000 0 0
3 0 0 0 2500
4 500 0 0 0
5 1000 0 0 0
6 1500 0 0 0
7 1500 0 0 0
8 2500 0 0 0
9 3000 0 0 0

2. Prepare a set of data describing the network link characteristics, including the two nodes specifying each link, the link distance, and the link speed. Use the xy coordinates from the network to compute the link distances. 

3. Balance the productions and attractions.