On-street Car Parking Sensor Data - 2016

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 2016 calendar year.Known data issues: 1. There are 342,475 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. Data that is excluded: In the 2016 car parking event data there are 4,346 records where the parking event goes into 2017 and ends at midnight.Download:Download compressed CSV (1.07GB, 34.1 million rows)

墨尔本市（City of Melbourne）已在绝大多数中央商务区（Central Business District, CBD）的停车泊位内部署地下停车泊位传感器。此类传感器可记录车辆的抵达与驶离时刻，每条记录同时包含该泊位的停车限制规则，以及车辆是否存在超时违规行为。本数据集涵盖2016日历年的全部相关数据。

已知数据问题：
1. 共计342475条记录的"Sign"字段中，停车限制文本末尾带有"OLD"字样。经排查与验证，该标记存在两种释义：
· 停车事件发生时采集的限制规则准确无误，但在2017年7月从服务器导出数据时，该泊位的限制规则已发生变更；
· 该特定传感器已完成更换。
2. 存在部分记录的"seconds"（时长）字段为负值。该问题源于传感器检测到的车辆抵达时间晚于驶离时间。
3. 部分记录未记录抵达与驶离时刻。若未记录具体时间，则以抵达当日午夜作为起始时间，计算至驶离当日午夜或实际驶离时刻。

已排除的数据：
本2016年停车事件数据中，共有4346条记录的停车事件延续至2017年并于午夜结束，此类数据已被排除。

下载：压缩格式CSV文件（1.07GB，共3410万行）