面向土地质量评价的省级农业地质大数据平台构建

doi:10.19788/j.issn.2096-6369.230120

摘要/Abstract

摘要：

农业地质是地质科学与现代农业生产发展相结合的边缘学科。面向土地质量评价的农业地质调查涵盖了各种调查比例尺、不同调查对象、多种评价方法，产生各类多源、异构、多尺度和海量基础数据，文章从土地质量评价视角出发，围绕农业地质大数据应用平台的开发进行探索实践。文章采用面向服务架构和B/S网络结构，基于ArcGIS软件平台和WebService形式的OLAP技术，借助C#和JavaScript开发地理信息共享系统，采用关系型数据库系统SQL Server和Geodatabase进行数据管理，构建省级农业地质大数据平台。该平台集成了以往基础地质、农业地质、区域化探资料，挂接“地质云”(全国地质资料馆)公开馆藏资料，以地图结合图表的形式，直观、动态地展示了农业地质大数据信息。实现山东省农业地质“一张图”、大数据可视化、土壤监测预警、名特优产地环境辅助决策等典型应用。本次大数据平台针对农业地质典型应用进行了探索的研发，实现农业施肥精准化指导，对名特优产品的实现动态监测；面对不同尺度、不同时间的同源异构数据进行可视化对比、网格化比较，对地球化学指标周期性变化的观测，实现对土壤质量现状监测、对土壤环境污染预警的作用。还通过分布式数据挖掘和多维数据分析，实现了省级多目标区域化探、中大比例尺土地质量调查及农业地质相关同源异构数据的叠加分析，即对格网数据时间变化走势的展现，构建了基于地学思维的农业地质检测应用接口，为今后的科技创新提供了决策依据。

关键词: 农业地质, 地质大数据, 地质信息化, 土地质量评价

Abstract:

Agricultural geology is a new field of geological science serving the development strategy of modern agricultural production. The agricultural geological survey faced land quality evaluation covered various survey scales, different survey objects, and various evaluation methods, and has produced various multi-source, heterogeneous, multi-scale and massive basic data. This article, from the perspective of land quality evaluation, has explored and practiced the development of the application platform of agricultural geological big data. The article has adopted service-oriented architecture and B/S network structure, based on ArcGIS software platform and OLAP technology in the form of Web Service, has developed a geographic information sharing system with the help of C # and JavaScript, has used relational database systems SQL Server and Geodatabase for data management, and has constructed a provincial agricultural geology big data platform.The platform has integrated the previous basic geology, agricultural geology and regional geochemical exploration data, linked the "geological cloud" (National Geological Data Center) to open the collection data, and visually and dynamically displayed the agricultural geological big data information in the form of maps and charts. Realized typical applications such as "one map" of agricultural geology in Shandong Province, big data visualization, soil monitoring and early warning, and environmental aid decision-making for famous and excellent producing areas. This big data platform has carried out exploratory research and development on typical applications of agricultural geology to achieve precise guidance of agricultural fertilization and dynamic monitoring of famous, special and excellent products; Visual comparison and gridding comparison have been carried out for the homologous and heterogeneous data of different scales and different times, and the observation of the periodic changes of geochemical indicators has been carried out to realize the role of monitoring the status quo of soil quality and early warning of soil environmental pollution.Through distributed data mining and multi-dimensional data analysis, the provincial multi-target regional geochemical exploration, medium and large scale land quality survey, and the superposition analysis of homologous and heterogeneous data related to agricultural geology have also been realized, that is, the display of the time change trend of grid data, and the application interface of agricultural geological detection based on geoscience was constructed, which provides a decision-making basis for future scientific and technological innovation.

Key words: agricultural geology, geological big data, geological information, land quality evaluation

徐佳, 康桂玲, 于林松, 赵玉岩, 刘敬兵. 面向土地质量评价的省级农业地质大数据平台构建[J]. 农业大数据学报, 2023, 5(1): 116-125.

XU Jia, KANG Guiling, YU Linsong, ZHAO Yuyan, LIU Jingbing. Construction of Provincial Agricultural Geological Survey Information System Platform for Land Quality Evaluation[J]. Journal of Agricultural Big Data, 2023, 5(1): 116-125.

图/表 6

图1

图2

图3

图4

图5

图6

参考文献 30

[1]	陈海龙. 农业地质研究现状及未来发展方向的思考——以湖南农业地质为例[J]. 国土资源导刊, 2020, 17(4): 13-17.
	Chen H L. Thoughts on the present situation and future de-velopment direction of agricultural geology research—Taking Hunan agricultural geology as an example[J]. Land and Resources Herald, 2020, 17(4): 13-17.
[2]	高琳, 龙怀玉, 刘鸣达, 等. 农业地质背景与特色农作物品质相关性研究进展[J]. 土壤通报, 2011, 42(5): 1263-1267.
	Gao L, Long H Y, Liu M D, et al. Research progress on correlation between agricultural geological background and quality of characteristic crops[J]. Chinese Journal of Soil Science, 2011, 42(5): 1263-1267.
