Design of a query language for accessing Spatial analysis in the web environment

被引：7

作者：

Huang B. ^{[1
]}

Lin H. ^{[1
]}

机构：

[1] Dept. Geogr. Jt. Lab. G., Chinese University of Hong Kong, Shatin, NT

来源：

GeoInformatica | 1999年 / 3卷 / 2期

关键词：

CGI; Client/server; Internet; Query languages; Spatial analysis; SQL; SQL/Spatial; Web GIS;

D O I：

10.1023/A:1009803811153

中图分类号：

学科分类号：

摘要：

A spatial query language called SQL/Spatial has been designed to support the expression of user requests dealing with a variety of GIS analysis functions (e.g., map overlay and buffer) in the Web environment. Using the familiar SELECT - FROM - WHERE statement instead of procedural commands like macro language in some GIS packages, users can formulate their queries more easily, while conducting powerful spatial data retrieval and analysis. The language investigates an appropriate structure to express spatial queries within the framework of the on-going SQL standards for spatial extensions (i.e., Open GIS Simple Features Specification for SQL and SQL3 MultiMedia Specification Part 3: Spatial). By restructuring the FROM clause via a subquery, SQL/Spatial is well adapted to the general spatial analysis procedure by using current GIS packages, while conforming well to the SQL design concepts. The interface (client) of the language resides with a Web browser, while the query is processed by a query server. The query server, linked to the Web server via Common Gateway Interface (CGI) scripts, is composed of a query processor, Spatial Database Engine (SDE) and MapObjects Internet Map Server. It was demonstrated that the design of SQL/Spatial facilitates the access to spatial analysis functionalities on the Web.

引用

页码：165 / 183

页数：18

共 35 条

[11]

Getting Started with MapObjects Internet Map Server, (1996)

[12]

SDE Developer's Guide Version 2.1, (1996)

[13]

Frank A., Mapquery - Database query languages for retrieval of geometric data and its graphical representation, ACM Computer Graphics, 16, 3, pp. 199-207, (1982)

[14]

Gadia S.K., Parametric databases: Seamless integration of spatial, temporal, belief, and ordinary data, SIGMOD Record, 22, 1, pp. 15-20, (1993)

[15]

Changing the Face of GIS, (1997)

[16]

Gunther O., Environmental Information Systems, (1998)

[17]

Guting R.H., Geo-relational algebra: A model and query language for geometric database system, Proceedings of the International Conference on EDBT, pp. 506-527, (1988)

[18]

Goodchild M., Egenhofer M., Fegeas R., Interoperating GISs, Report of a Specialist Meeting of Interop'97, (1997)

[19]

Herring J.R., Larsen R.C., Shivakumar J., Extensions to the SQL query language to support spatial analysis in a topological database, Proceedings of GISILIS' 88, (1988)

[20]

Huang B., GeoSQL: A visual spatial SQL for topological relationships in GIS, Proceedings of the ISPRS Workshop on Dynamic and Multi-dimensional GIS, (1997)

← 1 2 3 4 →