[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