Converts a hypergraph-based sfmesh object to a WGS84-based sfmesh object.
Syntax
sfmesh ST_FromSuperMap(sfmesh mesh);Parameters
Parameter | Description |
mesh | The target sfmesh object. |
Description
An sfmesh object in the SuperMap format uses an east-north-up (ENU) coordinate system and a local coordinate system. These systems are not suitable for calculations or queries. This function converts the object to the WGS84 format to facilitate these operations.
Examples
SELECT ST_AsText(ST_FromSupermap(the_mesh))
FROM t_sm_mesh
ORDER BY num;
-----------------
{"version" : 1, "srid" : 4326, "root" : 0, "meshes" : [{"root" : 0, "meshgeoms" : ["MESHGEOM(PATCH(POINT Z (116.375228273102 40.000091623698 13.8479756591842)))"], "primitives" : [{"meshgeom" : 0}], "nodes" : [{"primitive" : 0}]}], "primitives" : [{"mesh" : 0}], "nodes" : [{"children" : [1]}, {"primitive" : 0}]}