CN115100856B - Method for analyzing vehicle flow direction from multiple departure places to multiple destinations - Google Patents

Abstract

The present invention provides a vehicle flow direction analysis method from multiple departure points to multiple destinations, which presets the source, destination and analysis time period for which the vehicle flow analysis needs to be carried out. Corresponding relationship between different administrative regions and bayonet filing information, find all the bayonet equipment in the source and destination, and extract the pending operation data corresponding to the source and destination from the national vehicle traffic record data; The type and number of the license plate included in the operation data, and the basic information of the source and destination vehicles to be analyzed are counted; and then for each target vehicle, the basic results of the vehicle flow analysis from the source to the destination are obtained, and the abnormal data After filtering, the vehicle flow analysis results are obtained, and the vehicle flow analysis results are grouped according to the destinations and pushed to the destinations respectively.

Description

A Method of Vehicle Flow Analysis from Multiple Departures to Multiple Destinations

technical field

The invention relates to the technical field of intelligent traffic control, in particular to a method for analyzing vehicle flow from multiple starting points to multiple destinations.

Background technique

In modern traffic control, in the face of emergencies outside the province or outside the city, it is necessary to quickly check and control and continue to pay attention to vehicles with passing history in key areas in each jurisdiction. The analysis of vehicle flow requires fast and accurate analysis. Especially when it is necessary to check and control vehicles departing from multiple designated departure points and flowing into multiple designated destinations, the inspection and control work needs to be carried out every day and last for a long time. At the same time, the source and destination are changing. The level of administrative districts and destinations is also changing, and the amount of data calculation is very large and the calculation is complicated. In the prior art, there is no fast and accurate method to quickly determine the flow of vehicles from multiple sources to multiple destinations, and it usually requires the management department to invest a lot of manpower and time to complete this investigation and analysis work .

Contents of the invention

In order to solve the problem that the existing traffic control technology cannot take into account the analysis of vehicle flow from multiple sources to multiple destinations, the present invention provides a vehicle flow analysis method from multiple departure points to multiple destinations, which can accurately study and predict Set the flow of vehicles from multiple sources to multiple destinations within a time period, and provide data support for the destination jurisdiction to quickly locate and check related vehicles, which not only improves the efficiency of analysis work, but also saves human resources.

The technical solution of the present invention is as follows: a vehicle flow direction analysis method from multiple starting places to multiple destinations, characterized in that it includes the following steps:

S1: Create a vehicle passage record extraction operation record table, denoted as: operation record table, and the operation record table is initialized to be empty;

The operation record sheet includes: administrative division code and date;

Build the basic data set and initialize it to be empty;

The basic data set includes: provincial-level vehicle traffic basic information, city-level vehicle traffic basic information, and district-level vehicle traffic basic information;

S2: Determine the source, destination and analysis time period that need to be analyzed for vehicle flow;

The place of origin mentioned is: the area where vehicle outflow analysis is required;

The stated destination is: the area where the inflow of vehicles needs to be analyzed;

The analysis time period is: the time period in which vehicle flow analysis is required;

S3: Extract the source, the administrative division code corresponding to the destination, and the date corresponding to the analysis time period to generate a temporary table;

The temporary table includes: administrative division code and date;

S4: Comparing the temporary table and the operation record table, deleting the repeated data of administrative regions and dates in the two tables from the temporary table to obtain a table to be operated; the table to be operated includes: administrative division code and date;

S5: within the analysis time period, obtain vehicle traffic records nationwide, and create national vehicle traffic record data;

The national vehicle traffic record data includes: bayonet equipment number, bayonet capture time, bayonet capture direction, license plate type and license plate number;

S6: Associate the national vehicle traffic record data with the pending operation table based on the bayonet filing information, extract the vehicle traffic record data corresponding to the source and the destination, and obtain: pending operation data;

Denote the vehicles included in the data to be operated as: vehicles to be analyzed;

The bayonet filing information includes: the bayonet equipment number, the 2-digit province code of the province where the bayonet is located, the 4-digit city code of the city where the bayonet is located, the 6-digit administrative division code of the administrative division where the bayonet is located, the road where the bayonet is located, and the road where the bayonet is located. The type of road, the longitude and latitude of the checkpoint;

