Design and Implementation of Customizable Crop Breeding Data Acquisition System Based on Android

doi:10.15933/j.cnki.1004-3268.2021.07.021

Abstract

Abstract: In order to achieve paperless collection of crop breeding data，reduce the secondary data entry process，and improve the efficiency of data collection，a customizable crop breeding data acquisition system based on Android was proposed and developed by using Android Studio development tool and JAVA programming language.The APP architecture adopted a single machine version，and the traits of different crops were stored in the attribute database of the system.The acquisition of traits referred to the investigation standard of agronomic traits of related crops.The APP functions included testmanagement,template customization，data acquisition，data query and data export.Before entering the system，users selected crop types firstly，and created test projects by importing Excel template files.In the template customization module，the APP provided corresponding traits according to the selected categories，andusers selected the traits that needed to be collected at present to be saved as customized templates.Data collection was executed based on the combination of test projects and custom templates.Data storage,query，and export were indexed by the names of test items and custom templates. The APP was preliminarily applied in the investigation of millet core germplasm resources in Anyang Academy of Agricultural Sciences，which improved the data collection efficiency of millet test by 65.18%.The system has the advantages of simple operation,convenient carrying，low popularization cost and shows a broad application prospect.

Key words: Android, Crop, Breeding data, Customization, Data acquisition system

摘要： 为了实现作物育种数据的无纸化采集，减少数据二次录入过程，提高数据采集效率，采用Android Studio开发工具和JAVA编程语言，提出并开发了基于Android的可定制作物育种数据采集系统。该 APP架构采用单机版，不同作物的性状指标保存在系统的属性数据库中，性状指标获取参考相关作物的农艺性状调查标准。APP功能主要包括试验管理、模板定制、数据采集和数据查询导出。用户在进入系统前首先选择作物种类，通过导入Excel模板文件在APP中创建试验项目。在模板定制模块中，APP根据所选作物类别提供相应的性状指标，勾选当前需要采集的性状保存为定制模板。数据采集在试验项目和定制模板组合基础上进行。数据保存、查询和导出以试验项目和定制模板名称为索引。APP已在安阳市农业科学院谷子核心种质资源调查中进行初步应用，可使谷子试验数据采集耗时较人工采集降低65.18%。该系统操作简单，携带方便，推广成本低，应用前景广阔。

关键词: Android, 作物, 育种数据, 定制, 数据采集系统

CLC Number:

S330
S126

LI Guoqiang, ZHAO Qiaoli, ZANG Hecang, ZHAO Qing, ZHANG Jie, SONG Hui, WANG Meng. Design and Implementation of Customizable Crop Breeding Data Acquisition System Based on Android[J]. Journal of Henan Agricultural Sciences, 2021, 50(7): 174-180.

李国强, 赵巧丽, 臧贺藏, 赵晴, 张杰, 宋慧, 王猛. 基于Android 的可定制作物育种数据采集系统设计与实现[J]. 河南农业科学, 2021, 50(7): 174-180.

Figures/Tables 5

References

［1］谭会君，潘霞. 基于嵌入式电子信息的农田信息采集系统开发［J］. 农机化研究，2019，41（4）：238⁃241.

TAN H J，PAN X. Development of farmland information collection system based on embedded electronic information ［J］. Journal of Agricultural Mechanization Research，2019，41（4）：238⁃241.

［2］张士敏. 物联网在水稻区域试验信息采集中的应用研究［J］. 农机化研究，2019，41（1）：220⁃223.
ZHANG S M. Application of Internet of things in rice regional test information collection ［J］. Journal of Agricultural Mechanization Research，2019，41（1）：220⁃223.
［3］吴沧海，熊焕亮，何火娇. 基于Android智能手机油菜病害识别系统设计［J］. 中国农机化学报，2013，3（4):257⁃260.
WU C H，XIONG H L，HE H J. Rape diseases recognition system design based on Android platform［J］. Journal of
Chinese Agricultural Mechanization，2013，34（4）：257⁃260.
［4］周翔. 基于移动3S技术的农田信息实时采集终端的设计与实现［D］. 南京：南京农业大学，2009.
ZHOU X. The research and implement on mobile farmland information real⁃time［D］. Nanjing：Nanjing Agricultural University，2009.
［5］李佳毅，徐晓辉，苏彦莽，等. 基于Android平台的智能温室视频无线监控系统［J］. 农机化研究，2013（8）：188⁃191.
LI J Y，XU X H，SU Y M，et al. Video wirelesssurveillance system in intelligent greenhouse based on Android platform ［J］. Journal of Agricultural Mechanization Research，2013（8）：188⁃191.

