MultiSurface Data Type
A MultiSurface can contain between 1 to N surfaces of the types POLYGON or CURVEPOLYGON with any combination of the above.
Examples:
Without specifying SRID:
CREATE TABLE surfaces (name VARCHAR(30), msurf MULTISURFACE);
With specifying SRID:
CREATE TABLE surfaces (name VARCHAR(30), msurf MULTISURFACE SRID 4326);
Show a collection of curves that may or may not be related:
CREATE TABLE surfaces (id INT, msurf MULTISURFACE);
INSERT INTO surfaces (id, msurf) VALUES (1, GeomFromText('MULTISURFACE(((0 0, 0 4, 4 4, 4 0, 0 0)), CURVEPOLYGON(COMPOUNDCURVE((0 0, 2 0), CIRCULARSTRING(2 0, 2 1, 4 0))))'));
Last modified date: 11/09/2022