[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