Scientia Agricultura Sinica ›› 2015, Vol. 48 ›› Issue (3): 460-468.doi: 10.3864/j.issn.0578-1752.2015.03.06

• AGRICULTURE INFORMATION TECHNOLOGY • Previous Articles     Next Articles

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

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

[1]    陈志雄. 茶叶质量安全追溯体系的建立及应用[D]. 福州: 福建农林大学, 2011.
Chen Z X. The establishment of traceability system for tea quality and safety and its application [D]. Fuzhou: Fujian Agriculture and Forestry University, 2011. (in Chinese)
[2]    赵荣, 乔娟. 中国农产食品追溯体系实施现状与展望. 农业展望, 2010(5): 44-48.
Zhao R, Qiao J. Current situation and prospect of food traceability system of agricultural production in China. Agricultural Outlook, 2010(5): 44-48. (in Chinese)
[3]    吴迪, 鲁成银, 成浩. 食品质量安全追溯系统研究进展及在茶叶行业应用展望. 中国农学通报, 2009, 25(1): 251-255.
Wu D, Lu C, Cheng H. Recent developments of food safety traceability system and its perspective on tea. Chinese Agricultural Science Bulletin, 2009, 25(1): 251-255. (in Chinese)
[4]    王婷. 以毒奶粉事件为例探讨我国食品安全责任强制保险制度的构建. 华北电力大学学报: 社会科学版, 2012(4): 65-68.
Wang T. Discussion on the construction of food safety liability compulsory insurance system in China using the poisonous milk powder incident as an example. Journal of North China Electric Power University: Social Sciences, 2012(4): 65-68. (in Chinese)
[5]    田婧. 从双汇瘦肉精事件看中国的食品安全. 现代商业, 2011(9): 17.
Tian J. On China’s food safety in reference with Shuanghui “Clenbuterol” event. Modern Business, 2011(9): 17. (in Chinese)
[6]    赵荣, 陈绍志, 乔娟. 美国、欧盟、日本食品质量安全追溯监管体系及对中国的启示. 世界农业, 2012(3): 1-4, 25.
Zhao R, Chen S Z, Qiao J. System of supervision in traceability of food quality and safety of American, the EU, Japan and enlightenment to China. World Agriculture, 2012(3): 1-4, 25. (in Chinese)
[7]    Iyengar V. Food safety measurement issues: way forward. Journal of Radioanalytical and Nuclear Chemistry, 2013, 297: 451-455.
[8]    Peets S, Gasparin C P, Blackburn D W K, Godwin R J. RFID tags for identifying and verifying agrochemicals in food traceability systems. Precision Agriculture, 2009, 10: 382-394.
[9]    Kim R B. Meeting Consumer concerns for food safety in South Korea: the importance of food safety and ethics in a globalizing market.Journal of Agricultural and Environmental Ethics, 2009, 22: 141-152.
[10]   Christophe C, Egizio V. Coordination for traceability in the food  chain. a critical appraisal of European regulation. European Journal of Law Economics, 2008, 25: 1-15.
[11]   Rouvière E, Latouche K. Impact of liability rules on modes of coordination for food safety in supply chains. European Journal of Law Economics, 2014, 37: 111-130.
[12]   Langiano E, Ferrara M, Lanni L, Viscardi V, Abbatecola A M, Vito E D. Food safety at home: knowledge and practices of consumers. Journal of Public Health, 2012, 20: 47-57.
[13]   万硕, 张习锋, 夏萍, 冯东. 农产品质量安全可追溯系统的研究与应用. 辽宁农业科学, 2011(5): 68-71.
Wan S, Zhang X F, Xia P, Feng D. Study and application of the traceability system of agricultural products quality and safety. Liaoning Agricultural Sciences, 2011(5): 68-71. (in Chinese)
[14]   章海亮, 孙旭东, 刘燕德, 刘娟娟. 农产品质量安全可追溯系统的研究进展. 湖北农业科学, 2010, 49(12): 3220-3223.
Zhang H L, Sun X D, Liu Y D, Liu J J. Research on the feedback system for quality and safety of agricultural products. Hubei Agricultural Sciences, 2010, 49(12): 3220-3223. (in Chinese)
[15]   赵月皎. 中国食品质量安全追溯制度发展现状. 吉林农业,  2012(2): 200.
Zhao Y J. The current development situation of the food safety traceability system in China. JILIN Agriculture, 2012(2): 200. (in Chinese)
[16]   刘战豫. 产品质量安全风险预警与应急处置研究[D]. 北京:中国矿业大学, 2011: 13.
Liu Z Y. Study on risk warning and emergency disposal of product quality safety [D]. Beijing: China University of Mining Technology, 2011: 13. (in Chinese)
[17]   孟猛. 基于B/S结构的农产品质量安全追溯系统研究. 热带农业工程, 2010, 34(3): 21-24.
Meng M. Traceability system of agricultural products quality and safety based on B/S structure. Tropical Agricultural Engineering, 2010, 34(3): 21-24. (in Chinese)
[18]   钱建平, 吴晓明, 范蓓蕾, 杨信廷, 孙连新, 陈明. 基于条码-RFID关联的蔬菜流通过程追溯精确度提高方法. 中国农业科学, 2013, 46(18): 3857-3863.
Qian J P, Wu X M, Fan B L, Yang X T, Sun L X, Chen M. A solution for improving vegetable circulation traceability precision based on barcode-RFID correspondence. Scientia Agricultura Sinica, 2013, 46(18): 3857-3863. (in Chinese)
[19]   顾小林, 张大为, 张可, 浦徐进, 曹文彬. 基于关联规则挖掘的食品安全信息预警模型. 软科学, 2011, 25(11): 136-141.
Gu X L, Zhang D W, Zhang K, Pu X J, Cao W B. The information pre-warning model of food safety based on association rules mining. Soft Science, 2011, 25(11): 136-141. (in Chinese)
[20]   吴晓明, 杨信廷, 钱建平, 周向明. ArcGIS Server支持下农产品质量安全追溯模型的实现. 农机化研究, 2010(5): 190-192, 196.
Wu X M, YangX T, Qian J P, Zhou X M. Realization of agricultural products quality safety traceability model supported by ArcGIS Server. Journal of Agricultural Mechanization Research, 2010(5): 190-192, 196. (in Chinese)
[21]   杨信廷, 钱建平, 孙传恒, 赵春江, 王俊英, 台社红, 侯彦林. 蔬菜安全生产管理及质量追溯系统设计与实现. 农业工程学报, 2008, 24(3): 162-166.
Yang X T, Qian J P, Sun C H, Zhao C J, Wang J Y, Tai S H, Hou Y L. Design and application of safe production and quality traceability system for vegetable. Transactions of the CSAE, 2008, 24(3): 162-166. (in Chinese)
[22]   郑火国, 刘世洪, 孟泓, 胡海燕, 苏晓路. 粮油产品质量安全可追溯系统构建. 中国农业科学, 2009, 42(9): 3243-3249.
Zheng H G, Liu S H, Meng H, Hu H Y, Su X L. Construction of traceability system for quality safety of cereal and oil products. Scientia Agricultura Sinica, 2009, 42(9): 3243-3249. (in Chinese)
[23]   卢磊, 张峰. 基于物联网的蔬菜可追溯系统的设计与实现. 电子设计工程, 2011, 19(7): 19-22.
Lou L, Zhang F. Design and implementation of vegetable traceability system based on internet of things. Electronic Design Engineering, 2011, 19(7): 19-22. (in Chinese)
[24]   邬伦, 刘瑜, 张晶. 地理信息系统-原理、方法和应用. 北京: 科学出版社, 2001: 312-313.
Wu L, Liu Y, Zhang J. Geographic Information System-Principle, Method and Application. Beijing: Science Press, 2001: 312-313. (in Chinese)
[25]   郭伟鹏, 沈松雨. Silverlight 支持下的WebGIS的研究与实现. 地理空间信息, 2011, 9(4): 34-36, 39.
Guo W P, Shen S Y. Research and implementation of WebGIS based on Silverlight. Geospatial Information, 2011, 9(4): 34-36, 39. (in Chinese)
[26]   王天宝, 王尔琪, 卢浩, 黄跃峰. 基于Silverlight的WebGIS客户端技术与应用试验. 地球信息科学学报, 2010, 12(1): 69-75.
Wang T B, Wang E Q, Lu H, Huang Y F. WebGIS client based upon Silverlight. Journal of Geo-Information Science, 2010, 12(1): 69-75. (in Chinese)
[1] GUO Can,YUE XiaoFeng,BAI YiZhen,ZHANG LiangXiao,ZHANG Qi,LI PeiWu. Research on the Application of a Balanced Sampling-Random Forest Early Warning Model for Aflatoxin Risk in Peanut [J]. Scientia Agricultura Sinica, 2022, 55(17): 3426-3436.
[2] WU QiuLin,JIANG YuYing,LIU Yuan,LIU Jie,MA Jing,HU Gao,YANG MingJin,WU KongMing. Migration Pathway of Spodoptera frugiperda in Northwestern China [J]. Scientia Agricultura Sinica, 2022, 55(10): 1949-1960.
[3] CHEN Zhi-Fang, WANG Jing-Lei, LIU Zu-Gui, SONG Ni. Multi-Index Irrigation Information Management System Based on WebGIS [J]. Scientia Agricultura Sinica, 2013, 46(9): 1781-1789.
[4] . Prescription Map Generation System of Precision Agriculture Based on Knowledge Model and WebGIS [J]. Scientia Agricultura Sinica, 2007, 40(6): 1190-1197 .
[5] ,. Study on WebGIS-Based Farming Environment Quality Assessment System [J]. Scientia Agricultura Sinica, 2005, 38(03): 551-557 .
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!