The data to be operated includes: bayonet equipment number, bayonet capture time, bayonet capture direction, plate type, plate number, 2-digit province code of the province where the bayonet is located, 4-digit city code of the city where the bayonet is located, and card The 6-digit administrative division code of the administrative division where the port is located;

S7: According to the table to be operated, based on the number plate number, type of license plate and administrative division code in the data to be operated, after sorting the data to be operated, extract the status of the vehicle to be analyzed according to the administrative district level. The basic information of traffic in the level administrative area;

The basic traffic information of the vehicles to be analyzed in administrative regions at all levels is respectively stored in the provincial-level vehicle traffic basic information, city-level vehicle traffic basic information, and district-level vehicle traffic basic information in the basic data set according to the administrative district level;

storing the contents of the table to be operated into the operation record table;

S8: From the basic data set, according to different administrative district levels, respectively count the basic traffic information of each vehicle included in the basic data set corresponding to the destination and the source within the analysis time period;

The vehicles included in the basic data set in the analysis time period are denoted as: target vehicles;

The statistics of the basic information of the destination and the source of the vehicle traffic at each administrative district level are recorded as: the basic information data set of the regional traffic; the basic information data set of the regional traffic includes: the basic information of the vehicle traffic of the source, the purpose Basic information on local vehicle traffic;

S9: According to different combinations of administrative district levels, extract the source and destination vehicle traffic basic information pair by pair from the basic traffic information data set in the area, and perform data screening on the basis of the source and destination. For the target vehicle, keep the correlation result that the source is different from the destination, and the latest capture time of the source is earlier than the latest capture time of the destination, which is recorded as: the basic result of vehicle flow analysis;

S10: Filter the abnormal data in the basic result of the vehicle flow analysis to obtain the vehicle flow analysis result;

S11: After grouping the vehicle flow analysis results according to the destinations, push them to the destinations respectively;

S12: Steps S9-S11 are executed cyclically until all the administrative region-level data corresponding to the destination and the source have been extracted and participated in the calculation, then the vehicle flow analysis is completed;

S13: Specify the source, the destination and the analysis time period, execute steps S2-S12 in a loop, and continuously monitor the vehicle flow.

It is further characterized by:

The vehicle flow analysis results include: vehicle information, source information, destination information, source traffic record information in the analysis time period, and destination traffic record information in the analysis time period;

The vehicle information includes: license plate type, license plate number;

The source information includes: source province code, city code, administrative division code;

The destination information includes: destination province code, city code, administrative division code;

The traffic record information of the source in the analysis time period includes: the number of snapshots of the vehicle at the source, the number of highway snapshots, the earliest capture time, the latest capture time, the number of driving days, and the number of the bayonet device corresponding to the latest capture of the vehicle at the source , capture direction, road, road type;

The destination traffic record information in the analysis time period includes: the number of snapshots taken by the vehicle at the destination, the number of snapshots taken on the expressway, the earliest snapshot time, the latest snapshot time, the number of driving days, and the number of the bayonet device corresponding to the latest snapshot taken by the vehicle at the destination , capture direction, road, road type;

The basic results of the vehicle flow analysis are classified according to the source and destination administrative regions, including: province-province, province-city, province-district, city-province, city-city, city-district, district-province, district-city , district-district;

In step S10, filtering the abnormal data in the basic result of the vehicle flow analysis includes the following steps:

a1: preset speed threshold vt;

The speed threshold is the maximum value of the attainable average driving speed of the target vehicle between two regions;

a2: Obtain the bayonet device when the target vehicle was last captured at the source, and obtain the latitude and longitude of the bayonet device from the record information of the bayonet device, which is recorded as: the longitude and latitude of the source place Gs; the capture time is recorded as: t1;

Obtain the bayonet device when the target vehicle was last captured at the destination, and obtain the latitude and longitude of the bayonet device in the filing information of the bayonet device, denoted as: destination longitude and latitude Ge; capture time as: tg;

a3: Calculate the spherical distance between the latitude and longitude Gs of the source and the latitude and longitude Ge of the destination to obtain the spatial interval L between the source and the destination;

Calculate the difference between t1 and tg to obtain the time interval T between the source and destination;

Then, the traveling speed of the target vehicle between the two regions V=L/T;

a4: Compare V and vt;

If V>vt then, it is determined that the target vehicle is abnormal data from the traffic record data between the source and the destination;

