CN104766469B - Urban traffic flow tide simulating analysis based on big data analysis - Google Patents

Urban traffic flow tide simulating analysis based on big data analysis Download PDF

Info

Publication number
CN104766469B
CN104766469B CN201510135384.2A CN201510135384A CN104766469B CN 104766469 B CN104766469 B CN 104766469B CN 201510135384 A CN201510135384 A CN 201510135384A CN 104766469 B CN104766469 B CN 104766469B
Authority
CN
China
Prior art keywords
data
car
time
traffic flow
analysis
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.)
Expired - Fee Related
Application number
CN201510135384.2A
Other languages
Chinese (zh)
Other versions
CN104766469A (en
Inventor
王昕�
刘海峰
黄溅华
蒋子鹏
花萌
戴涛
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE ITS Beijing Ltd
Original Assignee
ZTE ITS Beijing Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by ZTE ITS Beijing Ltd filed Critical ZTE ITS Beijing Ltd
Priority to CN201510135384.2A priority Critical patent/CN104766469B/en
Publication of CN104766469A publication Critical patent/CN104766469A/en
Application granted granted Critical
Publication of CN104766469B publication Critical patent/CN104766469B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G08SIGNALLING
    • G08GTRAFFIC CONTROL SYSTEMS
    • G08G1/00Traffic control systems for road vehicles
    • G08G1/01Detecting movement of traffic to be counted or controlled
    • G08G1/0104Measuring and analyzing of parameters relative to traffic conditions
    • G08G1/0125Traffic data processing
    • G08G1/0129Traffic data processing for creating historical data or processing based on historical data
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/20Design optimisation, verification or simulation

Landscapes

  • Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Evolutionary Computation (AREA)
  • Geometry (AREA)
  • General Engineering & Computer Science (AREA)
  • Chemical & Material Sciences (AREA)
  • Analytical Chemistry (AREA)
  • Traffic Control Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses it is a kind of based on big data analysis urban traffic flow tide simulating analysis, including, establish Hive sheet formats;Industrial computer is captured and arrived after car data, and the car data of crossing that industrial computer is captured is saved in the first database according to car data initial data tableau format is crossed;The day data of past one that timing preserves to the first database daily is analyzed, and analyze data is saved in into the second database according to data results tableau format, meanwhile, record number of each place as beginning and end;Data are taken out in the data results table preserved from the second database to combine data using the set time as time granularity, the dynamic simulation vehicle start-stop route evolution on GIS according to time shaft;According to the result of step 4 by analyzing generation design sketch or statistical form, so as to draw the conclusion suggestion of urban traffic flow tide.Realize reduction resources costs and ensure the advantages of data are accurate.

Description

Urban traffic flow tide simulating analysis based on big data analysis
Technical field
The present invention relates to intelligent transportation field, in particular it relates to a kind of urban traffic flow tide based on big data analysis Simulating analysis.
Background technology
At present, with the continuous expansion of China's city size and being continuously increased for the size of population, substantial amounts of residential quarters with Between the groundwork region of city, between old town and Xincheng District etc., can all occur in morning, evening peak period obvious " tide " Phenomenon;Morning, a large amount of vehicle crowds are pooled on major trunk roads to enter towards workspace from respective settlement through minor road Hair;Afternoon, these stream of people's wagon flows return to residence according to former route, have thereby resulted in the unbalanced phenomena of period bidirectional traffics.
This " tide " phenomenon in each city includes multiple start-stop regions, each not phase of stream of people's wagon flow scale in each region Together, and with urban construction scale and population increase, the start-stop region that " tide " phenomenon is related to also slowly is changing.With Toward by manual research, mathematical modeling, forecasting traffic flow or traffic simulation software mode to traffic flow " tide " discriminatory analysis, this A little modes all existing defects from resources costs, time efficiency, data accuracy, especially with the expansion of city size, this A little defects can also highlight.
It is existing by manual research, mathematical modeling, forecasting traffic flow or traffic simulation software mode to traffic flow " tide " Discriminatory analysis, these modes all existing defects from resources costs, time efficiency and data accuracy, is advised especially with city The expansion of mould, these defects can also highlight.It is specific as follows:
1) manual research needs to expend ample resources, and as this investigation work of urban development may need again Expansion, and the time cycle is longer.
2) mathematical modeling is typically to be drawn a conclusion under relative ideal state, deviation be present for data result authenticity.
3) forecasting traffic flow is generally analyzed using flow collection data, and analysis result is mainly used in traffic In terms of judgement, such as congestion, slow, unimpeded, but it can not judge for tide initiation region.
4) traffic simulation needs mass data to support, and realizes that " tide " phenomenon emulates by simulation software internal algorithm And analysis.For this mode firstly the need of mass data, big data needs user's advanced processing, and workload is larger.In simulation software Algorithms realize that effect and truth can also have deviation.
The content of the invention
It is an object of the present invention in view of the above-mentioned problems, propose a kind of urban traffic flow tide based on big data analysis Simulating analysis, to realize reduction resources costs and ensure the advantages of data are accurate.
To achieve the above object, the technical solution adopted by the present invention is:
A kind of urban traffic flow tide simulating analysis based on big data analysis, including Step 1: establish Hive tables Form, Hive are Tool for Data Warehouse, are specially:Established car data raw data table;Establish data results table;
Arrived Step 2: industrial computer is captured after car data, by industrial computer capture to cross car data former according to car data is crossed Beginning data tableau format is saved in the first database;
Step 3: the day data of past one that timing preserves to the first database daily is analyzed, according to setting time section Data analysis to crossing car data raw data table, each car start-stop route information in setting time section is recorded, and will analysis Data are saved in the second database according to data results tableau format, meanwhile, each place is recorded as beginning and end Number;
Step 4: data are taken out out of the second database preserves data results table is used as time grain using the set time Degree combines data, and according to time shaft, dynamic simulation vehicle start-stop route evolution, pass course color thickness are anti-on GIS The quantity by the route vehicle is reflected, each place is reflected by vehicle fleet by shade;
Step 5: according to the result of step 4 by analyzing generation design sketch or statistical form, so as to draw urban traffic flow The conclusion suggestion of tide.
Preferably, the car data raw data table excessively, including number plate species+brand number, excessively mistake car time, car place Numbering and picture path.
Preferably, the data results table, including number plate species+brand number, by starting time, by terminal Time, starting point location number, terminal location number, starting point crosses car picture path and terminal crosses car picture path.
Preferably, the step 4 takes out data with the set time out of the second database preserves data results table Set time during data are combined as time granularity is set as 10 minutes.
Preferably, the setting time section in the step 3 is urban transportation morning peak period and urban transportation evening peak Period.
Technical scheme has the advantages that:
Technical scheme, using the existing relevant database of big data technical substitution, realize that data on flows is united Meter analysis.And bayonet system is combined, new application is put forward to the number-plate number for capturing vehicle, found by analyzing the number-plate number Traffic flow tide migrates relation, and most this tide relation of migrating is presented on GIS and realizes traffic simulation effect at last.Reach reduction Resources costs and the guarantee accurate purpose of data.
Below by drawings and examples, technical scheme is described in further detail.
Brief description of the drawings
Fig. 1 is the urban traffic flow tide simulating analysis effect based on big data analysis described in the embodiment of the present invention Schematic diagram;
Fig. 2 is the urban traffic flow tide simulating analysis statistics based on big data analysis described in the embodiment of the present invention Vehicle flowrate tendency chart;
Fig. 3 a and Fig. 3 b are the urban traffic flow tide simulation analysis based on big data analysis described in the embodiment of the present invention The statistical chart of method;
Fig. 4 is based on the urban traffic flow tide simulating analysis that big data is analyzed and inspection described in the embodiment of the present invention Rope flow chart.
Embodiment
The preferred embodiments of the present invention are illustrated below in conjunction with accompanying drawing, it will be appreciated that described herein preferred real Apply example to be merely to illustrate and explain the present invention, be not intended to limit the present invention.
A kind of urban traffic flow tide simulating analysis based on big data analysis, including Step 1: establish Hive tables Form, Hive are Tool for Data Warehouse, are specially:Established car data raw data table;Establish data results table;
Arrived Step 2: industrial computer is captured after car data, by industrial computer capture to cross car data former according to car data is crossed Beginning data tableau format is saved in the first database;
Step 3: the day data of past one that timing preserves to the first database daily is analyzed, according to setting time section Data analysis to crossing car data raw data table, each car start-stop route information in setting time section is recorded, and will analysis Data are saved in the second database according to data results tableau format, meanwhile, each place is recorded as beginning and end Number;
Step 4: data are taken out out of the second database preserves data results table is used as time grain using the set time Degree combines data, and according to time shaft, dynamic simulation vehicle start-stop route evolution, pass course color thickness are anti-on GIS The quantity by the route vehicle is reflected, each place is reflected by vehicle fleet by shade;
Step 5: according to the result of step 4 by analyzing generation design sketch or statistical form, so as to draw urban traffic flow The conclusion suggestion of tide.
Preferably, car data raw data table, including number plate species+brand number, excessively mistake car time, car location number excessively With picture path.
Data results table, including number plate species+brand number, by starting time, by terminal time, starting point Point numbering, terminal location number, starting point cross car picture path and terminal crosses car picture path.
Step 4 takes out data out of the second database preserves data results table and is used as time grain using the set time Set time during degree combines data is set as 10 minutes.
Setting time section in step 3 is urban transportation morning peak period and urban transportation evening peak period.
Specially:
(1)Establish Hive table structures:
1)Car data raw data table T_PASSEDCAR was established, including:Number plate species+brand number, the car time is spent, Cross car location number, picture path.The table preserves early, evening peak data on the day of only preservation.Early peak time section is 5:00-9:00, The evening peak period is 16:00-20:00.Such as:02V8G53(02 represents vehicle below private savings 7, and V8G53 represents local car ), 20150307101011, ad000001, http://pic.snap.device/20150307/ad000001/02V8G53_ 20150307101011.jpg。
2)Data results table T_ANALYSIS_RESULT, field include:Number plate species+brand number, by starting point Time, car picture path is crossed by terminal time, starting point location number, terminal location number, starting point, terminal crosses car picture road Footpath.Such as:02V8G53,20150307101011,20150307102011, ad000001, ad000002, http:// pic.snap.device/20150307/ad000001/02V8G53_20150307101011.jpg, http:// pic.snap.device/20150307/ad000002/02V8G53_20150307102011.jpg。
(2)Industrial computer is captured and arrived after car data, is put in storage and preserved according to T_PASSEDCAR format designs.
(3)Timing is analyzed the day data of past one daily, according to early peak time section 5:00-9:00 and the evening peak period 16:00-20:00 pair of T_PASSEDCAR data analysis, record each car start-stop route information in two periods, including start-stop Picture is captured in time, start-stop place, start-stop.Analyze data is put in storage according to T_ANALYSIS_RESULT format designs and preserved, together When, record number of each place as beginning and end.
(4)Data are taken out from T_ANALYSIS_RESULT to combine data using 10 minutes as time granularity, according to the time Axle dynamic simulation vehicle start-stop route evolution on GIS.The number of the route vehicle is passed through in the reflection of pass course color thickness Amount, each place is reflected by vehicle fleet by shade.
(5)By analyzing generation design sketch, statistical form, conclusion suggestion.As shown in Figure 1, Figure 2, shown in Fig. 3 a and Fig. 3 b.
Suggestion can be drawn the following conclusions according to Fig. 1, Fig. 2, Fig. 3 a and Fig. 3 b:
1st, A → E sections morning peak period vehicle flowrate is larger, it is proposed that sets tide direction traffic single file car in the morning peak period Road, ensure A → E directions the coast is clear.
2nd, A → F sections morning peak period vehicle flowrate is larger, due to stroke farther out, it is proposed that tide is increased to section bus, and Public transport priority signal scheme is set, ensures A → F directions the coast is clear.
3rd, B → F, D → E sections are increased month by month by January to historical data analysis in March, vehicle flowrate, it is proposed that relevant department Prioritization scheme is formulated in anticipation in advance.
As shown in figure 4, after establishing emulation to urban traffic flow tide according to the technical program, can be according to demand to emulation Database carry out retrieval and inquisition.
The technical program combines existing bayonet system, on the basis of cost is reduced, ensure accuracy, is analyzed using big data Realize that traffic flow tidal phenomena emulates.Emulated with respect to other traffic flow tides, this method simulation efficiency is higher, and cost is lower, imitates It is very time-consuming to greatly shorten.
This programme combines generalized information system using the traditional relevant database of big data technical substitution, the policy effect made More directly perceived, more fitting is actual.Generalized information system is GIS-Geographic Information System.
Finally it should be noted that:The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, Although the present invention is described in detail with reference to the foregoing embodiments, for those skilled in the art, it still may be used To be modified to the technical scheme described in foregoing embodiments, or equivalent substitution is carried out to which part technical characteristic. Within the spirit and principles of the invention, any modification, equivalent substitution and improvements made etc., it should be included in the present invention's Within protection domain.

