ArcGIS Server Banner

ST_GeomCollFromWKB

ST_GeomCollFromWKB

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback

NOTE: Spatial type for PostgreSQL only

Definition

ST_GeomCollFromWKB constructs a geometry collection from a well-known binary representation.

Syntax

st_geomcollfromwkb (wkb bytea, srid integer)

Return type

ST_GeomCollection

Example

NOTE: Hard returns are inserted for readability. Remove them if you copy the statements.

Create a table, gcolltest.

CREATE TABLE gcoll_test (pkey integer, shape st_geomcollection );

Insert values into the table.

INSERT INTO gcoll_test VALUES 
(1,
st_geomcollfromwkb (st_asbinary(st_geomcollection
('multipoint(20 20, 30 30, 20 40, 30 50)', 0)), 0));

INSERT INTO into gcoll_test VALUES 
(2,
st_geomcollfromwkb (st_asbinary(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)), 0));

INSERT INTO gcoll_test VALUES 
(3,
st_geomcollfromwkb (st_asbinary(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)), 0));

Select the geometry from the gcoll_test table.

SELECT pkey, st_astext(shape) from gcoll_test;

 pkey   st_astext

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

   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))

See Also

  • An overview of SQL functions used with ST_Geometry types