Otherwise, it is judged as non-abnormal data;

a5: Delete the vehicle traffic record information corresponding to the abnormal data, complete the filtering of the abnormal data, and obtain the analysis result of the vehicle flow.

The present invention provides a vehicle flow analysis method from multiple departure points to multiple destinations, which presets the source, destination, and analysis time period that need to be analyzed for vehicle flow, according to the source, Corresponding relationship between different administrative district-level areas included in the destination and checkpoint filing information, find all the checkpoint equipment in the source and destination, and extract the data to be operated corresponding to the source and destination from the national vehicle traffic record data ; Then, through the license plate type and license plate number included in the data to be operated, the basic information of the source and destination vehicles to be analyzed is counted; and then for each target vehicle, the basic results of the vehicle flow analysis from the source to the destination are obtained After filtering the abnormal data, the vehicle flow analysis results are obtained, and the vehicle flow analysis results are grouped according to the destinations, and pushed to the destinations respectively; the technical solution of the present invention divides and processes all the data according to the administrative district level, Then filter the abnormal data of the flow direction analysis results to obtain the traffic record data of the vehicle from the departure point to the destination, avoid redundant data processing and storage, and quickly obtain the final result, especially suitable for the massive data analysis process that lasts for a long time ; At the same time, by constructing a basic data set to store the basic information of vehicle traffic in different levels of administrative regions, the vehicle traffic records are used to extract the operation record table, temporary table, and pending operation table as an aid to the extraction and analysis of massive data. Before the data is extracted and analyzed, the temporary table is compared with the operation record table. When the source, destination and analysis time period of each analysis process overlap with the previous analysis, the administrative districts that have participated in data extraction and analysis And the corresponding date will be filtered, no repeated operations will be performed, the repeated storage and analysis of data will be avoided, the overall analysis efficiency of the system will be improved, and the results can be calculated quickly and accurately, ensuring that the technical solution of the present invention is flexibly applicable to various Different scenarios can improve the efficiency of analysis work and save human resources.

Description of drawings

FIG. 1 is a schematic flowchart of a method for analyzing vehicle flow from multiple sources to multiple destinations according to the present invention.

Detailed ways

As shown in FIG. 1 , the present invention includes a vehicle flow analysis method from multiple origins to multiple destinations, which includes the following steps.

S1: Create a vehicle passage record extraction operation record table, denoted as: operation record table, the operation record table is initialized to be empty;

The operation record sheet includes: administrative division code and date;

Build the basic data set and initialize it to be empty;

The basic data set includes: provincial-level vehicle traffic basic information, city-level vehicle traffic basic information, and district-level vehicle traffic basic information.

During the specific implementation, the fields included in the basic data set are the data that can be directly collected based on the existing checkpoint equipment and checkpoint filing information. The specific package includes: license plate type, license plate number, checkpoint equipment number, checkpoint snapshot Direction, checkpoint capture time, road type where checkpoint is located, province code where checkpoint is located, city code where checkpoint is located, administrative division code where checkpoint is located, initial capture time, number of snapshots, and number of expressway snapshots.

S2: Determine the source, destination and analysis time period that need to be analyzed for vehicle flow;

The source is: the area where vehicle outflow analysis is required;

The destination is: the area where the inflow of vehicles needs to be analyzed;

The analysis time period is: the time period in which vehicle flow analysis is required.

According to the existing administrative division and administrative division code recording method, the source and destination include: province, city and district-level administrative divisions, among which the province, city and district-level administrative divisions are respectively referred to by 2, 4 and 6-digit administrative division codes. generation.

In this embodiment: the analysis time period is from January 1 to January 2, 2022, a total of 2 days;

The origin is set to Hebei Province, Xingtai City, Hebei Province, and Nangong City, Xingtai City, Hebei Province, and the administrative division codes are 13, 1305, and 130581 respectively;

The destination is set to Jiangsu Province, Suzhou City, Jiangsu Province, and Kunshan City, Suzhou City, Jiangsu Province, and the administrative division codes are 32, 3205, and 320583 respectively.

S3: Extract the administrative division code corresponding to the source and destination and the date corresponding to the analysis time period to generate a temporary table; the temporary table includes: administrative division code and date.

S4: Compare the temporary table and the operation record table, and delete the duplicate data of administrative regions and dates in the two tables from the temporary table to obtain the pending operation table; the pending operation table includes: administrative division code and date; refer to Table 1 for details.

