作　　者： (马金麟）; (张宗博）; (谢君平）; (张其强）;

机构地区： 江苏大学汽车与交通工程学院,江苏镇江212013

出　　处： 《重庆理工大学学报（自然科学）》 2017年第7期48-55,共8页

摘　　要： 利用高清智能卡口系统采集的车牌数据和调查得到的交通信息建立原始资料数据库,提出车辆OD矩阵的获取步骤,并利用VBA编程实现对Excel车牌数据文件的数据挖掘。提出了卡口间的车辆行程时间的获取方法,运用VBA编程获取全区所有的卡口间的行程时间,实现基于行程时间的卡口聚类划分,从而完成对调查范围的交通小区划分。以某主城区为例,通过设定适当的卡口间行程时间的划分标准,实现对主城分区的交通小区划分,并根据交通小区的车辆OD矩阵获取流程图得到车辆OD矩阵。 The original database based on theobtained license plate number and investigation on the traffic information was established. And then, data processing steps for the license plate were put forward with the use of VBA Excel programming license plate data files for data mining. The method of acquiring the travel time between bayonets is proposed by using the VBA programming to obtain all of the travel time between bayonets. The division of the traffic area through clustering analysis the length of the vehicle＇ s travel time between bayonets was achieved. Taking the main district of Wujin as an example, the main city zone is divided into pieces of traffic areas by setting the appropriate standard of travel time between bayonets. Obtaining OD matrix of vehicle is demonstrated by flowchart of achieving OD matrix of traffic zone.

关 键 词： 城市交通 矩阵获取 车牌 行程时间 小区划分