[3]	李括, 彭敏, 赵传冬, 等. 全国土地质量地球化学调查二十年[J]. 地学前缘, 2019, 26(6): 128-158. doi: 10.13745/j.esf.sf.2019.8.25
	Li K, Peng M, Zhao Ch D, et al. Twenty years of national land quality geochemical survey[J]. Earth Science Frontiers, 2019, 26(6): 128-158. doi: 10.13745/j.esf.sf.2019.8.25
[4]	代杰瑞, 庞绪贵, 刘华峰, 等. 山东省东部地区农业生态地球化学调查及生态问题浅析[J]. 岩矿测试, 2012, 31(1): 189-197.
	Dai J R, Pang X G, Liu H F, et al. Agroecological geochemical survey and analysis of ecological problems in eastern Shandong Province[J]. Rock and Mineral Analysis, 2012, 31(1): 189-197.
[5]	庞绪贵, 崔元俊, 王晓梅, 等. 山东省生态地球化学调查与评价综述[J]. 山东国土资源, 2013, 29: 10-15.
	Pang X G, Cui Y J, Wang X M, et al. Survey and evaluation on ecogeochemistry in Shandong Province[J]. Shandong Land and Resources, 2013, 29: 10-15.
[6]	万昊宇. 现代化农业的大数据分析状况与发展前景[J]. 山西农经, 2018(9): 31+36.
	Wan H Y. Big data analysis status and development prospect of modern agriculture[J]. Shanxi Agricultural Economics, 2018(9): 31+36.
[7]	黄家凯, 樊旭东, 秦丽娟. 省级地质大数据建设的总体框架研究[J]. 资源环境与工程, 2019, 33(1): 103-108. doi: 10.16536/j.cnki.issn.1671-1211.2019.01.021
	Huang J K, Fan X D, Qin L J. Research on the overall frame-work of provincial geological big data construction[J]. Resources, environment and Engineering, 2019, 33(1): 103-108. doi: 10.16536/j.cnki.issn.1671-1211.2019.01.021
[8]	黄少芳, 刘晓鸿. 地质大数据应用与地质信息化发展的思考[J]. 中国矿业, 2016, 25(8): 166-170.
	Huang Sh F, Liu X H. Thoughts on the application of geological big data and the development of geological informatization[J]. China Mining Magazine, 2016, 25(8): 166-170.
[9]	杨舒. 首届全国地质资料数据创新应用大赛启动[N]. 光明日报, 2018-04-22.
	Yang S. The first national geological data innovation and application competition was launched[N]. Guangming Daily, 2018-04-22.
[10]	谭永杰. 地质大数据体系建设的总体框架研究[J]. 中国地质调查, 2016 (3): 1-6.
	Tan Y J. Research on the overall framework of geological big data system construction[J]. Geological Survey of China, 2016 (3): 1-6.
[11]	潘宝玉, 于广婷, 刘同文. 智慧地矿建设框架研究[J]. 地矿测绘, 2016, 32(1): 5-7+15.
	Pan B Y, Yu G T, Liu T W. Research on the framework of intelligent geological and mineral construction[J]. Surveying and Mapping of Geology and Mineral Resources, 2016, 32(01): 5-7+15.
[12]	于广婷, 曹发伟, 刘同文, 等. 地质大数据支持下的智慧地矿业务支撑平台构建[J]. 测绘通报, 2020 (12): 128-131.
	Yu G T, Cao F W, Liu T W, et al. Construction of intelligent geological and mineral business support platform supported by geological big data[J]. Bulletin of Surveying and Mapping, 2020(12): 128-131.
[13]	严光生, 薛群威, 肖克炎. 地质调查大数据研究的主要问题分析[J]. 地质通报, 2015, 34(7): 1273-1279.
	Yan G S, Xue Q W, Xiao K Y. Analysis of main problems in geological survey big data research[J]. Geological Bulletin of China, 2015, 34(7): 1273-1279.
[14]	郑啸, 李景朝, 王翔, 等. 大数据背景下的国家地质信息服务系统建设[J]. 地质通报, 2015, 34(7): 1316-1322.
	Zheng X, Li J M, Wang X, et al. Construction of national geological information service system under the back-ground of big data[J]. Geological Bulletin of China, 2015, 34(7): 1316-1322.
[15]	庞绪贵, 代杰瑞, 陈磊. 山东省17市土壤地球化学背景值[J]. 山东国土资源, 2019, 35(1): 46-56.
	Pang X G, Dai J R, Chen L. Background values of soil geochemistry in 17 cities of Shandong Province[J]. Shandong Land and Resources, 2019, 35(1): 46-56.
[16]	庞绪贵, 陈钰, 刘汉栋. 山东半岛蓝色经济区土壤地球化学基准值与背景值[J]. 山东国土资源, 2014, 30(8): 21-26.
	Pang X G, Chen Y, Liu H D. Soil geochemical reference values and background values in the blue economic zone of Shandong peninsula[J]. Shandong Land and Resources, 2014, 30(8): 21-26.
