[SCM] PostGIS branch stable-3.6 updated. 3.6.0-18-g03737df1d
git at osgeo.org
git at osgeo.org
Tue Oct 7 20:14:33 PDT 2025
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.6 has been updated
via 03737df1dec03f07453218573d2489d9b8d2622c (commit)
from ba2639c5145af2647fb9d70a4730f45cf9c07bcb (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 03737df1dec03f07453218573d2489d9b8d2622c
Author: Nikolai B <nikolai-b at users.noreply.github.com>
Date: Wed Sep 24 14:05:19 2025 +0100
doc(St_Subdivide) mention potential changes in geography
Closes https://github.com/postgis/postgis/pull/831
for PostGIS 3.6.1
Patch provided by Nikolai Berkoff
diff --git a/doc/introduction.xml b/doc/introduction.xml
index 209707e05..983f01f64 100644
--- a/doc/introduction.xml
+++ b/doc/introduction.xml
@@ -316,6 +316,7 @@
<member>Mike Toews</member>
<member>Nathan Wagner</member>
<member>Nathaniel Clay</member>
+ <member>Nikolai Berkoff</member>
<member>Nikita Shulga</member>
<member>Norman Vine</member>
<member>Patricia Tozer</member>
diff --git a/doc/reference_overlay.xml b/doc/reference_overlay.xml
index a380b6447..7225cea18 100644
--- a/doc/reference_overlay.xml
+++ b/doc/reference_overlay.xml
@@ -654,6 +654,11 @@ SELECT ST_AsText( ST_Split( ST_Snap(line, point, 1), point)) AS snapped_split,
The "hit" cases are faster because the spatial operations
executed by the index recheck process fewer points.
</para>
+ <note><para>
+ When casting a subdivided geometry to geography, the resulting geography may differ from the original.
+ Subdivision adds vertices in planar (geometry) space. If vertices are inserted along the boundary, they will alter the geographical representation, where edges are interpreted as geodesic segments.
+ To minimize distortion, first densify the geography using <xref linkend="ST_Segmentize"/> to add geodesic vertices, then cast to geometry before subdivision.
+ </para></note>
<note><para>
This is a <link xlink:href="https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-TABLEFUNCTIONS">set-returning function</link>
(SRF) that return a set of rows containing single geometry values.
@@ -703,6 +708,8 @@ SELECT row_number() OVER() As rn, ST_AsText(geom) As wkt
<para><emphasis role="bold">Example:</emphasis>
Densify a long geography line using ST_Segmentize(geography, distance),
and use ST_Subdivide to split the resulting line into sublines of 8 vertices.
+ Densification minimizes the impact of changes to the geography representation of a geometry
+ when subdividing.
</para>
<informalfigure>
<mediaobject>
-----------------------------------------------------------------------
Summary of changes:
doc/introduction.xml | 1 +
doc/reference_overlay.xml | 7 +++++++
2 files changed, 8 insertions(+)
hooks/post-receive
--
PostGIS
More information about the postgis-tickets
mailing list