[SCM] PostGIS branch master updated. 3.6.0rc2-123-gc3325a32c

git at osgeo.org git at osgeo.org
Tue Oct 7 17:46:40 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, master has been updated
       via  c3325a32c85604bf56f280c41bdf83f619500b4b (commit)
      from  115ee04ba2263ff714bd4f66b77cc3be1d5c35e1 (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 c3325a32c85604bf56f280c41bdf83f619500b4b
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.7.0
    
    Patch provided by Nikolai Berkoff

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/reference_overlay.xml | 7 +++++++
 1 file changed, 7 insertions(+)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list