Table 1: Examples of Tables to Be Operated

Administrative division code date 13 2022-01-01 1305 2022-01-01 130581 2022-01-01 32 2022-01-01 3205 2022-01-01 320583 2022-01-01 13 2022-01-02 1305 2022-01-02 130581 2022-01-02 32 2022-01-02 3205 2022-01-02 320583 2022-01-02

By comparing the temporary table with the operation record table, the administrative districts and corresponding dates that have been extracted and stored are filtered, and the administrative districts and corresponding dates that have not been extracted and stored are recorded in the pending operation table, and the pending operation table is used as a mass The guidelines for the extraction and storage steps of traffic record data, on the one hand, can ensure that the source, destination, and analysis time period can be flexibly specified; application scenarios.

S5: Obtain vehicle traffic records across the country within the analysis time period, and create national vehicle traffic record data;

National vehicle traffic record data include: bayonet equipment number, bayonet capture time, bayonet capture direction, license plate type and license plate number;

S6: Associate the national vehicle traffic record data with the pending operation table based on the bayonet filing information, extract the vehicle traffic record data corresponding to the source and destination, and obtain: pending operation data;

Vehicles included in the data to be operated, denoted as: vehicles to be analyzed;

Checkpoint filing information includes the following fields: checkpoint equipment number, 2-digit province code of the province where the checkpoint is located, 4-digit city code of the city where the checkpoint is located, 6-digit administrative division code of the administrative division where the checkpoint is located, road where the checkpoint is located, card The type of road where the checkpoint is located, the longitude and latitude of the checkpoint;

The data to be operated includes: bayonet equipment number, bayonet capture time, bayonet capture direction, license plate type, license plate number, 2-digit province code of the province where the bayonet is located, 4-digit city code of the bayonet location and bayonet location Administrative division 6-digit administrative division code.

S7: According to the table to be operated, based on the number plate number, type of license plate and administrative division code in the data to be operated, after sorting the data to be operated, extract the basic information on the passage of the vehicles to be analyzed in the administrative areas at all levels according to the level of the administrative area;

Among them, the administrative division code includes: 2-digit province code, 4-digit city code and 6-digit administrative division code. The data to be operated is divided into three administrative division-level data, and then extracted according to the vehicles to be analyzed;

The basic traffic information of the vehicles to be analyzed in administrative regions at all levels is stored in the provincial-level vehicle traffic basic information, municipal-level vehicle traffic basic information, and district-level vehicle traffic basic information in the basic data set according to the administrative district level;

Store the content of the table to be operated into the operation record table.

During specific implementation, the provincial-level vehicle traffic basic information, city-level vehicle traffic basic information, and district-level vehicle traffic basic information in the basic data set are counted and stored in units of dates. The specific content is as follows:

The basic information of provincial-level vehicle traffic includes the following fields: plate type, plate number, province code, bayonet device number corresponding to the latest capture of the vehicle in the province within a day, capture direction, road where it is located, road type, prefecture code, Administrative division code, the initial capture time, the latest capture time, the number of captures, and the number of expressway captures in the province within a day;

The basic information of city-level vehicle traffic contains fields: license plate type, license plate number, province code, prefecture and city code, the bayonet device number corresponding to the latest capture of the vehicle in the city within a day, capture direction, road where it is located, road type, Administrative division code, the initial capture time, the latest capture time, the number of captures, and the number of expressway captures in the city within a day;

The basic information of vehicle traffic at the district level includes the following fields: license plate type, license plate number, province code, city code, administrative division code, the number of the bayonet device corresponding to the latest capture of the vehicle in the area within a day, the capture direction, and the road where it is located , road type, the initial capture time, the latest capture time, the number of captures, and the number of expressway captures within a day.

S8: From the basic data set, according to different administrative district levels, respectively count the basic traffic information of each vehicle included in the basic data set corresponding to the destination and source within the analysis time period; the basic data set in the analysis time period Included vehicles, denoted as: target vehicle;

The statistics of the basic information on vehicle traffic at the destination and source at each administrative district level are recorded as: the basic information data set on regional traffic; the basic information data set on regional traffic includes: basic information on vehicle traffic at the source and basic information on vehicle traffic at the destination.

