PostGIS: Difference between revisions

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
VisualWikitext
imported>Marko H Zajc
m Update latest minor version for 3.5
 
imported>Rich Farmbrough
Copyedit. Date formats.
 
Line 5: Line 5:
| logo size = 150px
| logo size = 150px
| developer = Refractions Research, Paul Ramsey, Dave Blasby, Mark Cave-Ayland, Regina Obe, Sandro Santilli,  Olivier Courtin, Nicklas Avén, Bborie Park, Pierre Racine, Daniel Baston, Darafei Praliaskouski, Raúl Marín Rodríguez, Kevin Neufeld, Jeff Lounsbury, Chris Hodgson, Jorge Arévalo, Mateusz Loskot, Norman Vine, Carl Anderson, Ralph Mason, Klaus Foerster,  Bruno Wolff III, Markus Schaber
| developer = Refractions Research, Paul Ramsey, Dave Blasby, Mark Cave-Ayland, Regina Obe, Sandro Santilli,  Olivier Courtin, Nicklas Avén, Bborie Park, Pierre Racine, Daniel Baston, Darafei Praliaskouski, Raúl Marín Rodríguez, Kevin Neufeld, Jeff Lounsbury, Chris Hodgson, Jorge Arévalo, Mateusz Loskot, Norman Vine, Carl Anderson, Ralph Mason, Klaus Foerster,  Bruno Wolff III, Markus Schaber
| released = {{Start date|2001|04|19}}
| released = {{Start date|2001|04|19|df=y}}
| latest release version = {{wikidata|property|preferred|references|edit|P348|P548=Q2804309}}                                   | latest release date    = {{Start date and age|{{wikidata|qualifier|preferred|single|P348|P548=Q2804309|P577}}|df=yes}}
| latest release version = {{wikidata|property|preferred|references|edit|P348|P548=Q2804309}}
| latest release date    = {{Start date and age|{{wikidata|qualifier|preferred|single|P348|P548=Q2804309|P577}}|df=yes}}
| operating_system = [[Linux]], [[Microsoft Windows|Windows]], [[Mac OS X]], [[POSIX]]-compliant systems
| operating_system = [[Linux]], [[Microsoft Windows|Windows]], [[Mac OS X]], [[POSIX]]-compliant systems
| genre = [[Geographic information system]]
| genre = [[Geographic information system]]
Line 18: Line 19:


