欢迎访问《中国农学通报》,

中国农学通报 ›› 2026, Vol. 42 ›› Issue (20): 64-70.doi: 10.11924/j.issn.1000-6850.casb2026-0374

• 资源·环境·生态·土壤·气象 • 上一篇    下一篇

基于ArcPy与Excel配置文件的耕地质量等级评价自动化方法

刘婷(), 邓南荣, 华德梅, 邓嘉荣   

  1. 广东省科学院生态环境与土壤研究所/华南土壤污染控制与修复国家地方联合工程研究中心/广东省农业环境综合治理重点实验室, 广州 510650
  • 收稿日期:2026-05-11 修回日期:2026-08-18 出版日期:2026-10-25 发布日期:2026-10-26
  • 作者简介:

    刘婷,女,1984年出生,广东梅州人,助理研究员,硕士研究生,研究方向:耕地质量评价。通信地址:510650 广东省广州市天源路808号 广东省科学院生态环境与土壤研究所,Tel:020-87580291,E-mail:。

  • 基金资助:
    广东省科技计划项目“广东省农业环境综合治理重点实验室”(2023B1212060044)

Automated Method for Cultivated Land Quality Grade Evaluation Based on ArcPy and Excel Configuration Files

LIU Ting(), DENG Nanrong, HUA Demei, DENG Jiarong   

  1. National-regional Joint Engineering Research Center for Soil Pollution Control and Remediation in South China/ Guangdong Key Laboratory of Integrated Agro-environmental Pollution Control and Management/Institute of Eco-environmental and Soil Sciences, Guangdong Academy of Sciences, Guangzhou 510650
  • Received:2026-05-11 Revised:2026-08-18 Published:2026-10-25 Online:2026-10-26

摘要:

耕地质量等级评价是指导耕地质量管理、保障国家粮食安全和促进农业可持续发展的有效手段。为解决传统耕地质量等级评价依赖人工操作、效率低下的问题,本文构建自动化耕地质量等级评价方法。该方法依据《耕地质量等级》 (GB/T 33469—2016)国家标准,利用ArcPy开发自动化脚本,并封装为ArcToolbox工具,通过将评价规则与程序代码分离并存储于Excel配置文件中,实现评价规则的集中管理和灵活配置。以广东省新丰县2022年度15986个耕地图斑为案例进行实证研究。结果表明:该自动化工具在20 s内完成全部图斑的评价计算,正确率达100%,处理效率较传统人工方式显著提升。该方法实现了耕地质量等级评价流程的自动化与标准化,可为县域尺度耕地质量等级评价的批量处理提供技术支撑。

关键词: 耕地质量等级评价, ArcPy, Excel规则配置, 自动化, 新丰县

Abstract:

Cultivated land quality grade evaluation serves as an effective means of guiding cultivated land quality management, ensuring national food security, and promoting sustainable agricultural development. Traditional evaluation approaches rely heavily on manual operations, resulting in low efficiency. To address these issues, an automated evaluation method was developed in this study. Based on the national standard Cultivated Land Quality Grade (GB/T 33469—2016), an automated script was developed using ArcPy and encapsulated as an ArcToolbox tool. Evaluation rules were decoupled from program code through an Excel configuration file. An empirical study was conducted using 15986 cultivated land patches in Xinfeng County, Guangdong Province, of year 2022. The results indicated that the tool completed the evaluation calculations for all patches within 20 seconds, with an accuracy rate of 100%. The processing efficiency was significantly improved compared to conventional manual methods. The proposed approach automates and standardizes the cultivated land quality grade evaluation process through the decoupling of rule configuration from program code. This method provided technical support for county-scale batch processing and could be extended to other regions using the same national standard.

Key words: cultivated land quality grade evaluation, ArcPy, Excel rule configuration, automation, Xinfeng County

中图分类号: