제목
ST_CollectionHomogenize — Returns the simplest representation of a geometry collection.
요약
geometry ST_CollectionHomogenize(geometry collection);
설명
도형 집합을 입력받아 해당 내용의 "가장 단순한" 표현식을 반환합니다.
-
Homogeneous (uniform) collections are returned as the appropriate multi-geometry.
-
Heterogeneous (mixed) collections are flattened into a single GeometryCollection.
-
Collections containing a single atomic element are returned as that element.
-
Atomic geometries are returned unchanged. If required, these can be converted to a multi-geometry using ST_Multi.
![[주의]](../images/warning.png)
|
|
|
This function does not ensure that the result is valid. In particular, a collection containing adjacent or overlapping Polygons will create an invalid MultiPolygon. This situation can be checked with ST_IsValid and repaired with ST_MakeValid. |
2.0.0 버전부터 사용할 수 있습니다.
예시
Single-element collection converted to an atomic geometry
SELECT ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 0))');
POINT(0 0)
Nested single-element collection converted to an atomic geometry:
SELECT ST_CollectionHomogenize('GEOMETRYCOLLECTION(MULTIPOINT((0 0)))');
POINT(0 0)
Collection converted to a multi-geometry:
SELECT ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 0), POINT(1 1))');
MULTIPOINT((0 0),(1 1))
Nested heterogeneous collection flattened to a GeometryCollection:
SELECT ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 0), GEOMETRYCOLLECTION( LINESTRING(1 1,2 2)))');
GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))
Collection of Polygons converted to an (invalid) MultiPolygon:
SELECT ST_CollectionHomogenize('GEOMETRYCOLLECTION (POLYGON ((10 50,50 50,50 10,10 10,10 50)),POLYGON ((90 50,90 10,50 10,50 50,90 50)))');
MULTIPOLYGON(((10 50,50 50,50 10,10 10,10 50)),((90 50,90 10,50 10,50 50,90 50)))