ST_ForceSFS

更新时间:
复制 MD 格式

ST_ForceSFS converts a geometry object to a type defined in Simple Feature for SQL (SFS) 1.1. Use it when downstream systems or OGC-compliant tools require geometries limited to the SFS 1.1 type set.

Syntax

geometry ST_ForceSFS(geometry geomA);
geometry ST_ForceSFS(geometry geomA, text version);

Parameters

ParameterDescription
geomAThe geometry object to convert.
versionThe target SFS version.

Description

ST_ForceSFS supports circular strings, curves, polyhedral surfaces, triangles, triangulated irregular network (TIN) surfaces, and 3D objects as input.

Examples

SELECT ST_ForceSFS(ST_GeomFromText('POLYGON((1 1,2 1,2 2,1 2,1 1))'));
                          st_forcesfs
---------------------------------------------------------------
 01030000000100000005000000000000000000F03F000000000000F03F000.
.0000000000040000000000000F03F00000000000000400000000000000040.
.000000000000F03F0000000000000040000000000000F03F000000000000F.
.03F
(1 row)