[postgis-tickets] [SCM] PostGIS branch stable-3.3 updated. 3.3.0rc2-5-g4464fea52
git at osgeo.org
git at osgeo.org
Fri Aug 26 14:35:22 PDT 2022
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".
The branch, stable-3.3 has been updated
via 4464fea52902bdae4fc33cf9870d3043faa01080 (commit)
via 1550fcc70ee5d9183a5f12a54a87f11006faa7c6 (commit)
via 97892fae085de30dad5ba4d6a6051516262962be (commit)
from 337354f3ad30c4739d30d9c01d414f6345d906d4 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit 4464fea52902bdae4fc33cf9870d3043faa01080
Author: Regina Obe <lr at pcorp.us>
Date: Fri Aug 26 17:35:16 2022 -0400
Prepping for release
diff --git a/NEWS b/NEWS
index 83d901459..fd8a1ec8a 100644
--- a/NEWS
+++ b/NEWS
@@ -1,3 +1,78 @@
+PostGIS 3.3.0
+2022/08/26
+
+This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+Additional features are enabled if you are running GEOS 3.9+
+ST_MakeValid enhancements with 3.10+, ST_ConcaveHull and several other enhancements with GEOS 3.11+.
+Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.
+
+The new --enable-lto flag improves math computations. This new feature is disabled by default
+because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
+
+Use below to enable it.
+
+ ./configure --enable-lto flag
+
+ * New features *
+ - #5116, Topology export/import scripts (Sandro Santilli)
+ - ST_Letters creates geometries that look like letters (Paul Ramsey)
+ - #5037, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)
+ - postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
+ (Loïc Bartoletti)
+ - GH659, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)
+ - #5132, GH683, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)
+ - #5143, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
+ Requires SFCGAL 1.4.1+ (Loïc Bartoletti)
+ - #5162, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)
+ - #5162, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)
+ - #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)
+
+ * Breaking changes *
+ - Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
+ - Change output for WKT MULTIPOINT. All points now
+ wrapped in parens. (Even Roualt)
+ - GH674, geometry validation and fixing is disabled
+ for ST_DumpAsPolygons and ST_Polygon so it works faster
+ but might produce invalid polygons. (Aliaksandr Kalenik)
+
+ * Enhancements *
+ - #2861, Add index on topology.node(containing_face) speeding up
+ splitting and merging of faces (Sandro Santilli)
+ - #2083, Speed up ST_RemEdge topology functions adding index on
+ relation(element_id) and edge_data(abs_next*) (Sandro Santilli)
+ - #5118, Allow dropping topologies with missing topogeometry sequences
+ (Sandro Santilli)
+ - #5111, faster topology face MBR computation (Sandro Santilli)
+ - postgis_extensions_upgrade() support for upgrades from any PostGIS
+ version, including yet to be released ones (Sandro Santilli)
+ - #5040, add postgis_sfcgal_full_version (Loïc Bartoletti)
+ - GH655, GiST: balance the tree splits better in recursive calls (Darafei Praliaskouski)
+ - GH657, GiST: do not call no-op decompress function (Aliaksandr Kalenik)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
+ - ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)
+ - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
+ - GH676, faster ST_Clip (Aliaksandr Kalenik)
+ - #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
+ - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
+ - #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
+ - #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
+ control number of rows per copy statement.
+ Default to 50 when not specified (Regina Obe)
+ - GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
+ - #5024, Update spatial_ref_sys as part of ALTER EXTENSION update postgis (Paul Ramsey)
+
+ * Bug Fix *
+ These are fixes not backported to older minors
+ - #4912, GiST: fix crash on STORAGE EXTERNAL for geography (Aliaksandr Kalenik)
+ - #5088, Memory corruption in mvt_agg_transfn (Victor Collod)
+ - #5137, resetting interrupt flags before query execution (Sergei Shoulbakov)
+ - #5148, ST_Clip is more robust to alignment of raster and clip geometry (Sergei Shoulbakov)
+ - #4932, Bug with geography ST_Intersects / ST_Distance (Paul Ramsey)
+ - #5089, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)
+
PostGIS 3.3.0rc2
2022/08/21
This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
@@ -94,81 +169,6 @@ Changes since PostGIS 3.3.0alpha1
- #5114, pgsql2shp segfault with long or many truncated columns
-PostGIS 3.3.0dev
-2022/xx/xx
-
-This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
-Additional features are enabled if you are running GEOS 3.9+
-ST_MakeValid enhancements with 3.10+, ST_ConcaveHull and several other enhancements with GEOS 3.11+.
-
-The new --enable-lto flag improves math computations. This new feature is disabled by default
-because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)
-
-Use below to enable it.
-
- ./configure --enable-lto flag
-
- * Breaking changes *
- - Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
- - Change output for WKT MULTIPOINT. All points now
- wrapped in parens. (Even Roualt)
- - GH674, geometry validation and fixing is disabled
- for ST_DumpAsPolygons and ST_Polygon so it works faster
- but might produce invalid polygons. (Aliaksandr Kalenik)
-
- * Enhancements *
- - #2861, Add index on topology.node(containing_face) speeding up
- splitting and merging of faces (Sandro Santilli)
- - #2083, Speed up ST_RemEdge topology functions adding index on
- relation(element_id) and edge_data(abs_next*) (Sandro Santilli)
- - #5118, Allow dropping topologies with missing topogeometry sequences
- (Sandro Santilli)
- - #5111, faster topology face MBR computation (Sandro Santilli)
- - postgis_extensions_upgrade() support for upgrades from any PostGIS
- version, including yet to be released ones (Sandro Santilli)
- - #5040, add postgis_sfcgal_full_version (Loïc Bartoletti)
- - GH655, GiST: balance the tree splits better in recursive calls (Darafei Praliaskouski)
- - GH657, GiST: do not call no-op decompress function (Aliaksandr Kalenik)
- - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
- useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
- - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
- - ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)
- - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)
- - GH676, faster ST_Clip (Aliaksandr Kalenik)
- - #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)
- - #4939, #5161, ST_LineMerge now has option to keep the directions of input linestrings,
- useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
- - #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
- - #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
- control number of rows per copy statement.
- Default to 50 when not specified (Regina Obe)
- - GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
- - #5024, Update spatial_ref_sys as part of ALTER EXTENSION update postgis (Paul Ramsey)
-
-
- * New features *
- - #5116, Topology export/import scripts (Sandro Santilli)
- - ST_Letters creates geometries that look like letters (Paul Ramsey)
- - #5037, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)
- - postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
- (Loïc Bartoletti)
- - GH659, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)
- - #5132, GH683, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)
- - #5143, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
- Requires SFCGAL 1.4.1+ (Loïc Bartoletti)
- - #5162, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)
- - #5162, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)
- - #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)
-
- * Bug Fix *
- - #4912, GiST: fix crash on STORAGE EXTERNAL for geography (Aliaksandr Kalenik)
- - #5088, Memory corruption in mvt_agg_transfn (Victor Collod)
- - #5137, resetting interrupt flags before query execution (Sergei Shoulbakov)
- - #5148, ST_Clip is more robust to alignment of raster and clip geometry (Sergei Shoulbakov)
- - #4932, Bug with geography ST_Intersects / ST_Distance (Paul Ramsey)
- - #5089, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)
-
-
PostGIS 3.3.0alpha1
2022/05/21
diff --git a/README.postgis b/README.postgis
index 69aff4158..95f4a6ba3 100644
--- a/README.postgis
+++ b/README.postgis
@@ -1,8 +1,8 @@
PostGIS - Geographic Information Systems Extensions to PostgreSQL
=================================================================
-:Version: 3.3.0rc2
-:Date: 2022-08-21
+:Version: 3.3.0
+:Date: 2022-08-26
:Website: https://postgis.net
This distribution contains a module which implements GIS simple features, ties
@@ -258,6 +258,12 @@ PostGIS support must be enabled for each database that requires its usage.
Enabling spatial functionality requires a PostgreSQL super-user.
CREATE EXTENSION postgis;
+ CREATE EXTENSION postgis_raster;
+ CREATE EXTENSION postgis_sfcgal;
+ CREATE EXTENSION postgis_topology;
+ CREATE EXTENSION address_standardizer;
+ CREATE EXTENSION fuzzystrmatch; -- needed for postgis_tiger_geocoder
+ CREATE EXTENSION postgis_tiger_geocoder;
UPGRADING EXISTING SPATIAL DATABASES
@@ -265,7 +271,9 @@ UPGRADING EXISTING SPATIAL DATABASES
Upgrade PostGIS using the "ALTER EXTENSION" facility.
- ALTER EXTENSION postgis UPDATE TO '2.2.0';
+ ALTER EXTENSION postgis UPDATE;
+ SELECT postgis_extensions_upgrade();
+ SELECT postgis_extensions_upgrade();
USAGE
diff --git a/Version.config b/Version.config
index b7f7afe6e..0be9d9785 100644
--- a/Version.config
+++ b/Version.config
@@ -5,7 +5,7 @@
POSTGIS_MAJOR_VERSION=3
POSTGIS_MINOR_VERSION=3
-POSTGIS_MICRO_VERSION=0dev
+POSTGIS_MICRO_VERSION=0
# Liblwgeom interface versioning, reset to 0:0:0 (cur:age:rev)
# when changing POSTGIS_MINOR_VERSION
diff --git a/ci/winnie/build_postgis.sh b/ci/winnie/build_postgis.sh
index 336b21087..097f3a5d0 100644
--- a/ci/winnie/build_postgis.sh
+++ b/ci/winnie/build_postgis.sh
@@ -155,7 +155,7 @@ LDFLAGS="-Wl,--enable-auto-import -L${PGPATH}/lib -L${PROJECTS}/rel-libiconv-${I
--with-gui --with-gettext=no \
--with-sfcgal=${PROJECTS}/CGAL/rel-sfcgal-${SFCGAL_VER}w${OS_BUILD}${GCC_TYPE}/bin/sfcgal-config \
--without-interrupt-tests \
- --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE} --with-library-minor-version
+ --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE}
#exit
else
CPPFLAGS="-I${PGPATH}/include -I${PROJECTS}/rel-libiconv-${ICON_VER}w${OS_BUILD}${GCC_TYPE}/include" \
@@ -169,7 +169,7 @@ LDFLAGS="-L${PGPATH}/lib -L${PROJECTS}/gdal/rel-${GDAL_VER}w${OS_BUILD}${GCC_TYP
--with-libiconv=${PROJECTS}/rel-libiconv-${ICON_VER}w${OS_BUILD}${GCC_TYPE} \
--with-xsldir=${PROJECTS}/docbook/docbook-xsl-1.76.1 \
--without-interrupt-tests \
- --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE} --with-library-minor-version
+ --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE}
fi;
make clean
diff --git a/ci/winnie/package_postgis.sh b/ci/winnie/package_postgis.sh
index 886ccf1a5..7c18bbca1 100644
--- a/ci/winnie/package_postgis.sh
+++ b/ci/winnie/package_postgis.sh
@@ -253,6 +253,7 @@ export UPGRADEABLE_VERSIONS=$value
export WIN_RELEASED_VERSIONS="2.0.0 2.0.1 2.0.3 2.0.4 2.0.6 2.1.4 2.1.7 2.1.8 2.2.0 2.2.3 2.3.0 2.3.7 2.4.0 2.4.4"
for EXTNAME in postgis postgis_raster postgis_topology postgis_sfcgal postgis_tiger_geocoder address_standardizer; do
cp extensions/$EXTNAME/sql/$EXTNAME--${POSTGIS_MICRO_VER}.sql ${RELDIR}/${RELVERDIR}/share/extension
+ cp extensions/$EXTNAME/sql/*unpackaged*.sql ${RELDIR}/${RELVERDIR}/share/extension
cp extensions/$EXTNAME/sql/$EXTNAME--ANY--${POSTGIS_MICRO_VER}.sql ${RELDIR}/${RELVERDIR}/share/extension
cp extensions/$EXTNAME/sql/$EXTNAME--ANY--${POSTGIS_MICRO_VER}.sql ${RELDIR}/${RELVERDIR}/share/extension/$EXTNAME--${POSTGIS_MINOR_MAX_VER}--${POSTGIS_MICRO_VER}.sql
cp extensions/$EXTNAME/sql/$EXTNAME--ANY--${POSTGIS_MICRO_VER}.sql ${RELDIR}/${RELVERDIR}/share/extension/$EXTNAME--${POSTGIS_MICRO_VER}next--${POSTGIS_MICRO_VER}.sql
diff --git a/ci/winnie/regress_postgis.sh b/ci/winnie/regress_postgis.sh
index b75f02f46..fc250ef7b 100644
--- a/ci/winnie/regress_postgis.sh
+++ b/ci/winnie/regress_postgis.sh
@@ -161,7 +161,7 @@ LDFLAGS="-Wl,--enable-auto-import -L${PGPATH}/lib -L${PROJECTS}/rel-libiconv-${I
--with-gui --with-gettext=no \
--with-sfcgal=${PROJECTS}/CGAL/rel-sfcgal-${SFCGAL_VER}w${OS_BUILD}${GCC_TYPE}/bin/sfcgal-config \
--without-interrupt-tests \
- --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE} --with-library-minor-version
+ --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE}
#exit
else
CPPFLAGS="-I${PGPATH}/include -I${PROJECTS}/rel-libiconv-${ICON_VER}w${OS_BUILD}${GCC_TYPE}/include" \
@@ -174,7 +174,7 @@ LDFLAGS="-L${PGPATH}/lib -L${PROJECTS}/gdal/rel-${GDAL_VER}w${OS_BUILD}${GCC_TYP
--with-libiconv=${PROJECTS}/rel-libiconv-${ICON_VER}w${OS_BUILD}${GCC_TYPE} \
--with-xsldir=${PROJECTS}/docbook/docbook-xsl-1.76.1 \
--without-interrupt-tests \
- --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE} --with-library-minor-version
+ --prefix=${PROJECTS}/postgis/liblwgeom-${POSTGIS_VER}w${OS_BUILD}${GCC_TYPE}
fi;
diff --git a/doc/release_notes.xml b/doc/release_notes.xml
index 8e0ac27a3..250109adc 100644
--- a/doc/release_notes.xml
+++ b/doc/release_notes.xml
@@ -2,6 +2,86 @@
<appendix id="release_notes">
<title>Appendix</title>
<subtitle>Release Notes</subtitle>
+ <sect1>
+ <title>PostGIS 3.3.0</title>
+ <para>2022/08/26</para>
+ <para>This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
+ Additional features are enabled if you are running GEOS 3.9+
+ ST_MakeValid enhancements with 3.10+, numerouse additional enhancements with GEOS 3.11+.
+ Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.</para>
+ <para>NOTE: GEOS 3.11.0 details at <ulink url="https://libgeos.org/posts/2022-07-01-geos-3-11-0-released/">GEOS 3.11.0 release notes</ulink></para>
+ <para>The new configure --enable-lto flag improves speed of math computations. This new feature is disabled by default
+ because on some platforms, causes compilation errors (BSD and MingW64 issues have been raised)</para>
+
+ <simplesect>
+ <title>New features</title>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5116">5116</ulink>, Topology export/import scripts (Sandro Santilli)</para>
+ <para>ST_Letters creates geometries that look like letters (Paul Ramsey)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5037">5037</ulink>, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)</para>
+ <para>postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
+ (Loïc Bartoletti)</para>
+ <para><ulink url="https://github.com/postgis/postgis/pull/659">GH 659</ulink>, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5132">5132</ulink>, <ulink url="https://github.com/postgis/postgis/pull/683">GH 683</ulink>, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5143">5143</ulink>, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
+ Requires SFCGAL 1.4.1+ (Loïc Bartoletti)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5162">5162</ulink>, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5162">5162</ulink>, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5183">5183</ulink>, topology.RemoveUnusedPrimitives (Sandro Santilli)</para>
+ </simplesect>
+
+ <simplesect>
+ <title>Breaking Changes</title>
+ <para>Drop support for PostgreSQL 9.6 and 10 (Regina Obe)</para>
+ <para>Change output for WKT MULTIPOINT. All points now
+ wrapped in parens. (Even Roualt)</para>
+ <para><ulink url="https://github.com/postgis/postgis/pull/674">GH 674</ulink>, geometry validation and fixing is disabled
+ for ST_DumpAsPolygons and ST_Polygon so it works faster
+ but might produce invalid polygons. (Aliaksandr Kalenik)</para>
+ </simplesect>
+
+ <simplesect>
+ <title>Enhancements</title>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/2861">2861</ulink>, Add index on topology.node(containing_face) speeding up
+ splitting and merging of faces (Sandro Santilli)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/2083">2083</ulink>, Speed up ST_RemEdge topology functions adding index on
+ relation(element_id) and edge_data(abs_next*) (Sandro Santilli)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5118">5118</ulink>, Allow dropping topologies with missing topogeometry sequences
+ (Sandro Santilli)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5111">5111</ulink>, faster topology face MBR computation (Sandro Santilli)</para>
+ <para>postgis_extensions_upgrade() support for upgrades from any PostGIS
+ version, including yet to be released ones (Sandro Santilli)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5040">5040</ulink>, add postgis_sfcgal_full_version (Loïc Bartoletti)</para>
+ <para><ulink url="https://github.com/postgis/postgis/pull/655">GH 655</ulink>, GiST: balance the tree splits better in recursive calls (Darafei Praliaskouski)</para>
+ <para><ulink url="https://github.com/postgis/postgis/pull/657">GH 657</ulink>, GiST: do not call no-op decompress function (Aliaksandr Kalenik)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/4939">4939</ulink>, <ulink url="https://trac.osgeo.org/postgis/ticket/5161">5161</ulink>, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)</para>
+ <para>ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)</para>
+ <para>ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul Ramsey, Martin Davis)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/4574">4574</ulink>, <ulink url="https://github.com/postgis/postgis/pull/678">GH 678</ulink>, <ulink url="https://trac.osgeo.org/postgis/ticket/5121">5121</ulink> Enable Link-Time Optimizations using --enable-lto (Sergei Shoulbakov)</para>
+ <para><ulink url="https://github.com/postgis/postgis/pull/676">GH 676</ulink>, faster ST_Clip (Aliaksandr Kalenik)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5135">5135</ulink>, Fast GiST index build is enabled by default for PostgreSQL 15+ (Sergei Shoulbakov)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/4939">4939</ulink>, <ulink url="https://trac.osgeo.org/postgis/ticket/5161">5161</ulink>, ST_LineMerge now has option to keep the directions of input linestrings,
+ useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5158">5158</ulink>, pgtopo_import / pgtopo_export manpages (Sandro Santilli)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5170">5170</ulink>, add a optional max_rows_per_copy to -Y option to raster2pgsql to
+ control number of rows per copy statement.
+ Default to 50 when not specified (Regina Obe)</para>
+ <para><ulink url="https://github.com/postgis/postgis/pull/698">GH 698</ulink>, support parallel aggregate for ST_Union (Sergei Shoulbakov)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5024">5024</ulink>, Update spatial_ref_sys as part of ALTER EXTENSION update postgis (Paul Ramsey)</para>
+ </simplesect>
+
+ <simplesect>
+ <title>Bug Fixes</title>
+ <para>These are fixes issues in prior minors not backported</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/4912">4912</ulink>, GiST: fix crash on STORAGE EXTERNAL for geography (Aliaksandr Kalenik)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5088">5088</ulink>, Memory corruption in mvt_agg_transfn (Victor Collod)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5137">5137</ulink>, resetting interrupt flags before query execution (Sergei Shoulbakov)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5148">5148</ulink>, ST_Clip is more robust to alignment of raster and clip geometry (Sergei Shoulbakov)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/4932">4932</ulink>, Bug with geography ST_Intersects / ST_Distance (Paul Ramsey)</para>
+ <para><ulink url="https://trac.osgeo.org/postgis/ticket/5089">5089</ulink>, ST_Reverse also reverses components of CompoundCurve (Paul Ramsey)</para>
+ </simplesect>
+ </sect1>
+
<sect1>
<title>PostGIS 3.3.0rc2</title>
<para>2022/08/22</para>
diff --git a/extensions/upgradeable_versions.mk b/extensions/upgradeable_versions.mk
index d3c3caaca..b28957b18 100644
--- a/extensions/upgradeable_versions.mk
+++ b/extensions/upgradeable_versions.mk
@@ -77,9 +77,4 @@ UPGRADEABLE_VERSIONS = \
3.2.0 \
3.2.1 \
3.2.2 \
- 3.2.3 \
- 3.3.0alpha1 \
- 3.3.0beta1 \
- 3.3.0beta2 \
- 3.3.0rc1 \
- 3.3.0rc2
+ 3.2.3
commit 1550fcc70ee5d9183a5f12a54a87f11006faa7c6
Author: Regina Obe <lr at pcorp.us>
Date: Fri Aug 26 16:10:12 2022 -0400
Add note that geos 3.10 is required for newer make valid
diff --git a/doc/reference_validation.xml b/doc/reference_validation.xml
index 66862f459..6c46dc8b8 100644
--- a/doc/reference_validation.xml
+++ b/doc/reference_validation.xml
@@ -370,7 +370,7 @@ SELECT ST_IsValidReason('LINESTRING(220227 150406,2220227 150407,222020 150410)'
<para>Enhanced: 2.0.1, speed improvements</para>
<para>Enhanced: 2.1.0, added support for GEOMETRYCOLLECTION and MULTIPOINT.</para>
<para>Enhanced: 3.1.0, added removal of Coordinates with NaN values.</para>
- <para>Enhanced: 3.2.0, added algorithm options, 'linework' and 'structure'.</para>
+ <para>Enhanced: 3.2.0, added algorithm options, 'linework' and 'structure' which requires GEOS >= 3.10.0. </para>
<para>&Z_support;</para>
commit 97892fae085de30dad5ba4d6a6051516262962be
Author: Regina Obe <lr at pcorp.us>
Date: Fri Aug 26 16:07:08 2022 -0400
Backport doc changes
diff --git a/doc/po/de/using_postgis_query.xml.po b/doc/po/de/using_postgis_query.xml.po
index b3b5cb26f..3531820c5 100644
--- a/doc/po/de/using_postgis_query.xml.po
+++ b/doc/po/de/using_postgis_query.xml.po
@@ -6,8 +6,8 @@ msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.kde.org\n"
"POT-Creation-Date: 2022-05-03 02:58+0000\n"
-"PO-Revision-Date: 2022-01-15 01:45+0000\n"
-"Last-Translator: Regina Obe <regina at arrival3d.com>\n"
+"PO-Revision-Date: 2022-08-23 23:30+0000\n"
+"Last-Translator: Juergen E. Fischer <jef at norbit.de>\n"
"Language-Team: German <https://weblate.osgeo.org/projects/postgis/"
"using_postgis_queryxml/de/>\n"
"Language: de\n"
@@ -15,7 +15,7 @@ msgstr ""
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=n != 1;\n"
-"X-Generator: Weblate 4.10.1\n"
+"X-Generator: Weblate 4.13.1\n"
#. Tag: title
#: using_postgis_query.xml:3
@@ -33,12 +33,18 @@ msgid ""
"functions are available, how to use them in queries, and ensuring that "
"appropriate indexes are in place to provide good performance."
msgstr ""
+"Der Sinn von räumlichen Datenbanken liegt darin Abfragen in der Datenbank "
+"ausführen zu können, die normalerweise Desktop-GIS-Funktionionalität "
+"verlangen würden. Um PostGIS effektiv verwenden zu können muss man die "
+"verfügbaren räumlichen Funktionen kennen, wissen wie sie in Abfragen "
+"verwendet werden und sicherstellen, dass für gute Performanz die passenden "
+"Indizes vorhanden sind."
#. Tag: title
#: using_postgis_query.xml:14
#, no-c-format
msgid "Determining Spatial Relationships"
-msgstr ""
+msgstr "Räumliche Beziehungen feststellen"
#. Tag: para
#: using_postgis_query.xml:16
@@ -47,6 +53,8 @@ msgid ""
"Spatial relationships indicate how two geometries interact with one another. "
"They are a fundamental capability for querying geometry."
msgstr ""
+"Räumliche Beziehungen geben an wie zwei Geometrien miteinander interagieren. "
+"Sie sind die fundamentale Fähigkeit zum Abfragen von Geometrie."
#. Tag: title
#: using_postgis_query.xml:21
diff --git a/doc/reference_constructor.xml b/doc/reference_constructor.xml
index ef1c1bfff..9cf04149a 100644
--- a/doc/reference_constructor.xml
+++ b/doc/reference_constructor.xml
@@ -916,9 +916,26 @@ SRID=4326;POLYGON((75 29 1, 77 29 2, 77 29 3, 75 29 1))
<refsection>
<title>Description</title>
- <para>Creates a rectangular Polygon in <ulink url="https://en.wikipedia.org/wiki/Web_Mercator_projection">Web Mercator</ulink> (SRID:3857) using the <ulink url="https://en.wikipedia.org/wiki/Tiled_web_map">XYZ tile system</ulink>. By default, the bounds are the in EPSG:3857 using the standard range of the Web Mercator system (-20037508.342789, 20037508.342789). The optional bounds parameter can be used to generate envelopes for any tiling scheme: provide a geometry that has the SRID and extent of the initial "zoom level zero" square within which the tile system is to be inscribed.</para>
-
- <para>The optional margin parameter can be used to grow a tile by the given percentage, e.g. margin=0.125 grows the tile by 12.5%, which is equivalent to buffer=512 when extent is 4096, as used in <xref linkend="ST_AsMVTGeom" />. This is useful to create a tile buffer -- to include data lying outside of the tile's visible area, but whose existence affects current tile's rendering. For example, a city name (a geopoint) could be near an edge of a tile, but the text would need to render on two tiles, even though the geopoint is located in the visible area of just one tile. Using an expanded tile in a search would include the city geopoint for both tiles. Use negative value to shrink the tile instead. Values less than -0.5 are prohibited because that would eliminate the tile completely. Do not use margin with ST_AsMVTGeom(). See example in <xref linkend="ST_AsMVT" />.</para>
+ <para>Creates a rectangular Polygon
+ giving the extent of a tile in the <ulink url="https://en.wikipedia.org/wiki/Tiled_web_map">XYZ tile system</ulink>.
+ The tile is specifed by the zoom level Z and the XY index of the tile in the grid at that level.
+ Can be used to define the tile bounds required by <xref linkend="ST_AsMVTGeom" /> to convert geometry
+ into the MVT tile coordinate space.
+ </para>
+ <para>By default, the tile envelope is in the <ulink url="https://en.wikipedia.org/wiki/Web_Mercator_projection">Web Mercator</ulink> coordinate system (SRID:3857)
+ using the standard range of the Web Mercator system (-20037508.342789, 20037508.342789).
+ This is the most common coordinate system used for MVT tiles.
+ The optional <varname>bounds</varname> parameter can be used to generate tiles in any coordinate system.
+ It is a geometry that has the SRID and extent of the "Zoom Level zero" square within which the XYZ tile system is inscribed.</para>
+
+ <para>The optional <varname>margin</varname> parameter can be used to expand a tile by the given percentage.
+ E.g. <varname>margin=0.125</varname> expands the tile by 12.5%, which is equivalent to buffer=512 when the tile extent size is 4096, as used in <xref linkend="ST_AsMVTGeom" />.
+ This is useful to create a tile buffer to include data lying outside of the tile's visible area, but whose existence affects the tile rendering.
+ For example, a city name (a point) could be near an edge of a tile, so its label should be rendered on two tiles, even though the point is located in the visible area of just one tile.
+ Using expanded tiles in a query will include the city point in both tiles.
+ Use a negative value to shrink the tile instead. Values less than -0.5 are prohibited because that would eliminate the tile completely.
+ Do not specify a margin when using with <varname>ST_AsMVTGeom</varname>.
+ See the example for <xref linkend="ST_AsMVT" />.</para>
<para>Enhanced: 3.1.0 Added margin parameter.</para>
<para>Availability: 3.0.0</para>
diff --git a/doc/reference_output.xml b/doc/reference_output.xml
index e07bc22c8..29b95d3d7 100644
--- a/doc/reference_output.xml
+++ b/doc/reference_output.xml
@@ -1159,7 +1159,7 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
<refnamediv>
<refname>ST_AsMVTGeom</refname>
- <refpurpose>Transform a geometry into the coordinate space of a <ulink url="https://www.mapbox.com/vector-tiles/">Mapbox Vector Tile</ulink>.</refpurpose>
+ <refpurpose>Transforms a geometry into the coordinate space of a MVT tile.</refpurpose>
</refnamediv>
<refsynopsisdiv>
<funcsynopsis>
@@ -1177,15 +1177,27 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
<refsection>
<title>Description</title>
- <para>Transform a geometry into the coordinate space of a <ulink url="https://www.mapbox.com/vector-tiles/">Mapbox Vector Tile</ulink> of a set of rows corresponding to a Layer.
- Makes best effort to keep and even correct validity and might collapse geometry into a lower dimension in the process.
+ <para>Transforms a geometry into the coordinate space of a MVT (<ulink url="https://www.mapbox.com/vector-tiles/">Mapbox Vector Tile</ulink>) tile,
+ clipping it to the tile bounds if required.
+ The geometry must be in the coordinate system of the target map (using <xref linkend="ST_Transform" /> if needed).
+ Commonly this is <ulink url="https://en.wikipedia.org/wiki/Web_Mercator_projection">Web Mercator</ulink> (SRID:3857).
+ </para>
+ <para>The function attempts to preserve geometry validity, and corrects it if needed.
+ This may cause the result geometry to collapse to a lower dimension.
</para>
-
- <para><varname>geom</varname> is the geometry to transform.</para>
- <para><varname>bounds</varname> is the geometric bounds of the tile contents without buffer.</para>
- <para><varname>extent</varname> is the tile extent in tile coordinate space as defined by the <ulink url="https://www.mapbox.com/vector-tiles/specification/">specification</ulink>. If NULL it will default to 4096.</para>
- <para><varname>buffer</varname> is the buffer distance in tile coordinate space to optionally clip geometries. If NULL it will default to 256.</para>
- <para><varname>clip_geom</varname> is a boolean to control if geometries should be clipped or encoded as is. If NULL it will default to true.</para>
+ <para>The rectangular bounds of the tile in the target map coordinate space must be provided,
+ so the geometry can be transformed, and clipped if required.
+ The bounds can be generated using <xref linkend="ST_TileEnvelope" />.
+ </para>
+ <para>
+ This function is used to convert geometry into the tile coordinate space required by <xref linkend="ST_AsMVT" />.
+ </para>
+
+ <para><varname>geom</varname> is the geometry to transform, in the coordinate system of the target map.</para>
+ <para><varname>bounds</varname> is the rectangular bounds of the tile in map coordinate space, with no buffer.</para>
+ <para><varname>extent</varname> is the tile extent size in tile coordinate space as defined by the <ulink url="https://www.mapbox.com/vector-tiles/specification/">MVT specification</ulink>. Defaults to 4096.</para>
+ <para><varname>buffer</varname> is the buffer size in tile coordinate space for geometry clippig. Defaults to 256.</para>
+ <para><varname>clip_geom</varname> is a boolean to control if geometries are clipped or encoded as-is. Defaults to true.</para>
<para>Availability: 2.4.0</para>
@@ -1196,16 +1208,27 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
<refsection>
<title>Examples</title>
- <programlisting><![CDATA[SELECT ST_AsText(ST_AsMVTGeom(
+ <programlisting>
+SELECT ST_AsText(ST_AsMVTGeom(
ST_GeomFromText('POLYGON ((0 0, 10 0, 10 5, 0 -5, 0 0))'),
ST_MakeBox2D(ST_Point(0, 0), ST_Point(4096, 4096)),
4096, 0, false));
st_astext
--------------------------------------------------------------------
MULTIPOLYGON(((5 4096,10 4091,10 4096,5 4096)),((5 4096,0 4101,0 4096,5 4096)))
-
- ]]>
</programlisting>
+
+ <para>Canonical example for a Web Mercator tile using a computed tile bounds to query and clip geometry.
+ </para>
+ <programlisting>
+<![CDATA[SELECT ST_AsMVTGeom(
+ ST_Transform( geom, 3857 ),
+ ST_TileEnvelope(12, 513, 412), extent => 4096, buffer => 64) AS geom
+ FROM data
+ WHERE geom && ST_TileEnvelope(12, 513, 412, margin => (64.0 / 4096))
+]]>
+</programlisting>
+
</refsection>
<refsection>
@@ -1222,7 +1245,7 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
<refnamediv>
<refname>ST_AsMVT</refname>
- <refpurpose>Aggregate function returning a Mapbox Vector Tile representation of a set of rows.</refpurpose>
+ <refpurpose>Aggregate function returning a MVT representation of a set of rows.</refpurpose>
</refnamediv>
<refsynopsisdiv>
<funcsynopsis>
@@ -1264,8 +1287,8 @@ SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));
<para>An aggregate function which returns a binary <ulink url="https://www.mapbox.com/vector-tiles/">Mapbox Vector Tile</ulink>
representation of a set of rows corresponding to a tile layer.
- The rows should contain a geometry column which will be encoded as a feature geometry.
- The geometry should be in tile coordinate space
+ The rows must contain a geometry column which will be encoded as a feature geometry.
+ The geometry must be in tile coordinate space
and valid as per the <ulink url="https://www.mapbox.com/vector-tiles/specification/">MVT specification</ulink>.
<xref linkend="ST_AsMVTGeom" /> can be used to transform geometry into tile coordinate space.
Other row columns are encoded as feature attributes.
-----------------------------------------------------------------------
Summary of changes:
NEWS | 150 +++++++++++++++++------------------
README.postgis | 14 +++-
Version.config | 2 +-
ci/winnie/build_postgis.sh | 4 +-
ci/winnie/package_postgis.sh | 1 +
ci/winnie/regress_postgis.sh | 4 +-
doc/po/de/using_postgis_query.xml.po | 16 +++-
doc/reference_constructor.xml | 23 +++++-
doc/reference_output.xml | 53 +++++++++----
doc/reference_validation.xml | 2 +-
doc/release_notes.xml | 80 +++++++++++++++++++
extensions/upgradeable_versions.mk | 7 +-
12 files changed, 244 insertions(+), 112 deletions(-)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list