Traffic_Route_Stats

Vehicle travel time and delay data on routes in Hamilton City, based on Bluetooth sensor records. To get data for this dataset, please call the API directly talking to the HCC Data Warehouse: https://api.hcc.govt.nz/OpenData/get_traffic_route_stats?Page=1&Start_Date=2021-06-02&End_Date=2021-06-03. For this API, there are three mandatory parameters: Page, Start_Date, End_Date. Sample values for these parameters are in the link above. When calling the API for the first time, please always start with Page 1. Then from the returned JSON, you can see more information such as the total page count and page size. For help on using the API in your preferred data analysis software, please contact [e-mail]. NOTE: Anomalies and missing data may be present in the dataset. Column_Info Route_Id, int : Unique route identifier Travel_Time, int : Average travel time in seconds to travel along the route Delay, int : Average travel delay in seconds, calculated as the difference between the free flow travel time and observed travel time Excess_Delay, int : Excess Delay is similar to Delay, but it ignores recurring (expected) delays associated with peak times of day Date, varchar : Starting date and time for the recorded delay and travel time, in 15 minute periods Relationship Traffic_Route This table reference to table Analytics For convenience Hamilton City Council has also built a Quick Analytics Dashboard over this dataset that you can access here. Disclaimer Hamilton City Council does not make any representation or give any warranty as to the accuracy or exhaustiveness of the data released for public download. Levels, locations and dimensions of works depicted in the data may not be accurate due to circumstances not notified to Council. A physical check should be made on all levels, locations and dimensions before starting design or works. Hamilton City Council shall not be liable for any loss, damage, cost or expense (whether direct or indirect) arising from reliance upon or use of any data provided, or Council's failure to provide this data. While you are free to crop, export and re-purpose the data, we ask that you attribute the Hamilton City Council and clearly state that your work is a derivative and not the authoritative data source. Please include the following statement when distributing any work derived from this data: ‘This work is derived entirely or in part from Hamilton City Council data; the provided information may be updated at any time, and may at times be out of date, inaccurate, and/or incomplete.'本数据集基于蓝牙传感器记录，涵盖汉密尔顿市各道路的车辆行程时间与延误数据。 如需获取本数据集的数据，请直接调用对接汉密尔顿市议会（Hamilton City Council，简称HCC）数据仓库的API，接口地址为：https://api.hcc.govt.nz/OpenData/get_traffic_route_stats?Page=1&Start_Date=2021-06-02&End_Date=2021-06-03。该API包含三个必填参数：Page、Start_Date、End_Date，参数示例值可参见上述接口链接。首次调用该API时，请始终从Page=1开始，后续可从返回的JSON数据中获取总页数、页面大小等额外信息。如需了解如何在您偏好的数据分析软件中使用该API，请发送邮件至[e-mail]咨询。 注意：本数据集可能存在异常值与缺失数据。 ### 字段详情 1. Route_Id（int型）：唯一路径标识符 2. Travel_Time（int型）：沿该路径行驶的平均行程时间，单位为秒 3. Delay（int型）：平均行程延误时间，单位为秒，计算方式为自由流行程时间与实测行程时间的差值 4. Excess_Delay（int型）：超额延误，其定义与延误类似，但会剔除与日间高峰时段相关的周期性（预期）延误 5. Date（varchar型）：记录延误与行程时间对应的起始日期与时间，采样周期为15分钟 关联关系：Traffic_Route 本数据表关联至Analytics表 为方便使用，汉密尔顿市议会还基于本数据集搭建了快速分析仪表板，您可通过此处访问。 #### 免责声明 汉密尔顿市议会不对本次公开发布供公众下载的数据的准确性与完备性作出任何明示或默示的陈述与保证。由于未向议会通报的相关情形，数据中所展示的工程层级、位置与尺寸可能并不准确。在开展设计或工程作业前，您应当对所有层级、位置与尺寸进行实地核查。 汉密尔顿市议会不对因依赖或使用所提供的数据，或因议会未能提供本数据而导致的任何损失、损害、成本或开支（无论直接或间接）承担任何责任。 尽管您可自由裁剪、导出并重新使用本数据，但我们要求您注明汉密尔顿市议会为数据来源，并明确说明您的作品为衍生作品，并非权威数据源。在分发基于本数据创作的任何作品时，请包含以下声明： "本作品全部或部分衍生自汉密尔顿市议会的数据；所提供的信息可能随时更新，且有时可能存在过时、不准确和/或不完整的情况。"