[postgis-users] PostGIS 2.5.0 released

Sun Sep 23 15:26:52 PDT 2018

The PostGIS development team is pleased to release PostGIS 2.5.0.

Blog: http://postgis.net/2018/09/23/postgis-2.5.0/

Although this release will work for PostgreSQL 9.4 and above, 
to take full advantage of
what PostGIS 2.5 offers, you should be running PostgreSQL 11beta4+ and GEOS
3.7.0.

Best served with PostgreSQL 11beta4+ and pgRouting 2.6.1

WARNING: If compiling with PostgreSQL+JIT, LLVM >= 6 is required
Supported PostgreSQL versions for this release are:
PostgreSQL 9.4 - PostgreSQL 12 (in development)
GEOS >= 3.5

Source: https://download.osgeo.org/postgis/source/postgis-2.5.0.tar.gz

Documentation PDF: English:
https://download.osgeo.org/postgis/docs/postgis-2.5.0.pdf

German:
https://download.osgeo.org/postgis/docs/https://postgis.net/stuff/postgis-2.
5.0-de.pdf

Html Documentation:
https://download.osgeo.org/postgis/docs/doc-html-2.5.0.tar.gz

pgsql help files for non-english languages: 
     German:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-de.tar.gz

     Japanese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-ja.tar.gz

     Korean:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-kr.tar.gz

     Portuguese:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-br.tar.gz 

     Spanish:
https://download.osgeo.org/postgis/docs/pgsql-help-2.5-es.tar.gz

Change Log: https://svn.osgeo.org/postgis/tags/2.5.0/ChangeLog

**New Features**
* 1847, spgist 2d and 3d support for PG 11+
    (Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles
(ULB),
      Darafei Praliaskouski)
* 4056, ST_FilterByM (Nicklas Avén)
* 4050, ST_ChaikinSmoothing (Nicklas Avén)
* 3989, ST_Buffer single sided option (Stephen Knox)
* 3876, ST_Angle function (Rémi Cura)
* 3564, ST_LineInterpolatePoints (Dan Baston)
* 3896, PostGIS_Extensions_Upgrade() (Regina Obe)
* 3913, Upgrade when creating extension from unpackaged (Sandro Santilli)
* 2256, _postgis_index_extent() for extent from index (Paul Ramsey)
* 3176, Add ST_OrientedEnvelope (Dan Baston)
* 4029, Add ST_QuantizeCoordinates (Dan Baston)
* 4063, Optional false origin point for ST_Scale (Paul Ramsey)
* 4082, Add ST_BandFileSize and ST_BandFileTimestamp,
           extend ST_BandMetadata (Even Rouault)
* 2597, Add ST_Grayscale (Bborie Park)
* 4007, Add ST_SetBandPath (Bborie Park)
* 4008, Add ST_SetBandIndex (Bborie Park)

**Breaking Changes**
* 4054, ST_SimplifyVW changed from > tolerance to >= tolerance
* 3885, version number removed from address_standardize lib file
          (Regina Obe)
* 3893, raster support functions can only be loaded in the same schema
           with core PostGIS functions. (Sandro Santilli)
* 4035, remove dummy pgis_abs type from aggregate/collect routines.
           (Paul Ramsey)
* 4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)
* 4082, ST_BandMetaData extended to include filesize, timestamp (Even
Rouault)

**Enhancements and Fixes**
  - Upgrade scripts from multiple old versions are now all symlinks
    to a single upgrade script (Sandro Santilli)
* 3944, Update to EPSG register v9.2 (Even Rouault)
* 3927, Parallel implementation of ST_AsMVT
* 3925, Simplify geometry using map grid cell size before generating MVT
* 3899, BTree sort order is now defined on collections of EMPTY and
           same-prefix geometries (Darafei Praliaskouski)
* 3864, Performance improvement for sorting POINT geometries
           (Darafei Praliaskouski)
* 3900, GCC warnings fixed, make -j is now working (Darafei Praliaskouski)
  - TopoGeo_addLinestring robustness improvements (Sandro Santilli)
    #1855, #1946, #3718, #3838
* 3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)
* 1014, Hashable geometry, allowing direct use in CTE signatures (Paul
Ramsey)
* 3097, Really allow MULTILINESTRING blades in ST_Split() (Paul Ramsey)
* 3942, geojson: Do not include private header for json-c >= 0.13 (Björn
Esser)
* 3954, ST_GeometricMedian now supports point weights (Darafei
Praliaskouski)
* 3965, #3971, #3977, #4071 ST_ClusterKMeans rewritten: better
initialization,
           faster convergence, K=2 even faster (Darafei Praliaskouski)
* 3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY
           (Darafei Praliaskouski)
* 3986, ST_AsText now has second argument to limit decimal digits
           (Marc Ducobu, Darafei Praliaskouski)
* 4020, Casting from box3d to geometry now returns correctly connected
           PolyhedralSurface (Matthias Bay)
* 2508, ST_OffsetCurve now works with collections (Darafei Praliaskouski)
* 4006, ST_GeomFromGeoJSON support for json and jsonb as input
           (Paul Ramsey, Regina Obe)
* 4038, ST_Subdivide now selects pivot for geometry split that reuses input
           vertices. (Darafei Praliaskouski)
* 4025, #4032 Fixed precision issue in ST_ClosestPointOfApproach,
           ST_DistanceCPA, and ST_CPAWithin (Paul Ramsey, Darafei
Praliaskouski)
* 4076, Reduce use of GEOS in topology implementation (Björn Harrtell)
* 4080, Add external raster band index to ST_BandMetaData
  - Add Raster Tips section to Documentation for information about
    Raster behavior (e.g. Out-DB performance, maximum open files)
* 4084: Fixed wrong code-comment regarding front/back of BOX3D (Matthias
Bay)
* 4060, #4094, PostgreSQL JIT support (Raúl Marín, Laurenz Albe)
* 3960, ST_Centroid now uses lwgeom_centroid (Darafei Praliaskouski)
* 4027, Remove duplicated code in lwgeom_geos (Darafei Praliaskouski,
           Daniel Baston)
* 4115, Fix a bug that created MVTs with incorrect property values under
    parallel plans (Raúl Marín).
* 4120, ST_AsMVTGeom: Clip using tile coordinates (Raúl Marín).
* 4132, ST_Intersection on Raster now works without throwing
TopologyException
          (Vinícius A.B. Schmidt, Darafei Praliaskouski)
* 4177, #4180 Support for PostgreSQL 12 dev branch (Laurenz Albe, Raúl
Marín)
* 4156, ST_ChaikinSmoothing: also smooth start/end point of
  polygon by default (Darafei Praliaskouski)

Thanks,
PostGIS Development Team