青岛市停车情况综合分析数据

通过对青岛市道路停车清洗加工统计，分析道路停车的各路段泊位周转率、日平均停车时长分布等数据：
为研究院对静态交通研究提供城市车辆动静态数据支持。
为主管部门提供路面流动及车辆管理提供数据支持。
为静态交通研究室私有知识库提供数据支持
为管理平台及城市规划停车设施建设提供数据支持。当车辆驶入或驶出停车位时系统实时上传， 平台解析数据并根据数据库中存储的车位设备关系表，找到对应所属的车位编号以及路段信息。平台每小时按照省份、城市、路段的层次从数据库检索，并按照如下规则做数据统计：统计最近一小时内，该路段下所有泊位地磁上报的有车总数据条数作为【停车次数】；统计当前时刻该路段下有车的泊位数量，作为【占用泊位】数量；统计当前时刻该路段下无车的泊位数量，作为【空闲泊位】数量；空闲泊位+占用泊位作为【泊位总数】；占用泊位/泊位总数作为【泊位占用率】；停车次数/泊位总数作为【周转率】；每个泊位停车时长总和作为【总停车时长】；总停车时长/停车次数 作为【平均停车时长】； 最后将省份、城市、路段、日期、统计时间、泊位总数、空闲泊位、占用泊位、泊位占用率、停车次数、周转率、总停车时长(分钟)、平均停车时长（分钟）存储到数据库中供后续查询。

This dataset is developed based on cleaned and statistically processed road parking data of Qingdao City, and analyzes indicators including the parking space turnover rate of each road section and the distribution of daily average parking duration. It provides the following four types of data support:
1. Urban dynamic and static vehicle data support for research institutes conducting static traffic research;
2. Data support for competent authorities to manage road traffic flow and vehicle operations;
3. Data support for the private knowledge base of the Static Traffic Research Office;
4. Data support for management platforms and urban planning of parking facility construction.

When a vehicle enters or exits a parking space, the system uploads data in real time. The platform parses the data and retrieves the corresponding parking space number and road section information based on the parking space-equipment relationship table stored in the database.
The platform retrieves data from the database hourly in the hierarchy of province, city, and road section, and conducts data statistics according to the following rules:
- Count the total number of reported data entries with occupied parking spaces from all geomagnetic sensors on the road section in the last hour as *Parking Frequency*;
- Count the number of parking spaces occupied by vehicles on the road section at the current moment as *Occupied Parking Spaces*;
- Count the number of unoccupied parking spaces on the road section at the current moment as *Vacant Parking Spaces*;
- Calculate *Total Parking Spaces* as the sum of Vacant Parking Spaces and Occupied Parking Spaces;
- Calculate *Parking Space Occupancy Rate* as the ratio of Occupied Parking Spaces to Total Parking Spaces;
- Calculate *Parking Space Turnover Rate* as the ratio of Parking Frequency to Total Parking Spaces;
- Calculate *Total Parking Duration* as the sum of parking durations of all parking spaces on the section;
- Calculate *Average Parking Duration* as the ratio of Total Parking Duration to Parking Frequency.
Finally, the following data are stored in the database for subsequent queries: province, city, road section, date, statistics time, Total Parking Spaces, Vacant Parking Spaces, Occupied Parking Spaces, Parking Space Occupancy Rate, Parking Frequency, Parking Space Turnover Rate, Total Parking Duration (in minutes), and Average Parking Duration (in minutes).

搜集汇总

背景与挑战

背景概述

该数据集为青岛市停车情况的综合分析数据，包含694条记录，每月更新，涵盖泊位总数、占用率、周转率等关键指标，主要用于静态交通研究和城市规划。数据通过实时上传和特定算法统计生成，适用于多种应用场景。