st_astext-MULTIPOINT((0 1.00002443285827),(0 2.00004274948544),(0 3.00004884128919),(0 4.00003661494431),(0 5))不重复插入：SELECT ST_AsText(ST_LineInterpolatePoints('LINESTRING(0 0,0 5)',0.20,false));st_astext-POINT(0 1)(1...
返回给定Geometry对象的三维周长。语法 float ST_3DPerimeter(geometry geomA);...示例 默认调用：SELECT ST_3DPerimeter('POLYGON((0 0 0,0 2 0,2 2 2,2 0 2,0 0 0))':geometry);st_3dperimeter-9.65685424949238(1 row)
返回给定Geometry对象的三维周长。语法 float ST_3DPerimeter(geometry geomA);...示例 默认调用：SELECT ST_3DPerimeter('POLYGON((0 0 0,0 2 0,2 2 2,2 0 2,0 0 0))':geometry);st_3dperimeter-9.65685424949238(1 row)
返回给定Geometry对象的三维周长。语法 float ST_3DPerimeter(geometry geomA);...示例 默认调用：SELECT ST_3DPerimeter('POLYGON((0 0 0,0 2 0,2 2 2,2 0 2,0 0 0))':geometry);st_3dperimeter-9.65685424949238(1 row)
返回结果：+-+|iscontain|+-+|true|+-+示例3 SELECT ST_Contains(ST_GeomFromText('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GeomFromText('POINT(180 23)'))AS iscontain;返回结果：+-+|iscontain|+-+|false|+-+示例4 SELECT ST_Contains...
返回结果：+-+|iscontain|+-+|true|+-+示例3 SELECT ST_Contains(ST_GeomFromText('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GeomFromText('POINT(180 23)'))AS iscontain;返回结果：+-+|iscontain|+-+|false|+-+示例4 SELECT ST_Contains...
返回Geometry1上最接近Geometry2的三维点。此点也是Geometry1和...示例 默认调用：SELECT ST_AsText(ST_3DClosestPoint('LINESTRING(0 0 0,1 1 1)':geometry,'LINESTRING(0 0 1,1 1 0)':geometry));st_astext-POINT Z(0.5 0.5 0.5)(1 row)
返回Geometry1上最接近Geometry2的三维点。此点也是Geometry1和...示例 默认调用：SELECT ST_AsText(ST_3DClosestPoint('LINESTRING(0 0 0,1 1 1)':geometry,'LINESTRING(0 0 1,1 1 0)':geometry));st_astext-POINT Z(0.5 0.5 0.5)(1 row)
SELECT st_astext(geom)FROM holo_gis_2 WHERE ST_Covers(ST_SetSRID(ST_MakeBox2D(ST_Point(116,39),ST_Point(117,40)),4326),geom);返回结果如下：st_astext-POINT(116 39)多边形相交判定（在内部或在边界上）不指定SRID值。SELECT st_...
st_astext-POINT(0 1)(1 row)-geography SELECT ST_AsText(ST_LineInterpolatePoint(geog,ST_LineLocatePoint(geog,'POINT(1 1)':geography)))FROM(SELECT 'LINESTRING(0 0,0 2)':geography As geog)As test;POINT(0 1.00015229710421)
st_astext-POINT(0 1)(1 row)-geography SELECT ST_AsText(ST_LineInterpolatePoint(geog,ST_LineLocatePoint(geog,'POINT(1 1)':geography)))FROM(SELECT 'LINESTRING(0 0,0 2)':geography As geog)As test;POINT(0 1.00015229710421)
st_astext-POINT(0 1)(1 row)-geography SELECT ST_AsText(ST_LineInterpolatePoint(geog,ST_LineLocatePoint(geog,'POINT(1 1)':geography)))FROM(SELECT 'LINESTRING(0 0,0 2)':geography As geog)As test;POINT(0 1.00015229710421)
如果Geometry对象A包含Geometry对象B，则返回True。语法 boolean ST_Contains(geometry geomA,geometry ...示例 SELECT ST_Contains('POLYGON((0 0,0 3,3 0,0 0))':geometry,'POLYGON((0 0,0 1,1 0,0 0))':geometry);st_contains-t(1 row)
如果Geometry对象A包含Geometry对象B，则返回True。语法 boolean ST_Contains(geometry geomA,geometry ...示例 SELECT ST_Contains('POLYGON((0 0,0 3,3 0,0 0))':geometry,'POLYGON((0 0,0 1,1 0,0 0))':geometry);st_contains-t(1 row)
如果Geometry对象A包含Geometry对象B，则返回True。语法 boolean ST_Contains(geometry geomA,geometry ...示例 SELECT ST_Contains('POLYGON((0 0,0 3,3 0,0 0))':geometry,'POLYGON((0 0,0 1,1 0,0 0))':geometry);st_contains-t(1 row)
语法 geometry ST_UnaryUnion(geometry geom,float8 gridsize defalut-1.0,cstring options default '{}');geometry ST_UnaryUnion(geometry geom,cstring options);参数 参数名称 描述 geom Geometry对象，通常是复杂Geometry、...
示例 SELECT ST_NumPatches('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))':...
示例 SELECT ST_NumPatches('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))':...
示例 SELECT ST_NumPatches('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))':...
返回每个Geometry对象基于二维K均值算法生成的聚类结果数量。语法 integer ST_ClusterKMeans(geometry winset geom,integer numberOfClusters);...st_clusterkmeans|st_astext-+-0|POINT(0 0)0|POINT(1 1)1|POINT(-1-1)1|POINT(-2-2)(4 rows)
返回每个Geometry对象基于二维K均值算法生成的聚类结果数量。语法 integer ST_ClusterKMeans(geometry winset geom,integer numberOfClusters);...st_clusterkmeans|st_astext-+-0|POINT(0 0)0|POINT(1 1)1|POINT(-1-1)1|POINT(-2-2)(4 rows)
返回每个Geometry对象基于二维K均值算法生成的聚类结果数量。语法 integer ST_ClusterKMeans(geometry winset geom,integer numberOfClusters);...st_clusterkmeans|st_astext-+-0|POINT(0 0)0|POINT(1 1)1|POINT(-1-1)1|POINT(-2-2)(4 rows)
根据Geometry对象的m值过滤掉其...st_astext-LINESTRING M(2 2 2,3 3 3)(1 row)无法构成Geometry的情况：SELECT ST_AsText(ST_FilterByM('LINESTRINGM(0 0 0,1 1 1,2 2 2,3 3 3)':geometry,3,4,true));st_astext-LINESTRING M EMPTY(1 row)
根据Geometry对象的m值过滤掉其...st_astext-LINESTRING M(2 2 2,3 3 3)(1 row)无法构成Geometry的情况：SELECT ST_AsText(ST_FilterByM('LINESTRINGM(0 0 0,1 1 1,2 2 2,3 3 3)':geometry,3,4,true));st_astext-LINESTRING M EMPTY(1 row)
根据Geometry对象的m值过滤掉其...st_astext-LINESTRING M(2 2 2,3 3 3)(1 row)无法构成Geometry的情况：SELECT ST_AsText(ST_FilterByM('LINESTRINGM(0 0 0,1 1 1,2 2 2,3 3 3)':geometry,3,4,true));st_astext-LINESTRING M EMPTY(1 row)
返回一个Point对象的X坐标值。语法 float ST_X(geometry aPoint);参数 参数名称 描述 aPoint 目标Point对象。描述 输入值必须是一个Point对象。如果输入值不可用或非法，则返回...示例 SELECT ST_X('POINT(0 1 2 3)':geometry);st_x-0(1 row)
如果给定的两个Geometry对象不相接，返回True。语法 boolean ST_Disjoint(geometry a,geometry b);...示例 默认调用：SELECT ST_Disjoint('LINESTRING(0 0,-3-3)':geometry,'LINESTRING(0 1,1 0)':geometry);st_disjoint-t(1 row)
如果给定的两个Geometry对象不相接，返回True。语法 boolean ST_Disjoint(geometry a,geometry b);...示例 默认调用：SELECT ST_Disjoint('LINESTRING(0 0,-3-3)':geometry,'LINESTRING(0 1,1 0)':geometry);st_disjoint-t(1 row)
如果给定的两个Geometry对象不相接，返回True。语法 boolean ST_Disjoint(geometry a,geometry b);...示例 默认调用：SELECT ST_Disjoint('LINESTRING(0 0,-3-3)':geometry,'LINESTRING(0 1,1 0)':geometry);st_disjoint-t(1 row)
根据传入的GLB构建Scene对象。语法 scene ST_SceneFromGlb(bytea glb,integer srid default 0,integer lod default 0);...{"type":"gltf","srid":4326,"lod":1,"affine":[0.5,0,0,1,0,0.5,0,1,0,0,0.5,1,0,0,0,1],"content":{"accessors":.}}
示例 原始图形，targetPercent=0.99时的凹包图形和targetPercent=0.98时的凹包图形效果对比：SELECT g,ST_ConcaveHull(g,0.99),ST_ConcaveHull(g,0.98),g from(select 'MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((0 6,6 3,6 6,0 6)))':...
使用Visvalingam-Whyatt算法返回给定Geometry对象的...示例 ST_Simplify和ST_SimplifyVW效果对比：select g,ST_Simplify(g,0.5),ST_SimplifyVW(g,0.5)from(select 'LINESTRING(0 0,2 2,3 1,3.5 1.5,5 0,5.25 0.25,5.5 0)':geometry as g)as t;
根据传入的GLB构建Scene对象。语法 scene ST_SceneFromGlb(bytea glb,integer srid default 0,integer lod default 0);...{"type":"gltf","srid":4326,"lod":1,"affine":[0.5,0,0,1,0,0.5,0,1,0,0,0.5,1,0,0,0,1],"content":{"accessors":.}}
示例 原始图形，targetPercent=0.99时的凹包图形和targetPercent=0.98时的凹包图形效果对比：SELECT g,ST_ConcaveHull(g,0.99),ST_ConcaveHull(g,0.98),g from(select 'MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((0 6,6 3,6 6,0 6)))':...
使用Visvalingam-Whyatt算法返回给定Geometry对象的...示例 ST_Simplify和ST_SimplifyVW效果对比：select g,ST_Simplify(g,0.5),ST_SimplifyVW(g,0.5)from(select 'LINESTRING(0 0,2 2,3 1,3.5 1.5,5 0,5.25 0.25,5.5 0)':geometry as g)as t;
使用Visvalingam-Whyatt算法返回给定Geometry对象的...示例 ST_Simplify和ST_SimplifyVW效果对比：select g,ST_Simplify(g,0.5),ST_SimplifyVW(g,0.5)from(select 'LINESTRING(0 0,2 2,3 1,3.5 1.5,5 0,5.25 0.25,5.5 0)':geometry as g)as t;
示例 原始图形，targetPercent=0.99时的凹包图形和targetPercent=0.98时的凹包图形效果对比：SELECT g,ST_ConcaveHull(g,0.99),ST_ConcaveHull(g,0.98),g from(select 'MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((0 6,6 3,6 6,0 6)))':...
根据传入的GLTF字符串构建Scene对象。语法 scene ST_SceneFromGltf(cstring gltf,integer srid default 0,integer lod ...{"type":"gltf","srid":4326,"lod":1,"affine":[0.5,0,0,1,0,0.5,0,1,0,0,0.5,1,0,0,0,1],"content":{"accessors":.}}
在不丢弃顶点的情况下，把无效的Geometry对象转换成有效的Geometry对象。语法 geometry ST_MakeValid(geometry input);参数 参数名称 描述 input ...st_astext-MULTIPOLYGON(((0 0,0 1,0.5 0.5,0 0)),((0.5 0.5,1 1,1 0,0.5 0.5.)))(1 row)
在不丢弃顶点的情况下，把无效的Geometry对象转换成有效的Geometry对象。语法 geometry ST_MakeValid(geometry input);参数 参数名称 描述 input ...st_astext-MULTIPOLYGON(((0 0,0 1,0.5 0.5,0 0)),((0.5 0.5,1 1,1 0,0.5 0.5.)))(1 row)