车牌识别技术为交通调查的数据挖掘和应用提供了便捷高效的数据来源。本文基于城市各卡口测点获取的车牌信息，结合交通特性分析需求，主要利用Python、SQL进行相关程序设计和数据可视化处理，实现了车辆行驶轨迹的生成、测点间车辆OD分布的获取、测点间车辆行程时间分布曲线图的生成等较为实用的功能。通过连接数据库的方式实现了对数据的及时更新和较大批量处理，为各项车辆出行特性的进一步分析研究提供了数据源，为交通规划和管理提供直观参考，进而帮助设计和管理部门进行交通系统的分析和问题解决措施设计，使交通系统的运行得到改善。
License plate recognition technology provides a convenient and efficient data source for data mining and application of traffic survey. This system is based on the license plate information acquired by the measuring points in the city. According to the demand of traffic characteristic analysis, this system mainly uses Python and SQL to carry out relevant programs’ designing and data visualization processing. It realizes the generation of vehicle path, the acquisition of vehicle OD distribution between measuring points, and the generation of vehicle travel time distribution curve between neighboring points and some other practical functions. By connecting with the database, the primitive data can be updated in time and processed in large quantities, which pro-vides a quality data source for further analysis and research of vehicle travel characteristics, provides intuitive reference for traffic planning and management, and helps the designer and management departments to carry out analysis of traffic system and design of problem-solving measures more effectively, then can improve the operation of the transportation system.
