[postgis-tickets] r15214 - get rid of invalid link and obsolete statements about ST_Collect
Regina Obe
lr at pcorp.us
Tue Oct 25 11:38:57 PDT 2016
Author: robe
Date: 2016-10-25 11:38:56 -0700 (Tue, 25 Oct 2016)
New Revision: 15214
Modified:
trunk/doc/reference_processing.xml
Log:
get rid of invalid link and obsolete statements about ST_Collect
Modified: trunk/doc/reference_processing.xml
===================================================================
--- trunk/doc/reference_processing.xml 2016-10-21 20:15:20 UTC (rev 15213)
+++ trunk/doc/reference_processing.xml 2016-10-25 18:38:56 UTC (rev 15214)
@@ -472,13 +472,10 @@
input geometries. Output type can be a MULTI* or a
GEOMETRYCOLLECTION.</para>
- <note><para>ST_Collect and ST_Union are often interchangeable.
- ST_Collect is in general orders of magnitude faster than ST_Union
- because it does not try to dissolve boundaries or validate that a constructed MultiPolgon doesn't
- have overlapping regions. It merely rolls up
- single geometries into MULTI and MULTI or mixed geometry types
- into Geometry Collections. Unfortunately geometry collections are
- not well-supported by GIS tools. To prevent ST_Collect from
+ <note><para>ST_Collect and ST_Union are often interchangeable except that ST_Collect will always return a GeometryCollection or MULTI geometry
+ and ST_Union may return single geometries when it dissolves boundaries. ST_Union will also split linestrings at node intersections, whereas ST_Collect
+ will never split linestrings and in turn just return as MULTILINESTRING.
+ To prevent ST_Collect from
returning a Geometry Collection when collecting MULTI geometries,
one can use the below trick that utilizes <xref linkend="ST_Dump" /> to expand the
MULTIs out to singles and then regroup them.</para></note>
@@ -492,9 +489,8 @@
<refsection>
<title>Examples</title>
- <para>Aggregate example (<ulink url="http://postgis.refractions.net/pipermail/postgis-users/2008-June/020331.html">http://postgis.refractions.net/pipermail/postgis-users/2008-June/020331.html</ulink>)</para>
- <programlisting>SELECT stusps,
- ST_Multi(ST_Collect(f.the_geom)) as singlegeom
+ <para>Aggregate example</para>
+ <programlisting>SELECT stusps, ST_Collect(f.the_geom) as singlegeom
FROM (SELECT stusps, (ST_Dump(the_geom)).geom As the_geom
FROM
somestatetable ) As f
More information about the postgis-tickets
mailing list