On-street Car Parking Sensor Data - 2013

The City of Melbourne has installed in-ground parking bay sensors in most CBD parking bays. These sensors record when a vehicle arrives and when it departs. Each record also includes the parking restriction for the bay and whether the vehicle has overstayed that restriction. This is the data for the 2013 calendar yearKnown data issues: 1. There are 987,179 records that have the text ‘OLD’ at the end of the restriction in the field named ‘Sign’. This has been investigated and determined the text refers to one of two things, either: · At the time of the parking event the restriction that has been captured is correct but when the data was extracted from the server (July 2017) the restriction had since changed. · (Or) The particular sensor has since been replaced. 2. There are a number of records that have a negative value in the duration in field ‘seconds’. This occurs due to a sensor detecting an arrival time being after the departure time. 3. There are a number of records where the arrival and departure times have not been recorded. If the time has not been recorded the time is calculated from midnight of the arrival day to either midnight of the departure day or to the departure time.Download:Download compressed CSV (1.24GB, 43.2 million rows)

墨尔本市已在绝大多数中央商务区（Central Business District, CBD）的停车泊位中部署了地下停车传感器。此类传感器能够记录车辆的驶入与驶离时刻。每条记录同时包含对应泊位的停车限制规则，以及对应车辆是否存在超时停放的情况。本数据集涵盖2013日历年的全部相关数据。
已知数据问题如下：
1. 共计987,179条记录的"Sign"字段中，停车限制文本末尾带有"OLD"字样。经调查确认，该字样包含两种情形之一：
· 停车事件发生时的限制规则有效，但在2017年7月从服务器提取数据时，该限制规则已发生变更；
· 该特定传感器已在后续完成更换。
2. 部分记录的"seconds"（时长，秒）字段存在负值。该问题源于传感器记录的驶入时间晚于驶离时间。
3. 部分记录未记录驶入与驶离时刻。对于此类缺失时间的记录，系统将以驶入当日午夜作为起始时间，以驶离当日午夜或实际驶离时间作为结束时间计算停放时长。
下载：压缩格式CSV文件（1.24GB，共4320万行）