The basic data set is associated with the corresponding level of administrative division code in the temporary table, and the basic information of the target vehicle's traffic in each source and destination is calculated according to different administrative district levels. The basic information of the source and destination is divided into provinces, cities, The three types of areas are stored separately.

In this embodiment, the source is set to Hebei Province, Xingtai City, Hebei Province, and Nangong City, Xingtai City, Hebei Province; the destination is set to Jiangsu Province, Suzhou City, Jiangsu Province, and Kunshan City, Suzhou City, Jiangsu Province. The sources and destinations include administrative district levels: provincial level, municipal level and district level. During the specific implementation, the first round of data to be operated in Hebei Province and Jiangsu Province will be extracted according to the provincial level, and the basic traffic information will be counted and stored in the basic data. Collect, and then statistically analyze the basic information of vehicle traffic in Hebei Province and Jiangsu Province within the time period, and implement the subsequent steps S9~S11; the second round extracts the data to be operated in Xingtai City, Hebei Province, and Suzhou City, Jiangsu Province according to the city level, and the traffic statistics are basically The information is stored in the basic data set, and then the basic information of vehicle traffic in Xingtai City, Hebei Province and Suzhou City, Jiangsu Province is statistically analyzed from it, and the subsequent steps S9~S11 are implemented; the third round extracts Nangong City, Xingtai City, Hebei Province according to the district level , Kunshan City, Suzhou City, Jiangsu Province, the data to be operated, the basic traffic information is counted and stored in the basic data set, and then the basic information of vehicle traffic in Nangong City, Xingtai City, Hebei Province, and Kunshan City, Suzhou City, Jiangsu Province is statistically analyzed from it, and the follow-up Steps S9-S11.

The basic information of provincial source and destination vehicle traffic contains fields: license plate type, license plate number, and province code; corresponding to the latest capture of the vehicle in the province within the time period: bayonet device number, capture direction, road, Road type, city code, administrative division code; vehicle in the province within the time period: initial capture time, latest capture time, sum of capture times, sum of expressway capture times, and capture days;

The basic information of city-level source and destination vehicle traffic contains fields: plate type, plate number, province code, prefecture and city code; corresponding to the latest capture of the vehicle in the city within the time period: bayonet device number, capture direction , road, road type, administrative division code; the vehicle is in the city within the time period: the initial capture time, the latest capture time, the sum of the capture times, the sum of the expressway capture times, and the capture days;

District-level source and destination vehicle traffic basic information contains fields: license plate type, license plate number, province code, prefecture-city code, administrative division code; corresponding to the latest capture of the vehicle in the area within the time period: bayonet device Number, capture direction, road, road type; vehicles in the area within the time period: initial capture time, latest capture time, sum of capture times, sum of expressway capture times, and capture days.

S9: According to the different combinations of the administrative district level, the basic information of the source and destination vehicles is taken out pair by pair from the regional traffic basic information data set, and the data is screened on the basis of the source and destination. For each target vehicle, the source is retained The association result that is different from the destination and the latest capture time of the source is earlier than the latest capture time of the destination is recorded as: the basic result of vehicle flow analysis.

The basic results of vehicle flow analysis are divided according to the level of source and destination administrative regions. In this embodiment, different combinations of administrative region levels specifically include 9 division methods: province-province, province-city, province-district, city-province, city- City, city-district, district-province, district-city, district-district.

In the specific implementation, a pair of combinations of the source and destination administrative regions is taken out each time, such as: province-district, and data screening is performed on the basic vehicle traffic information of the provincial source and district-level destinations based on the target vehicle.

The basic results of the vehicle flow analysis include the same fields as the vehicle flow analysis results, including: vehicle information, source information, destination information, source traffic record information in the analysis time period, and destination traffic record information in the analysis time period;

Vehicle information includes: license plate type, license plate number;

Source information includes: source province code, city code, administrative division code;

Destination information includes: destination province code, city code, administrative division code;

The source traffic record information of the analysis time period includes: the number of snapshots taken by the vehicle at the source, the number of highway snapshots, the earliest snapshot time, the latest snapshot time, the number of driving days, the corresponding bayonet device number of the vehicle’s latest snapshot at the source, and the snapshot direction, road, road type;

