Database Reference
In-Depth Information
usingaSQL
SELECT CASE
constructwherethefeaturehada
GeometryCollec-
tion
geometry, for which we extracted just the points (and not the eventual lines-
trings)usingthe
ST_CollectionExtract
function(
parameter type
=
1
)from
the composing collections.
Wefinallycomparedthetworesultsets,bothwithplainSQLandaDesktopGIS:the
intersecting points computed filtering out the geometric collections from the output
geometries and the intersecting points computed from all of the geometries gener-
ated from the intersections, including the
GeometryCollection
features.