ArcGIS Server Banner

ST_GeomCollFromShape

ST_GeomCollFromShape

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Spatial type for PostgreSQL only

Definition

ST_GeomCollFromShape constructs a geometry collection from an ESRI shape.

Syntax

st_geomcollfromshape (esri_shape bytea, srid integer)

Return type

ST_GeomCollection

Example

Create a table, gcollection.

CREATE TABLE gcollection (pkey integer, shape st_geomcollection );

Insert values into the gcollection table.

INSERT INTO gcollection VALUES
(1,
st_geomcollfromshape (st_asshape(st_geomcollection
('multipoint(20 20, 30 30, 20 40,30 50)', 0))::bytea, 0));

INSERT INTO gcollection VALUES 
(2,
st_geomcollfromshape (st_asshape(st_geomcollection
('multilinestring ((10.02 20.01, 10.32 23.98, 11.92 25.64),
(9.55 23.75, 15.36 30.11), (10 10, 20 20, 30 30, 40 40, 90 90))', 0))::bytea, 0));

INSERT INTO gcollection VALUES 
(3,
st_geomcollfromshape (st_asshape(st_geomcollection
('multipolygon(((0 0, 4 0, 4 4, 0 4, 0 0),(1 1, 2 1, 2 2, 1 2, 1 1)), 
((-1 -1, -1 -2, -2 -2, -2 -1, -1 -1)))', 0))::bytea, 0));

Select the geometry from the gcollection table.

SELECT pkey, st_astext(shape) from gcollection;

 pkey   st_astext

1  	MULTIPOINT ( 20 20, 30 30, 20 40, 30 50) 

2  	MULTILINESTRING (( 10.02000000 20.01000000, 10.32000000 23.98000000, 
		11.92000000 25.64000000),( 9.55000000 23.75000000, 
		15.36000000 30.11000000), ( 10 10, 20 20, 30 30, 40 40, 90 90))

3  	MULTIPOLYGON ((( 0 0, 4 0, 4 4, 0 4, 0 0)( 1 1, 1 2, 2 2,
2 1, 1 1)), (( -1 -1, -2 -1, -2 -2, -1 -2, -1 -1))

(3 rows)

See Also

  • An overview of SQL functions used with ST_Geometry types