CN109872525A - A method of it calculates to borrow based on shared bicycle stand and also measures and be distributed - Google Patents
A method of it calculates to borrow based on shared bicycle stand and also measures and be distributed Download PDFInfo
- Publication number
- CN109872525A CN109872525A CN201910188556.0A CN201910188556A CN109872525A CN 109872525 A CN109872525 A CN 109872525A CN 201910188556 A CN201910188556 A CN 201910188556A CN 109872525 A CN109872525 A CN 109872525A
- Authority
- CN
- China
- Prior art keywords
- data
- bicycle
- shared bicycle
- vehicle
- longitude
- 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
Landscapes
- Position Fixing By Use Of Radio Waves (AREA)
- Navigation (AREA)
- Traffic Control Systems (AREA)
Abstract
It is disclosed by the invention to belong to shared bicycle technical field, it is specially a kind of that the method for borrowing and also measuring and being distributed is calculated based on shared bicycle stand, the following steps are included: step 1: basic data prepares: shared bicycle stand GPS data is counted by the moment into tables of data, it needs to number comprising bicycle in table, longitude, latitude data, step 2: the bicycle number data in two tables of t and t+1 adjacent moment bicycle number data comparison: are compared automatically using Excel, reject identical number data, residue numbers different data, corresponding bicycle is numbered in ti time data table, the invention can extrapolate bicycle and borrow quantity also and its corresponding spatial positional information, realize shared bicycle borrow go back the effect that quantity space Characteristics of Distribution settles at one go.Meanwhile this method is lower to initial data requirement, is conducive to the development of correlative study work and the resultant effect of individual subscriber secret protection.
Description
Technical field
The present invention relates to shared bicycle technical field, it is specially a kind of calculated based on shared bicycle stand borrow also amount and
The method of distribution.
Background technique
Resident trip demand and its signature analysis are the premise and basis of traffic system planning, space division when trip requirements
Cloth is even more the important evidence of all kinds of traffic infrastructure addressings, scale calculation and traffic organization and management solution formulation etc..From
The one kind of driving trip as slow-moving traffic mode, goes on a journey in short distance and solves the problems, such as on urban public transport last one kilometer
Important function has been played, however has been increased rapidly with demand opposite, has been to be exposed in facilities planning and organization and administration level
All kinds of problems especially possess the shared bicycle of high user group, and how shared bicycle parking space of how making rational planning for has
Effect supervision etc. is all a problem to be solved, and shared bicycle borrows also amount and its distributed data spatially, then can be solution
Certainly problems provide decision support.
Shared bicycle is difficult to click through with being based on because borrowing also place randomness larger without fixed parking stake, by means of the statistics also measured
Row, it is usually for statistical analysis dependent on users personal data or vehicle GPS record data.
Currently used method is to be united by the collected individual of vehicle-mounted GPS equipment and App user terminal with car data
Meter analysis, such method can count personal and borrow number of returning the car, borrow the also data such as place and time, riding track, to shape
At borrow also amount spatial-temporal distribution characteristic analyze data, it is also necessary to all data by individual consumer collect based on and when
Between, the clustering processing of Spatial Dimension, meanwhile, such user data publicity is not high, protects in data access approaches and privacy of user
Shield aspect is problematic in that therefore needs to research and develop a kind of method for being calculated based on shared bicycle stand and borrowing and also measuring and be distributed.
Summary of the invention
The purpose of the present invention is to provide a kind of calculated based on shared bicycle stand to borrow also amount and the method being distributed, with
Solving mentioned above in the background art calculate based on shared bicycle stand borrows the method also measured and be distributed that cannot quickly estimate
Count the problem of bicycle borrows the also characteristics such as amount and its spatial distribution.
To achieve the above object, the invention provides the following technical scheme: a kind of borrowed based on shared bicycle stand reckoning
The method also measured and be distributed, comprising the following steps:
Step 1: basic data prepares: shared bicycle stand GPS data is counted by the moment into tables of data, is needed in table
Include bicycle number, longitude, latitude data.
Step 2: bicycle number data comparison: the bicycle in two tables of t and t+1 adjacent moment is compared automatically using Excel
Number data, reject identical number data, and residue numbers different data, corresponding bicycle, t are numbered in ti time data table
Moment is present in Statistical Area, and the t+1 moment not in Statistical Area, as lends vehicle, is included in lending vehicle data table.Similarly, t
It is to return vehicle that corresponding bicycle is numbered in+1 time data table, is included in and returns vehicle data table.
Step 3: with number bicycle longitude and latitude data comparison: comparing two tables of t and t+1 adjacent moment automatically using Excel
In bicycle number data, extract and number identical data, carry out longitude and latitude comparison to identical data are numbered, then it is right to number institute
The bicycle answered is to be used vehicle within (t, the t+1) period, and include lending and return two kinds of Activity Types, and data are included in respectively
It lends vehicle and returns vehicle data table.
Step 4: it is shown by means of data space distribution results are gone back: borrowing for different moments is gone back into the corresponding longitude and latitude data of vehicle
It reverts on map, shared bicycle can be obtained, also amount spatial and temporal distributions result visualization is borrowed to show.
Preferably, it rejects that longitude and latitude is identical in the step 3 or changing value is lower than twice of GPS measurement error of data.
Preferably, the GPS positioning worst error is in terms of 20 meters.
Preferably, borrowing for different moments is gone back into the corresponding longitude and latitude of vehicle using ArcGIS visual software in the step 4
Degree evidence reverts on map.
Preferably, the data in the step 2 and step 3 most start with python crawl data, the data that will be obtained
In notepad, then it is introduced directly into Excel.
Compared with prior art, the beneficial effects of the present invention are: the invention provides one kind to park position based on shared bicycle
The method for calculating and borrowing and also measuring and be distributed is set, bicycle can be extrapolated simultaneously and borrow quantity also and its corresponding spatial positional information,
Realize shared bicycle borrow go back the effect that quantity space Characteristics of Distribution settles at one go.Meanwhile this method is to initial data requirement
It is lower, need not rely on userspersonal information, do not need dynamic GPS track data, be conducive to correlative study work development and
Individual subscriber secret protection.
Detailed description of the invention
Fig. 1 is structure of the invention flow chart；
Fig. 2 tables of data (part) screenshot；
Fig. 3 bicycle number comparison (part)；
Vehicle tables of data is gone back in borrowing for obtaining after Fig. 4 comparison for the first time.
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.
The present invention provides a kind of technical solution: a kind of to calculate the side for borrowing and also measuring and being distributed based on shared bicycle stand
Method realizes that shared bicycle borrows the effect going back quantity space Characteristics of Distribution and settling at one go for improving, referring to Fig. 1, right first
The shared bicycle GPS data in parked state for obtaining different moments carries out data cleansing, rejects invalid data.It is basic herein
It is upper to be compared and analyzed by the data record of different moments, calculate that shared bicycle borrows also amount and its spatial distribution.Specific implementation
Scheme is as follows:
Step 1: basic data prepares
Bicycle stand longitude and latitude tables of data is shared with E (ti) (i=1,2,3,4 ... ..., N) name ti moment, N is
Tables of data sum.One complete E (ti) table need to include bicycle number BNo (ti) j, place longitude BLo (ti) j, latitude BLg
(ti) j (j=1,2,3,4 ... ..., mti), mti are the number of data in tables of data E (ti).Certain city analyzed area two is adjacent
The tables of data at moment arranges such as figure two.
Step 2: bicycle number data comparison
Using the bicycle number data BNo in the automatic contrast table E (t1) of Excel and E (t2), identical number data are extracted
(light-colored part in Fig. 3), then bicycle corresponding to the remaining number (dark parts in Fig. 3 .1) of table E (t1), t1 moment are present in
In Statistical Area, the t2 moment not in Statistical Area, as lends vehicle, is included in lending car statistics table B (t1, t2) (being detailed in Fig. 4).
Similarly, bicycle corresponding to remaining number (dark parts in Fig. 3 .2) is to return vehicle in table E (t2), is included in and returns vehicle
Statistical form R (t1, t2) (being detailed in Fig. 4).
Step 3: with number bicycle longitude and latitude data comparison
Using the bicycle number data BNo in the automatic contrast table E (t1) of Excel and E (t2), identical number data are extracted
(light-colored part in Fig. 2) carries out longitude and latitude data comparison to it, and rejecting longitude and latitude is identical or changing value is lower than GPS measurement error
Twice of data.
By taking the bicycle of number 8620120441# is in the longitude and latitude data comparison in table E (t1) and E (t2) as an example, calculating should
Bicycle is 0.033 in the longitude changing value of (t1, t2) in the period, and latitude changing value is 0.194, is converted into as unit of rice
Space length result be 7409 meters.For GPS positioning worst error in terms of 20 meters, which is greater than twice of error
Value similarly calculates the space length variation of the identical bicycle of other numbers, is as a result all larger than twice of error.
It follows that the corresponding bicycle of these numbers is to be used vehicle within (t1, the t2) period, it and include lending
With return two kinds of Activity Types, the data in table E (t1) are included in lending car statistics table B (t1, t2), the data in table E (t2)
It is included in and returns car statistics table R (t1, t2).
Step 4: it is shown by means of data space distribution results are gone back
By B (t1, t2), the longitude and latitude data in R (t1, t2) table are reverted on map using ArcGIS visual software,
Shared bicycle, which can be obtained, borrows also amount spatial and temporal distributions result visualization to show.
Data in Excel most start with python crawl data and then directly lead by the data obtained in notepad
Enter in Excel.
Although hereinbefore invention has been described by reference to embodiment, the scope of the present invention is not being departed from
In the case where, various improvement can be carried out to it and can replace component therein with equivalent.Especially, as long as being not present
Structural conflict, the various features in presently disclosed embodiment can be combined with each other use by any way,
The description for not carrying out exhaustive to the case where these combinations in this specification is examined merely for the sake of omission length with what is economized on resources
Consider.Therefore, the invention is not limited to specific embodiments disclosed herein, but the institute including falling within the scope of the appended claims
There is technical solution.
Claims (5)
1. a kind of calculate the method for borrowing and also measuring and being distributed based on shared bicycle stand, which comprises the following steps:
Step 1: basic data prepares: shared bicycle stand GPS data is counted by the moment into tables of data, needed in table include
Bicycle number, longitude, latitude data.
Step 2: bicycle number data comparison: the bicycle number in two tables of t and t+1 adjacent moment is compared automatically using Excel
Data, reject identical number data, and residue numbers different data, corresponding bicycle, t moment are numbered in ti time data table
It is present in Statistical Area, the t+1 moment not in Statistical Area, as lends vehicle, is included in lending vehicle data table.Similarly, when t+1
Carving and numbering corresponding bicycle in tables of data is to return vehicle, is included in and returns vehicle data table.
Step 3: with number bicycle longitude and latitude data comparison: being compared automatically using Excel in two tables of t and t+1 adjacent moment
Identical data are numbered in bicycle number data, extraction, carry out longitude and latitude comparison to identical data are numbered, then corresponding to number
Bicycle is to be used vehicle within (t, the t+1) period, and include lending and return two kinds of Activity Types, and data are included in lending respectively
Vehicle and return vehicle data table.
Step 4: it is shown by means of data space distribution results are gone back: borrowing for different moments is gone back into the corresponding longitude and latitude data convert of vehicle
Onto map, shared bicycle can be obtained, also amount spatial and temporal distributions result visualization is borrowed to show.
2. a kind of calculated based on shared bicycle stand according to claim 1 borrows also amount and the method being distributed, spy
Sign is: rejecting that longitude and latitude is identical in the step 3 or changing value is lower than twice of GPS measurement error of data.
3. a kind of calculated based on shared bicycle stand according to claim 2 borrows also amount and the method being distributed, spy
Sign is: the GPS positioning worst error is in terms of 20 meters.
4. a kind of calculated based on shared bicycle stand according to claim 1 borrows also amount and the method being distributed, spy
Sign is: borrowing for different moments being gone back the corresponding longitude and latitude data of vehicle also using ArcGIS visual software in the step 4
In original to map.
5. a kind of calculated based on shared bicycle stand according to claim 1 borrows also amount and the method being distributed, spy
Sign is: the data in the step 2 and step 3 most start with python crawl data, by the data obtained in notepad
In, then it is introduced directly into Excel.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910188556.0A CN109872525B (en) | 2019-03-13 | 2019-03-13 | Method for calculating borrowing and returning amount and distribution based on shared bicycle parking position |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910188556.0A CN109872525B (en) | 2019-03-13 | 2019-03-13 | Method for calculating borrowing and returning amount and distribution based on shared bicycle parking position |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109872525A true CN109872525A (en) | 2019-06-11 |
| CN109872525B CN109872525B (en) | 2020-11-06 |
Family
ID=66920411
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910188556.0A Active CN109872525B (en) | 2019-03-13 | 2019-03-13 | Method for calculating borrowing and returning amount and distribution based on shared bicycle parking position |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109872525B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111368312A (en) * | 2020-02-17 | 2020-07-03 | 山东师范大学 | Facility site selection method and system for hiding position information |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150161718A1 (en) * | 2013-12-06 | 2015-06-11 | International Business Machines Corporation | Device and method for implementing a vehicle sharing reward program |
| CN106296350A (en) * | 2016-08-04 | 2017-01-04 | 杭州电子科技大学 | A kind of visual analyzing city public bicycle system borrows the method for also pattern |
| CN107547636A (en) * | 2017-08-08 | 2018-01-05 | 千寻位置网络有限公司 | A kind of shared bicycle management method based on elaborate position |
-
2019
- 2019-03-13 CN CN201910188556.0A patent/CN109872525B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150161718A1 (en) * | 2013-12-06 | 2015-06-11 | International Business Machines Corporation | Device and method for implementing a vehicle sharing reward program |
| CN106296350A (en) * | 2016-08-04 | 2017-01-04 | 杭州电子科技大学 | A kind of visual analyzing city public bicycle system borrows the method for also pattern |
| CN107547636A (en) * | 2017-08-08 | 2018-01-05 | 千寻位置网络有限公司 | A kind of shared bicycle management method based on elaborate position |
Non-Patent Citations (1)
| Title |
|---|
| 白江龙: "基于 Spark 平台的共享单车骑行分析", 《中国优秀硕士学位论文全文数据库工程科技Ⅱ辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111368312A (en) * | 2020-02-17 | 2020-07-03 | 山东师范大学 | Facility site selection method and system for hiding position information |
| CN111368312B (en) * | 2020-02-17 | 2022-08-09 | 山东师范大学 | Facility site selection method and system for hiding position information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109872525B (en) | 2020-11-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wibowo et al. | Modeling walking accessibility to public transport terminals: case study of Singapore mass rapid transit | |
| Zhao et al. | The effects of metro fare increase on transport equity: New evidence from Beijing | |
| CN108717676B (en) | Multi-data fusion-based job and live space evaluation method and system under different scales | |
| Chakirov et al. | Activity identification and primary location modelling based on smart card payment data for public transport | |
| Wang et al. | Nonlinear effects of factors on dockless bike-sharing usage considering grid-based spatiotemporal heterogeneity | |
| CN106529754A (en) | Taxi operation condition assessment method based on big data analysis | |
| CN108053240B (en) | Method and device for generating vehicle-mounted advertisement delivery bus route scheme | |
| CN109931856A (en) | Acquisition method/system of road evenness, evaluation system, medium and server-side | |
| CN109190507A (en) | A kind of passenger flow crowding calculation method and device based on rail transit train | |
| Sun et al. | Gated university campus and its implications for socio-spatial inequality: Evidence from students' accessibility to local public transport | |
| Montini et al. | Searching for parking in GPS data | |
| Deng et al. | The impact of new metro on travel behavior: Panel analysis using mobile phone data | |
| Ribeiro et al. | Influence of GPS and self-reported data in travel demand models | |
| CN110097264A (en) | A kind of measure of group of cities space and economic relation intensity | |
| Hato | Development of behavioral context addressable loggers in the shell for travel-activity analysis | |
| Saghapour et al. | Measuring walking accessibility in metropolitan areas | |
| Wang et al. | Where are equity and service effectiveness? A tale from public transport in Shanghai | |
| Morton et al. | A spatial analysis of demand patterns on a bicycle sharing scheme: Evidence from London | |
| CN109872525A (en) | A method of it calculates to borrow based on shared bicycle stand and also measures and be distributed | |
| Patlins et al. | The new approach for passenger counting in public transport system | |
| CN106297286A (en) | A kind of mountainous area highway actual road test signal detection system | |
| Kuo et al. | The impact of large-scale events: A difference-in-difference model for a Pokémon go safari zone event in Tainan and its effect on bikeshare systems | |
| Wang et al. | Exploring regional sustainable commuting patterns based on dockless bike-sharing data and POI data | |
| Ji et al. | Non-linear effects of street patterns and land use on the bike-share usage | |
| CN108022426B (en) | Method for identifying public bicycle connection rail traffic passenger flow in peak time period |
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 |