data-act-gov-au/actqp-hts-average-trip-time-categorised-by-trip-2hx4-2gfs
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 2 years ago
Indexed 1 month ago

ACTQP HTS - Average Trip Time Categorised by Trip Purpose and Time of Day

This data set provides the average time of trips (in minutes) categorised by the purpose of the trip and the time of day. 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, and average times include wait times at transport interchanges. The main method of travel across a trip is used to classify trip types. The time of day is based on the mid-point of the start and arrival time of the trip.

AM Peak: 8-9AM, PM Peak: 5-6PM

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-time-categorised-by-trip-2hx4-2gfs\".\"actqp_hts_average_trip_time_categorised_by_trip\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • actqp_hts_average_trip_time_categorised_by_trip
     
     
     
     
     
Upstream Metadata