excel交通规划“四阶段法”教程

Input 2: Household Demographic IDensfcorimpationn: and income
Income 0 Cars 1 Car 2 Cars
Identifies # of households in each zone with the specified car ownership
2.2
8.9
1.4
5.2
2.1
8.7
2.1
5.7
2.3 10.1
2.5
6.8
3.1 12.4
Input 5: Trip Attraction Coefficient Table Trip Attraction Table Trip Type HBW HBO NHB
Reference: HBW = 1.45(Total Equation Employment)
Low
Middle
High Low
Middle
0
0
0
0
0
2000
8000 10000
0 4000
8000
22000 30000
0 16000
Input 4: Trip Production Table: Cars/HH
0
1
2
HH Income
HBW
Low
Middle
High
Low
Middle
High
4
6
4
5
4
6
5
10
5
Trip Generation Objective: Estimate the number of trips entering and leaving each zone Inputs: Zone Characteristics (# of HH, HH Income, Auto Ownership, Employment, etc.) Outputs: # of Productions, # of Attractions
Input 6: Travel Time Table: Time in (minutes)
Destination
TAZ 1 TAZ 2 TAZ 3 TAZ 4
TAZ 1
5 6
TAZ 2 TAZ 3 TAZ 4
2.5
10
20
20
10
2.5
20
20
20
20
2.5
10
20
20
10
2.5
5
5
15
15
15
15
1.7 10 2
Other 1.7 0.5 2.5
Trip Distribution Objective: Estimate the number of trips made between each zone Inputs: Productions, Attractions, Travel time between zones Outputs: # of Person Trips from Zone i to Zone j
NCHRP Report 365,
Transportation
Research Board,
Washington, DC.
# of Productions/HH
HΒιβλιοθήκη BaiduO
NHB
Total
0.5
2
0.9
3.4
1.1
3
1.2
5.3
1.4
3.9
1.8
7.1
0.8
3.2
1.3
5.3
1.5
3.9
1.6
7
1.8
4.9
5
5
Origin
Input 7: Friction Factor Coefficients:
Trip Purpose
a
HBW HBO
NHB
b
28507 139173
c
-0.02 -0.123 -1.285 -0.094
219113
-1.332 -0.1
Friction Factor Model: (Gamma Model)
# of HH
Retail
0
0.9
0.5
ITE Trip
Attraction Rates
Employment Type
Service Other
1.45 1.45 1.45
9
1.7
0.5
4.1
1.2
0.5
HBO = 0.9(# of Households) + 9(Retail Employment) + 1.7(Service Employment) + 0.5(Other Employment) NHB = 0.5(# of Households) + 4.1(Retail Employment) + 1.2(Service Employment) + 0.5(Other Employment)
Input 1: Traffic Network
from_node_id
to_node_ length_i number_o
id
n_mile f_lanes
1
2
10
4
1
3
20
4
1
5
5
4
2
1
10
4
2
4
20
4
2
5
5
4
3
1
20
4
3
4
10
4
3
6
5
4
4
2
20
4
4
3
10
4
4
6
5
4
5
1
5
4
5
2
5
4
5
6
10
5
6
3
5
Zone 1
Zone 2
Low
Middle
High Low
Middle
4000
8000 8000 2000 4000
12000
32000 36000 8000 26000
4000
20000 16000 10000 30000
Zone 3
Zone 4
Income 0 Cars 1 Car 2 Cars
Alternative Trip
Attraction Table
Trip Type HBW
# of HH
Retail 0
HBO
1
NHB
0.5
Quick Response
Method Tables
Source:
(NCHRP 187, Sosslau et al., 1978)
Employment Type
SOLUTION PROCESS Trip Productions
i= origin zone
j= destinat ion zone
Method:
Cross Classification
Process:
Trip Production Table:
Cars/HH 0 1 2
HH Income Low Middle High Low Middle High Low Middle High
Low
Middle
High
Source: based on
Martin and
McGuckin (1998),
Table 7, pg. 27.
Martin,W.A. and
N.A.McGuckin
(1998). Travel
Estimation
Techniques for
Urban Planning,
Given Household Characteristics Data: