MultiPolygon Data Type
A MultiPolygon is a collection that consists of only polygons.
Examples:
Without specifying SRID:
CREATE TABLE parks (name VARCHAR(30), park MULTIPOLYGON);
With specifying SRID:
CREATE TABLE parks (name VARCHAR(30), park MULTIPOLYGON SRID 26911);
Group several parcels of land into a MultiPolygon representing all the pieces of a park:
CREATE TABLE parks (id INTEGER PRIMARY KEY, polygon MULTIPOLYGON);
INSERT INTO parks (id, polygon) VALUES (1, MPOLYFROMTEXT('MULTIPOLYGON(((0 0, 10 10, 0 10, 0 0)), ((0 0, 10 10, 10 0, 0 0)))'));
Last modified date: 04/03/2024