[17]	李强, 高懋芳, 方莹. 农业大数据信息平台搭建方法初探[J]. 农业大数据学报, 2021, 3(2): 24-30.
	Li Q, Gao M F, Fang Y. Research on the construction of the agricultural big data information platform[J]. Journal of Agricultrual Big Data, 2021, 3(2): 24-30.
[18]	高琳, 龙怀玉, 刘鸣达, 等. 农业地质背景与特色农作物品质相关性研究进展[J]. 土壤通报, 2011, 42(5): 1263-1267.
	Gao L, Long H Y, Liu M D, et al. Review on the relationship between agrogeological background and crop quality[J]. Chinese Journal of Soil Science, 2011, 42(5): 1263-1267.
[19]	王永志, 包晓栋, 缪谨励, 等. 基于大数据的地质云监控平台建设与应用[J]. 地球物理学进展, 2018, 33(2): 0850-0859.
	Wang Y Z, Bao X D, Liao J L, et al. Construction and application of geological cloud monitoring platform based on big data[J]. Progress in Geophysics, 2018, 33(2): 0850-0859.
[20]	张学利, 马娜, 朱瑜馨. 基于云平台的农业综合信息应用系统的设计与开发[J]. 地理空间信息, 2019, 17(2): 27-30.
	Zhang X L, Ma N, Zhu Y X. Design and development of agricultural comprehensive information application system based on cloud platform[J]. Geospatial Information, 2019, 17(2): 27-30.
[21]	于广婷, 刘同义, 曹发伟. 地质大数据轻量化集成展示与专题应用[J]. 测绘通报, 2021(11): 140-144.
	Yu G T, Liu T Y, Cao F W. Lightweight integrated display and thematic application of geological big data[J]. Bulletin of Surveying and Mapping, 2021(11): 140-144.
[22]	赵鹏大. 地质大数据特点及其合理开发利用[J]. 地学前缘, 2019, 26(4): 1-5. doi: 10.13745/j.esf.sf.2018.9.8
	Zhao P D. Characteristics of geological big data and its rational development and utilization[J]. Earth Science Frontiers, 2019, 26(4): 1-5. doi: 10.13745/j.esf.sf.2018.9.8
[23]	吴冲龙, 刘刚, 张夏林. 地质科学大数据及其利用的若干问题探讨[J]. 科学通报, 2016, 61(16): 1797-1807.
	Wu C L, Liu G, Zhang X L. Discussion on some problems of geological big data and its utilization[J]. Chinese Science Bulletin, 2016, 61(16): 1797-1807.
[24]	谭永杰, 屈红刚, 文敏. 论地质调查工作大数据[J]. 地理信息世界, 2018, 25(2): 7-11.
	Tan Y J, Qu H G, Wen M. On big data of geological survey[J]. Geomatics World, 2018, 25(2): 7-11.
[25]	李超岭, 李健强, 张宏春. 智能地质调查大数据应用体系架构与关键技术[J]. 地质通报, 2015, 34(7): 1288-1299.
	Li C L, Li J Q, Zhang H C. Big data application architecture and key technologies of intelligent geological survey[J]. Geological Bulletin of China, 2015, 34(7): 1288-1299.
[26]	贾瑞婷, 晋保红. 地矿智慧护航“未来之城”[N]. 中国自然资源报, 2022-01-12.
	Jia R T, Jin B H. Geological and mineral wisdom escorts the “city of the future”[N]. China Natural Resources News, 2022-01-12.
[27]	刘世梁, 傅伯杰, 刘国华, 等. 我国土壤质量及其评价研究的进展[J]. 土壤通报, 2006(1): 137-143.
	Liu S L, Fu B J, Liu G H, et al. Progress in soil quality and its evaluation in China[J]. Chinese Journal of Soil Science, 2006(1): 137-143.
[28]	邵岩. 大数据环境下高校智慧校园信息化模式探究[J]. 吉林大学学报(信息科学版), 2020, 38(4): 502-508.
	Shao Y. Research on the informatization mode of university smart campus in the big data environment[J]. Journal of JiLin University (Information Science Edition), 2020, 38(4): 502-508.
[29]	李晓会, 陈潮阳, 伊华伟, 等. 基于云计算和大数据分析的大规模网络流量预测[J]. 吉林大学学报(工学版), 2021, 51(3): 1034-1039.
	Li X H, Chen C Y, Yi H W, et al. Large scale network traffic prediction based on cloud computing and big data analysis[J]. Journal of JiLin University(Engineering Edition), 2021, 51(3): 1034-1039.
[30]	于婧, 陈艳红, 彭婕, 等. 基于GIS和Fragstats的土地生态质量综合评价——以湖北省仙桃市为例[J]. 生态学报, 2020, 40(9): 2932-2943.
	Yu J, Chen Y H, Peng J, et al. Comprehensive evaluation of land ecological quality based on GIS and Fragstats—a case study of Xiantao city, Hubei Province[J]. Journal of ecology, 2020, 40(9): 2932-2943.