中图分类号：F23 文献标志码：A

Abstract： 【Objective】 In urban landscape design，landscape plants can not only beautify the environment，but also have important ecological value and cultural attributes.This paper discussed the problems such as unreasonable resource allocation and lack of diversity in the selection of traditional garden landscape plant models in order to provide a reference for urban greening.【Method】 In this paper，a data integration system for landscape plants based on Excel was designed.First of all，according to the principles of garden design，parameters that can change dynamically were set up.Based on the factors such as plant volume，morphological information，color and smell，time sequence and cost，interactive auxiliary analysis toolsand parameter models were established through functional programming and VB scripting language. The experiment took Lanzhou landscaping as an example.【Result】 The results showed that the integrated system can accurately select suitable native plants （such as sea buckthorn，1 indigo，drooping willow，etc.）according to the special climate （drought，sand and salinization）in northwest China，and form diversified design schemes.Compared with the traditional manual screening method，the system technology module wassignificantly superior to the traditional method in data retrieval efficiency（up to 93% ），cost estimation accuracy （ 89.75% on average）and ecological adaptability guidance，especially the recommendation accuracy of drought-tolerant plants was increased.【Conclusion】 This system provided a scientific and localized plant allocation scheme for landscaping in northwest China，solved the problems of low plant survival rate and landscape homogeneity in the high-cold and arid environment，and improved the regional ecological protection efficiency through intelligent scree-ning of sand-fixing plants such as sea buckthorn and Caragana.It is of great significance to provide scientific guidance for urban greening in northwest China and promote the sustainable development of landscape architecture.

Keywords： Garden landscape;plant configuration;mode selection;northwest China

0 引言

【研究意义】在国家经济与文化的蓬勃发展中，生态环境问题日益凸显，成为制约可持续发展的关键因素。西北地区，作为我国重要的生态屏障，面临着更加严峻的环境挑战，如土地荒漠化、水资源短缺及生态系统脆弱等（殷允可等，2024；杨月英和陈静，2024）。因此，构建与区域生态环境相适应的园林景观植物模式，对于提升城市生态功能、促进生态文明建设具有重要意义（袁杰，2024；张超，2024；蒲泽敏，2023）。【前人研究进展】蒋亚蓉等（2022）针对草花混播设计中种类选择盲目、杂草清除成本高及景观持续性差等问题，提出结合CSR生态学理论的方法，通过施加环境压力、减少干扰、降低优势种竞争，构建稳定群落。结果显示，该方法有效指导了混播物种选择。ISLAM等（2024）针对园林植物施肥选择准确率不高的问题，提出通过光学传感器监测植物的优化施肥量。结果显示，通过采用该方法，园区的植物生长量提升了 12.6% 。王军校（2024）针对生态修复项目的园林植物选择问题，结合实际案例分析讨论了资源与项目之间的联系，但方法不具备具体的选择细节。张巍（2024）基于生态平衡和文化内涵对园林设计中的植物选择方法进行了探讨，结合实践案例证明了可持续性管理在园林建设中的优势，但缺乏对于具体植物类型的分析。【本研究切入点】前人的研究成果应用于西北高寒干旱区时面临显著局限。首先，现有生态模型普遍缺乏对干旱、盐碱化等极端环境因子的整合，导致乡土植物筛选精准度低下，文献及实践数据显示如沙棘、柠条等关键物种存活率仅维持在低水平。……