About PostGIS

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

SELECT superhero.name
FROM city, superhero
WHERE ST_Contains(city.geom, superhero.geom)
AND city.name = 'Gotham';

In addition to basic location awareness, PostGIS offers many features rarely found in other competing spatial databases such as Oracle Locator/Spatial and SQL Server. Refer to PostGIS Feature List for more details.

License

PostGIS is released under the GNU General Public License (GPLv2 or later). Refer to License FAQ for more information. PostGIS is developed by a group of contributors led by a Project Steering Committee.

News

What's happening right now

Blogs, Tweets and more…

Follow @postgis

PostGIS 2.4.0alpha Released

The PostGIS development team is pleased to announce the release of PostGIS 2.4.0alpha. This is the first version to support PostgreSQL 10. Best served with PostgreSQL 10beta2. See the full list of changes in the news file.

Source Download
html doc download (this version includes Japanese translation postgis-ja.html)
pdf doc download
epub doc download
ChangeLog

PostGIS 2.3.3 Released

The PostGIS development team is pleased to announce the release of PostGIS 2.3.3 As befits a patch release, the focus is on bugs and breakages. Best served with PostgreSQL 9.6.3+ and pgRouting 2.4.1.

PostGIS 2.3.2 Released

The PostGIS development team is pleased to announce the release of PostGIS 2.3.2 As befits a patch release, the focus is on bugs and breakages. Best served with PostgreSQL 9.6.1+ and pgRouting 2.3.2.

PostGIS 2.2.5 Released

The PostGIS development team is pleased to announce the release of PostGIS 2.2.5 As befits a patch release, the focus is on bugs and breakages.

More News…

Upcoming Events

PGConf US Local: Seattle August 11th-12th, 2017 in Seattle, WA, USA

FOSS4G 2017, Boston, MA, USA, August 14th - 18th 2017

Boston, MA, USA, August 14th-19th 2017

PostgresOpen 2017
Silicon Valley, CA September 6-8th

Recent past events

Postgres Vision 2017,
Boston, MA, USA June 26th-28th 2017

PGConf 2017
May 23-26th Ottawa, Ontario

PGConf US March 28-31st, 2017 in Jersey City, NJ, USA

PgCon Silicon Valley, California, US November 14-16 2016

PostgreSQL Sessions, 22 Sept 2016, Lyon France

Tips

Causes for 'postgis.backend' is already set

The error ‘postgis.backend’ is already set comes up every so often in PostGIS mailing list. The issue arises often during or after an upgrade. I’ll go over causes for this I am aware of and how to fix.

The question goes something like this

After upgrading to Postgis 2.3 from 2.1, my server log is filled with these messages :

“WARNING ‘postgis.backend’ is already set and cannot be changed until you reconnect”

More Tips…

Case Studies

Nautilytics Case Study

Nautilytics is a small data visualization and GIS startup based out of Boston, MA. We use PostGIS and PostgreSQL, among other open-source tools to build powerful web applications for US government organizations, public, and private sector companies.

PostGIS for fast prototyping and Research

I used extensively postgis (+ecosystem) for my phd thesis, in several ways. The first is that PostGIS is a good steady horse (elephant?): a database is the perfect place to store a lot of very different information in the same place and put them in relation. For geospatial data, postgis means you always have a way to put data in relation (are they at the same place?).

More Case Studies…

PostGIS

Spatial and Geographic objects for PostgreSQL

About PostGIS

License

News

What's happening right now

PostGIS 2.4.0alpha Released

PostGIS 2.3.3 Released

PostGIS 2.3.2 Released

PostGIS 2.2.5 Released

Upcoming Events

Recent past events

Tips

Causes for 'postgis.backend' is already set

Case Studies

Nautilytics Case Study

PostGIS for fast prototyping and Research

Site Map

PostGIS Project Steering Committee (PSC)