The PostGIS development team released version 2.5.0 of PostGIS, a spatial database extender for PostgreSQL, yesterday. PostGIS 2.5.0 explores new features, breaking changes, improvements, and fixes.
PostGIS is an open source software program which provides support for geographic objects to the PostgreSQL object-relational database. PostGIS comprises simple features for SQL specification from the Open Geospatial Consortium (OGC).
ST_OrientedEnvelope (Returns a minimum rotated rectangle enclosing a geometry) and ST_QuantizeCoordinates (Sets least significant bits of coordinates to zero) have been added in PostGIS 2.5.0.
Apart from that, other new features such as ST_FilterByM (Filters vertex points based on their m-value) and ST_ChaikinSmoothing (Returns a “smoothed” version of the given geometry with the help of Chaikin algorithm) have also been added in PostGIS 2.5.0.
The Version number has been removed from address_standardize lib file in PostGIS 2.5.0. The raster support functions can be loaded only in the same schema with core PostGIS functions. The dummy pgis_abs type has been removed from aggregate/collect routines. Support has been removed for drop support GEOS < 3.5 and PostgreSQL < 9.4.
For more information on other updates and fixes in PostGIS 2.5.0, check out the official release notes.
Writing PostGIS functions in Python language [Tutorial]
Adding PostGIS layers using QGIS [Tutorial]
PostGIS extension: pgRouting for calculating driving distance [Tutorial]
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed…
Key takeaways The transformer architecture has proved to be revolutionary in outperforming the classical RNN…
Once we learn how to deploy an Ubuntu server, how to manage users, and how…
Key-takeaways: Clean code isn’t just a nice thing to have or a luxury in software projects; it's a necessity. If we…
While developing a web application, or setting dynamic pages and meta tags we need to deal with…
Software architecture is one of the most discussed topics in the software industry today, and…