Definición
ST_GeomCollection construye una colección de geometría desde una representación de texto conocida.
Sintaxis
Oracle
sde.st_multilinestring (wkt clob, srid integer) sde.st_multipoint (wkt clob, srid integer) sde.st_multipolygon (wkt clob, srid integer)
PostgreSQL
sde.st_multilinestring (wkt, srid integer) sde.st_multilinestring (esri_shape bytea, srid integer) sde.st_multipoint (wkt, srid integer) sde.st_multipoint (esri_shape bytea, srid integer) sde.st_multipolygon (wkt, srid integer) sde.st_multipolygon (esri_shape bytea, srid integer)
Tipo de devolución
ST_GeomCollection
Ejemplo
Crear una tabla, geomcoll_test.
CREATE TABLE geomcoll_test (id integer, geometry sde.st_geometry); INSERT INTO geomcoll_test (id, geometry) VALUES ( 1901, sde.st_multipoint ('multipoint (1 2, 4 3, 5 6)', 0) ); INSERT INTO geomcoll_test (id, geometry) VALUES ( 1902, sde.st_multilinestring ('multilinestring ((33 2, 34 3, 35 6), (28 4, 29 5, 31 8, 43 12), (39 3, 37 4, 36 7))', 0) ); INSERT INTO geomcoll_test (id, geometry) VALUES ( 1903, sde.st_multipolygon ('multipolygon (((3 3, 4 6, 5 3, 3 3), (8 24, 9 25, 1 28, 8 24), (13 33, 7 36, 1 40, 10 43, 13 33)))', 0) );
Seleccione la colección de geometría de la tabla geomcoll_test.
Oracle
SELECT id, sde.st_astext (geometry) Geomcollection FROM GEOMCOLL_TEST; ID GEOMCOLLECTION 1901 MULTIPOINT (1.00000000 2.00000000, 4.00000000 3.00000000, 5.00000000 6.00000000) 1902 MULTILINESTRING ((33.00000000 2.00000000, 34.00000000 3.00000000, 35.00000000 6.00000000),(28.00000000 4.00000000, 29.00000000 5.00000000, 31.00000000 8.00000000, 43.00000000 12.00000000),(39.00000000 3.00000000, 37.00000000 4.00000000, 36.00000000 7.00000000)) 1903 MULTIPOLYGON (((13.00000000 33.00000000, 10.00000000 43.00000000, 1.00000000 40.00000000, 7.00000000 36.00000000, 13.00000000 33.00000000)),((8.00000000 24.00000000, 9.00000000 25.00000000, 1.00000000 28.00000000, 8.00000000 24.00000000)), ((3.00000000 3.00000000,5.00000000 3.00000000, 4.00000000 6.00000000,3.00000000 3.00000000)))
PostgreSQL
SELECT id, sde.st_astext (geometry) AS geomcollection FROM geomcoll_test; id geomcollection 1901 MULTIPOINT (1 2, 4 3, 5 6) 1902 MULTILINESTRING ((33 2, 34 3, 35 6),(28 4, 29 5, 31 8, 43 12),(39 3, 37 4, 36 7)) 1903 MULTIPOLYGON (((13 33, 10 43, 1 40, 7 36, 13 33)),((8 24, 9 25, 1 28, 8 24)), 3 3, 5 3, 4 6, 3 3)))