MPolyFromText

Synonym for ST_MultiPolygonFromText. Constructs a MultiPolygon value from its WKT representation and an optional SRID.

Syntax

MPolyFromText(wkt[,srid])
MultiPolygonFromText(wkt[,srid])

Description

Constructs a MULTIPOLYGON value using its WKT representation and SRID.

MPolyFromText() and MultiPolygonFromText() are synonyms.

Examples

CREATE TABLE gis_multi_polygon  (g MULTIPOLYGON);
SHOW FIELDS FROM gis_multi_polygon;
INSERT INTO gis_multi_polygon VALUES
    (MultiPolygonFromText('MULTIPOLYGON(
       ((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),
       ((59 18,67 18,67 13,59 13,59 18)))')),
    (MPolyFromText('MULTIPOLYGON(
       ((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),
       ((59 18,67 18,67 13,59 13,59 18)))')),
    (MPolyFromWKB(AsWKB(MultiPolygon(Polygon(
       LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3)))))));

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}