# 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. The five files are: route_metrics.csv: Containing summary data on each route, with the fields route_name - name of route in report min median travel time - the lowest median travel time (by hour) for the route max median travel time - the highest median traveltime (by hour) for the route Peak time to best ratio - The ratio of longest to shortest median time min iq travel time - the interquartile range width for the hour in which is was most narrow max iq travel time - the interquartile range width for the hour in which is was most wide Peak iq to best ratio - the ratio of the widest to most narrow iq ranges min median travel hour - the hour of day (from 0 to 23) when median travel times were least max median travel hour - the hour of day (from 0 to 23) when median travel times were greatest min iq travel hour - the hour of day for which the iq range was narrowest max iq travel hour - the hour of day for which the iq range was greatest total obvs - the number of vehicle observations used to calculate all time Mean excess time ratio - the arithmetic mean of the ratio, by hour, of travel times to the best travel time 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) Mean excess iq ratio - the arithmetic mean of the ratio, by hour, of iq ranges to the best iq range 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 distance - the length of the route in metres

route_times.csv: Containing data for each hour, as graphed in the report, with the fields route_name - name of route hour - hour of the day (from 0 to 23) LQ_est - the travel time at the lowest quartile of speeds (that is the upper quartile of travel times) in seconds med_est - the travel time at the median travel speeds in seconds UQ_est - the travel time at the upper quartile of speeds (that is the lower quartile of travel times) in seconds LQ_est_char, med_est_char, UQ_est_char - the above but in human readable format n_obvs - the number of vehicle observations used to caculate the speeds for that hour

segment_summary.csv: containing summaries of the segments and their speeds used to calculate travel times route_name - the name of the route this data was generated for osm_id - an Open Street Map unqiue indentifier, valid at least at time of publication. A segment may appear in more than one route. hour - hour of day (from 0 to 23) 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 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. UQ - the upper quartile of speed (kph) median - the median speed (kph) LQ - the lower quartile of speed (sph) distance - the distance traversed on this segment by the route - a segment may be used for different lengths on different routes

The file geometries.csv contains only whole route geometries. Individual segments can be obtained from OpenStreetMap.

city_wide_indices_2020.csv: contains index values for the 5 cities, indexed to year 2019 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 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 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 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 year - the year of the observation

## Data Dictionary

Column | Type | Label | Description |
---|---|---|---|

city | text | ||

mean_odw | text | ||

mean_iq_odw | text | ||

mean_odw_hw | text | ||

mean_iq_odw_hw | text | ||

year | text |

## Additional Information

Field | Value |
---|---|

Data last updated | December 16, 2021 |

Metadata last updated | June 9, 2023 |

Metadata last updated | June 9, 2023 |

Created | unknown |

Format | CSV |

License | Creative Commons Attribution 3.0 Australia |

Ckan url | https://data.gov.au |

Datastore active | True |

Datastore contains all records of source file | True |

Has views | True |

Hash | 2c8129db154be863553deb7152f1402e |

Id | ce8ddaeb-587f-4412-b63d-f5a000aafab0 |

Ignore hash | False |

Mimetype | application/zip |

Original url | https://data.gov.au/data/dataset/444dc49a-780a-4c2a-840a-0a38cc4be635/resource/ce8ddaeb-587f-4412-b63d-f5a000aafab0/download/congestion_2020.zip |

Package id | 444dc49a-780a-4c2a-840a-0a38cc4be635 |

Position | 1 |

Resource id | ce8ddaeb-587f-4412-b63d-f5a000aafab0 |

Set url type | False |

Size | 4.7 MiB |

State | active |

Task created | 2023-06-09 00:23:46.639370 |

Url type | upload |

Zip extract | False |

Media type | unknown |

Size | unknown |

Has views | True |

ID | ce8ddaeb-587f-4412-b63d-f5a000aafab0 |

On same domain | False |

Package ID | 444dc49a-780a-4c2a-840a-0a38cc4be635 |

State | active |

URL type | upload |