GIS-SQL查询操作在植物景观规划设计教学中的应用

On Application of SQL-GIS Query Operation in Teaching of Plant Landscape Planning and Design

针对植物景观规划设计教学中学生表现出的对园林植物观赏特性、生态习性掌握不牢,对园林植物规格、体量认知不够,对园林植物价格不熟悉等三大困惑,尝试将GIS技术引入教学,以ARCVIEW GIS为平台,指导学生将植物景观调研成果数字化,形成植物景观信息系统.通过结构化查询语言操作(structured query language,SQL),实现园林植物与风景园林要素的组合查询、观赏特性及生态习性查询、规格与价格查询、多因素条件查询和识别性查询等多种查询方式,从而轻松获取需要的植物景观信息.如此,学生学习的目的性与针对性得到强化,学习积极性与主动性有所提高,教学效果明显.

In view of the three major puzzles that students show in the teaching of plant landscape planning and design such as mastering of ornamental characteristics and ecological habits of landscape plants are not firm,cognition of specifications and size of landscape plants are not enough,prices of landscape plants are not familiar and so on.In this paper,attempt has been made to introduce the GIS technology into teaching,so as to guide students to digital plant landscape research results,to form the plant landscape information system,and to take ARCVIEW GIS as the platform.Through SQL（Structured Query Language）operation,a variety of queries are achieved such as queries of the combination of landscape plants and landscape elements,queries of ornamental characteristics and ecological habits,queries of specification and price,queries of conditions of various factors,and queries of identification,thereby obtaining required plant landscape information.Thus,the purpose and pertinence of students＇learning is strengthened,enthusiasm and initiative of students＇learning is improved,and the effect of teaching is obvious.