[postgis-tickets] [SCM] PostGIS branch master updated. 3.1.0rc1-43-gebe9ec5

[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  ebe9ec54cfb2a5f3345a6a861961de63bb1ddf52 (commit)
       via  c0d3c719ab2ef59b1db20442855c31ef5820cb42 (commit)
      from  17088887c6df99a0e94f362f11371c92aada8720 (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 ebe9ec54cfb2a5f3345a6a861961de63bb1ddf52
Merge: c0d3c71 1708888
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Mon Jan 11 09:53:11 2021 -0800

    Merge branch 'master' of https://git.osgeo.org/gitea/postgis/postgis


commit c0d3c719ab2ef59b1db20442855c31ef5820cb42
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Mon Jan 11 09:53:01 2021 -0800

    Add example of using ST_SquareGrid for a 1-degree grid

diff --git a/doc/reference_constructor.xml b/doc/reference_constructor.xml
index 079a5b8..4b3ff05 100644
--- a/doc/reference_constructor.xml
+++ b/doc/reference_constructor.xml
@@ -982,6 +982,18 @@ POLYGON((-1 0,-0.5
         </refsection>
 
         <refsection>
+        <title>Example: Generating a 1 degree grid for a country</title>
+        <para>The grid will fill the whole bounds of the country, so if you want just squares
+            that touch the country you will have to filter afterwards with ST_Intersects.</para>
+            <programlisting>WITH grid AS (
+SELECT (ST_SquareGrid(1, ST_Transform(geom,4326))).*
+FROM admin0 WHERE name = 'Canada'
+)
+  SELEcT ST_AsText(geom)
+  FROM grid</programlisting>
+        </refsection>
+
+        <refsection>
         <title>Example: Counting points in squares (using single chopped grid)</title>
         <para>To do a point summary against a square tiling, generate a square grid using the
         extent of the points as the bounds, then spatially join to that grid. Note the estimated extent might be off from actual extent, so be cautious and at very least make sure you've analyzed your table.</para>

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

Summary of changes:
 doc/reference_constructor.xml | 12 ++++++++++++
 1 file changed, 12 insertions(+)


hooks/post-receive
-- 
PostGIS