The destination traffic record information in the analysis time period includes: the number of snapshots taken by the vehicle at the destination, the number of snapshots taken on the expressway, the earliest snapshot time, the latest snapshot time, the number of driving days, the number of the bayonet device corresponding to the latest snapshot of the vehicle at the destination, and the snapshot Direction, road, road type.

In this example, there are 9 types of basic results of vehicle flow analysis, namely Hebei Province-Jiangsu Province, Hebei Province-Suzhou City, Jiangsu Province, Hebei Province-Kunshan City, Suzhou City, Jiangsu Province, Xingtai City, Hebei Province-Jiangsu Province, and Hebei Province Xingtai City-Suzhou City, Jiangsu Province, Xingtai City, Hebei Province-Kunshan City, Suzhou City, Jiangsu Province, Nangong City, Xingtai City, Hebei Province-Jiangsu Province, Nangong City, Xingtai City, Hebei Province-Suzhou City, Jiangsu Province, Nangong City, Xingtai City, Hebei Province-Jiangsu Province Kunshan City, Suzhou City, Province.

S10: Filter the abnormal data in the basic results of the vehicle flow analysis to obtain the vehicle flow analysis results.

Filter the abnormal data in the basic results of the vehicle flow analysis, including the following steps:

a1: preset speed threshold vt;

The speed threshold is the maximum value of the average driving speed that the target vehicle can reach between the two regions;

a2: Obtain the bayonet device when the target vehicle was last captured at the source, and obtain the latitude and longitude of the bayonet device from the record information of the bayonet device, which is recorded as: the longitude and latitude of the source place Gs; the capture time is recorded as: t1;

Obtain the bayonet device when the target vehicle was last captured at the destination, and obtain the latitude and longitude of the bayonet device from the filing information of the bayonet device, which is recorded as: destination longitude and latitude Ge; capture time is recorded as: tg;

a3: Calculate the spherical distance between the source latitude and longitude Gs and the destination latitude and longitude Ge, and obtain the spatial interval L between the source place and the destination place;

Calculate the difference between t1 and tg to obtain the time interval T between the source and destination;

Then, the traveling speed of the target vehicle between the two regions V=L/T;

a4: Compare V and vt;

If V>vt, it is determined that the traffic record data of the target vehicle between the source and the destination is abnormal data;

Otherwise, it is judged as non-abnormal data;

a5: Delete the vehicle traffic record information corresponding to the abnormal data, complete the abnormal data filtering, and obtain the vehicle flow analysis results.

In this embodiment, the speed threshold vt is set to 120km/h, that is, under the current expressway operating speed regulations, the average speed of the vehicle will not exceed 120km/h, exceeding this threshold is considered to be an error in the recognition of the captured picture and the occurrence of two places. For the abnormal data caused by the same number plate, the analysis results corresponding to the abnormal data are deleted, and the abnormal data filtering is completed to improve the accuracy of the calculation results.

S11: After grouping the vehicle flow analysis results by destination, push them to each destination respectively.

The results of vehicle flow analysis include: vehicle information, source information, destination information, source traffic record information in the analysis time period, and destination traffic record information in the analysis time period;

Vehicle information includes: license plate type, license plate number;

Source information includes: source province code, city code, administrative division code;

Destination information includes: destination province code, city code, administrative division code;

The source traffic record information of the analysis time period includes: the number of snapshots taken by the vehicle at the source, the number of highway snapshots, the earliest snapshot time, the latest snapshot time, the number of driving days, the corresponding bayonet device number of the vehicle’s latest snapshot at the source, and the snapshot direction, road, road type;

The destination traffic record information in the analysis time period includes: the number of snapshots taken by the vehicle at the destination, the number of snapshots taken on the expressway, the earliest snapshot time, the latest snapshot time, the number of driving days, the number of the bayonet device corresponding to the latest snapshot of the vehicle at the destination, and the snapshot Direction, road, road type.

Integrate the analysis results of vehicle flow by destination, and push the analysis results of Hebei Province-Jiangsu Province, Xingtai City, Hebei Province-Jiangsu Province, Nangong City, Xingtai City, Hebei Province-Jiangsu Province for Jiangsu Province, and push Hebei Province-Jiangsu Province for Suzhou City, Jiangsu Province The analysis results of Suzhou City, Hebei Province, Xingtai City, Hebei Province-Suzhou City, Jiangsu Province, Nangong City, Xingtai City, Hebei Province-Suzhou City, Jiangsu Province are pushed to Kunshan City, Suzhou City, Jiangsu Province, Hebei Province-Kunshan City, Suzhou City, Jiangsu Province, and Xingtai City, Hebei Province City-Kunshan City, Suzhou City, Jiangsu Province, and Nangong City, Xingtai City, Hebei Province-Kunshan City, Suzhou City, Jiangsu Province.

