CN106651732A - Highway different-vehicle card-change toll-dodging vehicle screening method and system - Google Patents
Highway different-vehicle card-change toll-dodging vehicle screening method and system Download PDFInfo
- Publication number
- CN106651732A CN106651732A CN201611235092.7A CN201611235092A CN106651732A CN 106651732 A CN106651732 A CN 106651732A CN 201611235092 A CN201611235092 A CN 201611235092A CN 106651732 A CN106651732 A CN 106651732A
- Authority
- CN
- China
- Prior art keywords
- vehicle
- transaction
- card
- entrance
- car plate
- 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
- 238000012216 screening Methods 0.000 title claims abstract description 39
- 238000000034 method Methods 0.000 title claims abstract description 32
- 230000008859 change Effects 0.000 claims abstract description 31
- 238000012795 verification Methods 0.000 claims description 8
- 238000012217 deletion Methods 0.000 claims description 5
- 230000037430 deletion Effects 0.000 claims description 5
- 238000005516 engineering process Methods 0.000 abstract description 6
- 238000007418 data mining Methods 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000006855 networking Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 241000251468 Actinopterygii Species 0.000 description 1
- 241000196324 Embryophyta Species 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000000205 computational method Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000036651 mood Effects 0.000 description 1
- 230000008450 motivation Effects 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000004904 shortening Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/40—Business processes related to the transportation industry
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
- G06F16/43—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Multimedia (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Devices For Checking Fares Or Tickets At Control Points (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a highway different-vehicle card-change toll-dodging vehicle screening method and system. The method comprises the steps of obtaining an exit transaction information table; pairing different-plate card-change transaction records: performing pairing according to license plates, entry transaction time and exit transaction time of vehicles corresponding to the license plates in a generated transaction record table with inconsistent entry license plates and exit license plates to generate a transaction record pairing information table; and checking tolls: for the vehicles in the pairing information table, calculating difference of tolls of the paired vehicles not subjected to pass card change and actually paid tolls of the paired vehicles subjected to pass card change, and if a difference value is greater than 0, judging that two vehicles in the paired vehicles are card-change vehicles. By applying a big data mining technology, a vehicle behavior law is mined, transaction records of different-vehicle card change can be quickly searched, and all toll-dodging vehicles can be automatically screened, so that the problems of time and labor consumption caused by a manual mode and non-standard event handling and the like due to different business abilities of personnel at present are solved.
Description
Technical field
The present invention relates to big data digging technology field, more particularly to a kind of different car of highway changes card fee evasion vehicle examination
Method and system.
Background technology
The charge operation of highway is a basic service in highway operation, and to user reasonable expense is imposed
With, repair the roads loan for repaying, there is provided improve highway network construction fund, it is basis that highway is depended on for existence and developed.
Each highway inside the province domestic at present has been carried out networked fee collection, and with the carrying out of networked fee collection, the distance of networking is increasingly longer, single
The amount of money of secondary charge is also increasing, and under the ordering about of huge economic interests, evading the behavior of pass cost becomes more and more ferocious
It is rampant.Illegal driver is changed card, is blocked, rushes that hilllock is made a breakthrough and fee-collector gangs up in violation of rules and regulations free, vehicle refitting and personation is exempted from by different car
The means such as expense vehicle carry out fee evasion, and to highway unit of operation and country huge economic loss is caused, or even have influence on
The safe operation of highway.
At present, highway unit of operation does not change different car card fee evasion vehicle and sieves using big data mining algorithm
Look into, for different car changes the examination of card fee evasion behavior mainly by fee-collector's field screening and inspector two kinds of sides of examination afterwards
Formula.
1st, fee-collector's field screening
Fee-collector's field screening refers to vehicle when the lane in which the drivers should pay fees is sailed into, the fee-collector scene verification car plate of vehicle, vehicle,
And the information such as entry time, such as find that gateway car plate is not inconsistent, or entrance vehicle is sentenced type and is not inconsistent with outlet, and time-out etc. shows
As, then suspecting to be fee evasion vehicle, fee-collector is by system alarm and reports monitor, and monitor recalls entrance in visa card and captures
Picture or video are further examined, the card fee evasion vehicle to determine whether to change.
2nd, inspector's examination afterwards
Afterwards examination refers to that fee-collector scene is difficult to judge, or judges that the time is very long, flow process is complicated, to avoid impact car
Road is unimpeded, and fee-collector allows suspect vehicle normal pass, transfers to backstage inspector to transfer corresponding picture and video current record,
Detailed contrast judgement is carried out with the presence or absence of changing card fee evasion behavior.
Above-mentioned examination mode is to take artificial examination means, not only causes toll collector's working strength to increase, while holding
Yi Yinfa driver and toll collector clash, and affect normal charge order.Existing vehicle examination means, main deficiency
Show it is following some：
1st, artificial examination speed is slow, and efficiency is low
Fee-collector's field screening has an impact to gateway service time, also has very high to the qualification of fee-collector's operation
Require, in the case where vehicle flowrate is little, operation does not have much problems substantially, if vehicle flowrate increase, it is easy to cause track to go out
Mouth congestion, causes the discontented mood of the public.
2nd, image, video information are searched slowly, are difficult storage
The at present verification of information of vehicles relies primarily on vehicle pictures and video information, picture, video information due to excessive, one
Aspect lookup is inconvenient, searches the time longer；Another aspect storage time is shorter, the information longer for the time, and one
Denier is lost, inquiry of having no way of.
3rd, artificial examination easily causes omission
The examination of card fee evasion vehicle is changed different car at present, and either scene still afterwards, has been all based on fee-collector scene
The doubtful vehicle for checking carries out examination, and with the increasing to premium evasion car hitting dynamics, driver also " weeds out the old and bring forth the new " and finds out respectively
, to confuse toll collector, toll collector is due to lacking experience, business is not yet done, and the time for the illusion of the method for kind manufacture normal pass
The reason such as limited, it is impossible to which all fee evasion vehicles are recognized one by one, therefore have fish that has escape the net unavoidably.
The content of the invention
To overcome the above-mentioned technical problem of prior art presence, the invention provides a kind of different car of highway changes card fee evasion
Vehicle screening method, it applies big data digging technology, digging vehicle Behavior law quickly to search the transaction note that different car changes card
Record, all fee evasion vehicles of automatic examination solve time-consuming, the effort for causing by artificial mode at present, and due to personnel's business
Ability is uneven, the problems such as event handling is lack of standardization.
The technical scheme that the present invention solves above-mentioned technical problem is as follows：A kind of different car of highway changes card fee evasion vehicle examination
Method, it includes：
Obtain outlet Transaction Information table；
The inconsistent record of screening car plate：From the outlet Transaction Information table recorded entrance car plate is searched with outlet
The inconsistent record of car plate, generates the entrance car plate trading record sheet inconsistent with outlet car plate；
Different board changes card transaction record pairing：From the entrance car plate of the generation trading record sheet inconsistent with outlet car plate
In, matched according to each car plate, the entrance exchange hour of each car plate correspondence vehicle and outlet exchange hour, generate transaction
Record unpaired message table；
Verification expense：For the vehicle in the unpaired message table, calculate pairing vehicle does not switch the current of visa card
Expense and the reality after switching are paid dues and use its difference, if difference is more than zero, two cars being judged in the pairing vehicle are to change truck
.
On the basis of above-mentioned technical proposal, the present invention can also do following improvement.
Further, the Transaction Information of each visa card, a visa card letter are have recorded in the outlet Transaction Information table
Cease for a record, every record storage using the vehicle of the visa card entrance and outlet information.
Further, during the different board changes card transaction record pairing, it is assumed that arbitrary in transaction record unpaired message table
It is A transaction records and B transaction records to transaction record, the A transaction records and B transaction records meet following condition：
The outlet car plate of the entrance car plate of the A transaction records=B transaction records, and the B transaction records enter
The outlet car plate of mouth car plate=A transaction records；
The entrance transaction of the outlet of A transaction records correspondence vehicle B transaction records correspondence vehicle described in exchange hour ＞
Time, and the entrance exchange hour of A transaction records correspondence vehicle described in B transaction records outlet exchange hour ＞.
Further, during the verification expense, the pass cost for not switching pass ticket for calculating pairing vehicle is used
Pay dues and use it poor with the reality after switching, as the fee evasion amount of money, its computing formula is：
The fee evasion amount of money=A transaction records entrance vehicle * A transaction records Entrance Square to B transaction records export taking for square
Expense-A transaction record the reality on square is exported with+B transaction records entrance vehicle * B transaction records Entrance Square to A transaction records
Charge-B transaction record earned rates.
Further, the step of removal duplicate data is also included after the different board is changed the step of card transaction record is matched,
A deletion in two identical transaction records after will matching.
Further, after verification expense, if it is determined that when two cars in match vehicle are to change truck, then generating fee evasion
Information data table.
Further, also including exporting the fee evasion information data table and the step of preserve.
The present invention also provides a kind of different car of highway and changes card fee evasion vehicle screening system, and it includes：
Read module, for reading out a mouthful Transaction Information table；
Screening module, for screening entrance car plate and the outlet inconsistent record of car plate, and for generate entrance car plate with
The inconsistent trading record sheet of outlet car plate；
Matching module, during for according to each car plate, the entrance exchange hour of each car plate correspondence vehicle and outlet transaction
Between, transaction record in the entrance car plate trading record sheet inconsistent with outlet car plate is matched, and hand over for generating
Easily record unpaired message table；
Expense checks module, for calculating transaction record unpaired message table in pairing vehicle do not switch the logical of visa card
Row expense and the reality after switching are paid dues and use its difference, and judge that two cars in the pairing vehicle are according to the difference of the expense of the calculating
It is no to change truck.
Further, also including removing module and fee evasion information generating module；The removing module be used for by pairing after two
A deletion in individual identical transaction record；The fee evasion information generating module is used to be judged to change the fee evasion letter of truck
Breath generates fee evasion information data table.
Further, the output module for exporting the fee evasion information table is also included and for preserving the fee evasion information table
Preserving module.
Compared with prior art, the different car of highway that the present invention is provided changes card fee evasion vehicle screening method and system, its
Have the advantages that：1st, the transaction that different car changes card can accurately and fast be found with the method for time and spatial intersecting
Record, and then fee evasion behavior is judged whether, time-consuming, the effort for causing by artificial mode at present is solved, and due to people
Member's professional ability is uneven, the problems such as event handling is lack of standardization；2nd, with track transaction data, solve lookup picture or regard
Frequency is slow and is difficult the problem for storing, and track transaction data storage time is longer, is easy to inquire about transaction record at any time；3rd, wheeled digging machine
Behavior law, all fee evasion vehicles of automatic examination, and further collect vehicle whole historical trading, by there is different car to change card
The vehicle of fee evasion behavior is analyzed, and finds and summarize its Behavior law, with big data algorithm model from mass historical data
Automatic sieve finds all legal suspected vehicles, and can the history fee evasion information of each premium evasion car be carried out collecting and
Analysis, is easy to further carry out classification checking and administration to fee evasion vehicle.
Description of the drawings
Fig. 1 changes card schematic diagram for large and small car；
Fig. 2 changes card schematic diagram for long-distance change short distance；
Fig. 3 changes the flow process of card fee evasion vehicle screening method for the different car of highway of the exemplary offer of the embodiment of the present invention one
Figure；
Fig. 4 is the space-time alternative method execution flow chart of the exemplary offer of the embodiment of the present invention two.
Specific embodiment
The principle and feature of the present invention are described below in conjunction with accompanying drawing, example is served only for explaining the present invention, and
It is non-for limiting the scope of the present invention.It should be noted that in the case where not conflicting, in embodiments herein and embodiment
Feature can be mutually combined.
In describing the invention, different car changes card fee evasion and refers to different two cars by exchanging visa card, to shortening
The mode of current mileage realizes fee evasion.The different car of highway changes card fee evasion vehicle examination and refers to by certain rule, to different car
The vehicle for changing card fee evasion behavior is screened and confirmed, so as to filter out the process of fee evasion vehicle.Visa card refers to closed receipts
Charge system has entrance charge name of station (numbering) etc. to enter message in the record that entrance car is directed through vehicle (highway user) granting
The ticket of breath.
Embodiment one
At present, highway fee evasion vehicle identification and detection lacks effective technological means, part charge station limitation
It is more to take artificial examination means in infrastructure and hardware facility, artificial examination not only causes toll collector's work strong
Degree increases, while easily causing driver and toll collector to clash, affects normal charge order.
The different car of highway that the present embodiment is provided changes card fee evasion vehicle screening method, and it utilizes the data mining of big data
Technology, extracts useful information from mass data, the potential relation between data is found, for existing networking charging system
Transaction journal data are big and complete, imply it is abundant but it is still undiscovered evade cost information, these evade cost information or
Intuitively, it is more be it is potential, but it is all of there are many common features with the potential vehicle registration data for evading behavior,
Such as time-out, mileage record is shorter, gateway website is perverse etc., therefore, the present embodiment maintenance data digging technology is to height
Fast highway fee evasion vehicle carries out examination, studies the problem that high speed company evades expense.
Card fee evasion situation is changed for the different car of highway, two kinds of fee evasion modes are common are：
1st, cart becomes dolly
As shown in figure 1, A cars are high capacity waggon, it is compact car to stand into, B cars from K, from L stand into, the car of A, B two standing from M, N
The service area before exporting of standing changes card, and afterwards, A cars go out from M mouths, and B cars go out from N mouths, and according to expenses standard, the car vehicle of A, B two is different,
Outbound be defined calculating travelling expenses by vehicle classification, so will result in the pass cost that high capacity waggon A pays short distance LM section, dolly B
The pass cost of long-distance KN sections is paid, fee evasion purpose is reached with this.
2nd, long-distance change short distance
As shown in Fig. 2 the car of A, B two is relative travelling, A cars are travelled on K Zhan Shang roads toward N stations, and B cars are gone on L Zhan Shang roads toward M stations
Sail, the car of A, B two exchanges visa card at service area, A cars are exported out at a high speed in N, only pay LN section pass costs, and B cars are exported out in M
At a high speed, KM section pass costs are only paid, such A, B two cars reach long-distance car change short distance car by exchanging visa card, few traffic
The purpose that row takes.
Card fee evasion situation is changed regardless of different car, the two cars of different vehicle are exported after visa card is exchanged in high speed
During payment, fee-collector can receive the inconsistent prompting of car plate, but due to Car license recognition product in the market, all cannot also do
It is correct to 100%, if car owner proposes that car plate is inconsistent is because that Car license recognition mistake, particularly rear wait vehicle more
When, fee-collector possibly cannot carry out entry video confirmation, and directly let pass, so there is in transaction record entrance car plate with
The inconsistent record of outlet car plate.Change and necessarily had staggeredly on the time and spatial course that the two cars of card sail in high speed uplink,
Namely space-time alternative, this is the necessary condition for changing card, and time interleaving refers to two cars for changing card, there is a section simultaneously in high speed
Time, this is the time conditions for changing card；Spatial intersecting refers to two cars for changing card, on the basis of time interleaving is met, will also be
There is common factor in actual travel path, this is the steric requirements for changing card.By space-time alternative analytic approach, can find out and change card suspicion
Vehicle, rate is finally also checked, it is, the expense of actual travel path is greater than it changes the expense actually paid after card
With, that is, the fee evasion amount of money is greater than zero, this is the motivation for changing card.
Based on above-mentioned analysis, as shown in figure 3, the different car of highway that the present embodiment is provided changes card fee evasion vehicle examination side
Method, it specifically includes following steps：
S1：Obtain outlet Transaction Information table.
In the outlet Transaction Information table, the Transaction Information of each visa card is have recorded, a current card information is one
Bar is recorded, and per bar, record is stored using the entrance and outlet information of the vehicle of the visa card again, including entrance name of station, entrance car
Board, entry time, entrance judge vehicle and outlet name of station, outlet car plate, Outlet time, outlet judgement vehicle etc..
S2：The inconsistent record of screening car plate：Search from the outlet Transaction Information table recorded entrance car plate with
The inconsistent record of outlet car plate, generates the entrance car plate trading record sheet inconsistent with outlet car plate.
Based on the data in outlet Transaction Information table, screening outlet vehicle and the inconsistent record of entrance vehicle, that is, screen
The transaction record of license plate number ≠ entrance license plate number is exported, and generates the entrance car plate transaction record inconsistent with outlet car plate
Table.
S3：Different board changes card transaction record pairing：From the entrance car plate of the generation transaction note inconsistent with outlet car plate
In record table, matched according to each car plate, the entrance exchange hour of each car plate correspondence vehicle and outlet exchange hour, generated
Transaction record unpaired message table.
After two cars of different car plates are entered at a high speed, exchange and leave after visa card at a high speed, two transaction records can be produced, find out
This two records of association, just referred to as different board change card transaction record pairing, pairing is the transaction record filtered out based on S2, root
Matched according to gateway exchange hour and car plate.That is, the vehicle of two different car plates is realized after fee evasion by changing card,
It should occur in pairs to meet the transaction record in S2, and their gateway car plate intersection is equal, meets the sky that two cars change card
Between staggeredly condition.Meet the spatial intersecting condition that two cars change card two transaction records also need to one section it is common in high speed
Time, that is, need to meet the time interleaving condition that two cars change card, the transaction of spatial intersecting condition and time interleaving condition will be met
Record generates transaction record unpaired message table.
S4：Verification expense：For the vehicle in the unpaired message table, calculate pairing vehicle does not switch the logical of visa card
Row expense and the reality after switching are paid dues and use its difference, if difference is more than zero, two cars being judged in the pairing vehicle are to change card
Vehicle.
After transaction record unpaired message table is generated, the pass cost that the vehicle in unpaired message table does not switch visa card is calculated
With with switch after reality pay dues and use it poor, this difference if greater than 0, then preliminary judgement be two cars to change truck, difference is just
It is the fee evasion amount of money.
The above-mentioned different car provided based on the present embodiment changes card fee evasion vehicle screening method, can accurately and fast search different car and change
The transaction record of card, and then fee evasion behavior is judged whether, time-consuming, the effort for causing by artificial mode at present is solved,
With due to personnel's professional ability it is uneven, the problems such as event handling is lack of standardization；Meanwhile, with big data space-time alternative method, energy
Automatic sieve finds all different cars and changes card fee evasion vehicle from mass data, and can collect the history fee evasion of all fee evasion vehicles
Information, largely can retrieve because different car changes economic loss and the bad social influence that card is caused.
Embodiment two
Change that card fee evasion vehicle screening method applied for the different car of highway described in embodiment one is space-time alternative
Analysis screening method, its specific rules are as follows：
, there is the entrance car plate record inconsistent with outlet car plate, that is, the outlet concluded the business in transaction record in the first rule
The entrance license plate number of license plate number ≠ transaction.
Second rule, spatial intersecting：The vehicle of two different car plates realized after fee evasion by changing card, meets the first rules and regulations
Record then should be occurred in pairs, and their gateway car plate intersection is equal,.Assume to appoint in transaction record unpaired message table
One two transaction records for occurring in pairs are that A transaction records and B transaction records, then A transaction records and B transaction records meet following
Condition：The outlet car plate of the entrance car plate of the A transaction records=B transaction records, and the entrance car of the B transaction records
The outlet car plate of board=A transaction records.
Article 3 rule, time interleaving：Meet two transaction records of the second rule, in addition it is also necessary to have one section jointly in height
Time in speed, that is, meet the entrance of outlet B transaction records correspondence vehicle described in exchange hour ＞ of A transaction records correspondence vehicle
Exchange hour, and the entrance exchange hour of A transaction records correspondence vehicle described in B transaction records outlet exchange hour ＞.
Article 4 rule, checks expense：Meet the record of the rule of the above three simultaneously, need to calculate the fee evasion amount of money, fee evasion
The amount of money can just confirm as fee evasion suspected vehicles more than 0, and the computational methods of the fee evasion amount of money are as follows：
The fee evasion amount of money=A transaction records entrance vehicle * A transaction records Entrance Square to B transaction records export taking for square
Expense-A transaction record the reality on square is exported with+B transaction records entrance vehicle * B transaction records Entrance Square to A transaction records
Charge-B transaction record earned rates.
Above-mentioned space-time alternative analytic approach depends on the outlet tran list and Fee Schedule of charge data, charge data to be stored in
In Hive, Hive is, based on a Tool for Data Warehouse of Hadoop, structurized data file can be mapped as into a number
According to storehouse table, and simple sql query functions are provided, sql sentences can be converted to MapReduce tasks and be run.With biography
System relevant database is compared, Hive has capacity and a speed advantage in terms of super large data are processed, therefore the present invention is provided
Algorithm is under big data Hadoop environment, to perform what is completed by SQL statement, and concrete execution flow process is as shown in Figure 4：
1st, car plate inconsistency record is screened
Outlet Transaction Information table is recalled from Hive databases, the inconsistent record of car plate is screened from the table.In outlet
In tran list, the Transaction Information of each visa card is have recorded, a current card information is a record, and record is stored again per bar
Judged using the entrance and outlet information of the vehicle of the visa card, including entrance name of station, entrance car plate, entry time, entrance
Vehicle and outlet name of station, outlet car plate, Outlet time, outlet judgement vehicle etc..Outlet tran list is as shown in table 1：
Table 1 exports tran list
Based on this, the entrance car plate record inconsistent with outlet car plate is screened, sql sentences are performed in Hive, it is as follows：
truncate table antifraud.one；-- empty tables of data
insert into antifraud.one
select*from oaa.L05_Exit_Tran
Where DataSource=0-- manual transactions
and length(carlicense)>5-car plate is normally recorded
and length(ent_carlicense)>5-car plate is normally recorded
and carlicense<>ent_carlicense；- entrance car plate is inconsistent with outlet car plate
2nd, the entrance car plate of the above-mentioned screening trading record sheet inconsistent with outlet car plate can be replicated a, for next
Step operation：
truncate table antifraud.two；
insert into antifraud.two
select*from antifraud.one；
3rd, different board changes card transaction record pairing
After two cars of different car plates are entered at a high speed, exchange and leave after visa card at a high speed, two transaction records can be produced.Find out
This two of association record, and just referred to as different board changes card transaction record pairing.Pairing is the transaction note filtered out based on step 1
Record, is matched according to gateway exchange hour and car plate, and the sql sentences performed in Hive are as follows：
A.CarLicense=b.ENT_CarLicenseb transaction records enter high speed car plate be equal to a transaction records from
Open the car plate of high speed；
Andb.CarLicense=a.ENT_CarLicensea transaction records enter the car plate of high speed and are equal to b transaction records
Leave the car plate of high speed；
anda.ENT_OccurTime<B.TransOccurTime-a records leave height into high speed time less than b records
The fast time；
andb.ENT_OccurTime<a.TransOccurTime；- b records leave into high speed time less than a records
High speed time.
4th, duplicate data is removed
After pairing, a fee evasion information has two of two cars records, due to addition it is unrelated with tandem, so
Remove the record of repetition using the id of synthesis, it can be realized by following procedure：
5th, calculate and change expense difference before and after card
Association Fee Schedule, deducts it and changes the expense actually paid after card, rate table record with the expense of actual travel path
The vehicle of different automobile types by vehicle running path with rate in combination with, is counted by the pass cost paid needed for different section
Calculate the expense that two cars before card should be handed over of changing, then deduct and change the amount paid in expense of two cars after card, its difference is drawn, if difference is more than
0, then preliminary judgement change truck for fee evasion, generation includes gateway charge station, and track number, car plate, amount paid in takes, and should pay the fees etc. complete
The tables of data of whole fee evasion information, concrete calculating process is realized by following codes：
6th, the complete fee evasion information data table generated in step 5 is derived and is preserved
Fee evasion vehicle data message is exported into mysql relevant databases, is preserved as fee evasion evident information, be easy to use
Family uses.
Embodiment three
Card fee evasion vehicle screening method is changed based on the different car of highway described in above-described embodiment one or two, the present embodiment is carried
The different car of its corresponding highway has been supplied to change card fee evasion vehicle screening system, it is specifically included：
Read module, for reading out a mouthful Transaction Information table；
Screening module, for screening entrance car plate and the outlet inconsistent record of car plate, and for generate entrance car plate with
The inconsistent trading record sheet of outlet car plate；
Matching module, during for according to each car plate, the entrance exchange hour of each car plate correspondence vehicle and outlet transaction
Between, transaction record in the entrance car plate trading record sheet inconsistent with outlet car plate is matched, and hand over for generating
Easily record unpaired message table；
Expense checks module, for calculating transaction record unpaired message table in pairing vehicle do not switch the logical of visa card
Row expense and the reality after switching are paid dues and use its difference, and judge that two cars in the pairing vehicle are according to the difference of the expense of the calculating
It is no to change truck.
Also include removing module and fee evasion information generating module；The removing module be used for by pairing after two identicals
A deletion in transaction record；The fee evasion information generating module is used to be judged to that the fee evasion information for changing truck generation is escaped
Charge information tables of data.Also include the output module for exporting the fee evasion information table and for preserving the fee evasion information table
Preserving module.
The different car of highway provided using the present embodiment changes card fee evasion vehicle screening system can accurately and fast search different car
The transaction record of card is changed, fee evasion behavior is judged whether, Automatic sieve all different cars can be found and is changed card fee evasion from mass data
Vehicle, and can collect the history fee evasion information of all fee evasion vehicles, is easy to further to carry out classification to fee evasion vehicle to check
Check reason.
The foregoing is only presently preferred embodiments of the present invention, not to limit the present invention, all spirit in the present invention and
Within principle, any modification, equivalent substitution and improvements made etc. should be included within the scope of the present invention.
Claims (10)
1. a kind of different car of highway changes card fee evasion vehicle screening method, it is characterised in that include：
Obtain outlet Transaction Information table；
The inconsistent record of screening car plate：Recorded entrance car plate is searched from the outlet Transaction Information table with outlet car plate
Inconsistent record, generates the entrance car plate trading record sheet inconsistent with outlet car plate；
Different board changes card transaction record pairing：From the entrance car plate of the generation trading record sheet inconsistent with outlet car plate,
Matched according to each car plate, the entrance exchange hour of each car plate correspondence vehicle and outlet exchange hour, generated transaction note
Record unpaired message table；
Verification expense：For the vehicle in the unpaired message table, the pass cost for not switching visa card for calculating pairing vehicle is used
Pay dues and use it poor with the reality after switching, if difference is more than zero, two cars being judged in the pairing vehicle are to change truck.
2. the different car of highway according to claim 1 changes card fee evasion vehicle screening method, it is characterised in that the outlet
The Transaction Information of each visa card is have recorded in Transaction Information table, a current card information is a record, records per bar and deposit
Store up using the entrance and outlet information of the vehicle of the visa card.
3. the different car of highway according to claim 2 changes card fee evasion vehicle screening method, it is characterised in that described different
Board is changed during card transaction record pairing, it is assumed that arbitrary in transaction record unpaired message table is A transaction records and B to transaction record
Transaction record, the A transaction records and B transaction records meet following condition：
The outlet car plate of the entrance car plate of the A transaction records=B transaction records, and the entrance car of the B transaction records
The outlet car plate of board=A transaction records；
The entrance exchange hour of the outlet of A transaction records correspondence vehicle B transaction records correspondence vehicle described in exchange hour ＞,
And the entrance exchange hour of A transaction records correspondence vehicle described in the B transaction records outlet exchange hour ＞.
4. the different car of highway according to claim 3 changes card fee evasion vehicle screening method, it is characterised in that in the core
During to expense, the pass cost for not switching visa card for calculating pairing vehicle is used and the reality after switching is paid dues and uses its difference,
The as fee evasion amount of money, its computing formula is：
The fee evasion amount of money=A transaction records entrance vehicle * A transaction records Entrance Square exports the expense+B on square to B transaction records
Transaction record entrance vehicle * B transaction records Entrance Square is received to the expense-A transaction records that A transaction records export square are actual
Take-B transaction record earned rates.
5. the different car of highway according to Claims 1-4 any of which item changes card fee evasion vehicle screening method, its feature
It is, the step of removal duplicate data is also included after the different board is changed the step of card transaction record is matched, after will matching
Two identical transaction records in one deletion.
6. the different car of highway according to claim 5 changes card fee evasion vehicle screening method, it is characterised in that take in verification
With after, if it is determined that when two cars in match vehicle are to change truck, then generating fee evasion information data table.
7. the different car of highway according to claim 6 changes card fee evasion vehicle screening method, it is characterised in that also including defeated
The step of going out the fee evasion information data table and preserve.
8. a kind of different car of highway changes card fee evasion vehicle screening system, it is characterised in that include：
Read module, for reading out a mouthful Transaction Information table；
Screening module, the record inconsistent with outlet car plate for screening entrance car plate, and for generating entrance car plate with outlet
The inconsistent trading record sheet of car plate；
Matching module, for corresponding to the entrance exchange hour and outlet exchange hour of vehicle according to each car plate, each car plate, will
Transaction record is matched in the entrance car plate trading record sheet inconsistent with outlet car plate, and for generating transaction record
Unpaired message table；
Expense check module, for calculating transaction record unpaired message table in pairing vehicle the pass cost for not switching visa card
With with switch after reality pay dues and use it poor, and according to the difference of the expense of the calculating judge two cars in the pairing vehicle whether as
Change truck.
9. the different car of highway according to claim 8 changes card fee evasion vehicle screening system, it is characterised in that also including deleting
Except module and fee evasion information generating module；
The removing module be used for by pairing after two identical transaction records in one deletion；
The fee evasion information generating module is used to be judged to that the fee evasion information for changing truck generates fee evasion information data table.
10. the different car of highway according to claim 9 changes card fee evasion vehicle screening system, it is characterised in that also include
For exporting the output module and preserving module for preserving the fee evasion information table of the fee evasion information table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611235092.7A CN106651732A (en) | 2016-12-28 | 2016-12-28 | Highway different-vehicle card-change toll-dodging vehicle screening method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611235092.7A CN106651732A (en) | 2016-12-28 | 2016-12-28 | Highway different-vehicle card-change toll-dodging vehicle screening method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106651732A true CN106651732A (en) | 2017-05-10 |
Family
ID=58831839
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611235092.7A Pending CN106651732A (en) | 2016-12-28 | 2016-12-28 | Highway different-vehicle card-change toll-dodging vehicle screening method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106651732A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108305461A (en) * | 2017-12-20 | 2018-07-20 | 大唐软件技术股份有限公司 | A kind of determination method and apparatus for evading expense suspected vehicles |
| CN109118601A (en) * | 2017-06-26 | 2019-01-01 | 辽宁艾特斯智能交通技术有限公司 | A kind of highway auditing system based on virtual cloud Yu big data analysis technology |
| CN112950928A (en) * | 2020-12-30 | 2021-06-11 | 北京中科神探科技有限公司 | Data analysis method for expressway card-reversing fee-evading behavior |
| CN112967410A (en) * | 2021-02-02 | 2021-06-15 | 重庆首讯科技股份有限公司 | Method for identifying toll-evasion vehicles based on longest public subsequence |
| CN113569900A (en) * | 2021-06-04 | 2021-10-29 | 广州天长信息技术有限公司 | Method, storage medium, terminal and system for monitoring one car with multiple cards |
| CN113903175A (en) * | 2021-09-29 | 2022-01-07 | 深圳市捷顺科技实业股份有限公司 | Tail board filtering and vehicle meeting processing method under common channel mode and related device |
| CN114780591A (en) * | 2022-04-15 | 2022-07-22 | 广州天长信息技术有限公司 | Calculation method and system for detecting travel license plate recognition error |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100161385A1 (en) * | 2008-12-19 | 2010-06-24 | Nxn Tech, Llc | Method and System for Content Based Demographics Prediction for Websites |
| CN104732205A (en) * | 2015-03-09 | 2015-06-24 | 江苏省邮电规划设计院有限责任公司 | System for checking expressway toll evasion |
-
2016
- 2016-12-28 CN CN201611235092.7A patent/CN106651732A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100161385A1 (en) * | 2008-12-19 | 2010-06-24 | Nxn Tech, Llc | Method and System for Content Based Demographics Prediction for Websites |
| CN104732205A (en) * | 2015-03-09 | 2015-06-24 | 江苏省邮电规划设计院有限责任公司 | System for checking expressway toll evasion |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109118601A (en) * | 2017-06-26 | 2019-01-01 | 辽宁艾特斯智能交通技术有限公司 | A kind of highway auditing system based on virtual cloud Yu big data analysis technology |
| CN108305461A (en) * | 2017-12-20 | 2018-07-20 | 大唐软件技术股份有限公司 | A kind of determination method and apparatus for evading expense suspected vehicles |
| CN112950928A (en) * | 2020-12-30 | 2021-06-11 | 北京中科神探科技有限公司 | Data analysis method for expressway card-reversing fee-evading behavior |
| CN112967410A (en) * | 2021-02-02 | 2021-06-15 | 重庆首讯科技股份有限公司 | Method for identifying toll-evasion vehicles based on longest public subsequence |
| CN113569900A (en) * | 2021-06-04 | 2021-10-29 | 广州天长信息技术有限公司 | Method, storage medium, terminal and system for monitoring one car with multiple cards |
| CN113569900B (en) * | 2021-06-04 | 2022-06-14 | 广州天长信息技术有限公司 | Method, storage medium, terminal and system for monitoring one car with multiple cards |
| CN113903175A (en) * | 2021-09-29 | 2022-01-07 | 深圳市捷顺科技实业股份有限公司 | Tail board filtering and vehicle meeting processing method under common channel mode and related device |
| CN113903175B (en) * | 2021-09-29 | 2022-12-20 | 深圳市捷顺科技实业股份有限公司 | Tail board filtering and vehicle meeting processing method under common channel mode and related device |
| CN114780591A (en) * | 2022-04-15 | 2022-07-22 | 广州天长信息技术有限公司 | Calculation method and system for detecting travel license plate recognition error |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106651732A (en) | Highway different-vehicle card-change toll-dodging vehicle screening method and system | |
| CN104732205B (en) | A kind of system of highway fee evasion inspection | |
| CN104200669B (en) | Fake-licensed car recognition method and system based on Hadoop | |
| CN105160716B (en) | A kind of system and method for preventing vehicle from evading expense | |
| CN110992499A (en) | High-speed charging method and system based on block chain | |
| CN109064312A (en) | A kind of loan for vehicle risk control method, electronic device and storage medium | |
| CN106846153A (en) | A kind of vehicle insurance compensates method and system | |
| JP2004526234A (en) | Control method for use in toll determination system | |
| CN112925820B (en) | Method, device and system for identifying vehicle evasion toll | |
| CN107393055A (en) | Vehicle room entry/exit management method and management system based on the number-plate number and type of vehicle | |
| CN103761775B (en) | Novel truck no-parking weight-calculating charging system | |
| CN112967410B (en) | Method for identifying evasion toll vehicles based on longest public subsequence | |
| CN107680198B (en) | shared bicycle system and method for determining shared bicycle condition in the same | |
| CN115691148A (en) | Intelligent charging auxiliary method, equipment and medium based on expressway | |
| CN109345649B (en) | Method for realizing highway lane charging auxiliary monitoring | |
| CN108021361A (en) | A kind of the highway fee evasion of falling card vehicle screening method and device | |
| CN111404874A (en) | Taxi suspect vehicle discrimination analysis system architecture | |
| CN112183343A (en) | Highway toll balance analysis system, method and analysis system platform | |
| CN116704631A (en) | Highway cloud charging method, electronic equipment and storage medium | |
| CN116433166A (en) | Expressway toll anomaly auditing system and method | |
| CN104599188A (en) | Multi-target optimization calculation method for mobile school bus safety whole-process monitoring based on wireless PDA | |
| CN103700264B (en) | Based on the express highway section travel speed computing method of ETC charge data | |
| CN114036146A (en) | ETL processing method and device in high-speed audit service data warehouse | |
| Wei et al. | Design and reform of expressway toll collection system | |
| CN105631949A (en) | Intelligent bus fare collection system |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170510 |