中国农业科学 ›› 2015, Vol. 48 ›› Issue (3): 460-468.doi: 10.3864/j.issn.0578-1752.2015.03.06

• 农业信息技术 • 上一篇    下一篇

基于现代信息技术的蔬菜安全预警与追溯平台建设

刁海亭1,2,聂宜民2   

  1. 1山东农业大学信息科学与工程学院,山东泰安271018
     2山东农业大学资源与环境学院,山东泰安271018
  • 收稿日期:2014-03-12 出版日期:2015-01-31 发布日期:2015-01-31
  • 通讯作者: 聂宜民,Tel:0538-8249688;E-mail:ymnie@sdau.edu.cn
  • 作者简介:刁海亭,Tel:0538-8249032;E-mail:htdiao@sdau.edu.cn
  • 基金资助:
    国家“十二五”科技支撑计划项目(2012BAK17B05)

Platform Construction of Vegetable Safety Warning and Traceability Based on Modern Information Technology

DIAO Hai-ting1,2, NIE Yi-min2   

  1. 1College of Information Science and Engineering, Shandong Agricultural University, Taian 271018, Shandong
    2College of Resources and Environment, Shandong Agricultural University, Taian 271018, Shandong
  • Received:2014-03-12 Online:2015-01-31 Published:2015-01-31

摘要: 【目的】借助现代信息技术,实现蔬菜从生产到销售整个环节质量安全的预警与追溯。【方法】以蔬菜为研究对象,以国家蔬菜生产基地——寿光市为示范区,围绕寿光市蔬菜质量安全监管和溯源管理的信息化需求,采用WebGIS、物联网、条码识别、数据库等多种现代信息技术,研究蔬菜物流数据的采集和存储形式,并探索蔬菜质量安全预警与追溯平台的建设。【结果】结合物联网数据采集技术,采用SQLServer2008作为前台建立了一套属性数据库,包括产地蔬菜数据、蔬菜加工环节数据、蔬菜运输环节数据、蔬菜销售环节数据等。利用GIS功能制作了一套蔬菜质量安全相关空间数据,包括山东省道路图、寿光市采样点图、寿光市土壤养分图等。在此基础上,建立了一套切实有效的蔬菜质量安全预警与追溯平台。平台设计结合各种信息技术及寿光市蔬菜安全生产业务的需要,同时充分考虑数据的保密性和用户的需求,将平台划分为四大模块:数据查询、蔬菜质量安全预警、蔬菜质量安全追溯、辅助工具。实现的功能主要包括:蔬菜信息录入编辑,蔬菜产品信息及运送信息查询、地理坐标查询,实时预警,蔬菜质量安全追溯,蔬菜空间立体信息展示,蔬菜物流运输路径优化,蔬菜产地土壤养分统计,蔬菜产地土壤养分插值,网络视频监控等。其中实时预警功能利用物联网实时获取数据的特点,将采集的坐标、温度、湿度、时间等信息传送到平台服务器,该平台对蔬菜的温度、湿度、保质期等进行实时监测、预警,确保蔬菜的质量安全;蔬菜质量安全追溯功能根据蔬菜条形码和记载的物流坐标,在地图上对物流配送路径进行追溯;路径分析功能可以根据蔬菜运输的出发地和目的地进行路径的最优设计;蔬菜空间立体信息展示功能可以实现从土壤到地面再到大气的整个垂直面的立体化展示,是空间、时间不同节点信息数据的立体化集成。【结论】本研究充分利用GIS技术更形象地展示了蔬菜从开始种植到最后销售所有环节的信息,对蔬菜质量安全管理的提升有很大的帮助,一定程度上对政府相关部门监管蔬菜安全起到了很好的辅助决策功能。

关键词: WebGIS, 物联网, 质量安全, 预警, 追溯

Abstract: 【Objective】 A study was made for the purpose of warning and tracing the quality safety of vegetables from production to sale by modern information technology.【Method】In this study of vegetables from Shouguang City, the national production and demonstration base of vegetables, the authors mainly addressed the gathering of information on vegetable quality, safety supervision and traceability management in that city, by means of the WebGIS, the Internet of things, bar code identification, and database technology. In this research, the vegetable logistics data acquisition and storage were studied, and the platform construction of the system of vegetable safety warning and traceability was explored.【Result】The authors used the networking data acquisition technology, established a set of attribute database using SQLServer2008 database consisting of data of vegetable production, processing, transport and sale. A set of vegetables safe spatial data were produced by means of GIS, which includes the Shandong road map, Shouguang sampling map, and Shouguang soil nutrient map. On that basis, a set of effective vegetable safety warning and traceability platform was established. The platform consists of a variety of information technology, with consideration of the business needs of the vegetable safe production of Shouguang City. The whole platform is divided into four modules: data query, vegetable quality safety warning, vegetable quality safety traceability, and auxiliary tool. The platform is designed for the following: the vegetable information inputting and editing, vegetable information query, warning traceability, vegetable information stereoscopic display, the best path analysis, vegetable soil nutrient statistics, vegetable soil nutrient interpolation, etc. The real-time early warning system can transmit the information of coordination, temperature, humidity and time to the server with network real-time data acquisition. The platform can also monitor and forecast vegetables temperature, humidity, shelf life, to ensure the quality and safety of vegetables. As for the function of vegetable quality safety traceability, the authors trace the path of logistics and distribution on the map according to the vegetable bar codes and logistics coordinate. To fulfill the path analysis function, one can design the path for the optimum according to the transport of vegetables and destination. The function of vegetables spatial information display can be achieved by means of the vertical surface of stereoscopic display from the soil to the ground and the atmosphere, namely, the integration of three-dimensional space and different times. 【Conclusion】This study demonstrates the process from vegetable production to sale using the GIS technology. The system under discussion is of great help to improve vegetable quality and safety management. To some degree, the system has been proved effective for the government departments concerned for the sake of supervision of vegetable safety.

Key words: WebGIS, the internet of things; quality and safety, warning, traceability