Never get lost again with PostGIS

Find your way with PostGIS 2.5.0 for PostgreSQL database support

Jane Elizabeth
©  Shutterstock / Triff

Looking for additional support for your PostgreSQL databases? Thanks to PostGIS 2.5.0, you’ll never lose your way in a PostgreSQL database. This release comes with a number of new features and bugfixes that will support the database of your dreams.

PostGIS, the open source software that adds support for geographic objects to the PostgreSQL database, is back with even more features and bug fixes. This spatial database extender makes it possible to run location queries, meaning you’ll never get lost in the PostgreSQL data stacks again.

PostgreSQL is one of the most popular open source database management servers out there. We should know – PostgreSQL ranked number 1 in our last survey on favorite DB managers. Fans include Reddit, Spotify, the popular e-commerce site Zalando, and more.

PostGIS 2.5.0

The latest offering from PostGIS gives developers even more support for their PostgreSQL needs. It already adds extra types, functions, operators, and index entries to support spatial types in PostgreSQL databases. Used together, PostGIS makes PostgreSQL a fast, feature-plenty, and robust spatial database management system.

New features in 2.5.0 include:

  • spgist 2d and 3d support for PG 11
  • ST_FilterByM, ST_ChaikinSmoothing, ST_Buffer single sided option, ST_Angle function, and ST_LineInterpolatePoints
  • Upgrades for PostGISExtensionsUpgrade()
  • Upgrade when creating extension from unpackaged
  • postgisindex_extent() for extent from index
  • Add ST_OrientedEnvelope and ST_QuantizeCoordinates
  • Optional false origin point for ST_Scale
  • Add STBandFileSize and STBandFileTimestamp
  • Extend ST_BandMetadata
  • Add ST_Grayscale, ST_SetBandPath, and ST_SetBandIndex

SEE ALSO: Getting started with PostGIS

Other enhancements include:

  • Upgrade scripts from multiple old versions are now all symlinks to a single upgrade script
  • Parallel implementation of ST_AsMVT
  • Simplify geometry using map grid cell size before generating MVT
  • Performance improvement for sorting POINT geometries
  • GCC warnings fixed, make -j is now working
  • TopoGeo_addLinestring robustness improvements
  • Do not accept EMPTY points as topology nodes
  • Hashable geometry, allowing direct use in CTE signatures
  • ST_GeometricMedian now supports point weights
  • Casting from box3d to geometry now returns correctly connected PolyhedralSurface
  • And more!

Of course, there are some breaking changes in this update. Do be careful if you are using a version of GEOS lower than 3.5 or PostgreSQL 9.4, as PostGIS no longer supports either. Additionally, there are some minor changes for raster support functions, ST_BandMetaData, and ST_SimplifyVW. Check out the release notes for more information.

Getting PostGIS 2.5.0

To really take advantage of everything this release has to offer, developers should be running PostgreSQL 11beta4+ and GEOS 3.7.0. However, it will work with PostgreSQL 9.4+. The source download for 2.5.0 is available here.

The full changelog is available here.

baby its the way that you gouge me

Jane Elizabeth
Jane Elizabeth is an assistant editor for

Inline Feedbacks
View all comments