On-street Car Parking Sensor Data - 2017

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 2017 calendar year.Known data issues: 1. There are 860 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 (April 2018) 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 2017 car parking event data there are 3,858 records where the parking event goes into 2018 and ends at midnight.Download:Download compressed CSV (1.13GB, 35.9 million rows)

墨尔本市已在市中心商务区的大部分停车位安装了地下停车位传感器。这些传感器记录了车辆到达和离场的时间。每条记录还包括停车位的具体限制以及车辆是否超出了该限制。这是2017年日历年的相关数据。已知数据问题：1. 在名为‘Sign’的字段中，有860条记录以‘OLD’字样结尾，经过调查，该文本可能指代以下两种情况之一：· 在停车事件发生时，捕获的限制是正确的，但在数据从服务器提取（2018年4月）之后，限制已发生变更。· 或者，该特定传感器已被更换。2. 有多条记录在‘seconds’字段中显示负值，这是由于传感器检测到的到达时间晚于离场时间所致。3. 有多条记录未记录到达和离场时间。如果时间未记录，则从到达日的午夜开始计算至离场日的午夜或离场时间。排除的数据：在2017年汽车停车事件数据中，有3,858条记录，其中停车事件延续至2018年并结束于午夜。下载：下载压缩的CSV文件（1.13GB，35.9百万行）