==Features==
==Features==
* Geometry types for Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons, GeometryCollections, 3D types TINS and polyhedral surfaces, including solids.
* Geometry types for Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons, GeometryCollections, 3D types TINS and polyhedral surfaces, including solids.
* Spheroidal types under the geography datatype Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons and GeometryCollections.
* Spheroidal types under the geography datatype Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons and GeometryCollections.
Line 33: Line 33:
PostGIS is registered as "implements the specified standard" for "Simple Features for SQL" by the OGC.<ref>[http://www.opengeospatial.org/resource/products/details/?pid=509 OGC Implementing Product Details] Open Geospatial Consortium</ref> PostGIS has not been certified as compliant by the OGC.
PostGIS is registered as "implements the specified standard" for "Simple Features for SQL" by the OGC.<ref>[http://www.opengeospatial.org/resource/products/details/?pid=509 OGC Implementing Product Details] Open Geospatial Consortium</ref> PostGIS has not been certified as compliant by the OGC.


== History ==
==History==
{{Cquote|May of 2001, at that point I was running a small consulting company here in Victoria, working for the provincial government, mostly working in the geospatial field. Because all of our contracts came from the provincial government, we were very tied to the cycle of when they would release and sign contracts. And the government changed that year, so all the civil servants were very risk averse in terms of signing new contract contracts. They didn't know whether what their budget situation was going to be that year.<br><br>
{{Cquote|May of 2001, at that point I was running a small consulting company here in Victoria, working for the provincial government, mostly working in the geospatial field. Because all of our contracts came from the provincial government, we were very tied to the cycle of when they would release and sign contracts. And the government changed that year, so all the civil servants were very risk averse in terms of signing new contract contracts. They didn't know whether what their budget situation was going to be that year.<br><br>


So we ended up having like three months where we got almost no direct revenue. We, you know, didn't all go on vacation for three months. We were kind of young, excited about the field. So we thought, you know, let's see if we can build something to store the spatial data in a database. And we had used Postgres for one of our data processing projects the year previous, so we were kind of familiar with it. And that experimental work in the spring of 2001 ended up being released at the end of May 2001 as PostGIS version 0.1. |||Paul Ramsey (September 8, 2023) "[https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe/transcript Why people care about PostGIS and Postgres]" Path To Citus Con}}
So we ended up having like three months where we got almost no direct revenue. We, you know, didn't all go on vacation for three months. We were kind of young, excited about the field. So we thought, you know, let's see if we can build something to store the spatial data in a database. And we had used Postgres for one of our data processing projects the year previous, so we were kind of familiar with it. And that experimental work in the spring of 2001 ended up being released at the end of May 2001 as PostGIS version 0.1. |||Paul Ramsey (8 September 2023) "[https://pathtocituscon.transistor.fm/episodes/why-people-care-about-postgis-and-postgres-with-paul-ramsey-regina-obe/transcript Why people care about PostGIS and Postgres]" Path To Citus Con}}
Refractions Research released the first version of PostGIS in 2001 under the [[GNU General Public License]]. After six [[release candidate]]s, a stable "1.0" version followed on April 19, 2005.
Refractions Research released the first version of PostGIS in 2001 under the [[GNU General Public License]]. After six [[release candidate]]s, a stable "1.0" version followed on 19 April 2005.


In 2006 the OGC registered PostGIS  as "implement[ing] the specified standard" for "Simple Features for SQL".<ref name="history">[http://refractions.net/products/postgis/history/ PostGIS History]</ref>
In 2006 the OGC registered PostGIS  as "implement[ing] the specified standard" for "Simple Features for SQL".<ref name="history">[http://refractions.net/products/postgis/history/ PostGIS History]</ref>
Line 168: Line 168:
* [[uDig]] (LGPL)
* [[uDig]] (LGPL)


== See also ==
==See also==
{{Portal|Free and open-source software}}
{{Portal|Free and open-source software}}
* [[Well-known text]] and binary, descriptions of geospatial objects used within PostGIS
* [[Well-known text]] and binary, descriptions of geospatial objects used within PostGIS
Line 178: Line 178:
==External links==
==External links==
* {{Official website}}
* {{Official website}}
{{Authority control}}
{{Use dmy dates|date=June 2025}}


{{DEFAULTSORT:Postgis}}
{{DEFAULTSORT:Postgis}}

Latest revision as of 14:01, 3 June 2025

Template:Short description Script error: No such module "Infobox".Template:Template otherScript error: No such module "Check for unknown parameters".Template:Main other

PostGIS (Template:IPAc-en Template:Respell) is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC).

PostGIS is implemented as a PostgreSQL external extension.[1]

Features

  • Geometry types for Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons, GeometryCollections, 3D types TINS and polyhedral surfaces, including solids.
  • Spheroidal types under the geography datatype Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons and GeometryCollections.
  • raster type - supports various pixel types and more than 1000 bands per raster. Since PostGIS 3, is a separate PostgreSQL extension called postgis_raster.
  • SQL/MM Topology support - via PostgreSQL extension postgis_topology.
  • Spatial predicates for determining the interactions of geometries using the 3x3 DE-9IM (provided by the GEOS software library).
  • Spatial operators for determining geospatial measurements like area, distance, length and perimeter.
  • Spatial operators for determining geospatial set operations, like union, difference, symmetric difference and buffers (provided by GEOS).
  • R-tree-over-GiST (Generalized Search Tree) spatial indexes for high speed spatial querying.
  • Index selectivity support, to provide high performance query plans for mixed spatial/non-spatial queries.

The PostGIS implementation is based on "light-weight" geometries and indexes optimized to reduce disk and memory footprint. Using light-weight geometries helps servers increase the amount of data migrated up from physical disk storage into RAM, improving query performance substantially.

PostGIS is registered as "implements the specified standard" for "Simple Features for SQL" by the OGC.[2] PostGIS has not been certified as compliant by the OGC.

History

Template:Main other Refractions Research released the first version of PostGIS in 2001 under the GNU General Public License. After six release candidates, a stable "1.0" version followed on 19 April 2005.

In 2006 the OGC registered PostGIS as "implement[ing] the specified standard" for "Simple Features for SQL".[3]

Release history (as of 29th September 2024)
Release First release Latest minor version Latest release
1.0 2005-04-19 Template:Version 2005-12-06[4]
1.1 2005-12-21 Template:Version 2007-01-31[3]
1.2 2006-12-08 Template:Version 2007-01-11[5]
1.3 2007-08-09 Template:Version 2009-05-06[6]
1.4 2009-07-24 Template:Version 2010-03-11[7]
1.5 2010-02-04 Template:Version 2012-11-15[8]
2.0 2012-04-03 Template:Version 2015-04-06[9]
2.1 2013-08-17 Template:Version 2017-09-19[10]
2.2 2015-10-07 Template:Version 2018-11-22[11]
2.3 2016-09-26 Template:Version 2019-08-11[12]
2.4 2017-09-30 Template:Version 2022-04-24[13]
2.5 2018-09-23 Template:Version 2022-11-12[14]
3.0 2019-10-20 Template:Version 2023-05-29[15]
3.1 2020-12-18 Template:Version 2023-05-29[15]
3.2 2021-12-18 Template:Version 2023-05-29[15]
3.3 2023-05-29 Template:Version 2023-07-28[16]
3.4 2023-08-15 Template:Version 2024-09-04[17]
3.5 2025-01-18 Template:Version 2025-01-18[18]

Template:Version

Users

Many software products can use PostGIS as a database backend, including:

See also

Script error: No such module "Portal".

  • Well-known text and binary, descriptions of geospatial objects used within PostGIS
  • DE-9IM, the Dimensionally Extended nine-Intersection Model used by PostGIS

References

Template:Reflist

External links

Template:Authority control Template:Use dmy dates

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ OGC Implementing Product Details Open Geospatial Consortium
  3. ↑ a b PostGIS History
  4. ↑ PostGIS 1.0.6 Released
  5. ↑ PostGIS 1.2.1 Release
  6. ↑ PostGIS 1.3.6 Release
  7. ↑ PostGIS 1.4.2 Release
  8. ↑ PostGIS 1.5.8 Released
  9. ↑ PostGIS 2.0.7 and 2.1.7 Released
  10. ↑ PostGIS 2.1.9 Released
  11. ↑ PostGIS 2.2.8 EOL
  12. ↑ PostGIS 3.0.0alpha4, 2.5.3, 2.4.8, 2.3.10 Released
  13. ↑ PostGIS 2.4.10 Released
  14. ↑ PostGIS 2.5.9 Released
  15. ↑ a b c Script error: No such module "citation/CS1".
  16. ↑ Script error: No such module "citation/CS1".
  17. ↑ Script error: No such module "citation/CS1".
  18. ↑ Script error: No such module "citation/CS1".
Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=PostGIS&oldid=648846"