[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-1115-g96c3997dd

git at osgeo.org git at osgeo.org
Tue Jul 4 08:13:45 PDT 2023


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  96c3997dd2dfe53f26261b9214b9c1ca2f899eaa (commit)
      from  92a3500f67498ce328d73c0a8456928257d63859 (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 96c3997dd2dfe53f26261b9214b9c1ca2f899eaa
Author: Martin Davis <mtnclimb at gmail.com>
Date:   Tue Jul 4 08:13:44 2023 -0700

    Add doc ST_CoverageUnion diagram

diff --git a/doc/html/images/Makefile.in b/doc/html/images/Makefile.in
index 85ce22eb5..610b24d0d 100644
--- a/doc/html/images/Makefile.in
+++ b/doc/html/images/Makefile.in
@@ -79,6 +79,8 @@ GENERATED_IMAGES= \
 	st_convexhull01.png \
 	st_coveragesimplify01.png \
 	st_coveragesimplify02.png \
+	st_coverageunion01.png \
+	st_coverageunion02.png \
 	st_crosses01.png \
 	st_crosses02.png \
 	st_crosses03.png \
diff --git a/doc/html/images/wkt/st_coverageunion01.wkt b/doc/html/images/wkt/st_coverageunion01.wkt
new file mode 100644
index 000000000..99041e020
--- /dev/null
+++ b/doc/html/images/wkt/st_coverageunion01.wkt
@@ -0,0 +1 @@
+ArgA;GEOMETRYCOLLECTION (POLYGON ((10 10, 10 150, 80 190, 110 150, 90 110, 40 110, 50 60, 10 10)), POLYGON ((120 10, 10 10, 50 60, 100 70, 120 10)), POLYGON ((140 80, 120 10, 100 70, 40 110, 90 110, 110 150, 140 80)), POLYGON ((140 190, 120 170, 140 130, 160 150, 140 190)), POLYGON ((180 160, 170 140, 140 130, 160 150, 140 190, 180 160)))
diff --git a/doc/html/images/wkt/st_coverageunion02.wkt b/doc/html/images/wkt/st_coverageunion02.wkt
new file mode 100644
index 000000000..44e67c4e1
--- /dev/null
+++ b/doc/html/images/wkt/st_coverageunion02.wkt
@@ -0,0 +1 @@
+Result-thin;MULTIPOLYGON (((10 150, 80 190, 110 150, 140 80, 120 10, 10 10, 10 150), (50 60, 100 70, 40 110, 50 60)), ((120 170, 140 190, 180 160, 170 140, 140 130, 120 170)))
diff --git a/doc/reference_coverage.xml b/doc/reference_coverage.xml
index 8da79c8c9..a9889f35d 100644
--- a/doc/reference_coverage.xml
+++ b/doc/reference_coverage.xml
@@ -238,20 +238,47 @@ SELECT id, ST_AsText(ST_CoverageSimplify(geom, 30) OVER ())
 
     <refsection>
       <title>Examples</title>
+    <informaltable>
+      <tgroup cols="2">
+      <tbody>
+        <row>
+        <entry><para>
+        <informalfigure>
+          <mediaobject>
+              <imageobject>
+              <imagedata fileref="images/st_coverageunion01.png" />
+              </imageobject>
+              <caption><para>Input coverage</para></caption>
+          </mediaobject>
+        </informalfigure>
+        </para></entry>
+        <entry><para>
+        <informalfigure>
+          <mediaobject>
+              <imageobject>
+              <imagedata fileref="images/st_coverageunion02.png" />
+              </imageobject>
+              <caption><para>Union result</para></caption>
+          </mediaobject>
+        </informalfigure>
+        </para></entry>
+       </row>
+      </tbody>
+      </tgroup>
+    </informaltable>
 
-      <programlisting>CREATE TABLE coverage (id integer, geom geometry);
-
-INSERT INTO coverage VALUES
-  (1, 'POLYGON((0 0, 10 0, 10.1 5, 10 10, 0 10, 0 0))'),
-  (2, 'POLYGON((10 0, 20 0, 20 10, 10 10, 10.1 5, 10 0))'),
-  (3, 'POLYGON((20 0, 30 0, 30 10, 20 10, 20 0))');
-
+      <programlisting>WITH coverage(id, geom) AS (VALUES
+  (1, 'POLYGON ((10 10, 10 150, 80 190, 110 150, 90 110, 40 110, 50 60, 10 10))'::geometry),
+  (2, 'POLYGON ((120 10, 10 10, 50 60, 100 70, 120 10))'::geometry),
+  (3, 'POLYGON ((140 80, 120 10, 100 70, 40 110, 90 110, 110 150, 140 80))'::geometry),
+  (4, 'POLYGON ((140 190, 120 170, 140 130, 160 150, 140 190))'::geometry),
+  (5, 'POLYGON ((180 160, 170 140, 140 130, 160 150, 140 190, 180 160))'::geometry)
+)
 SELECT ST_AsText(ST_CoverageUnion(geom))
   FROM coverage;
 
-                        st_astext
-----------------------------------------------------------
- POLYGON((0 0,0 10,10 10,20 10,30 10,30 0,20 0,10 0,0 0))
+--------------------------------------
+MULTIPOLYGON (((10 150, 80 190, 110 150, 140 80, 120 10, 10 10, 10 150), (50 60, 100 70, 40 110, 50 60)), ((120 170, 140 190, 180 160, 170 140, 140 130, 120 170)))
       </programlisting>
     </refsection>
 

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

Summary of changes:
 doc/html/images/Makefile.in                |  2 ++
 doc/html/images/wkt/st_coverageunion01.wkt |  1 +
 doc/html/images/wkt/st_coverageunion02.wkt |  1 +
 doc/reference_coverage.xml                 | 47 +++++++++++++++++++++++-------
 4 files changed, 41 insertions(+), 10 deletions(-)
 create mode 100644 doc/html/images/wkt/st_coverageunion01.wkt
 create mode 100644 doc/html/images/wkt/st_coverageunion02.wkt


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list