S12: Steps S9-S11 are executed in a loop until all the administrative region-level data corresponding to the destination and the source have been extracted and participated in the calculation, then the vehicle flow analysis is completed.

S13: Designate the source, destination and analysis time period, execute steps S2-S12 in a loop, and continuously monitor the flow of vehicles.

Using the technical solution of the present invention, first preset the analysis time period, source, and destination, and compare the temporary table with the vehicle traffic record extraction operation record table by setting a temporary table to determine each extraction and storage of massive traffic record data The minimum processing capacity of the system can be improved to improve the processing efficiency of the system; the traffic record data of the source and destination vehicles are organized at the provincial, municipal, and district levels, and the basic information of the source and destination vehicles at all levels is counted, and then the source and destination within the analysis time period It is associated with the basic information of vehicles passing through the destination, and is pushed to each destination after screening and integration. Based on the technical solution of the present invention, there is no need to add new hardware devices, combined with the record information of bayonet devices, the flow direction of vehicles from multiple sources to multiple destinations can be studied and judged in a clear and efficient manner. The technical scheme of the present invention can not only avoid redundant processing and storage of data, but also classify and classify the data processing process, which is clear and easy to implement. Provide strong support for organizing investigation and control of vehicles entering the jurisdiction and maintaining daily attention.

Claims (4)

1. A method of analyzing a vehicle flow direction from a plurality of departure points to a plurality of destinations, comprising the steps of:

s1: creating a vehicle passing record extraction operation record table, which is recorded as: an operation record table initialized to be empty;

the operation record table includes: administrative district codes and dates;

constructing a basic data set and initializing to be empty;

the base data set includes: provincial level vehicle passing basic information, municipal level vehicle passing basic information and regional level vehicle passing basic information;

s2: determining a source, a destination and an analysis period of time for which a vehicle flow direction analysis is required;

the source is: areas where vehicle outflow analysis is required;

the destination is: the area into which the vehicle is to be analyzed;

the analysis time period is as follows: a time period during which a vehicle flow direction analysis is required;

s3: extracting administrative division codes corresponding to the source and the destination and dates corresponding to the analysis time period to generate a temporary table;

the temporary table includes: administrative district codes and dates;

s4: comparing the temporary table with the operation record table, deleting the data of administrative areas and date repetition in the two tables from the temporary table, and obtaining a table to be operated; the table to be operated includes: administrative district codes and dates;

s5: acquiring a vehicle passing record in a national range in the analysis time period, and creating national vehicle passing record data;

the national vehicle passage record data includes: the bayonet equipment number, the bayonet snapshot time, the bayonet snapshot direction, the number plate type and the number plate number;

s6: associating the national vehicle passing record data with the table to be operated based on the bayonet record information, and extracting the vehicle passing record data corresponding to the source and the destination to obtain: data to be operated;

and recording the vehicles included in the data to be operated as: a vehicle to be analyzed;

the bayonet record information comprises: the method comprises the steps of bayonet equipment numbering, a bayonet-located province 2-bit province code, a bayonet-located city 4-bit city code, a bayonet-located administrative division 6-bit administrative division code, a bayonet-located road type, a bayonet longitude and a bayonet latitude;

the data to be operated includes: the method comprises the steps of bayonet equipment numbering, bayonet snapshot time, bayonet snapshot direction, number plate type, number plate number, 2-bit province code of the province where the bayonet is located, 4-bit city code of the city where the bayonet is located and 6-bit administrative division code of the administrative division where the bayonet is located;

s7: according to the table to be operated, based on the number plate number, the number plate type and the administrative division code in the data to be operated, after the data to be operated are arranged, the basic traffic information of the vehicle to be analyzed in each administrative division is respectively extracted according to the administrative division level;

the passing basic information of the vehicles to be analyzed in each administrative area is respectively stored into provincial vehicle passing basic information, municipal vehicle passing basic information and regional vehicle passing basic information in the basic data set according to the administrative area level;

