[SCM] PostGIS branch master updated. 3.7.0beta1-125-g56a92ee3a0

[git at osgeo.org]

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  56a92ee3a024fe187741b11b5a9b72cf51668a71 (commit)
       via  e70a5901f50450c468604e4b543bd56bc755b3c5 (commit)
      from  37ee184bfb85bc02d4839fc0a7c296171614d7ac (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 56a92ee3a024fe187741b11b5a9b72cf51668a71
Merge: 37ee184bfb e70a5901f5
Author: Darafei Praliaskouski <komzpa at gmail.com>
Date:   Tue Jul 28 02:52:32 2026 -0700

    Merge pull request 'Use house_num in ST_LineLocatePoint example' (!604) from Komzpa/postgis:agent/workshops-160-house-num into master
    
    Use `house_num` for the estimated house-number output in the `ST_LineLocatePoint` documentation example.
    
    This keeps the column name aligned with the example text, which approximates the street number of a house rather than identifying a street.
    
    Closes https://github.com/postgis/postgis-workshops/issues/160
    
    Validation:
    
    - `xmllint --noout doc/postgis.xml`
    - `git diff --check`
    
    Reviewed-on: https://gitea.osgeo.org/postgis/postgis/pulls/604


commit e70a5901f50450c468604e4b543bd56bc755b3c5
Author: Darafei Praliaskouski <me at komzpa.net>
Date:   Tue Jul 28 12:16:01 2026 +0400

    Use house_num in line locate point example

diff --git a/doc/reference_lrs.xml b/doc/reference_lrs.xml
index 93f18292f8..2e9db17567 100644
--- a/doc/reference_lrs.xml
+++ b/doc/reference_lrs.xml
@@ -300,17 +300,17 @@ FROM street;
 
 			<para>This example approximates the street number of a house by locating the closest point on a street line. The subquery generates sample house and street data, and <function>ST_DWithin</function> excludes houses that are too far from the street.</para>
 			<programlisting>SELECT house_loc As as_text_house_loc,
-    startstreet_num +
-        CAST( (endstreet_num - startstreet_num)
-            * ST_LineLocatePoint(street_line, house_loc) As integer) As street_num
+    start_house_num +
+        CAST( (end_house_num - start_house_num)
+            * ST_LineLocatePoint(street_line, house_loc) As integer) As house_num
 FROM
 (SELECT 'LINESTRING(1 2,3 4)'::geometry As street_line,
-    ST_Point(x*1.01, y*1.03) As house_loc, 10 As startstreet_num,
-        20 As endstreet_num
+    ST_Point(x*1.01, y*1.03) As house_loc, 10 As start_house_num,
+        20 As end_house_num
 FROM generate_series(1, 3) x CROSS JOIN generate_series(2, 4) As y)
 As foo
 WHERE ST_DWithin(street_line, house_loc, 0.2);</programlisting>
-<screen> as_text_house_loc | street_num
+<screen> as_text_house_loc | house_num
 -------------------+------------
  POINT(1.01 2.06)  |         10
  POINT(2.02 3.09)  |         15

-----------------------------------------------------------------------

Summary of changes:
 doc/reference_lrs.xml | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)


hooks/post-receive
-- 
PostGIS