Re: [OSGeo-Discuss] PostGIS 2.5.0 released

2018-09-23 Thread Regina Obe 
Well they just released PostgreSQL 11 Beta4.  I expect RC1 will follow.

I heard they are planning for Mid-Late October.

 

 

 

From: Jody Garnett [mailto:jody.garn...@gmail.com] 
Sent: Sunday, September 23, 2018 6:37 PM
To: Regina Obe 
Cc: David Fetter ; PostGIS Development Discussion 
; PostGIS Users Discussion 
; discuss@lists.osgeo.org; 
pgsql-annou...@postgresql.org
Subject: Re: [OSGeo-Discuss] PostGIS 2.5.0 released

 

Congrats! When is PostgreSQL 11 expected?

 

On Sun, Sep 23, 2018 at 3:27 PM Regina Obe mailto:l...@pcorp.us> > wrote:

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. 
<https://download.osgeo.org/postgis/docs/https:/postgis.net/stuff/postgis-2.5.0-de.pdf>
 
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
   (M

Re: [OSGeo-Discuss] PostGIS 2.5.0 released

2018-09-23 Thread Jody Garnett 
Congrats! When is PostgreSQL 11 expected?

On Sun, Sep 23, 2018 at 3:27 PM Regina Obe  wrote:

> 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 inp

[OSGeo-Discuss] PostGIS 2.5.0 released

2018-09-23 Thread Regina Obe 
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 exter