ACTQP HTS - Average Trip Distance Categorised by Transport Method and Trip Purpose

This data set provides the average trip distance (in km) categorised by the method of transport used and the purpose of the trip. This data is obtained from individuals sampled in obtaining data for the ACT Household Travel Survey.

A trip is defined as the travel between two main activities, where a stop may constitute a change in transport mode. As an example: driving from home to a park and ride facility, then catching a bus to an interchange, then walking to a shop to purchase an item and finally walking to work is comprised of 4 ‘stops’ and two ‘trips’.

Note: This data represents travel and activity on an average weekday. The main method of travel across a trip is used to classify trip types. Bus data includes school and public bus travel.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"data-act-gov-au/actqp-hts-average-trip-distance-categorised-by-9i94-epwn\".\"actqp_hts_average_trip_distance_categorised_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.