CN115830729A - Vehicle travel information extraction method based on highway ETC data fusion - Google Patents
Vehicle travel information extraction method based on highway ETC data fusion Download PDFInfo
- Publication number
- CN115830729A CN115830729A CN202211344121.9A CN202211344121A CN115830729A CN 115830729 A CN115830729 A CN 115830729A CN 202211344121 A CN202211344121 A CN 202211344121A CN 115830729 A CN115830729 A CN 115830729A
- Authority
- CN
- China
- Prior art keywords
- vehicle
- data
- travel
- portal
- name
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention discloses a vehicle travel information extraction method based on highway ETC data fusion, which comprises the following steps: acquiring ETC portal frame passing data, toll vehicle flow detail data and a portal frame basic information table in a statistical time period in a target area; carrying out data cleaning on ETC portal passing data; carrying out vehicle path integrity analysis on the cleaned ETC portal passage data; carrying out data fusion on the cleaned ETC portal passage data, toll vehicle flow detail data and a portal basic information table; and extracting the vehicle travel information of each travel type according to the data fusion result. The invention can completely restore the driving path of the vehicle and accurately acquire the OD traffic volume of various travel modes by processing the fused data, and provides accurate and reliable data reference for the planning, construction and management of the expressway.
Description
Technical Field
The invention belongs to the technical field of traffic informatization, and particularly relates to a vehicle travel information extraction method based on highway ETC data fusion.
Background
By depending on an ETC portal system densely and continuously arranged on the highway, a large amount of section data can be collected, the vehicle driving path can be completely restored, the vehicle type can be divided to extract the OD traffic volume by combining with the charging data, and accurate and reliable data reference is provided for planning, constructing and managing the highway.
The charging detail data returned based on provincial level can obtain the origin-destination information of the vehicles entering and leaving the highway by the provincial and provincial trip vehicles, but the OD data of the vehicles crossing the provincial and provincial trip vehicles are lacked.
The invention with the patent application number of CN202011136539.1 realizes the accurate recording of the running path of the operation vehicle by using the GPS data of 'two passengers and one danger', thereby restoring the passing path of the vehicle, but the available object of the invention is only the vehicle of 'two passengers and one danger', the invention can not be used for non-operation vehicles, and the applicability is narrow. The invention with the patent application number of CN201710119409.9 utilizes a video monitoring system and a communication system of an original charging system, identifies vehicle characteristics through vehicle image information acquired by a camera, realizes restoration of a vehicle path, overcomes the defects caused by the problems of license plate deficiency and the like, and improves vehicle identification efficiency and accuracy.
Disclosure of Invention
In view of this, the invention aims to provide a vehicle travel information extraction method based on highway ETC data fusion.
The purpose of the invention is realized by the following technical scheme:
a vehicle travel information extraction method based on highway ETC data fusion comprises the following steps:
the ETC portal of statistics time interval in the acquisition target area passes data, toll collection vehicle flow detail data and portal basic information table, and wherein, the field that ETC portal passes the data and contains includes: the method comprises the following steps of charging license plate number, charging vehicle type code, portal HEX character string, portal name, entrance station name, passing time, entrance time, charging mileage, accumulated mileage before transaction and accumulated mileage after transaction;
the fields contained in the toll vehicle flow detail data include: a charging license plate number, a charging vehicle type code, an inbound number, an inbound name, an entry time, an outbound number, an outbound name and an exit time;
the fields contained in the basic information table of the portal comprise: the toll station code, the toll station Chinese name, the district and county where the toll station is located, the portal frame number code, the portal frame Chinese name, the name of the road where the portal frame belongs and whether the portal frame is provincial or not;
carrying out data cleaning on ETC portal passing data;
carrying out vehicle path integrity analysis on the cleaned ETC portal passing data;
carrying out data fusion on the cleaned ETC portal passing data, the toll vehicle flow detail data and the portal basic information table;
extracting vehicle travel information of each travel type according to a data fusion result, wherein the travel types comprise an in-and-out travel, an out-and-out travel and a cross-and-out travel, and fields contained in the travel information of the vehicle comprise: the system comprises starting time, ending time, license plate number, original starting point name, starting point number after turning, starting point name after turning, starting point district after turning, terminal point number, terminal point name, terminal point district, trip type, vehicle type, source province, destination province and trip distance.
Further, the vehicle path integrity analysis of the washed ETC portal traffic data includes:
in the statistics period, use the charging license plate number as the label, draw the orbit of traveling of corresponding vehicle in the current data of follow ETC portal, include:
and sequentially traversing downwards by taking the portal HEX character string of the first piece of data as a starting point, if the accumulated mileage field record before the transaction of the Nth piece of data is 0, determining the portal HEX character string of the (N-1) th piece of data as an end point, determining the record corresponding to the first piece of data to the (N-1) th piece of data as a complete OD trip record, taking the portal HEX character string of the Nth piece of data as a new starting point, and continuously traversing downwards, otherwise, taking the portal HEX character string in the last piece of data corresponding to the vehicle as an end point.
Further, the extracting of the vehicle travel information according to the data fusion result includes:
extracting all field data in the detailed data of the charging vehicle flow in the statistical time period one by one;
for each toll vehicle flow detail data, writing the entry time into the 'start time', writing the exit time into the 'end time', writing the exit name into the 'end name', writing the exit number into the 'end number', inquiring the district and county of the exit station through the portal basic information table, writing the 'end district and county', writing the charging license plate number into the 'license plate number', writing the charging vehicle type code into the 'vehicle type', and writing the province of the target region into the 'going province'; and extracting source provinces according to the names of the vehicle entrance stations, judging whether the provinces are the provinces where the target area is located, if so, determining that the travel type is intra-provincial travel, and otherwise, determining that the travel type is in-provincial travel.
Further, after determining that the travel type is intra-provincial travel, the method further includes: for each piece of toll car flow detail data, the inbound name is written into the starting point name, the county where the entry station is located is written into the starting point county, and the accumulated mileage after the trip end point transaction in each complete OD trip record is written into the trip distance.
Further, after determining that the travel type is an entrance and exit travel, the method further includes:
writing the inbound number into the original starting point number, and writing the inbound name into the original starting point name;
the door frame passing data of the corresponding time period of the vehicle is extracted, and for each complete OD travel record, the provincial door frame number passing through the door frame passing data of the corresponding vehicle is extracted according to the time sequence by taking the charging license plate number as a label; associating the provincial gate frame number with the provincial number of the toll station through a gate frame basic information table, and determining the provincial inbound number of the vehicle; respectively writing the number and the name of the provincial boundary inbound and the district where the provincial boundary inbound are written into the starting point number after turning, the starting point name after turning and the starting point district after turning; and writing the accumulated mileage after the transaction at the trip end point in the complete OD trip record corresponding to the vehicle into the trip distance.
Further, the extracting of the vehicle travel information according to the data fusion result includes: extracting all the vehicle information passing through the provincial and provincial gate frame in the cleaned ETC gate frame passing data within the statistical time period one by one; for each ETC portal frame passing data of the exit provincial and provincial portal frames, taking a toll station corresponding to the provincial portal frame in the ETC portal frame passing data as an exit station, writing the name of the exit station into a terminal name, writing the number of the exit station into a terminal number, inquiring a district and county where the exit station is located and writing the district and county into the terminal district through a portal frame basic information table, writing a charging license plate number into a license plate number, and writing a charging vehicle type code into a vehicle type; writing the province associated province of the province portal frame into 'go province'; and extracting a source province according to the name of the vehicle entrance station, writing the source province into the source province, judging whether the source province is the province where the target area is located, if so, determining that the travel type is a province travel, otherwise, determining that the travel type is a cross-province travel.
Further, after determining that the travel type is the exit travel, the method further includes: the method comprises the steps of writing an entrance station name into a starting point name, writing a district where the entrance station is located into a starting point district, writing the entrance time of a trip into a starting time, writing the exit time of the trip into an ending time, and writing the accumulated mileage after the trip end point transaction in each complete OD trip record in ETC portal traffic data corresponding to a vehicle into a trip distance.
Further, after determining that the travel type is a trans-provincial travel, the method further includes: writing the inbound number of the trip into an original starting point number, and writing the entry station name into an original starting point name; taking the charging license plate number as a label, and extracting the provincial gate frame number passing through in the gate frame passing data of the corresponding vehicle according to the time sequence; associating the provincial gate frame number with the provincial number of the toll station through a gate frame basic information table, and determining the provincial inbound number of the vehicle; respectively writing the number and the name of the provincial boundary inbound and the district where the provincial boundary inbound are written into the starting point number after turning, the starting point name after turning and the starting point district after turning; writing the entry time of the trip into the starting time, and writing the exit time of the trip into the ending time; and writing the accumulated mileage after the transaction at the travel end point in each complete OD travel record in the portal traffic data corresponding to the vehicle into the travel distance.
Further, the field contained in the travel information of the vehicle also comprises the vehicle registration, and the method also comprises the step of judging the vehicle registration through the first character in the charging license plate number.
The invention has the beneficial effects that:
1. the basic data used by the invention is generated by the ETC portal system, other equipment does not need to be additionally arranged for the second time, the cost is low, and the method is environment-friendly and energy-saving;
2. the invention provides a highway vehicle trip information extraction method based on the fusion of toll data and ETC portal data, which can be flexibly adjusted according to requirements by using toll stations, administrative areas and provinces as basic analysis units;
3. according to the invention, by fusing the data, the driving path of the vehicle can be completely restored, the OD traffic volume of various travel modes can be accurately obtained, and accurate and reliable data reference is provided for the planning, construction and management of the expressway; the vehicle identification efficiency and accuracy are improved;
4. the calculation result of the invention can be updated in a short time according to the return frequency of the ETC portal data, and effective support is provided for real-time transportation capacity analysis and scheduling.
Additional advantages, objects, and features of the invention will be set forth in part in the description which follows and in part will become apparent to those having ordinary skill in the art upon examination of the following or may be learned from practice of the invention. The objectives and other advantages of the invention may be realized and attained by the means of the instrumentalities and combinations particularly pointed out hereinafter.
Drawings
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings, in which:
FIG. 1 is a flow diagram of an exemplary method for counting OD traffic, according to one embodiment of the present application;
fig. 2 is a schematic diagram of travel types according to an embodiment of the present application;
FIG. 3 is a flow diagram of an exemplary method of determining an in-province exit and an in-province exit as shown in one embodiment of the present application;
fig. 4 is a flowchart illustrating an exemplary method of determining a province row and a cross-province row according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions, advantages and objects of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the described embodiments of the invention without any inventive step, are within the scope of protection of the present application.
The application provides a vehicle travel information extraction method based on highway ETC data fusion, which fuses ETC portal traffic data, toll detail data, portal basic data and the like, extracts OD information of a vehicle through driving path integrity analysis, divides the OD information into four travel types according to origin-destination positions, and can perform OD traffic statistics in a classified mode. The application can be used as a basic analysis unit according to a toll station, a administrative district and provinces, and can be flexibly adjusted according to requirements.
Fig. 1 is a flow chart of an exemplary method of determining OD traffic, according to one embodiment of the present application.
Referring to fig. 1, first, ETC portal traffic data, toll collection vehicle flow detail data, and a portal basic information table in a statistical period in a target area may be acquired. The portal passage data and the toll vehicle flow detail data are vehicle record information transmitted back by the toll device. The ETC portal traffic data comprises fields including but not limited to a charging license plate number, a charging vehicle type code, a portal HEX character string, a portal name, an entrance station name, passing time, entrance time, a charging mileage, a cumulative mileage before transaction, a cumulative mileage after transaction and the like, and the field names and descriptions in the table 1 can be specifically referred to. The fields included in the toll vehicle flow detail data include, but are not limited to, a charging license plate number, a charging vehicle type code, an entrance number, an entrance name, an entrance time, an exit number, an exit name, an exit time, and the like, and specifically, refer to the field names and descriptions in table 2. The fields included in the basic information table of the portal include, but are not limited to, a toll station code, a chinese name of the toll station, a location where the toll station is located, a portal number code, a chinese name of the portal, a road name to which the portal belongs, and whether the portal is a provincial portal, and the like, and specific reference may be made to the field names and descriptions in table 3.
TABLE 1 ETC Portal passage data table field
TABLE 2 details of toll-car flow data table section field
TABLE 3 Portal basic information table
| Serial number | Name of field | Description of field | Serial number | Name of field | Description of the field |
| 1 | STATION_TAX_CODE | Toll station code | 5 | ROAD | Name of road to which portal belongs |
| 2 | STATION_NAME | Toll station Chinese name | 6 | MJNAME | Portal Chinese name |
| 3 | REGION_NAME | The district of | 7 | PTS | Whether it is provincial portal frame |
| 4 | MJCODEHEX | Portal number code |
Then, the ETC portal traffic data can be subjected to data cleaning, and then vehicle path integrity analysis is performed on the cleaned ETC portal traffic data. Wherein, the data cleaning may include clearing out critical fields such as brand, ETC portal name, entrance station name, time passing through portal, time passing through entrance station (i.e. entrance time) and the like, missing or unclear data; clearing data which is not in the counting target area or in the counting time period, and the like. Integrity analysis of the vehicle path may extract the vehicle OD in preparation for classification for OD traffic statistics.
The ETC portal traffic data only contain vehicle entrance information and no vehicle exit data record, and the detail data of the toll vehicle flow only contain vehicle start and end point information of the provincial and intra-provincial lower lane for provincial return data after national networking, so that vehicle start and end point information of trans-provincial and out-provincial trips is lost. Therefore, the toll collection vehicle flow detail data and the ETC portal data are required to be fused, information such as vehicle type, origin and destination of the vehicle is extracted through ETC portal traffic data, a complete driving path of the vehicle is analyzed, OD information missing from the toll collection vehicle flow detail data is made up, and OD traffic volume is extracted.
The method and the device can also extract the vehicle travel information of each travel type according to the data fusion result. The travel types include an in-province travel, an out-province travel, and a cross-province travel. Fig. 2 is a schematic diagram of travel types according to an embodiment of the present application. The entering and saving travel refers to travel with a starting point outside the province and a finishing point inside the province (namely, the province where the target area is located). The exit of the province refers to the exit with the starting point in the province and the ending point out of the province. The travel in province refers to travel with the starting point and the terminal point in province. The cross-provincial travel refers to travel with the starting point and the end point outside the province, but passes through the province of the target area in the driving process.
The travel information of the vehicle includes fields including: the system comprises starting time, ending time, license plate number, original starting point name, starting point number after turning, starting point name after turning, starting point district after turning, terminal point number, terminal point name, terminal point district, travel type, vehicle type, origin province, destination province and travel distance.
In some embodiments, the present application may also extract the split-type traffic that passes through the same start point and end point on a certain day, i.e., the natural car OD traffic volume between the start point and the end point. In some embodiments, the OD traffic volume may also be converted to standard vehicle traffic volume according to actual demand.
The vehicle path integrity analysis of the washed ETC portal traffic data may include the steps of:
in the statistics period, use the charging license plate number as the label, draw the orbit of traveling of corresponding vehicle in the current data of follow ETC portal, include:
and sequentially traversing downwards by taking the portal HEX character string of the first piece of data as a starting point, if the accumulated mileage field record before the transaction of the Nth piece of data is 0, determining the portal HEX character string of the (N-1) th piece of data as an end point, determining the record corresponding to the first piece of data to the (N-1) th piece of data as a complete OD trip record, taking the portal HEX character string of the Nth piece of data as a new starting point, and continuously traversing downwards, otherwise, taking the portal HEX character string in the last piece of data corresponding to the vehicle as an end point.
Taking the vehicle with the brand of Yu DN1 × 0_0 as an example, the ETC portal frame traffic data (only partial information is reserved) is shown in Table 4.
Table 4 YuDN 1 × 0_0 Portal data part field
| Serial number | ENVEHPLATE | ENVEHCLASS | MJCODEHEX | PASSTIME | DISTANCE | JYQLJLC | JYHLJLC |
| 1 | Yu DN 0_0 | 1 | 581301 | 8:07:06 | 18000 | 0 | 18000 |
| 2 | Yu DN 0_0 | 1 | 581303 | 8:19:37 | 8450 | 18000 | 26450 |
| 3 | Yu DN 0_0 | 1 | 582901 | 8:25:03 | 8020 | 26450 | 34470 |
| 4 | Yu DN 0_0 | 1 | 592901 | 9:53:47 | 8020 | 0 | 8020 |
| 5 | Yu DN 0_0 | 1 | 591303 | 9:59:46 | 6450 | 8020 | 14470 |
| 6 | Yu DN 0_0 | 1 | 584409 | 14:54:52 | 7825 | 0 | 7825 |
| 7 | Yu DN 0_0 | 1 | 591301 | 15:08:56 | 18000 | 7825 | 25825 |
Referring to table 4, the data of serial numbers 1 to 3 is a complete OD trip record, the starting point portal number (corresponding to the portal HEX character string) is 581301, the end point portal number (corresponding to the portal HEX character string) is 582901, and the trip distance is 34.47km. The data of serial numbers 4 to 5 is a complete OD trip record, the starting point portal number (the portal HEX character string corresponding to the starting point portal number) is 592901, the end point portal number (the portal HEX character string corresponding to the end point portal number) is 591303, and the trip distance is 14.47km. The data of serial numbers 6-7 is a complete trip record, the starting portal number (corresponding to the portal HEX character string) is 584409, the end portal number (corresponding to the portal HEX character string) is 591301, and the trip distance is 25.825km.
Fig. 3 is a flow chart of an exemplary method for determining an in-province exit and an in-province exit according to one embodiment of the present application. Referring to fig. 3, the method includes:
extracting all field data in the detailed data of the charging vehicle flow in the statistical time period one by one;
for each piece of toll vehicle flow detail data, writing entry time (entry) into 'start time', writing exit time (exit) into 'end time', writing exit name (exit name) into 'end name', writing station port number (exit) into 'end number', inquiring district and county where the exit is located and writing into 'end district and county' through a portal basic information table, writing a charging license plate number (ENVEHPLATE) into 'license plate number', writing a charging vehicle type code (ENVEHCLASS) into 'vehicle type', and writing a province where a target area is located into 'going province';
extracting a source province according to a vehicle entrance station name (instationname), judging whether the source province is the province where the target area is located, and if so, determining that the travel type is intra-province travel; otherwise, determining the travel type as the in-out travel.
After determining that the travel type is an intra-provincial travel, the method further comprises the following steps:
for each toll vehicle flow detail data, writing the inbound name and the district where the entry station is located into the starting point name and the starting point district, and writing the post-transaction accumulated mileage (JYHLJLC) at the end point of the trip in each complete OD trip record into the trip distance.
After determining that the travel type is an in-out travel, the method further includes:
writing the inbound number into the original starting point number, and writing the inbound name into the original starting point name; portal passing data of the vehicle at the corresponding time period are extracted, and for each complete OD trip record, the provincial portal number passing through the vehicle in the ETC portal passing data is extracted according to the time sequence by taking the charging license plate number as a label;
associating the provincial gate number with the provincial number (STATION _ TAX _ CODE) of the toll STATION through the gate basic information table, and determining the provincial inbound number of the vehicle;
respectively writing the number and the name of the provincial boundary inbound and the district where the provincial boundary inbound are written into the starting point number after turning, the starting point name after turning and the starting point district after turning; writing the accumulated mileage after the trip end point transaction (JYHLJLC) in the one-time complete OD trip record corresponding to the vehicle into the 'trip distance'.
It should be noted that, since the entry time (entry) in each piece of toll vehicle flow detail data coincides with the entry time (entry) of one complete OD travel record in the corresponding ETC portal traffic data, when the entry time (entry) is missing in any one of the toll vehicle flow detail data or the ETC portal traffic data, the entry time can be found in the other data that is not missing, and the "start time" can be written.
Fig. 4 is a flowchart illustrating an exemplary method of determining a saving row and a cross-saving row according to an embodiment of the present application. Referring to fig. 4, the method includes:
extracting all the vehicle information passing through the provincial and provincial gate frame in the cleaned ETC gate frame passing data within the statistical time period one by one;
for each ETC portal frame passing through the provincial and provincial portal frame, taking a toll station (which can be obtained by inquiring a portal frame basic information table) corresponding to the provincial portal frame in the ETC portal frame passing data as an exit station, writing the name and the area of the exit station into a terminal name and the area of the terminal, writing the number of the exit station into a terminal number, writing the number of a charging license plate (ENVEHPLATE) into a license plate number, and writing the code of the charging vehicle type (ENVEHCLASS) into a vehicle type;
writing the province associated province of the province portal frame into 'go province';
extracting source provinces according to vehicle entrance station names (instationnames), judging whether the source provinces are the provinces where the target area is located, and if so, determining that the travel type is the exit province travel; otherwise, determining the travel type as the cross-province travel.
After determining that the travel type is an outgoing saved travel, the method further comprises:
writing the name of the entrance station into the name of the starting point, writing the area where the entrance station is located into the area of the starting point, writing the entrance time of the trip into the starting time, and writing the exit time of the trip into the ending time;
and writing the post-transaction accumulated mileage (JYHLJLC) at the travel end point in each complete OD travel record in the portal traffic data corresponding to the vehicle into the travel distance.
After determining that the travel type is a cross-province travel, the method further comprises:
writing the inbound number of the trip into an original starting point number, and writing the entry station name into an original starting point name; taking the charging license plate number as a label, and extracting the provincial gate frame number passing through in the gate frame passing data of the corresponding vehicle according to the time sequence;
associating a provincial boundary portal number (MJCODEHEX) with a provincial boundary number (STATION _ TAX _ CODE) of a toll STATION through a portal basic information table, and determining a provincial boundary inbound number of the vehicle;
writing the provincial inbound number, the name and the district in which the provincial inbound number, the name and the district are located into the starting point number after the transition, the starting point name after the transition and the starting point district after the transition respectively;
writing the entry time of the trip into the starting time, and writing the exit time of the trip into the ending time;
and writing the post-transaction accumulated mileage (JYHLJLC) at the trip end point in each complete OD trip record in the portal passing data corresponding to the vehicle into the trip distance.
For any travel mode, the vehicle's whereabouts can be determined by the first letter of the charging license plate number (ENVEHPLATE). Note that the original start point number recorded in the travel information is an entrance station number recorded in the toll car flow specification data and the portal passage data. The number of the starting point after turning refers to the number of a provincial toll station related to a provincial portal frame through which vehicles enter the province. And after the conversion, the starting point name is the name of the provincial toll station associated with the provincial gate frame.
The above process is illustrated below by specific examples.
Example 1: the trip type is provincial trip
Still taking the vehicle with the brand of Yu DN1 x 0_0 as an example, the ETC portal traffic data (only partial information is reserved) is shown in the table 4, and the toll collection vehicle detailed data (only partial information is reserved) is shown in the table 5.
Table 5 yu DN1 x 0_0 charges detail data part field
As can be obtained by combining table 4 and table 5, for each complete OD travel record (such as serial numbers 1 to 3, 4 to 5, and 6 to 7), the charging detail data table is filled with "start time" and "end time" for entry time (entry), "end time" for exit time (exit), "license plate number" for charging license plate number (ENVEHPLATE), "vehicle type" for charging vehicle type code (ENVEHCLASS), "original start point number" for entry number (entry), "original start point name" for entry name (entry), and "end point number" for exit number (exit), and "end point name" for exit name (exit) in each complete OD travel record. And inquiring the district and county where the toll station is located in the portal basic data table, and filling the result into the district and county. The vehicle name can indicate that the vehicle is Yu nationality. And according to the travel origin-destination, the travel type is provincial travel. The distance in one trip can be known from the accumulated mileage after transaction (JYHLJLC) in the portal data. The results are shown in Table 6:
table 6 example 1 yu DN 0_0 trip information detail
Example 2: the travel types are cross-provincial travel and income-provincial travel
The data of the gate frame (only part of the information is retained) of the vehicle with the license plate number of R7 × 6_0 are shown in table 7.
Table 7: sichuan R7, 6_0 portal data part field
The data in table 7 can be obtained after the vehicle path integrity analysis is performed, the data of serial numbers 1 to 12 is a complete OD trip record, the starting point portal number is 5A1E01, and the end point portal number is 5a020F; the data of serial numbers 13-24 is a complete trip record, the starting portal number is 5B4102, and the ending portal number is 594002.
The details of the toll collection traffic (only part of the information is retained) with the license plate number R7 × 6_0 are shown in table 8.
TABLE 8 CHUANR 7, 6_0 Charge detail data part field
Combining table 8, it can be known that, for the vehicle with the license plate number of chuan R7 × 6_0, part of the record of the vehicle striding province trip is lost in the toll flow detail data, but the ETC portal frame pass data can be used for knowing that, in the first trip (i.e. serial numbers 1-12), the original starting point of the vehicle is the high plateau station of Yu of south Sichuan, the starting time is 4. The original starting point of the vehicle in the second trip (i.e. serial number 13-24) is the Sichuan Rongyunlong station, and the vehicle enters Yu sequentially (Yu province) through G8515 An Fuan, the station is the starting point after turning, and the terminal point is the Chongqing Guxi station. The extraction method of other fields is the same as that of embodiment 1, and the final result of the travel information is shown in table 9.
TABLE 9 EXAMPLE 2 CHUANR 7 6_0 travel information details
Finally, the above embodiments are only intended to illustrate the technical solutions of the present invention and not to limit the present invention, and although the present invention has been described in detail with reference to the preferred embodiments, it will be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions, and all of them should be covered by the claims of the present invention.
Claims (9)
1. The utility model provides a vehicle trip information extraction method based on highway ETC data fusion which characterized in that includes:
the ETC portal of statistics time interval in the acquisition target area passes data, toll collection vehicle flow detail data and portal basic information table, and wherein, the field that ETC portal passes the data and contains includes: the method comprises the following steps of charging license plate number, charging vehicle type code, portal HEX character string, portal name, entrance station name, passing time, entrance time, charging mileage, accumulated mileage before transaction and accumulated mileage after transaction;
the fields contained in the toll vehicle flow detail data include: a charging license plate number, a charging vehicle type code, an inbound number, an inbound name, an entry time, an outbound number, an outbound name and an exit time;
the fields contained in the basic information table of the portal comprise: the method comprises the following steps of (1) judging whether a toll station code, a toll station Chinese name, a district and county where the toll station is located, a portal frame number code, a portal frame Chinese name, a portal frame belonging road name and a provincial portal frame are available or not;
carrying out data cleaning on ETC portal passing data;
carrying out vehicle path integrity analysis on the cleaned ETC portal passage data;
carrying out data fusion on the cleaned ETC portal passage data, toll vehicle flow detail data and a portal basic information table;
extracting vehicle travel information of each travel type according to a data fusion result, wherein the travel types comprise an in-and-out travel, an out-and-out travel and a cross-and-out travel, and fields contained in the travel information of the vehicle comprise: the system comprises starting time, ending time, license plate number, original starting point name, starting point number after turning, starting point name after turning, starting point district after turning, terminal point number, terminal point name, terminal point district, travel type, vehicle type, origin province, destination province and travel distance.
2. The method for extracting vehicle travel information based on highway ETC data fusion according to claim 1, wherein the step of carrying out vehicle path integrity analysis on cleaned ETC portal traffic data comprises the following steps:
in the statistics period to the charging license plate number is the label, draws the orbit that traveles of corresponding vehicle from ETC portal traffic data, includes:
and sequentially traversing downwards by taking the portal HEX character string of the first piece of data as a starting point, if the accumulated mileage field record before the transaction of the Nth piece of data is 0, determining the portal HEX character string of the (N-1) th piece of data as an end point, determining the record corresponding to the first piece of data to the (N-1) th piece of data as a complete OD trip record, taking the portal HEX character string of the Nth piece of data as a new starting point, and continuously traversing downwards, otherwise, taking the portal HEX character string in the last piece of data corresponding to the vehicle as an end point.
3. The highway ETC data fusion-based vehicle travel information extraction method according to claim 2, wherein vehicle travel information is to be extracted according to data fusion results, and the method comprises the following steps:
extracting all field data in the detailed data of the charging vehicle flow in the statistical time period one by one;
for each piece of the toll-car flow detail data,
the entry time is written to the "start time",
the exit time is written to the "end time",
the outbound name is written to the "end name",
the outbound number is written to the "end number",
inquiring the district and county where the exit station is located through the portal basic information table and writing the inquiry result into 'terminal district and county',
writing the charging license plate number into 'license plate number',
writing the code of the billing vehicle type into the vehicle type,
writing the province where the target area is located into a 'go province';
extracting source provinces according to the names of the vehicle entrance stations, judging whether the provinces are the provinces where the target areas are located, writing the source provinces into the provinces, if so, determining that the travel type is intra-provincial travel, and otherwise, determining that the travel type is in-provincial travel.
4. The highway ETC data fusion-based vehicle travel information extraction method according to claim 3, after determining that the type of travel is intra-provincial travel, the method further comprising:
for each piece of the toll-car flow detail data,
the inbound name is written to the "origin name",
writing the district where the entrance station is in into the starting district,
and writing the accumulated mileage after the transaction at the travel endpoint in each complete OD travel record into the travel distance.
5. The highway ETC data fusion-based vehicle travel information extraction method according to claim 3, wherein after determining the type of travel as an in-and-out row, the method further comprises:
the inbound name is written to the "original origin name",
writing the inbound number into the original starting point number, extracting the portal passing data in the corresponding time period of the vehicle, recording each complete OD trip,
taking the charging license plate number as a label, and extracting the provincial gate frame number of the corresponding vehicle passing through the gate frame passing data according to the time sequence;
associating the provincial gate frame number with the provincial number of the toll station through a gate frame basic information table, and determining the provincial inbound number of the vehicle;
respectively writing the number and the name of the provincial boundary inbound and the district where the provincial boundary inbound are written into the starting point number after turning, the starting point name after turning and the starting point district after turning;
and writing the accumulated mileage after the transaction at the trip end point in the one-time complete OD trip record corresponding to the vehicle into the trip distance.
6. The method for extracting vehicle travel information based on highway ETC data fusion according to claim 2, wherein the step of extracting vehicle travel information according to the data fusion result comprises the following steps:
extracting all the vehicle information passing through the provincial and provincial gate frame in the cleaned ETC gate frame passing data within the statistical time period one by one;
for each ETC portal traffic data passing through the provincial and provincial portals,
taking a toll station corresponding to the provincial gate frame in ETC gate frame passing data as an exit station, writing the name of the exit station into a destination name,
writing the exit station number into an 'end point number', inquiring the district and county where the exit station is located through a portal basic information table and writing the number into the 'end point district and county',
writing the charging license plate number into 'license plate number',
writing the code of the billing vehicle type into the vehicle type, and writing the province portal associated province into the going province;
extracting source provinces according to the names of the vehicle entrance stations, judging whether the provinces are the provinces where the target areas are located or not and writing the source provinces into the provinces, if so, determining that the travel type is the province travel, otherwise, determining that the travel type is the cross-province travel.
7. The method for extracting vehicle travel information based on highway ETC data fusion according to claim 6, wherein after determining the travel type as an exit and exit, the method further comprises:
the ingress site name is written to the "origin name",
writing the district where the entrance station is in into the starting district,
the entry time of the row is written into the starting time, the exit time of the row is written into the ending time,
and writing the accumulated mileage after the transaction at the travel end point in each complete OD travel record in the portal traffic data corresponding to the vehicle into the travel distance.
8. The method for extracting vehicle travel information based on highway ETC data fusion according to claim 6, wherein after determining the travel type as a trans-provincial travel, the method further comprises:
writing the inbound number of the trip into an original starting point number, and writing the entry station name into an original starting point name;
taking the charging license plate number as a label, and extracting the provincial gate frame number passing through in the gate frame passing data of the corresponding vehicle according to the time sequence;
associating the provincial gate frame number with the provincial number of the toll station through a gate frame basic information table, and determining the provincial inbound number of the vehicle;
respectively writing the number and the name of the provincial inbound, the number of the post-turn starting point, the name of the post-turn starting point and the county of the post-turn starting point into the provincial county, writing the entry time of the trip into the starting time, and writing the exit time of the trip into the ending time;
and writing the accumulated mileage after the transaction at the travel end point in each complete OD travel record in the portal passing data corresponding to the vehicle into the travel distance.
9. The highway ETC data fusion-based vehicle travel information extraction method according to claim 1, wherein fields contained in the travel information of the vehicle further comprise a vehicle membership, and the method further comprises judging the vehicle membership of the vehicle through the first character in the charging license plate number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211344121.9A CN115830729A (en) | 2022-10-31 | 2022-10-31 | Vehicle travel information extraction method based on highway ETC data fusion |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211344121.9A CN115830729A (en) | 2022-10-31 | 2022-10-31 | Vehicle travel information extraction method based on highway ETC data fusion |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115830729A true CN115830729A (en) | 2023-03-21 |
Family
ID=85525844
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211344121.9A Pending CN115830729A (en) | 2022-10-31 | 2022-10-31 | Vehicle travel information extraction method based on highway ETC data fusion |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115830729A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117238141A (en) * | 2023-11-14 | 2023-12-15 | 交通运输部规划研究院 | Cross-region travel behavior identification method and device of target vehicle and electronic equipment |
| CN117671975A (en) * | 2024-02-01 | 2024-03-08 | 交通运输部科学研究院 | Cross-regional travel amount calculating method, device, equipment and medium for high-speed small bus |
| CN117725356A (en) * | 2024-02-08 | 2024-03-19 | 交通运输部科学研究院 | Method, device, equipment and medium for calculating travel amount of high-speed middle and large bus personnel |
-
2022
- 2022-10-31 CN CN202211344121.9A patent/CN115830729A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117238141A (en) * | 2023-11-14 | 2023-12-15 | 交通运输部规划研究院 | Cross-region travel behavior identification method and device of target vehicle and electronic equipment |
| CN117238141B (en) * | 2023-11-14 | 2024-02-02 | 交通运输部规划研究院 | Cross-region travel behavior identification method and device of target vehicle and electronic equipment |
| CN117671975A (en) * | 2024-02-01 | 2024-03-08 | 交通运输部科学研究院 | Cross-regional travel amount calculating method, device, equipment and medium for high-speed small bus |
| CN117671975B (en) * | 2024-02-01 | 2024-04-16 | 交通运输部科学研究院 | Cross-regional travel amount calculating method, device, equipment and medium for high-speed small bus |
| CN117725356A (en) * | 2024-02-08 | 2024-03-19 | 交通运输部科学研究院 | Method, device, equipment and medium for calculating travel amount of high-speed middle and large bus personnel |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN115830729A (en) | Vehicle travel information extraction method based on highway ETC data fusion | |
| CN102595323B (en) | Method for obtaining resident travel characteristic parameter based on mobile phone positioning data | |
| CN106197458A (en) | A kind of cellphone subscriber's trip mode recognition methods based on mobile phone signaling data and navigation route data | |
| CN101989381B (en) | Method for road one-way restriction and traffic state identification based on floating car technology | |
| CN103700174A (en) | Method for data collection and OD (Origin-Destination) analysis of public transport passenger flow based on WIFI identity recognition | |
| CN111862606A (en) | Illegal operating vehicle identification method based on multi-source data | |
| CN113744420B (en) | Road parking charge management method, system and computer readable storage medium | |
| CN112184931B (en) | Vehicle charging path optimization system and analysis method based on highway network | |
| CN108122131B (en) | Public bicycle card swiping data-based commuting behavior and job and residence identification method | |
| CN108922178A (en) | The real-time load factor calculation method of public transit vehicle based on public transport multi-source data | |
| CN112925820B (en) | Method, device and system for identifying vehicle evasion toll | |
| CN111178577A (en) | Service station site selection method based on GEOHASH algorithm | |
| CN110969861B (en) | Vehicle identification method, device, equipment and computer storage medium | |
| CN109978746B (en) | Population exchange amount estimation method for judging travel effectiveness based on signaling data and combined with dynamic threshold | |
| CN111984806A (en) | Method, device and storage medium for determining association degree of vehicle and terminal | |
| CN115761920A (en) | ETC portal data-based vehicle track credible extraction method and system | |
| CN109615865B (en) | OD data increment based iterative road section traffic flow estimation method | |
| CN112770278B (en) | Mobile phone signaling analysis method and device, computer equipment and storage medium | |
| CN109447882B (en) | Population exchange amount estimation method based on signaling data | |
| CN111624638A (en) | Method for tracing trace and generating monitoring report based on big data system | |
| CN115988422A (en) | Multilevel rail transit transfer passenger flow extraction method based on travel chain analysis | |
| CN111931968B (en) | Method for optimizing public bicycle station layout by using mobile phone GPS data | |
| CN112185120A (en) | Commuting private car identification method based on electronic license plate data | |
| CN111724587A (en) | Traffic flow density parameter extraction method based on RFID technology | |
| CN114898574B (en) | Method and system for estimating traffic parameters |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |