[Git][debian-gis-team/postgis][upstream] New upstream version 3.3.0+dfsg
Bas Couwenberg (@sebastic)
gitlab at salsa.debian.org
Sat Aug 27 14:56:26 BST 2022
Bas Couwenberg pushed to branch upstream at Debian GIS Project / postgis
Commits:
279e9037 by Bas Couwenberg at 2022-08-27T15:05:50+02:00
New upstream version 3.3.0+dfsg
- - - - -
14 changed files:
- ChangeLog
- NEWS
- README.md
- README.postgis
- Version.config
- doc/po/de/using_postgis_query.xml.po
- doc/reference_constructor.xml
- doc/reference_output.xml
- doc/reference_validation.xml
- doc/release_notes.xml
- extensions/address_standardizer/Makefile
- extensions/postgis_raster/Makefile
- extensions/upgradeable_versions.mk
- postgis_revision.h
Changes:
=====================================
ChangeLog
=====================================
The diff for this file was not included because it is too large.
=====================================
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
=====================================
README.md
=====================================
@@ -3,13 +3,13 @@
| **Debbie** | **Winnie** | **Dronie** |
| --------- | ---------- | --------- |
-| [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_trunk/) | [](https://winnie.postgis.net/view/PostGIS/job/PostGIS_trunk/) | [](https://dronie.osgeo.org/postgis/postgis?branch=master) ||
+| [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_3.3/) | [](https://winnie.postgis.net/view/PostGIS/job/PostGIS_3.3/) | [](https://dronie.osgeo.org/postgis/postgis?branch=stable-3.3) ||
| **Bessie** | **Bessie32** | **Cirrus-CI** |
-| [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie/) | [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32/) | [](http://cirrus-ci.com/github/postgis/postgis) |
+| [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie/) | [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32/) | [](http://cirrus-ci.com/github/postgis/postgis) |
| **Berrie** | **Berrie64** |
-| [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie/) | [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64/) | ||
+| [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie/) | [](https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64/) | ||
| **GitHub** | **GitLab** |
-| [](https://github.com/postgis/postgis/actions?query=branch%3Amaster) | [](https://gitlab.com/postgis/postgis/commits/master) ||
+| [](https://github.com/postgis/postgis/actions?query=branch%3Astable-3.3) | [](https://gitlab.com/postgis/postgis/commits/stable-3.3) ||
This file is here to play nicely with modern code repository facilities.
Actual readme is [here](README.postgis).
=====================================
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
=====================================
Version.config
=====================================
@@ -5,7 +5,7 @@
POSTGIS_MAJOR_VERSION=3
POSTGIS_MINOR_VERSION=3
-POSTGIS_MICRO_VERSION=0rc2
+POSTGIS_MICRO_VERSION=0
# Liblwgeom interface versioning, reset to 0:0:0 (cur:age:rev)
# when changing POSTGIS_MINOR_VERSION
=====================================
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
=====================================
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>
=====================================
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.
=====================================
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>
=====================================
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>
=====================================
extensions/address_standardizer/Makefile
=====================================
@@ -30,7 +30,7 @@ POSTGIS_PGSQL_VERSION=110
# SQL preprocessor
SQLPP = /usr/bin/cpp -traditional-cpp -w -P
GREP=/bin/grep
-EXTVERSION = 3.3.0rc2
+EXTVERSION = 3.3.0
MODULE_big = address_standardizer-3
MODULEPATH = $$libdir/address_standardizer-3
ifeq (no,yes)
@@ -48,7 +48,7 @@ DATA_built = \
$(NULL)
all: sql/address_standardizer_pre.sql sql/address_standardizer.sql sql/address_standardizer--1.0--$(EXTVERSION).sql sql/$(EXTENSION)--$(EXTVERSION).sql sql/$(EXTENSION)--ANY--$(EXTVERSION).sql \
- sql/$(EXTENSION)_data_us.sql sql/address_standardizer--3.3.0rc2.sql sql/$(EXTENSION)_data_us--3.3.0rc2.sql sql/$(EXTENSION)_data_us--$(EXTVERSION)--$(EXTVERSION)next.sql \
+ sql/$(EXTENSION)_data_us.sql sql/address_standardizer--3.3.0.sql sql/$(EXTENSION)_data_us--3.3.0.sql sql/$(EXTENSION)_data_us--$(EXTVERSION)--$(EXTVERSION)next.sql \
sql/$(EXTENSION)_data_us--$(EXTVERSION)next--$(EXTVERSION).sql sql/$(EXTENSION)_data_us--ANY--$(EXTVERSION).sql \
sql/test-init-extensions.sql sql/test-parseaddress.sql sql/test-standardize_address_1.sql sql/test-standardize_address_2.sql
=====================================
extensions/postgis_raster/Makefile
=====================================
@@ -1,7 +1,7 @@
include ./../upgradeable_versions.mk
EXTENSION = postgis_raster
-EXTVERSION = 3.3.0rc2
+EXTVERSION = 3.3.0
MINORVERSION = 3.3
MODULEPATH = $$libdir/$(EXTENSION)-3
=====================================
extensions/upgradeable_versions.mk
=====================================
@@ -77,8 +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.2.3
=====================================
postgis_revision.h
=====================================
@@ -1 +1 @@
-#define POSTGIS_REVISION e7a4854
+#define POSTGIS_REVISION 60836cf
View it on GitLab: https://salsa.debian.org/debian-gis-team/postgis/-/commit/279e903703585ecf651f485fa6de67506d41a928
--
View it on GitLab: https://salsa.debian.org/debian-gis-team/postgis/-/commit/279e903703585ecf651f485fa6de67506d41a928
You're receiving this email because of your account on salsa.debian.org.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-grass-devel/attachments/20220827/eb38180f/attachment-0001.htm>
More information about the Pkg-grass-devel
mailing list