Constructs a meshgeom object from a well-known text (WKT) representation.
Syntax
meshgeom ST_MeshGeomFromText(text wkt);
meshgeom ST_MeshGeomFromText(text wkt, int4 srid);Parameters
| Parameter | Description |
|---|---|
wkt | The WKT representation of the meshgeom object. |
srid | The spatial reference identifier (SRID). |
Examples
Construct a meshgeom without an SRID:
SELECT ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))');Construct a meshgeom with SRID 4326 and verify the result using ST_AsEWKT:
SELECT ST_AsEWKT(ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))', 4326));Output:
SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))该文章对您有帮助吗？