storing the contents of the table to be operated into the operation record table;

s8: respectively counting the passing basic information of each vehicle included in the basic data set corresponding to the destination and the source in the analysis time period according to different administrative district levels from the basic data set;

the vehicles included in the basic data set in the analysis period are recorded as: a target vehicle;

recording the counted vehicle passing basic information of the destination and the source at each administrative district level as: a regional traffic basic information dataset; the regional traffic basic information data set comprises: source vehicle traffic basic information and destination vehicle traffic basic information;

s9: according to different combinations of administrative district levels, extracting source and destination vehicle passing basic information pair by pair from the district passing basic information data set, carrying out data screening based on the source and destination, and reserving the associated results that the source and destination are different and the latest snapshot time of the source is earlier than the latest snapshot time of the destination for each target vehicle, wherein the associated results are recorded as: analyzing a basic result of the vehicle flow direction;

s10: filtering abnormal data in the basic result of the vehicle flow direction analysis to obtain a vehicle flow direction analysis result;

s11: grouping the vehicle flow direction analysis results according to the destination, and then respectively pushing the vehicle flow direction analysis results to the destination;

s12: step S9-S11 is circularly executed until all the data of the administrative region levels corresponding to the destination and the source are extracted and participate in calculation, and then the flow direction analysis of the vehicle is completed;

s13: and designating the source, the destination and the analysis time period, and circularly executing the steps S2-S12 to continuously monitor the vehicle flow direction.

2. A vehicle flow direction analysis method from a plurality of departure points to a plurality of destinations according to claim 1, wherein: the vehicle flow direction analysis result includes: vehicle information, source information, destination information, source traffic record information for an analysis period, destination traffic record information for an analysis period;

the vehicle information includes: number plate type, number plate number;

the source location information includes: source province code, city code and administrative division code;

the destination information includes: destination province code, city code, administrative division code;

analyzing the source-location passing record information for a time period includes: the method comprises the steps of capturing the number of times of the vehicle at a source, capturing the number of times of the expressway, capturing the earliest capturing time, capturing the latest capturing time, driving days, capturing the corresponding bayonet equipment number, capturing direction, road and road type of the vehicle at the source at the latest capturing time;

analyzing the destination entry information for a time period includes: the method comprises the steps of capturing the vehicle at a destination, capturing the vehicle at the expressway, capturing the vehicle at the earliest capturing time, capturing the vehicle at the latest capturing time, driving days, capturing the vehicle at the latest capturing corresponding bayonet equipment number, capturing direction, road and road type.

3. A vehicle flow direction analysis method from a plurality of departure points to a plurality of destinations according to claim 1, wherein: the vehicle flow direction analysis basic result is divided into a source administrative district level and a destination administrative district level, and the vehicle flow direction analysis basic result comprises the following components: province-province, province-city, province-district, city-province, city-city, city-district, district-province, district-city, district-district.

4. A vehicle flow direction analysis method from a plurality of departure points to a plurality of destinations according to claim 1, wherein: in step S10, filtering the abnormal data in the basic result of the vehicle flow direction analysis, including the following steps:

a1: presetting a speed threshold vt;

the speed threshold is the maximum value of the average running speed that the target vehicle can reach between two areas;

a2: acquiring a bayonet device when the target vehicle is captured for the last time at the source, acquiring longitude and latitude of the bayonet device from record information of the bayonet device, and marking as: source latitude and longitude Gs; the snapshot time is recorded as: t1;

acquiring a bayonet device when the target vehicle is captured for the last time at a destination, acquiring longitude and latitude of the bayonet device from record information of the bayonet device, and marking as: destination longitude and latitude Ge; the snapshot time is recorded as: tg;

a3: calculating the source longitude and latitude Gs and the spherical distance of the destination longitude and latitude Ge to obtain a space interval L between the source and the destination;

calculating the difference between T1 and tg to obtain a time interval T of a source and a destination;

then, the travel speed v=l/T of the target vehicle between the two regions;

a4: comparing V and vt;

if V > vt, judging that the traffic record data of the target vehicle from the source and the destination is abnormal data;

otherwise, judging the data to be non-abnormal data;

a5: deleting the vehicle passing record information corresponding to the abnormal data, and completing the filtering of the abnormal data to obtain the vehicle flow direction analysis result.

Images