4. Geospatial Data Types : Two-dimensional Data Types : MultiPoint Data Type
 
Share this page                  
MultiPoint Data Type
A MultiPoint is a collection that consists of only points.
Examples:
Without specifying SRID:
CREATE TABLE trees (name VARCHAR(30), trees MULTIPOINT);
With specifying SRID:
CREATE TABLE trees (name VARCHAR(30), trees MULTIPOINT SRID 26911);
Manage trees with a park area as separate points but grouped together as a MULTIPOINT feature:
CREATE TABLE trees (id INTEGER PRIMARY KEY, park MULTIPOINT);
INSERT INTO trees (id, park) VALUES (1, MPOINTFROMTEXT('MULTIPOINT((0 0), (10 10),(15 20))'));