Field Name |
Name |
Type |
Description |
Fixed Values |
|
jtwid |
CHAR(133) |
Journey to work ID |
|
|
persid |
CHAR() |
Person ID number |
|
|
hhid |
CHAR(129) |
Household ID Number |
|
|
jtwtraveltime |
INTEGER(135) |
Journey to work - travel time (excludes stops, in minutes) |
|
|
jtw_at |
INTEGER(130) |
Journey to work - non-travel time (mins) |
|
|
jtwelapsedtime |
INTEGER(132) |
Journey to work - total elapsed travel time (inc. stops, in minutes) |
|
|
jtwdist |
FLOAT(131) |
Journey to work - distance (in km) |
|
|
jtwmode |
CHAR(134) |
Journey to work - main mode (assigned) |
|
|
starthour |
INTEGER() |
Hour of starting Journey |
|
|
startime |
INTEGER() |
Time of starting Journey (in minutes, from midnight) |
|
|
arrhour |
INTEGER(255) |
Hour of ending journey (27 hr - day)� |
|
|
arrtime |
INTEGER(100) |
Time of ending journey (in minutes, from midnight)� |
|
|
duration |
INTEGER(128) |
Duration at journey destination |
|
|
dephour |
INTEGER(101) |
Hour Departing from journey destination (from midnight) |
|
|
deptime |
INTEGER(102) |
Time of Departing from journey destination (in minutes, from midnight) |
|
|
origLGA |
CHAR() |
Journey origin – Local government Area |
|
|
destLGA |
CHAR(103) |
Journey destination � Local government Area |
|
|
dist1 |
FLOAT(104) |
Travel distance for journey-stage (Stop) #1 (in km)�� |
|
|
dist2 |
FLOAT(108) |
Travel distance for journey-stage (Stop) #2�� |
|
|
dist3 |
FLOAT(109) |
Travel distance for journey-stage (Stop) #3���� |
|
|
dist4 |
FLOAT(110) |
Travel distance for journey-stage (Stop) #4���� |
|
|
dist5 |
FLOAT(111) |
Travel distance for journey-stage (Stop) #5���� |
|
|
dist6 |
FLOAT(112) |
Travel distance for journey-stage (Stop) #6���� |
|
|
dist7 |
FLOAT(113) |
Travel distance for journey-stage (Stop) #7���� |
|
|
dist8 |
FLOAT(114) |
Travel distance for journey-stage (Stop) #8���� |
|
|
dist9 |
FLOAT(115) |
Travel distance for journey-stage (Stop) #9���� |
|
|
dist10 |
FLOAT(105) |
Travel distance for journey-stage (Stop) #10 |
|
|
dist11 |
FLOAT(106) |
Travel distance for journey-stage (Stop) #11���� |
|
|
dist12 |
FLOAT(107) |
Travel distance for journey-stage (Stop) #12���� |
|
|
dur1 |
INTEGER(116) |
Duration at place #1 (in Minutes)� |
|
|
dur2 |
INTEGER(120) |
Duration at place #2� |
|
|
dur3 |
INTEGER(121) |
Duration at place #3� |
|
|
dur4 |
INTEGER(122) |
Duration at place #4� |
|
|
dur5 |
INTEGER(123) |
Duration at place #5� |
|
|
dur6 |
INTEGER(124) |
Duration at place #6� |
|
|
dur7 |
INTEGER(125) |
Duration at place #7� |
|
|
dur8 |
INTEGER(126) |
Duration at place #8� |
|
|
dur9 |
INTEGER(127) |
Duration at place #9� |
|
|
dur10 |
INTEGER(117) |
Duration at place #10� |
|
|
dur11 |
INTEGER(118) |
Duration at place #11� |
|
|
dur12 |
INTEGER(119) |
Duration at place #12� |
|
|
mode1 |
CHAR(136) |
Travel mode for Journey-stage (stop) #1�� |
|
|
mode2 |
CHAR(140) |
Travel mode for Journey-stage (stop) #2���� |
|
|
mode3 |
CHAR() |
Travel mode for Journey-stage (stop) #3 |
|
|
mode4 |
CHAR() |
Travel mode for Journey-stage (stop) #4 |
|
|
mode5 |
CHAR() |
Travel mode for Journey-stage (stop) #5 |
|
|
mode6 |
CHAR() |
Travel mode for Journey-stage (stop) #6 |
|
|
mode7 |
CHAR() |
Travel mode for Journey-stage (stop) #7 |
|
|
mode8 |
CHAR() |
Travel mode for Journey-stage (stop) #8 |
|
|
mode9 |
CHAR() |
Travel mode for Journey-stage (stop) #9 |
|
|
mode10 |
CHAR(137) |
Travel mode for Journey-stage (stop) #10��� |
|
|
mode11 |
CHAR(138) |
Travel mode for Journey-stage (stop) #11��� |
|
|
mode12 |
CHAR(139) |
Travel mode for Journey-stage (stop) #12��� |
|
|
place1 |
CHAR() |
Type of destination - Journey-stage (stop) #1 |
|
|
place2 |
CHAR() |
Type of destination - Journey-stage (stop) #2 |
|
|
place3 |
CHAR() |
Type of destination - Journey-stage (stop) #3 |
|
|
place4 |
CHAR() |
Type of destination - Journey-stage (stop) #4 |
|
|
place5 |
CHAR() |
Type of destination - Journey-stage (stop) #5 |
|
|
place6 |
CHAR() |
Type of destination - Journey-stage (stop) #6 |
|
|
place7 |
CHAR() |
Type of destination - Journey-stage (stop) #7 |
|
|
place8 |
CHAR() |
Type of destination - Journey-stage (stop) #8 |
|
|
place9 |
CHAR() |
Type of destination - Journey-stage (stop) #9 |
|
|
place10 |
CHAR() |
Type of destination - Journey-stage (stop) #10 |
|
|
place11 |
CHAR() |
Type of destination - Journey-stage (stop) #11 |
|
|
place12 |
CHAR() |
Type of destination - Journey-stage (stop) #12 |
|
|
purp1 |
CHAR() |
Purpose - Journey-stage (stop) #1 |
|
|
purp2 |
CHAR() |
Purpose - Journey-stage (stop) #2 |
|
|
purp3 |
CHAR() |
Purpose - Journey-stage (stop) #3 |
|
|
purp4 |
CHAR() |
Purpose - Journey-stage (stop) #4 |
|
|
purp5 |
CHAR() |
Purpose - Journey-stage (stop) #5 |
|
|
purp6 |
CHAR() |
Purpose - Journey-stage (stop) #6 |
|
|
purp7 |
CHAR() |
Purpose - Journey-stage (stop) #7 |
|
|
purp8 |
CHAR() |
Purpose - Journey-stage (stop) #8 |
|
|
purp9 |
CHAR() |
Purpose - Journey-stage (stop) #9 |
|
|
purp10 |
CHAR() |
Purpose - Journey-stage (stop) #10 |
|
|
purp11 |
CHAR() |
Purpose - Journey-stage (stop) #11 |
|
|
purp12 |
CHAR() |
Purpose - Journey-stage (stop) #12 |
|
|
stop1 |
CHAR() |
STOP ID - Journey-stage (stop) #1 |
|
|
stop2 |
CHAR() |
STOP ID - Journey-stage (stop) #2 |
|
|
stop3 |
CHAR() |
STOP ID - Journey-stage (stop) #3 |
|
|
stop4 |
CHAR() |
STOP ID - Journey-stage (stop) #4 |
|
|
stop5 |
CHAR() |
STOP ID - Journey-stage (stop) #5 |
|
|
stop6 |
CHAR() |
STOP ID - Journey-stage (stop) #6 |
|
|
stop7 |
CHAR() |
STOP ID - Journey-stage (stop) #7 |
|
|
stop8 |
CHAR() |
STOP ID - Journey-stage (stop) #8 |
|
|
stop9 |
CHAR() |
STOP ID - Journey-stage (stop) #9 |
|
|
stop10 |
CHAR() |
STOP ID - Journey-stage (stop) #10 |
|
|
stop11 |
CHAR() |
STOP ID - Journey-stage (stop) #11 |
|
|
stop12 |
CHAR() |
STOP ID - Journey-stage (stop) #12 |
|
|
time1 |
INTEGER() |
Travel time for journey-stage (stop) #1 (in minutes) |
|
|
time2 |
INTEGER() |
Travel time for journey-stage (stop) #2 |
|
|
time3 |
INTEGER() |
Travel time for journey-stage (stop) #3 |
|
|
time4 |
INTEGER() |
Travel time for journey-stage (stop) #4 |
|
|
time5 |
INTEGER() |
Travel time for journey-stage (stop) #5 |
|
|
time6 |
INTEGER() |
Travel time for journey-stage (stop) #6 |
|
|
time7 |
INTEGER() |
Travel time for journey-stage (stop) #7 |
|
|
time8 |
INTEGER() |
Travel time for journey-stage (stop) #8 |
|
|
time9 |
INTEGER() |
Travel time for journey-stage (stop) #9 |
|
|
time10 |
INTEGER() |
Travel time for journey-stage (stop) #10 |
|
|
time11 |
INTEGER() |
Travel time for journey-stage (stop) #11 |
|
|
time12 |
INTEGER() |
Travel time for journey-stage (stop) #12 |
|
|
wdjtwwgt_LGA |
FLOAT() |
JTW weight for an 'Average weekday' of the combined 2012-20 dataset, using the ASGC. |
|
|
wejtwwgt_LGA |
FLOAT() |
JTW weight for an 'Average weekend day' of the combined 2012-20 dataset, using the ASGC. |
|