| Field Name |
Name |
Type |
Description |
Fixed Values |
| hhid |
Household ID |
|
Household ID |
|
| persid |
Person ID |
|
Person ID |
|
| jtwid |
Journey to work ID |
|
Journey ID |
|
| dayType |
Travel day type |
CHAR() |
Household travel day type: weekday or weekend |
|
| start_loc |
Start location |
CHAR() |
Journey start Location (Group) |
|
| start_stopid |
Start Stop ID |
|
Journey start stop ID (ID from Stop data file) |
|
| start_time |
Start time |
CHAR() |
Journey start time |
|
| start_LGA |
Start LGA |
CHAR() |
Journey start Local Government Area (LGA) name |
|
| end_loc |
End location |
CHAR() |
Journey end Location (Group) |
|
| end_stopid |
End Stop ID |
|
Journey end stop ID (ID from Stop data file) |
|
| end_time |
End time |
CHAR() |
Journey end time |
|
| end_LGA |
End LGA |
CHAR() |
Journey end Local Government Area (LGA) name |
|
| mainmode_desc_01 |
Mode of stop 1 |
CHAR() |
Travel mode for journey-stage (stop) #1 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_02 |
Mode of stop 2 |
CHAR() |
Travel mode for journey-stage (stop) #2 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_03 |
Mode of stop 3 |
CHAR() |
Travel mode for journey-stage (stop) #3 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_04 |
Mode of stop 4 |
CHAR() |
Travel mode for journey-stage (stop) #4 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_05 |
Mode of stop 5 |
CHAR() |
Travel mode for journey-stage (stop) #5 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_06 |
Mode of stop 6 |
CHAR() |
Travel mode for journey-stage (stop) #6 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_07 |
Mode of stop 7 |
CHAR() |
Travel mode for journey-stage (stop) #7 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_08 |
Mode of stop 8 |
CHAR() |
Travel mode for journey-stage (stop) #8 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_09 |
Mode of stop 9 |
CHAR() |
Travel mode for journey-stage (stop) #9 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_10 |
Mode of stop 10 |
CHAR() |
Travel mode for journey-stage (stop) #10 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_11 |
Mode of stop 11 |
CHAR() |
Travel mode for journey-stage (stop) #11 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_12 |
Mode of stop 12 |
CHAR() |
Travel mode for journey-stage (stop) #12 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_13 |
Mode of stop 13 |
CHAR() |
Travel mode for journey-stage (stop) #13 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_14 |
Mode of stop 14 |
CHAR() |
Travel mode for journey-stage (stop) #14 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| mainmode_desc_15 |
Mode of stop 15 |
CHAR() |
Travel mode for journey-stage (stop) #15 |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| destpurp1_desc_01 |
Destination purpose stop 1 |
CHAR() |
Destination purpose for journey-stage (stop) #1 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_02 |
Destination purpose stop 2 |
CHAR() |
Destination purpose for journey-stage (stop) #2 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_03 |
Destination purpose stop 3 |
CHAR() |
Destination purpose for journey-stage (stop) #3 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_04 |
Destination purpose stop 4 |
CHAR() |
Destination purpose for journey-stage (stop) #4 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_05 |
Destination purpose stop 5 |
CHAR() |
Destination purpose for journey-stage (stop) #5 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_06 |
Destination purpose stop 6 |
CHAR() |
Destination purpose for journey-stage (stop) #6 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_07 |
Destination purpose stop 7 |
CHAR() |
Destination purpose for journey-stage (stop) #7 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_08 |
Destination purpose stop 8 |
CHAR() |
Destination purpose for journey-stage (stop) #8 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_09 |
Destination purpose stop 9 |
CHAR() |
Destination purpose for journey-stage (stop) #9 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_10 |
Destination purpose stop 10 |
CHAR() |
Destination purpose for journey-stage (stop) #10 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_11 |
Destination purpose stop 11 |
CHAR() |
Destination purpose for journey-stage (stop) #11 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_12 |
Destination purpose stop 12 |
CHAR() |
Destination purpose for journey-stage (stop) #12 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_13 |
Destination purpose stop 13 |
CHAR() |
Destination purpose for journey-stage (stop) #13 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_14 |
Destination purpose stop 14 |
CHAR() |
Destination purpose for journey-stage (stop) #14 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destpurp1_desc_15 |
Destination purpose stop 15 |
CHAR() |
Destination purpose for journey-stage (stop) #15 |
Change Mode; Accompany Someone; Buy Something; Pick-up or Deliver Something; Pick-up or Drop-off Someone; Education; Work Related; At Home; Personal Business; Social; Recreational; Other Purpose; Unknown Purpose (at start of day) |
| destplace1_desc_01 |
Destination place stop 1 |
CHAR() |
Destination place for journey-stage (stop) #1 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_02 |
Destination place stop 2 |
CHAR() |
Destination place for journey-stage (stop) #2 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_03 |
Destination place stop 3 |
CHAR() |
Destination place for journey-stage (stop) #3 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_04 |
Destination place stop 4 |
CHAR() |
Destination place for journey-stage (stop) #4 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_05 |
Destination place stop 5 |
CHAR() |
Destination place for journey-stage (stop) #5 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_06 |
Destination place stop 6 |
CHAR() |
Destination place for journey-stage (stop) #6 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_07 |
Destination place stop 7 |
CHAR() |
Destination place for journey-stage (stop) #7 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_08 |
Destination place stop 8 |
CHAR() |
Destination place for journey-stage (stop) #8 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_09 |
Destination place stop 9 |
CHAR() |
Destination place for journey-stage (stop) #9 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_10 |
Destination place stop 10 |
CHAR() |
Destination place for journey-stage (stop) #10 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_11 |
Destination place stop 11 |
CHAR() |
Destination place for journey-stage (stop) #11 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_12 |
Destination place stop 12 |
CHAR() |
Destination place for journey-stage (stop) #12 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_13 |
Destination place stop 13 |
CHAR() |
Destination place for journey-stage (stop) #13 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_14 |
Destination place stop 14 |
CHAR() |
Destination place for journey-stage (stop) #14 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| destplace1_desc_15 |
Destination place stop 15 |
CHAR() |
Destination place for journey-stage (stop) #15 |
Transport Feature; Accommodation; Place of work; Outdoor feature; Place of education; Retail venue; Personal services; Entertainment venue; Sport and Recreation venue; Other place; Not applicable |
| startime_01 |
Start time stop 1 |
CHAR() |
Start time for journey-stage (stop) #1 |
|
| startime_02 |
Start time stop 2 |
CHAR() |
Start time for journey-stage (stop) #2 |
|
| startime_03 |
Start time stop 3 |
CHAR() |
Start time for journey-stage (stop) #3 |
|
| startime_04 |
Start time stop 4 |
CHAR() |
Start time for journey-stage (stop) #4 |
|
| startime_05 |
Start time stop 5 |
CHAR() |
Start time for journey-stage (stop) #5 |
|
| startime_06 |
Start time stop 6 |
CHAR() |
Start time for journey-stage (stop) #6 |
|
| startime_07 |
Start time stop 7 |
CHAR() |
Start time for journey-stage (stop) #7 |
|
| startime_08 |
Start time stop 8 |
CHAR() |
Start time for journey-stage (stop) #8 |
|
| startime_09 |
Start time stop 9 |
CHAR() |
Start time for journey-stage (stop) #9 |
|
| startime_10 |
Start time stop 10 |
CHAR() |
Start time for journey-stage (stop) #10 |
|
| startime_11 |
Start time stop 11 |
CHAR() |
Start time for journey-stage (stop) #11 |
|
| startime_12 |
Start time stop 12 |
CHAR() |
Start time for journey-stage (stop) #12 |
|
| startime_13 |
Start time stop 13 |
CHAR() |
Start time for journey-stage (stop) #13 |
|
| startime_14 |
Start time stop 14 |
CHAR() |
Start time for journey-stage (stop) #14 |
|
| startime_15 |
Start time stop 15 |
CHAR() |
Start time for journey-stage (stop) #15 |
|
| arrtime_01 |
Arrival time stop 1 |
CHAR() |
End time for journey-stage (stop) #1 |
|
| arrtime_02 |
Arrival time stop 2 |
CHAR() |
End time for journey-stage (stop) #2 |
|
| arrtime_03 |
Arrival time stop 3 |
CHAR() |
End time for journey-stage (stop) #3 |
|
| arrtime_04 |
Arrival time stop 4 |
CHAR() |
End time for journey-stage (stop) #4 |
|
| arrtime_05 |
Arrival time stop 5 |
CHAR() |
End time for journey-stage (stop) #5 |
|
| arrtime_06 |
Arrival time stop 6 |
CHAR() |
End time for journey-stage (stop) #6 |
|
| arrtime_07 |
Arrival time stop 7 |
CHAR() |
End time for journey-stage (stop) #7 |
|
| arrtime_08 |
Arrival time stop 8 |
CHAR() |
End time for journey-stage (stop) #8 |
|
| arrtime_09 |
Arrival time stop 9 |
CHAR() |
End time for journey-stage (stop) #9 |
|
| arrtime_10 |
Arrival time stop 10 |
CHAR() |
End time for journey-stage (stop) #10 |
|
| arrtime_11 |
Arrival time stop 11 |
CHAR() |
End time for journey-stage (stop) #11 |
|
| arrtime_12 |
Arrival time stop 12 |
CHAR() |
End time for journey-stage (stop) #12 |
|
| arrtime_13 |
Arrival time stop 13 |
CHAR() |
End time for journey-stage (stop) #13 |
|
| arrtime_14 |
Arrival time stop 14 |
CHAR() |
End time for journey-stage (stop) #14 |
|
| arrtime_15 |
Arrival time stop 15 |
CHAR() |
End time for journey-stage (stop) #15 |
|
| vistadist_01 |
Distance stop 1 |
CHAR() |
Distance travelled for journey-stage (stop) #1 |
|
| vistadist_02 |
Distance stop 2 |
CHAR() |
Distance travelled for journey-stage (stop) #2 |
|
| vistadist_03 |
Distance stop 3 |
CHAR() |
Distance travelled for journey-stage (stop) #3 |
|
| vistadist_04 |
Distance stop 4 |
CHAR() |
Distance travelled for journey-stage (stop) #4 |
|
| vistadist_05 |
Distance stop 5 |
CHAR() |
Distance travelled for journey-stage (stop) #5 |
|
| vistadist_06 |
Distance stop 6 |
CHAR() |
Distance travelled for journey-stage (stop) #6 |
|
| vistadist_07 |
Distance stop 7 |
CHAR() |
Distance travelled for journey-stage (stop) #7 |
|
| vistadist_08 |
Distance stop 8 |
CHAR() |
Distance travelled for journey-stage (stop) #8 |
|
| vistadist_09 |
Distance stop 9 |
CHAR() |
Distance travelled for journey-stage (stop) #9 |
|
| vistadist_10 |
Distance stop 10 |
CHAR() |
Distance travelled for journey-stage (stop) #10 |
|
| vistadist_11 |
Distance stop 11 |
CHAR() |
Distance travelled for journey-stage (stop) #11 |
|
| vistadist_12 |
Distance stop 12 |
CHAR() |
Distance travelled for journey-stage (stop) #12 |
|
| vistadist_13 |
Distance stop 13 |
CHAR() |
Distance travelled for journey-stage (stop) #13 |
|
| vistadist_14 |
Distance stop 14 |
CHAR() |
Distance travelled for journey-stage (stop) #14 |
|
| vistadist_15 |
Distance stop 15 |
CHAR() |
Distance travelled for journey-stage (stop) #15 |
|
| travtime_01 |
Travel time stop 1 |
CHAR() |
Travel time for journey-stage (stop) #1 |
|
| travtime_02 |
Travel time stop 2 |
CHAR() |
Travel time for journey-stage (stop) #2 |
|
| travtime_03 |
Travel time stop 3 |
CHAR() |
Travel time for journey-stage (stop) #3 |
|
| travtime_04 |
Travel time stop 4 |
CHAR() |
Travel time for journey-stage (stop) #4 |
|
| travtime_05 |
Travel time stop 5 |
CHAR() |
Travel time for journey-stage (stop) #5 |
|
| travtime_06 |
Travel time stop 6 |
CHAR() |
Travel time for journey-stage (stop) #6 |
|
| travtime_07 |
Travel time stop 7 |
CHAR() |
Travel time for journey-stage (stop) #7 |
|
| travtime_08 |
Travel time stop 8 |
CHAR() |
Travel time for journey-stage (stop) #8 |
|
| travtime_09 |
Travel time stop 9 |
CHAR() |
Travel time for journey-stage (stop) #9 |
|
| travtime_10 |
Travel time stop 10 |
CHAR() |
Travel time for journey-stage (stop) #10 |
|
| travtime_11 |
Travel time stop 11 |
CHAR() |
Travel time for journey-stage (stop) #11 |
|
| travtime_12 |
Travel time stop 12 |
CHAR() |
Travel time for journey-stage (stop) #12 |
|
| travtime_13 |
Travel time stop 13 |
CHAR() |
Travel time for journey-stage (stop) #13 |
|
| travtime_14 |
Travel time stop 14 |
CHAR() |
Travel time for journey-stage (stop) #14 |
|
| travtime_15 |
Travel time stop 15 |
CHAR() |
Travel time for journey-stage (stop) #15 |
|
| main_journey_mode |
Main journey mode |
CHAR() |
Main journey to work mode of transport |
Vehicle Driver; Vehicle Passenger; Motorcycle; Walking; Bicycle; Taxi; Train; Tram; School Bus; Public Bus; Plane; Other; Mobility Scooter; Rideshare Service; e-Scooter; Running/jogging |
| journey_travel_time |
Journey travel time |
CHAR() |
Total journey travel time |
|
| journey_distance |
Journey distance |
CHAR() |
Total journey distance |
|
| journey_elapsed_time |
Journey elapsed time |
CHAR() |
Total journey time (travel time plus wait time) |
|
| journey_weight |
Journey weight |
CHAR() |
Journey expansion weights |
|
| homesubregion_ASGS |
Home Subregion |
CHAR() |
Household subregion sorted into Greater Melbourne - Inner/Middle/Outer and regions into SA4 |
|
| homeregion_ASGS |
Home region |
CHAR() |
Household region sorted into Greater Melbourne (GGCS), Ballarat SA4, Bendigo SA4, Geelong SA4, Latrobe SA4, Shepparton SA4 |
|
