Design And Application Of Traffic Flow Parameter Entry And Analysis System Based On Oracle

With the rapid development of road traffic in China,there is increasing recognition of traffic surveys which is as the basis for traffic planning and traffic management policy analysis.The traditional traffic survey data processing relies on manual work,which is of heavy workload,poor reliability and low efficiency.It is of practical significance and practical value to develop an input analysis system for traffic flow parameters and change the management method of traffic survey data by taking advantage of the openness of Oracle database platform.Through the literature review of a large number of previous traffic survey data,combined with personally participating in various traffic survey work,to summarize the deficiencies of traditional traffic survey data management,it is proposed that the traffic flow parameter entry system based on the Oracle database platform should have the following functions:(1)The input subsystem can either manually enter data or directly import data,which is suitable for investigation tasks under various conditions;(2)The analysis subsystem also has the functions of analyzing traffic volume,speed data,and OD survey information.Through the Oracle platform,various types of mathematical analysis,modeling and mapping software(Matlab,Echarts,ArcGIS,Matplotlib,geometric sketchpad)can be invoked to output traffic volume period statistics tables,peak hour traffic volume related data,and 24 h traffic volume time-varying according to survey needs Histogram,intersection flow direction diagram,continuous traffic volume survey data summary table,road design capacity related data,continuous traffic volume graph;for speed survey,vehicle speed frequency distribution table,frequency distribution histogram,cumulative frequency curve can be generated The figure also shows the characteristic values of various types of vehicle speed,and then the vehicle speed data is tested for the goodness of fit of the normal distribution to determine the type of speed distribution at the location of the cross section.When the traffic volume and vehicle speed data are entered at the same time,the speed-density relationship diagram and flow-density relationship diagram required for the traffic density survey can also be obtained.In addition,various OD survey information pie charts can be generated by inputting the output OD information statistical table of the subsystem;by importing the survey area map file and the triangular OD table output by the input subsystem,the expected line graph is generated.During the development process,some of the data from previous surveys were used for system function testing,and shortcomings were found and improvements were made.Finally,Wuhan Jiefang Park was selected as the empirical object to conduct an OD questionnaire survey on the tourists in the park,and the traffic volume statistics of the intersection of Huiji Road and Jiefang Park Road around the park was conducted for 24 hours.The survey data is managed through this system,and the results obtained are consistent with the purpose of the experiment to verify the reliability and usefulness of the system.