MultiPoint Data Type

Was this helpful?

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

Last modified date: 11/28/2023