Web client for PostGIS—the concept and implementation

Authors

  • Michal Kepka Geomatics section, Department of Mathematics, Faculty of Applied Sciences, University of West Bohemia, Univerzitní 8, 30614 Plzeň
  • Jan Ježek Geomatics section, Department of Mathematics, Faculty of Applied Sciences, University of West Bohemia, Univerzitní 8, 30614 Plzeň

DOI:

https://doi.org/10.14311/gi.11.5

Keywords:

PostgreSQL, PostGIS

Abstract

PostgreSQL with PostGIS extension plays one of the major roles in many complex GIS frameworks. There exist many possibilities how to access such data storage, but most of them might be seen as not simple for new users. In this paper we would like to introduce the concept of the implementation of a web based PostGIS client application. The main emphasis of described solution is placed on simplicity and straightforward approach for visualisation of general SQL queries.

References

QGIS User Guide. Available: http://www.qgis.org/en/docs/user_manual/index.html

GeoServer Documentation: User Manual. GeoServer [online]. Release 2.4.1. 2013. Available: http://docs.geoserver.org/

MapServer Documentation: MapServer. [online]. Release 6.4.0. 2013. Available: http://mapserver.org/documentation.html

OGC Standards. Open Geospatial Consortium. 2013. [online]. Available: http://www.opengeospatial.org/standards/is

GeoRaptor Documentation. GeoRaptor [online]. Release 3.0.1. 2011. Available: http://sourceforge.net/apps/mediawiki/georaptor/index.php?title=Main_Page

LI, Zhilin. Algorithmic foundation of multi-scale spatial representation. Boca Raton, FL: CRC Press, c2007, 280 p. ISBN 978-084-9390-722.

Google Inc. KML Documentation. 2012. [online]. Available: https://developers.google.com/kml/documentation/

Refractions Research Inc. PostGIS 1.5 Manual. SVN Revision (11757). 2012. [online]. Available: http://postgis.net/docs/manual-1.5/index.html

Visigoth Software Society. FreeMarker Manual. Version 2.3.20. 2013. [online]. Available: http://freemarker.org/

Fielding, Roy Thomas. Architectural Styles and the Design of Network-based Software Architectures. Chapter 5: Representational State Transfer (REST). Doctoral dissertation, University of California, Irvine, 2000. Available: http://www.ics.uci.edu/~fielding/pubs/dissertation/rest_arch_style.htm

MacQueen, J. B. (1967). Some Methods for classification and Analysis of Multivariate Observations. In Proceedings of 5th Berkeley Symposium on Mathematical Statistics and Probability Vol. 1. University of California Press. 1967. pp. 281–297. Available: http:

//projecteuclid.org/euclid.bsmsp/1200512992

Hartigan, J. A. and Wong, M. A. Algorithm AS 136: A K-Means Clustering Algorithm. Journal of the Royal Statistical Society. Series C (Applied Statistics), Vol. 28, No. 1 1979. pp. 100-108. Available: http://www.jstor.org/stable/2346830

Harada Hitoshi. Kmeans 1.1.0. Plugin for PostgreSQL. Release 22. 7. 2011. [online]. Available: http://pgxn.org/dist/kmeans/

Skála, Jiří. Algorithms for manipulating large geometric data. Ph.D. dissertation. Fakulta aplikovaných věd, Západočeská univerzita v Plzni, Plzeň. 2012.

Marvalová, Jindra. Správa a vizualizace časoprostorových bodových dat. Bachelor thesis. Fakulta aplikovaných věd, Západočeská univerzita v Plzni, Plzeň. 2013.

Niemeyer, Gustavo. Geohash. [online]. Available: http://geohash.org/

GNIEMEYER. Geohash. In: Wikipedia: the free encyclopedia. [online]. San Francisco (CA): Wikimedia Foundation, 2001- [cit. 2013-09-19]. Available: http://en.wikipedia.org/wiki/Geohash

Van Tulder, Gijs. Storing Hierarchical Data in a Database. Sitepoint. 30.4.2013. [online]. Available: http://www.sitepoint.com/hierarchical-data-database/

Downloads

Published

2013-12-28

Issue

Vol. 11 (2013)

Section

Articles

License

    1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
    2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
    3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).