［6］尚明华，秦磊磊，王风云，等. 基于Android智能手机的小麦生产风险信息采集系统［J］. 农业工程学报，2011，27（5）：178⁃182.

SHANG M H，QIN L L，WANG F Y，et al. Information collection system of wheat production risk based on Android smartphone［J］. Transactions of the CSAE，2011，27（5）：178⁃182.

［7］陈桂鹏，严志雁，瞿华香，等. 基于Android手机的农业环境信息采集系统设计与实现［J］. 广东农业科学，2014，
41（13）：178⁃181，219.
CHEN G P，YAN Z Y，QU H X，et al. Design and implementation of agricultural environmental information acquisition system based on Android mobile phone［J］.Guangdong Agricultural Sciences，2014，41 （13）：178⁃181，219.
［8］叶思菁，朱德海，姚晓闯，等. 基于移动GIS的作物种植环境数据采集技术［J］. 农业机械学报，2015，46（9）：325⁃334.
YE S J，ZHU D H，YAO X C，et al. Mobile GIS based approach for collection of crop planting environment data［J］. Transactions of the Chinese Society for AgriculturalMachinery，2015，46（9）：325⁃334.
［9］朱均超，张强，赵岩. 基于物联网的农业大棚环境监测系统设计［J］. 中国农机化学报，2018，39（9）：76⁃80.
ZHU J C，ZHANG Q，ZHAO Y. Design of environmental monitoring system for agricultural greenhouse based on
internet of things［J］. Journal of Chinese Agricultural Mechanization，2018，39（9）：76⁃80.
［10］赵庆展，靳光才，周文杰，等. 基于移动GIS的棉田病虫害信息采集系统［J］. 农业工程学报，2015，31（4）：183⁃190.
ZHAO Q Z，JIN G C，ZHOU W J，et al. Information collection system for diseases and pests in cotton field based on mobile GIS［J］. Transactions of the CSAE，2015，31（4）：183⁃190.
［11］杨林楠，郜鲁涛，林尔升，等. 基于Android系统手机的甜玉米病虫害智能诊断系统［J］. 农业工程学报，2012，28（18）：163⁃168.
YANG L N，GAO L T，LIN E S，et al. Intelligent diagnose system of diseases and insect pests in sweet corn based on mobile terminal with Android system［J］.Transactions of the CSAE，2012，28（18）：163⁃168.
［12］田磊，李丽，王明绪. 基于Android的玉米病虫害机器视觉诊断系统研究［J］. 农机化研究，2017，39（4）：207⁃211.
TIAN L，LI L，WANG M X. Research on the diagnosis system of maize plant diseases and insect pests based on
Android ［J］. Journal of Chinese Agricultural Mechanization，2017，39（4）：207⁃211.
［13］钱晔，李超，李彤，等. 基于Android手机系统的月季病虫害智能系统研究［J］. 北方园艺，2019，433（10）：151⁃157.
QIAN Y，LI C，LI T，et al. Research on intelligent diagnostic system of pests and diseases of Chinese rose
based on Android mobile phone system［J］. Northern Horticulture，2019，433（10）：151⁃157.
［14］张谷丰，罗岗，孙雪梅，等. 基于Android的水稻害虫诊断系统［J］. 应用昆虫学报，2015，52（4）：837⁃843.
ZHANG G F，LUO G，SUN X M，et al. An android mobile phone⁃based identification system for rice insects
［J］. Chinese Journal of Applied Entomology，2015，52（4）：837⁃843.
［15］ LIEBISCH F，KIRCHGESSNER N，SCHNEIDER D，et al. Remote aerial phenotyping of maize traits with a mobile multi⁃sensor approach［J］. Plant Methords，2015，11（1）：1⁃20.
［16］杨贵军，李长春，于海洋，等. 农用无人机多传感器遥感辅助小麦育种信息获取［J］. 农业工程学报，2015，31（21）：184⁃190.
YANG G J，LI C C，YU H Y，et al. UAV based multi⁃load remote sensing technologies for wheat breeding information acquirement［J］. Transactions of the CSAE，2015，31（21）：184⁃190.
［17］牛庆林，冯海宽，杨贵军，等. 基于无人机数码影像的玉米育种材料株高和LAI监测［J］. 农业工程学报，2018，34（5）：73⁃82.
NIU Q L，FENG H K，YANG G J，et al. Monitoring plant height and leaf area index of maize breeding material based on UAV digitali mages［J］. Transactions of the CSAE，2018，34（5）：73 ⁃82.
［18］ CRESCENTE J M，GUIDOBALDI F，DEMICHELIS M，et al. Phenobook：An open source software for phenotypic
data collection［J］. Gigascience，2017，6（4）：1⁃5.
［19］ RIFE T W，POLAND J A. Field book：An open⁃source application for field data collection on android［J］.Crop Sci，2014，54（4）：1624⁃1627.
［20］陈立平，李丰令. 农博士育种家软件在育种工作中的应用技术［J］. 中国园艺文摘，2010，26（7）：171⁃172.
CHEN L P，LI F L. Application technology of Dr. farmer breeder software in breeding work ［J］. Chinese Horticulture Abstracts，2010，26（7）：171⁃172.