Claims (3)

1. a kind of urban traffic flow tide simulating analysis based on big data analysis, it is characterised in that including including step First, Hive sheet formats are established, Hive is Tool for Data Warehouse, is specially:Established car data raw data table;Establish data point Analyse result table;Wherein, car data raw data table was established, including:Number plate species, brand number, spend the car time, cross car place Coding, picture path;Data results table, field include:Number plate species, brand number, by starting time, by terminal Time, starting point location number, terminal location number, starting point crosses car picture path, terminal crosses car picture path;
Arrived Step 2: industrial computer is captured after car data, the car data excessively that industrial computer is captured is according to car data original number excessively The first database is saved according to tableau format;
Step 3: the day data of past one that timing preserves to the first database daily is analyzed, according to setting time section to mistake The data analysis of car data raw data table, each car start-stop route information in setting time section is recorded, and by analyze data Second database is saved according to data results tableau format, meanwhile, record time of each place as beginning and end Number;
Will using the set time as time granularity Step 4: taking out data out of the second database preserves data results table Data combine, the dynamic simulation vehicle start-stop route evolution on GIS according to time shaft, pass course color thickness reflection warp The quantity of the route vehicle is crossed, each place is reflected by vehicle fleet by shade;
Step 5: according to the result of step 4 by analyzing generation design sketch or statistical form, so as to draw urban traffic flow tide Conclusion suggestion.
2. the urban traffic flow tide simulating analysis according to claim 1 based on big data analysis, its feature exist Data are taken out out of the second database preserves data results table in, the step 4 time granularity is used as using the set time Set time during data are combined is set as 10 minutes.
3. the urban traffic flow tide simulating analysis based on big data analysis according to any one of claim 1 to 2, Characterized in that, the setting time section in the step 3 is urban transportation morning peak period and urban transportation evening peak time Section.
CN201510135384.2A 2015-03-26 2015-03-26 Urban traffic flow tide simulating analysis based on big data analysis Expired - Fee Related CN104766469B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510135384.2A CN104766469B (en) 2015-03-26 2015-03-26 Urban traffic flow tide simulating analysis based on big data analysis

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510135384.2A CN104766469B (en) 2015-03-26 2015-03-26 Urban traffic flow tide simulating analysis based on big data analysis

