Definition
PostGIS is a spatial database extension for the PostgreSQL (SQL being structured query language) object-relational database. It is certified as a compliant “Simple Features for SQL” database by the Open Geospatial Consortium (OGC).
PostGIS adds geometry data types and spatial functions to the PostgreSQL database. The supported geometry data types are “Points,” “LineStrings,” “Polygons,” “MultiPoints,” “MultiLineStrings,” “MultiPolygons” and “GeometryCollections”. Spatial functions enable the analysis and processing of geographic information systems (GIS) objects. Examples are measurement functions like “Area,” “Distance,” “Length” and “Perimeter” and spatial operators like “Union,” “Difference,” “Symmetric Difference” and “Buffer”. Topological relationships, like “Equals,” “Disjoint,” “Intersects,” “Touches,”...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Free Software Foundation (1991) GNU general public license. http://www.gnu.org/copyleft/gpl.html. Accessed 1 Jan 2007
GEOS (2006) Geometry engine open source. http://geos.refractions.net. Accessed 1 Jan 2007
Guttman A (1984) R-trees: a dynamic index structure for spatial searching. In: Proceedings of ACM SIGMOD international conference on management of data, Boston, 18–21 June 1984
Hellerstein JM, Naughton JF, Pfeffer A (1995) Generalized search trees for database systems. In: Proceedings of the 21st international conference on very large data bases, Zürich, 11–15 Sept 1995
ISO/TC211 (2003) ISO 19107 Geographic information-spatial schema. ISO
ISO/IEC (2006) ISO/IEC 13249-3: information technology-database languages-SQL multimedia and application packages. Part 3, Spatial
Nebert DD (2004) Developing spatial data infrastructures: the SDI cookbook, version 2.0. http://www.gsdi.org/pubs/cookbook/cookbookV2.0.pdf. Accessed 12 Oct 2005
OGC (ed) (1999) OpenGIS simple features specification for SQL (Revision 1.1). OGC
OGP Surveying & Positioning Committee (2006) EPSG geodetic parameter dataset v 6.11.2. http://www.epsg.org. Accessed 1 Jan 2007
PostgreSQL Global Development Group (2007) PostgrSQL. http://www.postgresql.org/. Accessed 1 Jan 2007
PROJ.4 (2000) Cartographic projections library. http://www.remotesensing.org/proj. Accessed 1 Jan 2007
Refractions Research (2007) PostGIS. http://postgis.refractions.net/. Accessed 1 Jan 2007
Rigaux P, Scholl M, Voisard A (2002) Spatial databases: with application to GIS. Morgan Kaufmann, San Fransisco
Shekhar S, Chawla S (2003) Spatial databases: a tour. Prentice Hall, Upper Saddle River
Sigaev T, Bartunov O (2006) GiST for PostgreSQL. http://www.sai.msu.su/~megera/postgres/gist. Accessed 1 Jan 2007
The GiST Indexing Project (1999) GiST: a generalized search tree for secondary storage. http://gist.cs.berkeley.edu. Accessed 1 Jan 2007
University of California (Berkeley) (1999) The BSD license. http://www.opensource.org/licenses/bsd-license.php. Accessed 1 Jan 2007
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this entry
Cite this entry
Strobl, C. (2017). PostGIS. In: Shekhar, S., Xiong, H., Zhou, X. (eds) Encyclopedia of GIS. Springer, Cham. https://doi.org/10.1007/978-3-319-17885-1_1012
Download citation
DOI: https://doi.org/10.1007/978-3-319-17885-1_1012
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-17884-4
Online ISBN: 978-3-319-17885-1
eBook Packages: Computer ScienceReference Module Computer Science and Engineering