［21］朱大洲，王成，王晓冬，等. 信息技术在作物育种中的应用［J］. 中国稻米，2011，17（6）：25⁃28.

ZHU D Z，WANG C，WANG X D，et al. Application of information technology in crop breeding［J］. China Rice，2011，17（6）：25⁃28.

［22］臧贺藏，王言景，赵巧丽，等. 表型性状数据采集系统在玉米区域试验中的应用［J］. 河南农业科学，2019，48（12）：152⁃156.
ZANG H C，WANG Y J，ZHAO Q L，et al. Application of data acquisition system for phenotypic traits in maize
regional experiment［J］. Journal of Henan Agricultural Sciences，2019，48（12）：152⁃156.
［23］臧贺藏，赵巧丽，李国强，等. 玉米农艺性状数据采集与管理系统的设计与实现［J］. 南方农业学报，2019，50（11）：2606⁃2613.
ZANG H C，ZHAO Q L，LI G Q，et al. Design and implementation of data acquisition and management system of agronomic trait for maize［J］. Journal of Southern Agriculture，2019，50（11）：2606⁃2613.
［24］赵巧丽，臧贺藏，李国强，等. 基于Android的作物表型性状数据采集系统研究［J］. 河南农业科学，2019，48（8）：175⁃180.
ZHAO Q L，ZANG H C，LI G Q，et al. Study on crop phenotypic traits data acquisition system based on Android［J］. Journal of Henan Agricultural Sciences，2019，48（8）：175⁃180.