Publications (2)

Publication Number Publication Date
CN104766469A CN104766469A (en) 2015-07-08
CN104766469B true CN104766469B (en) 2018-01-09

Family

ID=53648266

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510135384.2A Expired - Fee Related CN104766469B (en) 2015-03-26 2015-03-26 Urban traffic flow tide simulating analysis based on big data analysis

Country Status (1)

Country Link
CN (1) CN104766469B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105427602B (en) * 2015-12-16 2018-04-27 浙江宇视科技有限公司 A kind of vehicle driving theme determines method and device
CN105916111A (en) * 2016-04-15 2016-08-31 上海河广信息科技有限公司 Time statistical system and method for route
CN109829023A (en) * 2019-01-18 2019-05-31 苏州维众数据技术有限公司 A kind of four-dimensional spacetime GIS-Geographic Information System and its construction method
CN111653091B (en) * 2020-05-13 2021-06-18 深圳市山行科技有限公司 Tidal traffic jam identification method based on high-grade data and floating car data

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101540099A (en) * 2008-03-17 2009-09-23 上海宝康电子控制工程有限公司 Method and system for judging road traffic states
CN103268336A (en) * 2013-05-13 2013-08-28 刘峰 Fast data and big data combined data processing method and system
CN103473609A (en) * 2013-09-04 2013-12-25 银江股份有限公司 Method for obtaining OD real-time running time between adjacent checkpoints
CN103531024A (en) * 2013-10-28 2014-01-22 武汉旭云科技有限公司 Dynamic traffic network urban road feature model and modeling method thereof
CN103810849A (en) * 2012-11-15 2014-05-21 北京掌城科技有限公司 Traffic flow change trend extraction method based on floating car data
CN103902838A (en) * 2014-04-17 2014-07-02 北京泰乐德信息技术有限公司 TMIS traffic flow determination method and system based on cloud computing

