PostGIS
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

2.2.0 Released!

PostGIS 2.2.0 is released! Over the last two years a number of interesting new features have been added, such as: True nearest-neighbor searching for all geometry and geography types New volumetric geometry support, including ST_3DDifference, ST_3DUnion and more Temporal data model support and functions like ST_ClosestPointOfApproach to support temporal query Spatial clustering functions ST_ClusterIntersecting and ST_ClusterWithin Subdividing large geometries with ST_Subdivide Fast box clipping with ST_ClipByBox2D In-database raster processing with ST_Retile and ST_CreateOverview.
Read more gdoc_arrow_right_alt

2.2.0rc1 Available

This is it, PostGIS 2.2 is almost out the door, so we’re looking for testing and feedback! Please give the release candidate a try and report back any issues you encounter. Download Changelog View all [closed tickets for 2.2.0][1]. [1]:http://trac.osgeo.org/postgis/query?status=closed&groupdesc=1&group=priority&milestone=PostGIS+2.2.0&order=priority

2.1.8 Released

Due to a number of bugs capable of crashing a back-end, we have released 2.1.8. If you are running an earlier version on a public site, we recommend that you update as soon as possible. Download Changelog View all [closed tickets for 2.1.8][1]. [1]:http://trac.osgeo.org/postgis/query?status=closed&groupdesc=1&group=priority&milestone=PostGIS+2.1.8&order=priority

PostGIS 2.0.7 and 2.1.7 Released

Due to a critical bug in GeoJSON ingestion we have made an early release of versions 2.0.7 and 2.1.7. If you are running an earlier version on a public site and accepting incoming GeoJSON, we recommend that you update as soon as possible. Download 2.1.7 Download 2.0.7 View all closed tickets for 2.0.7.

Foreign Data Wrappers for PostGIS

The last couple weeks have seen two interesting updates in the world of PostgreSQL “foreign data wrappers” (FDW). Foreign data wrappers allow you to access remote data inside your database, exactly like other tables. PostgreSQL ships with two example implementations, one for accessing text files, and the other for accessing remote PostgreSQL servers. The two updates of interest to PostGIS users are: The Oracle FDW implementation was recently enhanced to support spatial columns, so an Oracle table with SDO_GEOMETRY columns can be exposed in PostgreSQL as a table with PostGIS geometry columns.
Read more gdoc_arrow_right_alt