> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Aggregation Functions

<AccordionGroup>
  <Accordion title="ST_AGGREGATE_COLLECT(geom)" id="st_aggregate_collect-geom" defaultOpen>
    Alias for `ST_COLLECT_AGGREGATE()`
  </Accordion>

  <Accordion title="ST_AGGREGATE_INTERSECTION(geom)" id="st_aggregate_intersection-geom" defaultOpen>
    Alias for `ST_INTERSECTION_AGGREGATE()`
  </Accordion>

  <Accordion title="ST_COLLECT_AGGREGATE(geom)" id="st_collect_aggregate-geom" defaultOpen>
    Returns a GEOMETRYCOLLECTION comprising all geometries found in the `geom` set.
    Any MULTI\* geometries will be divided into separate singular geometries, e.g.,
    MULTIPOINT((0 0), (1 1)) would be divided into POINT(0 0) and POINT(1 1) in the
    results; the same is true for elements of a GEOMETRYCOLLECTION found in `geom`,
    where a GEOMETRYCOLLECTION within the provided `geom` set will also be parsed,
    effectively flattening it and adding the individual geometries to the resulting
    GEOMETRYCOLLECTION. Any empty geometries in `geom` are ignored even if they are
    part of a GEOMETRYCOLLECTION. Any duplicate WKTs will be retained.
  </Accordion>

  <Accordion title="ST_DISSOLVE(geom)" id="st_dissolve-geom" defaultOpen>
    Dissolves all geometries within a given set into a single geometry. Note that the
    resulting single geometry can still be a group of noncontiguous geometries but
    represented as a single group, e.g., a GEOMETRYCOLLECTION.  Best performance when
    used in conjunction with adjacent geometries.
  </Accordion>

  <Accordion title="ST_DISSOLVEOVERLAPPING(geom)" id="st_dissolveoverlapping-geom" defaultOpen>
    Dissolves all geometries within a given set into a single geometry. Note that the
    resulting single geometry can still be a group of noncontiguous geometries but
    represented as a single group, e.g., a GEOMETRYCOLLECTION.  Best performance when
    used in conjunction with overlapping geometries.
  </Accordion>

  <Accordion title="ST_INTERSECTION_AGGREGATE(geom)" id="st_intersection_aggregate-geom" defaultOpen>
    Returns a POLYGON or MULTIPOLYGON comprising the shared portion between all
    geometries found in the `geom` set.  Returns an empty GEOMETRYCOLLECTION if
    there is no shared portion between all geometries. Functionally equivalent to
    `ST_INTERSECTION(ST_INTERSECTION(geom1, geom2), ... geomN)`.
  </Accordion>

  <Accordion title="ST_LINESTRINGFROMORDEREDPOINTS(x, y, t)" id="st_linestringfromorderedpoints-x-y-t" defaultOpen>
    Returns a LINESTRING that represents a "track" of the given points (`x`, `y`)
    ordered by the given sort column `t` (e.g., a timestamp or sequence number). If
    any of the values in the specified columns are `null`, the null "point" will be
    left out of the resulting LINESTRING. If there's only one non-null "point" in the
    source table, a POINT is returned. If there are no non-null "points" in the
    source table, a `null` is returned.
  </Accordion>

  <Accordion title="ST_LINESTRINGFROMORDEREDPOINTS3D(x, y, z, t)" id="st_linestringfromorderedpoints3d-x-y-z-t" defaultOpen>
    Returns a LINESTRING that represents a "track" of the given 3D points
    (`x`, `y`, `z`) ordered by the given sort column `t` (e.g., a timestamp
    or sequence number). If any of the values in the specified columns are `null`,
    the null "point" will be left out of the resulting LINESTRING. If there's only
    one non-null "point" in the source table, a POINT is returned. If there are no
    non-null "points" in the source table, a `null` is returned.
  </Accordion>

  <Accordion title="ST_POLYGONIZE(geom)" id="st_polygonize-geom" defaultOpen>
    Returns a GEOMETRYCOLLECTION containing POLYGONs comprising the provided
    (MULTI)LINESTRING(s). (MULTI)POINT and (MULTI)POLYGON geometries are ignored when
    calculating the resulting GEOMETRYCOLLECTION. If a valid POLYGON cannot be
    constructed from the provided (MULTI)LINESTRING(s), an empty GEOMETRYCOLLECTION
    will be returned.
  </Accordion>
</AccordionGroup>