Design of a Query Language for Accessing Spatial Analysis in the Web Environment

Authors:
Bo Huang;Hui Lin
Affiliations:
Department of Geography and Joint Laboratory for Geoinformation Science, The Chinese University of Hong Kong, Shatin, NT, Hong Kong bohuang@cuhk.edu.hk;Department of Geography and Joint Laboratory for Geoinformation Science, The Chinese University of Hong Kong, Shatin, NT, Hong Kong huilin@cuhk.edu.hk
Venue:
Geoinformatica
Year:
1999

Citing 10
Cited 2

Thematic map modeling

SSD '90 Proceedings of the first symposium on Design and implementation of large spatial databases
Efficient query processing in geographic information systems

Efficient query processing in geographic information systems
Parametric databases: seamless integration of spatial, temporal, belief and ordinary data

ACM SIGMOD Record
Spatial SQL: A Query and Presentation Language

IEEE Transactions on Knowledge and Data Engineering
An Efficient Pictorial Database System for PSQL

IEEE Transactions on Software Engineering
Geo-Relational Algebra: A Model and Query Language for Geometric Database Systems

EDBT '88 Proceedings of the International Conference on Extending Database Technology: Advances in Database Technology
Geo-SAL: A Query Language for Spatial Data Analysis

SSD '91 Proceedings of the Second International Symposium on Advances in Spatial Databases
Extending a DBMS with Spatial Operations

SSD '91 Proceedings of the Second International Symposium on Advances in Spatial Databases
A Small Set of Formal Topological Relationships Suitable for End-User Interaction

SSD '93 Proceedings of the Third International Symposium on Advances in Spatial Databases
MAPQUERY: Data base query language for retrieval of geometric data and their graphical representation

SIGGRAPH '82 Proceedings of the 9th annual conference on Computer graphics and interactive techniques

A Filter Flow Visual Querying Language and Interface for Spatial Databases

Geoinformatica
Personalized local internet in the location-based mobile web search

Decision Support Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.