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). 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…

PostGIS 2.1.0beta2 Released

The 2.1.0beta2 release of PostGIS is now available.

The PostGIS development team is proud to release a feature complete beta version of upcoming PostGIS 2.1.0. As befits a minor release, the focus is on speed improvements, more features, and bug fixes. While this beta release is feature complete, we expect some bugs and we’d appreciate it if you test it before final release and report back with any issues you run into so we can have a smooth release.

If you are currently using PostGIS 2.0+, you can go the soft upgrade path: ALTER EXTENSION postgis UPDATE TO “2.1.0beta2”;

Users of 1.5 and below will need to go the hard-upgrade path.

Best served with a bottle of GEOS 3.4.0dev and PostgreSQL 9.3beta1. (which will also be released soon)

http://download.osgeo.org/postgis/source/postgis-2.1.0beta2.tar.gz

html doc download pdf doc download epub doc download

This release contains a ton of speed improvements, function additions , and super sexy new features. It has been over a year in the making.

Enhancements

documentation now also available in epub format
Faster geography distance and intersects, more functions for geography
index selectivity and stats improvements for both geometry and geography which means complicated queries should be planned more efficiently
significantly faster raster operations particularly union and clipping
multi-band union support and mapalgebra
better raster out-db and non-georeferenced rasters (like pictures)
bug fixes and some new functions for topology
support for PostgreSQL 9.3
tiger geocoder now can be installed with CREATE EXTENSION postgis_tiger_geocoder;

New Features

New functions itemized in http://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewFunctions21

more functions for geography
more functions for geometry (need geos 3.4.0 to take advantage of many new ones)
more functions for topology
overflowing number of new functions for raster
advanced 3D support via SFCGAL module (requires compilation with SFCGAL) Refer to matrix to see which functions utilize SFCGAL http://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#PostGIS_TypeFunctionMatrix
tiger geocoder support for TIGER 2012
tiger geocoder can now use pagc address standardizer extension for better normalization of addresses using pagc_normalize_address (requires installing pagc address_standardizer PostgreSQL extension) http://pagc.svn.sourceforge.net/viewvc/pagc/branches/sew-refactor/postgresql/?view=tar

Team PostGIS

View all closed tickets.

PostGIS 2.0.3 Released

The 2.0.3 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2, the 2.0.3 release. As befits a patch release, the focus is on bugs and breakages.

Best served with a bottle of GEOS 3.3.8.

http://download.osgeo.org/postgis/source/postgis-2.0.3.tar.gz

html doc download pdf doc download

Bug Fixes

#2126, Better handling of empty rasters from ST_ConvexHull()
#2134, Make sure to process SRS before passing it off to GDAL functions
Fix various memory leaks in liblwgeom
#2173, Fix robustness issue in splitting a line with own vertex also affecting topology building (#2172)
#2174, Fix usage of wrong function lwpoly_free()
#2176, Fix robustness issue with ST_ChangeEdgeGeom
#2184, Properly copy topologies with Z value
postgis_restore.pl support for mixed case geometry column name in dumps
#2188, Fix function parameter value overflow that caused problems when copying data from a GDAL dataset
#2216, More memory errors in MultiPolygon GeoJSON parsing (with holes)
Fix Memory leak in GeoJSON parser