Skip to main content
SpringerLink
Log in

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

  • Published:
GeoInformatica Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. D.J. Abel, R.G. Ackland, and S. Hungerford. “The Web and spatial information systems: beyond hypermedia?” 2 nd International Conference on GeoComputation and SIRC'97, The Spatial Information Research Center, University of Otago, New Zealand, http://divcom.otago.ac.nz:800/conferences/geocomp97/cd-rom/geocomp97/Geo_Titles.htm, 26th–29th 1997.

    Google Scholar 

  2. W. Aref. “Query processing in distributed spatial databases,” Interop'97, Santa Barbara, CA, http://www.ncgia.ucsb.edu/conf/interop97/program, 1997.

  3. W. Aref and H. Samet. “Extending a DBMS with spatial operations,” in O. Günther and H.J. Schek (eds.), Advances in Spatial Databases, LNCS 525, Springer-Verlag: Berlin/Heidelberg/New York, pp. 299–318, 1991.

    Google Scholar 

  4. P. Boursier and M. Mainguenaud. “Spatial query languages: extended SQL vs. visual language vs. hypermaps,” 5th International Symposium on Spatial Data Handling, Charleston, SC, USA, 1992.

  5. Y.H. Chou. Exploring Spatial Analysis in Geographic Information Systems. OnWord Press: Santa Fe, USA, 1996.

    Google Scholar 

  6. E. Clementini, D. Paolino, and P. Oosterom. “A small set of formal topological relationships suitable for end-user interaction,” in D.J. Abel and B.C. Ooi (eds.), Advances in Spatial Databases, SSD'1993, LNCS 692, Singapore, pp. 277–295, 1993.

  7. M. Egenhofer. “Spatial SQL: a query and presentation language,” IEEE Transactions on Knowledge Engineering and Data Engineering, Vol. 6(1):86–95, 1994.

    Google Scholar 

  8. M. Egenhofer and R. Franzosa. “Point-set topological spatial relations,” International Journal of Geographical Information Systems, Vol. 5(2):161–174, 1991.

    Google Scholar 

  9. M. Egenhofer and J. Herring. “A mathematical framework for the definition of topological relationships,” 5th International Symposium on Spatial Data Handling, Columbus, Ohio, pp. 803–813, 1990.

  10. Environmental Systems Research Institute Inc. (ESRI). Understanding GIS—The Arc/Info Method. Redlands, CA, 1990.

  11. ESRI. Getting Started with MapObjects Internet Map Server. Redlands: CA, 1996.

  12. ESRI. SDE Developer's Guide Version 2.1. Redlands, CA, 1996.

  13. A. Frank. “Mapquery—database query languages for retrieval of geometric data and its graphical representation,” ACM Computer Graphics, Vol. 16(3):199–207, 1982.

    Google Scholar 

  14. S.K. Gadia. “Parametric databases: seamless integration of spatial, temporal, belief, and ordinary data,” SIGMOD Record, Vol. 22(1):15–20, 1993.

    Google Scholar 

  15. Genasys Inc. “Changing the face of GIS,” http://www.genasys.com/homepage/info/publications.html, 1997.

  16. O. Günther. Environmental Information Systems. Springer-Verlag: Berlin/Heidelberg/New York, 1998.

    Google Scholar 

  17. R.H. Guting. “Geo-relational algebra: a model and query language for geometric database system,” In J.W. Schmidt, S. Ceri and M. Missikoff (eds.), Proceedings of the International Conference on EDBT, Venice, 506–527, 1988.

  18. M. Goodchild, M. Egenhofer, and R. Fegeas, eds., “Interoperating GISs,” Report of a specialist meeting of Interop'97, Santa Barbara, CA, 1997.

  19. J.R. Herring, R.C. Larsen, and J. Shivakumar. “Extensions to the SQL query language to support spatial analysis in a topological database,” in Proceedings of GIS/LIS' 88, San Antonio, 1988.

  20. B. Huang. “GeoSQL: a visual spatial SQL for topological relationships in GIS,” in Z.L. Li and Y.C. Lee (eds.), Proceedings of the ISPRS Workshop on Dynamic and Multi-dimensional GIS, The Polytechnic University of Hong Kong, Hong Kong, 1997.

    Google Scholar 

  21. K.J. Ingram and W.W. Phillips. “Geographic information processing using a SQL based query language,” in Proceedings of AutoCarto 8, Baltimore, Maryland, 326–335, 1987.

  22. International Organization for Standardization (ISO). SQL Multimedia and Application Packages (SQL/ MM, Part3: Spatial), Working Draft, 1995.

  23. D. Kvedarauskas, P. Boursier, X. Culos, T. Deltheil, and S. Iris. “GEOLIB: a software component for making GIS tools interoperable,” Interop'97, Santa Barbara, CA, http://www.ncgia.ucsb.edu/conf/interop97/program, 1997.

  24. H. Lin and L. Zhang. “Pluggable computing strategy for integration of GIS and environmental modeling,” in Proceedings of GeoInformatics'97, Taibei, 299–305, 1997.

  25. Open GIS Consortium Inc. (OGC). The OpenGIS Abstract Specification: An Object Model for Interoperable Geoprocessing, Revision 1. OpenGIS Project Document Number 96–015R1, 1996.

  26. OGC. OpenGIS Simple Features Specification for SQL (Revision 1), http://www.opengis.org/techno/specs.htm, 1998.

  27. B.C. Ooi. Efficient query processing for Geographic Information System. LNCS 471, Springer-Verlag, Berlin, 1990.

    Google Scholar 

  28. Oracle Corporation. “Advances in relational database technology for spatial data management,” Oracle Spatial Cartridge Technical White Paper, 1997.

  29. Z.R. Peng. “An assessment of the development of Internet GIS,” ESRI user conference, San Diego, California, 1997.

  30. N. Roussopoulos, C. Faloutsos, and T. Sellis. “An efficient pictorial database system for PSQL,” IEEE Transactions on Software Engineering, Vol. 14(5):639–650, 1988.

    Google Scholar 

  31. M. Scholl and A. Voisard. “Thematic map modeling,” 1 st International Symposium on Large Spatial Databases, Santa Barbara, CA. (LNCS 409), Springer-Verlag: New York, 1989.

    Google Scholar 

  32. P. Svensson and Z.X. Huang. “Geo-SAL: a query language for spatial data analysis,” in 2nd Symposium on Large Spatial Databases, Zurich, Switzerland, 1991.

  33. M. Yuan and J. Albrecht. “Structural analysis of geographic information and GIS operations from a user's perspective,” in Proc. COSIT, Lecture Notes in Computer Science 998, Springer Verlag, 107–122, 1995.

  34. A. Voigtmann, L. Becker, and K. Hinrichs. “A query language for geo-applications,” Bericht Nr. 5/96–1, Institut für Informatik, Westf, Wilhelms-University Munster, Germany, 1996.

    Google Scholar 

  35. M.F. Worboys. “Object-oriented models of spatio-temporal information,” in Proceedings of GIS/LIS'92, San Jose, California, USA, Vol. 2:825–34, 1992.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Geography and Joint Laboratory for Geoinformation Science, The Chinese University of Hong Kong, Shatin, NT, Hong Kong

    Bo Huang & Hui Lin

Authors
  1. Bo Huang
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Hui Lin
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Huang, B., Lin, H. Design of a Query Language for Accessing Spatial Analysis in the Web Environment. GeoInformatica 3, 165–183 (1999). https://doi.org/10.1023/A:1009803811153

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1023/A:1009803811153

Search

Navigation