河北省沧州市停车情况综合分析数据

提供河北省沧州市道路停车数据，方便交通管理部门及停车运营单位查询河北省沧州市内的停车情况，分析道路停车的各路段泊位周转率、日平均停车时长分布等，进行停车运营的管理。当车辆驶入或驶出停车位时，安装在此停车位上的地磁车位检测器检测到磁场变化，判断有车还是无车，将判断后的数据通过NB-IoT实时传输到云平台， 平台解析数据并根据数据库中存储的车位设备关系表，找到对应所属的车位编号以及路段信息。平台每小时按照省份、城市、路段的层次从数据库检索，并按照如下规则做数据统计：统计最近一小时内，该路段下所有泊位地磁上报的有车总数据条数作为【停车次数】；统计当前时刻该路段下有车的泊位数量，作为【占用泊位】数量；统计当前时刻该路段下无车的泊位数量，作为【空闲泊位】数量；空闲泊位+占用泊位作为【泊位总数】；占用泊位/泊位总数作为【泊位占用率】；停车次数/泊位总数作为【周转率】；每个泊位停车时长总和作为【总停车时长】；总停车时长/停车次数 作为【平均停车时长】； 最后将省份、城市、路段、日期、统计时间、泊位总数、空闲泊位、占用泊位、泊位占用率、停车次数、周转率、总停车时长(分钟)、平均停车时长（分钟）存储到数据库中供后续查询。

This dataset provides road parking data for Cangzhou City, Hebei Province, to enable traffic management departments and parking operation entities to query parking conditions within the city, analyze indicators such as the turnover rate of parking spaces per road segment and the daily average parking duration distribution, and support parking operation management.

When a vehicle enters or exits a parking space, the magnetic parking space detector installed at the corresponding spot detects magnetic field changes to determine whether the space is occupied or vacant. The detected occupancy status data is transmitted to the cloud platform in real time via NB-IoT. The platform parses the data and retrieves the matching parking space number and road segment information based on the parking space-device relationship table stored in the database.

The platform retrieves data from the database on an hourly basis at the hierarchy of province, city, and road segment, and conducts data statistics according to the following rules:
1. Count the total number of reported occupied status records from magnetic detectors of all parking spaces on the target road segment in the past hour as **Parking Frequency**;
2. Count the number of occupied parking spaces on the road segment at the current moment as **Occupied Parking Spaces**;
3. Count the number of vacant parking spaces on the road segment at the current moment as **Vacant Parking Spaces**;
4. Calculate **Total Parking Spaces** as the sum of Vacant Parking Spaces and Occupied Parking Spaces;
5. Calculate **Parking Space Occupancy Rate** as the ratio of Occupied Parking Spaces to Total Parking Spaces;
6. Calculate **Turnover Rate** as the ratio of Parking Frequency to Total Parking Spaces;
7. Calculate **Total Parking Duration** as the sum of parking durations of all parking spaces on the segment;
8. Calculate **Average Parking Duration** as the ratio of Total Parking Duration to Parking Frequency;

Finally, the platform stores the following data into the database for subsequent queries: province, city, road segment, date, statistics timestamp, Total Parking Spaces, Vacant Parking Spaces, Occupied Parking Spaces, Parking Space Occupancy Rate, Parking Frequency, Turnover Rate, Total Parking Duration (in minutes), and Average Parking Duration (in minutes).

搜集汇总

数据集介绍

特点

该数据集包含河北省沧州市的道路停车数据，每日更新，规模为1321条，数据格式为xlsx。数据集通过地磁车位检测器实时采集数据，统计各路段泊位的占用情况、停车次数、周转率等指标，适用于交通管理部门和停车运营单位进行停车管理和分析。