Family Cites Families (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2011003002A (en) * 2009-06-18 2011-01-06 Toyota Central R&D Labs Inc Discharged amount calculation device of discharged material during engine operation time and program
CN102542106B (en) * 2011-12-27 2013-09-11 中国科学院自动化研究所 Distributed traffic simulation system and simulation method based on variable region division
JP5958989B2 (en) * 2012-03-29 2016-08-02 日本電気株式会社 Simulation system, method and program
CN103050005B (en) * 2012-11-16 2015-06-03 北京交通大学 Method and system for space and time analysis of urban road traffic states
CN103177570B (en) * 2012-12-25 2015-03-04 北京交通发展研究中心 Method for predicting traffic jam indexes for rush hours in morning and evening
CN103116608A (en) * 2013-01-18 2013-05-22 同济大学 Method of reproducing traffic flow on express way
CN103279534B (en) * 2013-05-31 2016-06-01 西安建筑科技大学 Travel frequently OD distribution estimation method based on the mass transit card passenger of intelligent public transportation system data
CN103646187B (en) * 2013-12-27 2017-02-08 中国科学院自动化研究所 Method for obtaining vehicle travel path and OD (Origin-Destination) matrix in statistic period

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101540099A (en) * 2008-03-17 2009-09-23 上海宝康电子控制工程有限公司 Method and system for judging road traffic states
CN103810849A (en) * 2012-11-15 2014-05-21 北京掌城科技有限公司 Traffic flow change trend extraction method based on floating car data
CN103268336A (en) * 2013-05-13 2013-08-28 刘峰 Fast data and big data combined data processing method and system
CN103473609A (en) * 2013-09-04 2013-12-25 银江股份有限公司 Method for obtaining OD real-time running time between adjacent checkpoints
CN103531024A (en) * 2013-10-28 2014-01-22 武汉旭云科技有限公司 Dynamic traffic network urban road feature model and modeling method thereof
CN103902838A (en) * 2014-04-17 2014-07-02 北京泰乐德信息技术有限公司 TMIS traffic flow determination method and system based on cloud computing

Also Published As

Publication number Publication date
CN104766469A (en) 2015-07-08

Similar Documents

Publication Publication Date Title
Jehling et al. Assessing urban containment policies within a suburban context—An approach to enable a regional perspective
CN104766469B (en) Urban traffic flow tide simulating analysis based on big data analysis
Lin et al. Impact of weather conditions and built environment on public bikesharing trips in Beijing
CN104899360B (en) A kind of method for drawing macroscopical parent map
CN110222959B (en) Urban employment reachability measuring and calculating method and system based on big data
CN102074124A (en) Dynamic bus arrival time prediction method based on support vector machine (SVM) and H-infinity filtering
WO2022083684A1 (en) Road network operation management method and device, storage medium, and terminal
Li et al. Classifying community space at a historic site through cognitive mapping and GPS tracking: The case of Gulangyu, China
CN104933286A (en) City spatial quality evaluation method based on big data
Hou et al. Identification of low-carbon travel block based on GIS hotspot analysis using spatial distribution learning algorithm
CN107562953A (en) A kind of river information system based on GIS geographical information technologies
CN102682155A (en) Network analysis micro-simulation system for urban road traffic
CN105678034A (en) Pedestrian crossing time model and signalized intersection pedestrian crosswalk width optimizing method
CN105303292A (en) Distribution data storage method and device
CN109002961A (en) Functional structure planing method between a kind of trans-regional cultural landscape based on network data
CN112966925A (en) Village and town rubbish increment risk analysis system based on remote sensing time sequence change analysis
Gupta et al. Quality of life, big data and the power of statistics
Kong et al. The method and application of big data mining for mobile trajectory of taxi based on MapReduce
CN111198918A (en) Data processing system based on big data platform and link optimization method
Czupich The role of ICT in the smart city concept
WO2019104952A1 (en) Scene intelligent analysis system and method based on metropolitan area level internet of things perceptual data
Würstle et al. The conception of an urban energy dashboard using 3D city models
CN116385690B (en) BIM model-based three-dimensional operation and maintenance management and control platform and management and control method thereof
Chen et al. Workflow for generating 3D urban models from open city data for performance-based urban design
Borchi et al. The HUSH project–The geographical data platform for city noise action planning

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
EXSB Decision made by sipo to initiate substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information

Address after: 214135 Jiangsu province Wuxi District Road No. 200 Chinese Linghu Sensor Network International Innovation Zone A building 6 floor

Applicant after: ZTE ITS CO.,LTD.

Address before: 214000 Jiangsu New District of Wuxi, Taihu international science and Technology Parks Linghu Road No. 200 China Sensor Network International Innovation Park building A

Applicant before: ZTE ITS LTD.

COR Change of bibliographic data
GR01 Patent grant
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20180109

CF01 Termination of patent right due to non-payment of annual fee