Freight Vehicle Congestion in Australia's 5 Major Cities

Brief description

Data hosted on data.gov.au

Full description

2019 Congestion Report Data - There are four files containing the data displayed in the BITRE Congestion Report, three csv files and one geojson. The file containing route parameters can be found at the github repository at github.com/bitre-telematics/congestion.\r\nThe three files are:\r\nroute_metrics.csv: Containing summary data on each route, with the fields\r\n route_name - name of route in report\r\n min median travel time - the lowest median travel time (by hour) for the route\r\n max median travel time - the highest median traveltime (by hour) for the route\r\n Peak time to best ratio - The ratio of longest to shortest median time\r\n min iq travel time - the interquartile range width for the hour in which is was most narrow\r\n max iq travel time - the interquartile range width for the hour in which is was most wide\r\n Peak iq to best ratio - the ratio of the widest to most narrow iq ranges\r\n min median travel hour - the hour of day (from 0 to 23) when median travel times were least\r\n max median travel hour - the hour of day (from 0 to 23) when median travel times were greatest\r\n min iq travel hour - the hour of day for which the iq range was narrowest\r\n max iq travel hour - the hour of day for which the iq range was greatest\r\n total obvs - the number of vehicle observations used to calculate all time\r\n Mean excess time ratio - the arithmetic mean of the ratio, by hour, of travel times to the best travel time\r\n Mean excess time ratio - weighted - the arithmetic mean of the ratio, by hour, of travel times to the best travel time, weighted by observations in that hour - hour of the day (from 0 to 23)\r\n Mean excess iq ratio - the arithmetic mean of the ratio, by hour, of iq ranges to the best iq range\r\n Mean excess iq ratio - weighted - the arithmetic mean of the ratio, by hour, of iq ranges to the best iq range, weighted by observations in that hour\r\n distance - the length of the route in metres\r\n\r\nroute_times.csv: Containing data for each hour, as graphed in the report, with the fields\r\n route_name - name of route\r\n hour - hour of the day (from 0 to 23)\r\n LQ_est - the travel time at the lowest quartile of speeds (that is the upper quartile of travel times) in seconds\r\n med_est - the travel time at the median travel speeds in seconds\r\n UQ_est - the travel time at the upper quartile of speeds (that is the lower quartile of travel times) in seconds\r\n LQ_est_char, med_est_char, UQ_est_char - the above but in human readable format\r\n n_obvs - the number of vehicle observations used to caculate the speeds for that hour\r\n\r\nsegment_summary.csv: containing summaries of the segments and their speeds used to calculate travel times\r\n route_name - the name of the route this data was generated for\r\n osm_id - an Open Street Map unqiue indentifier, valid at least at time of publication. A segment may appear in more than one route.\r\n hour - hour of day (from 0 to 23)\r\n n_obvs - the number of vehicle observations available for that hour and segment. This may be 0 in some cases in which case alternate methods were used to assume a distribution of speeds\r\n speed_limit - the speed limit. This report assumes all vehicles obey the speed limit. This was taken from OpenStreetMap where available and assumed based on road class and observed speed in others.\r\n UQ - the upper quartile of speed (kph)\r\n median - the median speed (kph)\r\n LQ - the lower quartile of speed (sph)\r\n distance - the distance traversed on this segment by the route - a segment may be used for different lengths on different routes\r\n\r\nThe file geometries.geojson contains only whole route geometries. Individual segments can be obtained from OpenStreetMap.
2020 Congestion Report Data - There are five files containing the data displayed in the BITRE Congestion Report, three csv files and one geojson. The file containing route parameters can be found at the github repository at github.com/bitre-telematics/congestion.\r\nThe five files are:\r\nroute_metrics.csv: Containing summary data on each route, with the fields\r\n route_name - name of route in report\r\n min median travel time - the lowest median travel time (by hour) for the route\r\n max median travel time - the highest median traveltime (by hour) for the route\r\n Peak time to best ratio - The ratio of longest to shortest median time\r\n min iq travel time - the interquartile range width for the hour in which is was most narrow\r\n max iq travel time - the interquartile range width for the hour in which is was most wide\r\n Peak iq to best ratio - the ratio of the widest to most narrow iq ranges\r\n min median travel hour - the hour of day (from 0 to 23) when median travel times were least\r\n max median travel hour - the hour of day (from 0 to 23) when median travel times were greatest\r\n min iq travel hour - the hour of day for which the iq range was narrowest\r\n max iq travel hour - the hour of day for which the iq range was greatest\r\n total obvs - the number of vehicle observations used to calculate all time\r\n Mean excess time ratio - the arithmetic mean of the ratio, by hour, of travel times to the best travel time\r\n Mean excess time ratio - weighted - the arithmetic mean of the ratio, by hour, of travel times to the best travel time, weighted by observations in that hour - hour of the day (from 0 to 23)\r\n Mean excess iq ratio - the arithmetic mean of the ratio, by hour, of iq ranges to the best iq range\r\n Mean excess iq ratio - weighted - the arithmetic mean of the ratio, by hour, of iq ranges to the best iq range, weighted by observations in that hour\r\n distance - the length of the route in metres\r\n\r\nroute_times.csv: Containing data for each hour, as graphed in the report, with the fields\r\n route_name - name of route\r\n hour - hour of the day (from 0 to 23)\r\n LQ_est - the travel time at the lowest quartile of speeds (that is the upper quartile of travel times) in seconds\r\n med_est - the travel time at the median travel speeds in seconds\r\n UQ_est - the travel time at the upper quartile of speeds (that is the lower quartile of travel times) in seconds\r\n LQ_est_char, med_est_char, UQ_est_char - the above but in human readable format\r\n n_obvs - the number of vehicle observations used to caculate the speeds for that hour\r\n\r\nsegment_summary.csv: containing summaries of the segments and their speeds used to calculate travel times\r\n route_name - the name of the route this data was generated for\r\n osm_id - an Open Street Map unqiue indentifier, valid at least at time of publication. A segment may appear in more than one route.\r\n hour - hour of day (from 0 to 23)\r\n n_obvs - the number of vehicle observations available for that hour and segment. This may be 0 in some cases in which case alternate methods were used to assume a distribution of speeds\r\n speed_limit - the speed limit. This report assumes all vehicles obey the speed limit. This was taken from OpenStreetMap where available and assumed based on road class and observed speed in others.\r\n UQ - the upper quartile of speed (kph)\r\n median - the median speed (kph)\r\n LQ - the lower quartile of speed (sph)\r\n distance - the distance traversed on this segment by the route - a segment may be used for different lengths on different routes\r\n\r\nThe file geometries.csv contains only whole route geometries. Individual segments can be obtained from OpenStreetMap.\r\n\r\ncity_wide_indices_2020.csv: contains index values for the 5 cities, indexed to year 2019\r\n mean_excess_time - the mean of the METR (as in route_metrics.csv) weighted by the product of total observations and the distance of the trip\r\n mean_uncert_odw - the mean of the MEUR (as in route_metrics.csv) weighted by the product of total observations and the distance of the trip\r\n mean_excess_time_odw_hw - the mean of the METR - weighted (as in route_metrics.csv) weighted by the product of total observations and the distance of the trip\r\n mean_uncert_odw_hw - the mean of the MEUR - weighted (as in route_metrics.csv) weighted by the product of total observations and the distance of the trip\r\n year - the year of the observation
2021 Congestion Report Data -
2022 Congestion Report Data.zip -