[1]	MU Lan, XUE Shiming, ZANG Qingji, LIU Yanpei, DUAN Jiaxin, CAI Ming, ZHANG Meiyan. Study on Intercropping Patterns and Silage Quality of Gramineous Forage and Leguminous Forage in Alpine Area of Shangri‑La [J]. Journal of Henan Agricultural Sciences, 2024, 53(1): 78-86.
[2]	ZHAO Lishang, WANG Xiangsheng, GAO Nanan, HAN Pengbin, LI Jie, REN Yongzhe, LIN Tongbao, WANG Zhiqiang, LIAN Yanhao. Effects of Intercropping of Two Genotypes of Wheat on Grain Filling Characteristics and Yield [J]. Journal of Henan Agricultural Sciences, 2023, 52(8): 18-25.
[3]	FAN Xiaoqing, ZHAO Xinyue, WANG Yuwen, ZHANG Liangyao, YUAN Jincheng, LIU Yinghui, WENG Qiaoyun. Effect of Intercropping of Silage Corn and Forage Rape on Forage Crop Yield and Quality [J]. Journal of Henan Agricultural Sciences, 2023, 52(7): 40-51.
[4]	XU Doudou, HE Yunxin, LI Fei, LIU Aiyu, ZHOU Zhonghua. Research Progress of Intercropping Patterns in Cotton Fields [J]. Journal of Henan Agricultural Sciences, 2023, 52(6): 1-11.
[5]	XIONG Rui, ZHANG Wei, ZHONG Kangyu, ZHOU Wentao, OU Xi, WANG Hongrui, LONG Pan, XU Ying, FU Zhiqiang. Effects of Straw Returning and Rotating Tillage on Soil Physical Characteristics and Carbon and Nitrogen Content in Double‐Cropping Paddy Field [J]. Journal of Henan Agricultural Sciences, 2023, 52(5): 81-90.
[6]	LI Chengyu, CHENG Sixian, MA Haibin, LIU Weiling, ZHANG Xuelin, LIU Tianxue, LI Chaohai, ZHAO Yali. Soil Physicochemical Properties of Different Yield Fields with Irrigated Lime Concretion Black Soil and Correlation between Them and Crop Yield in South Henan [J]. Journal of Henan Agricultural Sciences, 2023, 52(4): 74-81.
[7]	SONG Penghui, JIAO Kuibao, LI Yuze, YANG Ruihua, ZHANG Lei, DUAN Yadong, ZHANG Kun, WU Xinjuan, ZHOU Shuang, WANG Mingjie. Screening of Trap Plant Intercropping with Strawberry and Its Trapping Effect on Frankliniella occidentalis [J]. Journal of Henan Agricultural Sciences, 2023, 52(4): 82-89.
[8]	WANG Huanxin, SHEN Zhihao, LIU Quan, LIU Jinjiang. Identification of Crop Leaf Diseases Based on Improved MobileNetV2 Model [J]. Journal of Henan Agricultural Sciences, 2023, 52(4): 143-151.
[9]	LI Qian, SUN Lihui, GUO Jianlin, ZHENG Gang, JIANG Jianhu, CHEN Jianming, GAO Lingmei. Analysis of Biofilm Culturing，Microbial Community Composition of Three Biological Fillers in Recirculating Aquaculture System and#br# Their Effects on Growth of Largemouth Bass（Micropterus salmoides） [J]. Journal of Henan Agricultural Sciences, 2023, 52(3): 143-152.
[10]	WANG Cong, LI Ming, QIU Guangwei, WANG Lichun, LIU Lingling, WANG Huaipeng, PANG Ze , TANG Chunshuang, SUN Jiying. Effects of Different Planting Pattern on Soil Physical and Chemical Properties of Heilongjiang Black Soil [J]. Journal of Henan Agricultural Sciences, 2023, 52(2): 74-83.
[11]	RONG Yasi, LI Guoqiang, ZHANG Jie, ZHANG Jiantao, WANG Meng, ZHENG Guoqing, FENG Wei. Irrigation Strategies Optimization for Winter Wheat in Henan Province Based on AquaCrop Model [J]. Journal of Henan Agricultural Sciences, 2023, 52(2): 151-161.
[12]	LI Xiangchun, SUI Yihu, TANG Jingwen, HU Nengbing. Effects of the Combination of Four Cultivation Factors on Agronomic，Fruit Traits and Yield of the Intercropping Systerm of Watermelon‐Pepper in Greenhouses [J]. Journal of Henan Agricultural Sciences, 2023, 52(12): 116-126.
[13]	WANG Guangyin, GUO Weili, CHEN Bihua, PAN Feifei, HUANG Xinqi, CAI Zucong, ZHOU Jianhua, GU Guilan. Research Progress on Mechanism and Application of Reductive Soil Disinfection（RSD）in Prevention and Control of Continuous Cropping Obstacles of Facility Soil and Vegetable [J]. Journal of Henan Agricultural Sciences, 2023, 52(1): 1-10.
[14]	TANG Wei, CHEN Can, HUANG Huang, ZHOU Tiansong, WANG Ren. Analysis on Crop Yield and Nitrogen and Phosphorus Balance of Different Crop+Crayfish Models [J]. Journal of Henan Agricultural Sciences, 2023, 52(1): 24-33.
[15]	XU Jiatong, CHEN Shutao, ZHANG Miaomiao, XIA Ke, WANG Hui. Relationships between Total Phosphorus Contents of Leaf and Stem of Different Crops and Hyperspectral Vegetation Indexes [J]. Journal of Henan Agricultural Sciences, 2022, 51(9): 141-150.