CN109101549A - A kind of extracting method of the taxi GPS track data beyond business scope - Google Patents
A kind of extracting method of the taxi GPS track data beyond business scope Download PDFInfo
- Publication number
- CN109101549A CN109101549A CN201810746928.2A CN201810746928A CN109101549A CN 109101549 A CN109101549 A CN 109101549A CN 201810746928 A CN201810746928 A CN 201810746928A CN 109101549 A CN109101549 A CN 109101549A
- Authority
- CN
- China
- Prior art keywords
- taxi
- data
- gps track
- management data
- business scope
- 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.)
- Granted
Links
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
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0645—Rental transactions; Leasing transactions
Abstract
The extracting method for the taxi GPS track data beyond business scope that the invention discloses a kind of, it taxi is managed into table is divided into multiple taxis and manage partition table, taxi GPS track table is divided into multiple taxi GPS track partition tables, retrieval taxi manages the taxi management data in partition table, it is compared by the fence data in taxi management data and selected urban district, it will exceed the taxi management data of the longitude and latitude range of fence data, as abnormal taxi management data, taxi GPS track partition table taxi GPS track data identical with license plate number in abnormal taxi management data are extracted, as the taxi GPS track data beyond selected urban district business scope.By implementing method of the invention, quickly and effectively can handle and store the taxi car data of magnanimity, and calculate matching automatically and obtain the taxi GPS track data beyond business scope, be not necessarily to be judged according to artificial experience taxi whether over range operation.
Description
Technical field
The present invention relates to information technology field more particularly to a kind of taxi GPS track data beyond business scope
Extracting method.
Background technique
With the continuous development of China's communications and transportation, takes trip of taxi and have become a kind of indispensable trip of people
Mode.The situation being skyrocketed through is presented in taxis quantity, occurs the problem of many taxi over range operation at the same time, such as
What judges whether taxi operates in defined region, reinforces most important to the management of taxi.The present inventor is implementing
It is found in process of the invention, following technical problem exists in the prior art: the prior art is simply extracted using forms data node
Taxi out manages track GPS data, is only used for taxi and manages trace playback, fails effectively whether judge taxi
Handling beyond limits, it is also necessary to taxi business scope is judged according to artificial experience, while data volume monthly million grades with
On, traditional data processing method quickly and effectively can not be handled and be stored to the data of magnanimity.
Summary of the invention
The extracting method that the embodiment of the present invention provides a kind of taxi GPS track data beyond business scope can quickly have
The processing of effect and the taxi car data for storing magnanimity, and the taxi GPS rail that matching obtains Handling beyond limits can be calculated automatically
Mark data, thus judge taxi whether over range operation, without according to artificial experience judge taxi whether over range operation.
A kind of extracting method of the taxi GPS track data beyond business scope, comprising:
It taxi is managed into table by database horizontal partitioning technology is divided into several taxis and manage partition table, will go out
GPS track of hiring a car table is divided into several taxi GPS track partition tables.
It retrieves taxi and manages taxi management data in partition table, and by taxi management data and preselect
The fence data in urban district are compared, and will exceed the taxi management data of the longitude and latitude range of fence data, make
For abnormal taxi management data.
By taxi GPS track partition table taxi GPS track identical with license plate number in abnormal taxi management data
Data are extracted, as the taxi GPS track data beyond selected urban district business scope.
Further, taxi is managed by table, taxi GPS track table progress level by database horizontal partitioning technology
Subregion is divided into multiple taxis and manages partition table and multiple taxi GPS track partition tables, specifically:
Taxi is managed into table and monthly carries out horizontal partitioning, is divided into a monthly table, obtains several taxi operation
Taxi GPS track table is per diem carried out horizontal partitioning by partition table, is divided into a daily table, is obtained several taxis GPS
Track partition table.
Further, it retrieves taxi and manages taxi management data in partition table, specifically:
The computer operation for defining a timed task is executed, by the taxi of preset frequency automatically retrieval current month
The data in partition table are managed, are sorted by data generation time, taxi management data is obtained.
Further, the fence data in taxi management data and preselected urban district are compared, are will exceed
The taxi management data of the longitude and latitude range of fence data, as abnormal taxi management data, specifically:
The fence data in selected urban district are stored to Distributed cache queries A, taxi management data storage to distribution
In formula buffer queue B.
It executes and enables the computer operation that the effective business scope of multiple taxis calculates service, each service is slow from distribution
It deposits and takes out the taxi management data in queue B, then take out fence data from Distributed cache queries A, will hire out
The longitude and latitude for starting valuation, the longitude and latitude for terminating to valuate in vehicle management data are compared with the longitude and latitude of fence, will
Start the longitude and latitude of valuation and terminates taxi operation of the longitude and latitude of valuation all not within the scope of the longitude and latitude of fence
Data are stored in Distributed cache queries C as abnormal taxi management data.
Further, taxi GPS track partition table is identical with license plate number in the abnormal taxi management data
Taxi GPS track data are extracted, as the taxi GPS track data beyond selected urban district business scope, specifically:
The computer operation for enabling multiple taxi GPS track data extraction services is executed, each service is slow from distribution
It deposits and takes out abnormal taxi management data in queue C, by starting dozen table time and end in abnormal taxi management data
The date for beating the table time matches the taxi GPS track of identical license plate number in the taxi GPS track partition table on corresponding date
Data obtain the taxi GPS track data beyond business scope.
Further, performed calculating operation is realized by Hadoop technology.
A kind of extracting method of taxi GPS track data beyond business scope provided in an embodiment of the present invention, has
As follows the utility model has the advantages that by database horizontal partitioning and distributed storage technology to taxi management data and taxi GPS number
According to data subregion and storage is carried out, solve the problems, such as how the data of magnanimity are quickly and effectively handled and be stored, together
Shi Liyong Hadoop technology to taxi management data, selected each urban district fence, taxi manage GPS track data into
Row calculation processing filters out the taxi GPS track data of over range operation.
Detailed description of the invention
Fig. 1 is a kind of extracting method of taxi GPS track data beyond business scope provided in an embodiment of the present invention
Flow diagram.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
It is a kind of extraction of taxi GPS track data beyond business scope provided in an embodiment of the present invention referring to Fig. 1
The flow diagram of method, comprising:
S101: it taxi is managed by table by database horizontal partitioning technology is divided into several taxis and manage subregion
Taxi GPS track table is divided into several taxi GPS track partition tables by table, specifically:
Taxi is managed into table and monthly carries out horizontal partitioning, is divided into a monthly table, obtains several taxi operation
Taxi GPS track table is per diem carried out horizontal partitioning by partition table, is divided into a daily table, is obtained several taxis GPS
Track partition table.
S102: retrieving taxi and manage taxi management data in partition table, and by taxi management data and pre-
The fence data for first selecting urban district are compared, and the taxi that will exceed the longitude and latitude range of fence data manages number
According to, as abnormal taxi management data, specifically: the computer operation for defining a timed task is executed, by preset frequency
The taxi of rate automatically retrieval current month manages the data in partition table, sorts by data generation time, obtains taxi warp
Data are sought, then the fence data in selected urban district are stored to Distributed cache queries A, taxi management data is stored
Into Distributed cache queries B.
It executes and enables the computer operation that the effective business scope of multiple taxis calculates service, each service is slow from distribution
Taking-up taxi management data in queue B is deposited, then takes out fence data from Distributed cache queries A, taxi is passed through
The longitude and latitude for starting valuation, the longitude and latitude for terminating to valuate in battalion's data are compared with the longitude and latitude of fence, will start
The taxi management data of the longitude and latitude of valuation and the longitude and latitude for terminating to valuate all not within the scope of the longitude and latitude of fence,
It is stored in Distributed cache queries C as abnormal taxi management data.
S103: by taxi GPS track partition table taxi GPS identical with license plate number in abnormal taxi management data
Track data extracts, as the taxi GPS track data beyond selected urban district business scope, specifically:
The computer operation for enabling multiple taxi GPS track data extraction services is executed, each service is slow from distribution
It deposits and takes out abnormal taxi management data in queue C, by starting dozen table time and end in abnormal taxi management data
The date for beating the table time matches the taxi GPS track of identical license plate number in the taxi GPS track partition table on corresponding date
Data obtain the taxi GPS track data beyond business scope.
The implementing procedure of method in order to better illustrate the present invention is below specifically described method of the invention:
It is selected taxi object with the taxi operated in Foshan City, takes the longitude and latitude degree of Foshan City's regional scope
According to the fence data as selected urban district, it is stored in Distributed cache queries A.
By database horizontal partitioning technology, by the taxi management data table for taxi of operating in Foshan City by days into
Row subregion is divided into a monthly table, its taxi GPS track table is daily carried out subregion, is divided into a daily table.
By Hadoop technology, following operation is executed in a computer:
A timed task " JOB " is defined to manage in table by every 5 minutes primary frequency automatically retrieval this month taxis
Taxi management data takes out newest taxi management data according to the time-sequencing that data generate, and is stored in distributed slow
It deposits in queue B.
It enables the effective business scope of multiple taxis and calculates service, each characteristic serviced according to queue first in first out is suitable
Sequence takes out taxi management data from Distributed cache queries B, while taking out and being stored in Foshan alternating current in distributed caching team A
Sub- fence data compare longitude and latitude and Foshan City's electronics that the taxi in taxi management data starts to valuate and terminate valuation
The longitude and latitude of regional scope in fence data does not all have if taxi starts the longitude and latitude of valuation and terminates the longitude and latitude of valuation
Have within the scope of the longitude and latitude for falling in Foshan City, then judge the vehicle over range operation, the management data of the taxi is taken out, makees
For abnormal taxi management data, it is stored in Distributed cache queries C.
Multiple taxi GPS track data extraction services are enabled, abnormal taxi is taken out in each service from buffer queue C
Management data is then searched in the taxi GPS track partition table on corresponding date and the vehicle in abnormal taxi management data
The identical taxi GPS track data of the trade mark, and take out and save as in vaild evidence relation table.
The taxi GPS track data beyond business scope of the above calculated result extracted are stored in relationship type number
It is calculated and the matched process of data according in library, completion is entire.
Taxi can be passed through using database horizontal partitioning and distributed storage technology by implementing the embodiment of the present invention
It seeks data and GPS data from taxi carries out data subregion and storage, solve and how the data of magnanimity are carried out quickly and effectively
The problem of processing and storage, while using Hadoop technology to taxi management data, selected each urban district fence, taxi
Vehicle manages GPS track data and carries out calculation processing, calculates the taxi GPS track data that matching obtains over range operation, is not necessarily to
According to artificial experience, to taxi, whether over range operation judges again.
It should be noted that the above is a preferred embodiment of the present invention, it is noted that for the general of the art
For logical technical staff, various improvements and modifications may be made without departing from the principle of the present invention, these improve and
Retouching is also considered as protection scope of the present invention.
Claims (6)
1. a kind of extracting method of the taxi GPS track data beyond business scope characterized by comprising
It taxi is managed into table by database horizontal partitioning technology is divided into several taxis and manage partition table, by taxi
GPS track table is divided into several taxi GPS track partition tables；
It retrieves the taxi and manages taxi management data in partition table, and by the taxi management data and in advance
The fence data in selected urban district are compared, and will exceed the taxi operation of the longitude and latitude range of the fence data
Data, as abnormal taxi management data；
By taxi GPS track partition table taxi GPS identical with license plate number in the abnormal taxi management data
Track data extracts, as the taxi GPS track data beyond selected urban district business scope.
2. a kind of extracting method of the taxi GPS track data beyond business scope as described in claim 1, feature exist
In, it is described taxi managed by table by database horizontal partitioning technology be divided into several and hire a car manage partition table, will hire out
Vehicle GPS track table is divided into several taxi GPS track partition tables, specifically:
Taxi is managed into table and monthly carries out horizontal partitioning, is divided into a monthly table, several taxis is obtained and manages subregion
Taxi GPS track table is per diem carried out horizontal partitioning by table, is divided into a daily table, is obtained several taxi GPS tracks
Partition table.
3. a kind of extracting method of the taxi GPS track data beyond business scope as claimed in claim 2, feature exist
In, it is described to retrieve the taxi and manage taxi management data in partition table, specifically:
The computer operation for defining a timed task is executed, by the taxi operation of preset frequency automatically retrieval current month
Data in partition table sort by data generation time, obtain the taxi management data.
4. a kind of extracting method of the taxi GPS track data beyond business scope as claimed in claim 3, feature exist
In the fence data by the taxi management data and preselected urban district are compared, and will exceed the electricity
The taxi management data of the longitude and latitude range of sub- fence data, as abnormal taxi management data, specifically:
To Distributed cache queries A, the taxi management data storage is arrived for the fence data storage in the selected urban district
In Distributed cache queries B；
It executes and enables the computer operation that the effective business scope of multiple taxis calculates service, it is each to service from described distributed slow
It deposits and takes out the taxi management data in queue B, then take out the fence number from the Distributed cache queries A
According to by longitude and latitude and the fence of the longitude and latitude for starting valuation, end valuation in the taxi management data
Longitude and latitude is compared, and by the longitude and latitude for starting valuation and terminates the longitude and latitude of valuation all not in the longitude and latitude of the fence
The taxi management data in range is spent, is stored in Distributed cache queries C as the abnormal taxi management data.
5. a kind of extracting method of the taxi GPS track data beyond business scope as claimed in claim 4, feature exist
In by taxi GPS track partition table taxi GPS rail identical with license plate number in the abnormal taxi management data
Mark data extract, as the taxi GPS track data beyond selected urban district business scope, specifically:
The computer operation for enabling multiple taxi GPS track data extraction services is executed, each service is slow from the distribution
It deposits and takes out the abnormal taxi management data in queue C, by the abnormal taxi management data when starting to play table
Between and terminate to beat date of table time, the taxi of identical license plate number is matched in the taxi GPS track partition table on correspondence date
Vehicle GPS track data obtain the taxi GPS track data beyond business scope.
6. a kind of extraction side of taxi GPS track data beyond business scope as described in claim 3-5 any one
Method, which is characterized in that the computer operation is realized by Hadoop technology.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810746928.2A CN109101549B (en) | 2018-07-09 | 2018-07-09 | Taxi GPS track data extraction method beyond operation range |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810746928.2A CN109101549B (en) | 2018-07-09 | 2018-07-09 | Taxi GPS track data extraction method beyond operation range |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109101549A true CN109101549A (en) | 2018-12-28 |
| CN109101549B CN109101549B (en) | 2021-12-28 |
Family
ID=64845931
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810746928.2A Active CN109101549B (en) | 2018-07-09 | 2018-07-09 | Taxi GPS track data extraction method beyond operation range |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109101549B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050285723A1 (en) * | 2004-06-29 | 2005-12-29 | Ying-Nan Chen | Global positioning system having instant notification of vehicle status function |
| CN101315731A (en) * | 2008-07-17 | 2008-12-03 | 上海途锐信息技术有限公司 | System for implementing vehicle monitoring scheduling by GPS intelligent vehicle mounted terminal |
| CN101398973A (en) * | 2007-09-30 | 2009-04-01 | 厦门雅迅网络股份有限公司 | Automobile checking method and device by GPS technology |
| CN104700646A (en) * | 2015-03-31 | 2015-06-10 | 南京大学 | Online GPS data based abnormal taxi track real-time detection method |
| CN105045788A (en) * | 2014-05-02 | 2015-11-11 | 国民大学校产学协力团 | Method of processing and analysing vehicle driving big data and system thereof |
-
2018
- 2018-07-09 CN CN201810746928.2A patent/CN109101549B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050285723A1 (en) * | 2004-06-29 | 2005-12-29 | Ying-Nan Chen | Global positioning system having instant notification of vehicle status function |
| CN101398973A (en) * | 2007-09-30 | 2009-04-01 | 厦门雅迅网络股份有限公司 | Automobile checking method and device by GPS technology |
| CN101315731A (en) * | 2008-07-17 | 2008-12-03 | 上海途锐信息技术有限公司 | System for implementing vehicle monitoring scheduling by GPS intelligent vehicle mounted terminal |
| CN105045788A (en) * | 2014-05-02 | 2015-11-11 | 国民大学校产学协力团 | Method of processing and analysing vehicle driving big data and system thereof |
| CN104700646A (en) * | 2015-03-31 | 2015-06-10 | 南京大学 | Online GPS data based abnormal taxi track real-time detection method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109101549B (en) | 2021-12-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107610469B (en) | Day-dimension area traffic index prediction method considering multi-factor influence | |
| CN102999519B (en) | Read-write method and system for database | |
| CN109544316B (en) | Method and system for urging collection of real-time case division according to proportion | |
| CN110728429B (en) | Case distribution method, device, medium and computer equipment | |
| CN106528865A (en) | Quick and accurate cleaning method of traffic big data | |
| CN110543562A (en) | Event map-based automatic urban management event distribution method and system | |
| CN103425663B (en) | Embedded system data base establishment table, deposit record, the method and apparatus for deleting record | |
| CN107679160A (en) | Data processing method and device based on chart database | |
| CN105426375B (en) | A kind of calculation method and device of relational network | |
| CN109033153A (en) | A method of dynamically distributing sole electron Air Way Bill No. | |
| CN102262664A (en) | Quality estimating method and quality estimating device | |
| CN105976188A (en) | Multi-channel client information processing system and processing method | |
| CN108986448A (en) | A kind of traffic facility management method and terminal device | |
| CN112348404A (en) | Village planning implementation evaluation system | |
| CN109669915A (en) | A kind of computer task management method, device and relevant device | |
| CN110570113A (en) | Work order processing method and system | |
| CN103455619B (en) | A kind of scoring treatment method and system based on Lucene slice structure | |
| Ripoll-Zarraga et al. | Exploring the reasons for efficiency in Spanish airports | |
| Vogel et al. | Cost-efficient allocation of bikes to stations in bike sharing systems | |
| CN111737325A (en) | Power data analysis method and device based on big data technology | |
| CN108052278A (en) | The storage controlling method and storage system of electron microscopic data | |
| CN107911829A (en) | A kind of Intelligent call bill analyzes and processes flow | |
| CN107526804A (en) | A kind of railway investment project data statistics system and method | |
| CN107291878A (en) | A kind of data-erasure method and device of distributed storage file system | |
| CN106709584A (en) | Method and system for issuing ticket for air ticket order |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |