返回给定Geometry对象或Geography对象的WKT表示，不包含SRID元数据。...st_astext-POINT(116 40)(1 row)指定位数：SELECT ST_AsText(ST_GeomFromText('POINT(116.112 40.412)',4326),2);st_astext-POINT(116.11 40.41)(1 row)
查询网格对象代表的空间范围和几何对象是否是包含关系。语法 boolean ST_Contains(geomgrid grid,geometry ...st_intersects-f select st_contains(ST_gridfromtext('G00133103221330'),ST_gridfromtext('G001331032213300013'))st_contains-t
ST_PGEpochToTS(49),19),ST_2dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50),20),ST_3dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50),20),ST_2dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(70),21),ST_3dtDWithin(a,b,ST_...
This topic describes the ST_ConcaveHull function.This function returns the concave hull of the input geometry objects.Syntax geometry ST_ConcaveHull(geometry geomA,float targetPercent,boolean allowHoles);Parameters ...
ST_PGEpochToTS(49),19),ST_2dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50),20),ST_3dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50),20),ST_2dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(70),21),ST_3dtDWithin(a,b,ST_...
查询网格对象代表的空间范围和几何对象是否是包含关系。语法 boolean ST_Contains(geomgrid grid,geometry ...st_contains-f select st_contains(ST_gridfromtext('G00133103221330'),ST_gridfromtext('G001331032213300013'))st_contains-t
查询网格对象代表的空间范围和几何对象是否是被包含关系。语法 boolean ST_Within(geomgrid grid,geometry geom);...st_within-f select st_within(ST_gridfromtext('G001331032213300013'),ST_gridfromtext('G001331032213300'))st_within-t
返回给定Geometry对象或Geography对象的WKT表示，不包含SRID元数据。...st_astext-POINT(116 40)(1 row)指定位数：SELECT ST_AsText(ST_GeomFromText('POINT(116.112 40.412)',4326),2);st_astext-POINT(116.11 40.41)(1 row)
This topic describes the ST_AsBinary function.This function converts a grid into a binary structure.Syntax bytea ST_AsBinary(geomgrid grid)bytea ST_AsBinary(h3grid grid)Parameters Parameter Description grid The grid object...
返回给定Geometry对象或Geography对象的WKT表示，不包含SRID元数据。...st_astext-POINT(116 40)(1 row)指定位数：SELECT ST_AsText(ST_GeomFromText('POINT(116.112 40.412)',4326),2);st_astext-POINT(116.11 40.41)(1 row)
This topic describes the ST_GeometryType function.This function returns the type of the input geometry object.Syntax text ST_GeometryType(geometry g1);Parameters Parameter Description g1 The geometry object that you want ...
查询网格对象代表的空间范围和几何对象是否是被包含关系。语法 boolean ST_Within(geomgrid grid,geometry geom);...st_within-f select st_within(ST_gridfromtext('G001331032213300013'),ST_gridfromtext('G001331032213300'));st_within-t
功能同 ST_AsMVT，但是相较于 ST_AsMVT，基于不同矢量要素之间的关系，过滤对显示效果影响较小的矢量要素，从而减小MVT大小，提升可视化效率。过滤的效果由新增参数scale_factor控制。新增参数 mvt_size_limit，限制一个MVT可以包含的矢量...
This topic describes the ST_ConcaveHull function.This function returns the concave hull of the input geometry objects.Syntax geometry ST_ConcaveHull(geometry geomA,float targetPercent,boolean allowHoles);Parameters ...
Centroid Returns the centroid of the specified geometry object.ST_EndPoint Returns the last point of the specified LineString object.ST_NPoints Returns the number of vertexes in the specified geometry object.ST_StartPoint ...
This topic describes the ST_Parent function.This function returns the parent grid of an H3-encoded geographic grid at the specified level.Syntax h3grid ST_Parent(h3grid code,integer level);Parameters Parameter Description ...
ST_PGEpochToTS(49),19),ST_2dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50),20),ST_3dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50),20),ST_2dtDWithin(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(70),21),ST_3dtDWithin(a,b,ST_...
功能同 ST_AsMVT，但是相较于 ST_AsMVT，基于不同矢量要素之间的关系，过滤对显示效果影响较小的矢量要素，从而减小MVT大小，提升可视化效率。过滤的效果由新增参数scale_factor控制。新增参数 mvt_size_limit，限制一个MVT可以包含的矢量...
This topic describes the ST_Parent function.This function returns the parent grid of an H3-encoded geographic grid at the specified level.Syntax h3grid ST_Parent(h3grid code,integer level);Parameters Parameter Description ...
This topic describes the ST_AsBinary function.This function converts a grid into a binary structure.Syntax bytea ST_AsBinary(geomgrid grid)bytea ST_AsBinary(h3grid grid)Parameters Parameter Description grid The grid object...
功能同 ST_AsMVT，但是相较于 ST_AsMVT，基于不同矢量要素之间的关系，过滤对显示效果影响较小的矢量要素，从而减小MVT大小，提升可视化效率。过滤的效果由新增参数scale_factor控制。新增参数 mvt_size_limit，限制一个MVT可以包含的矢量...
This topic describes the ST_GeometryType function.This function returns the type of the input geometry object.Syntax text ST_GeometryType(geometry g1);Parameters Parameter Description g1 The geometry object that you want ...
This topic describes the ST_CoordDim function.This function returns the coordinate dimension of a geometry object.Syntax integer ST_CoordDim(geometry geomA);Parameters Parameter Description geomA The geometry object that ...
This topic describes the ST_Perimeter function.This function calculates the perimeter of a geometry object or geography object.Syntax float ST_Perimeter(geometry g1);float ST_Perimeter(geography geog,boolean useSpheroid);...
This topic describes the ST_Parent function.This function returns the parent grid of an H3-encoded geographic grid at the specified level.Syntax h3grid ST_Parent(h3grid code,integer level);Parameters Parameter Description ...
This topic describes the ST_Points function.This function constructs a MultiPoint object that contains all vertexes of a geometry object.Syntax geometry ST_Points(geometry geom);Parameters Parameter Description geom The ...
st_astext-GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 2,0 3))(1 row)聚合数据集：select ST_AsText(ST_Collect(t.geom))from(select(ST_DumpPoints(st_buffer('POINT(0 0)':geometry,1,'quad_segs=2'))).geom as geom)as t;st_astext-...
This topic describes the ST_ConcaveHull function.This function returns the concave hull of the input geometry objects.Syntax geometry ST_ConcaveHull(geometry geomA,float targetPercent,boolean allowHoles);Parameters ...
This topic describes the ST_OffsetCurve function.This function returns a geometry object representing all offset lines at the specified distance and margin from the input geometry object.Syntax geometry ST_OffsetCurve...
This topic describes the ST_PointN function.This function returns the Nth point of a LineString object or circular LineString object.Syntax geometry ST_PointN(geometry aLinestring,integer n);Parameters Parameter ...
函数分类 相关文档 描述 构造函数 ST_GeomFromText 返回与指定WKT字符串对应的Geometry对象。ST_LineFromMultiPoint 返回与指定MultiPoint对象对应的LineString对象。ST_MakePoint 返回构建的Point对象。输出函数 ST_AsText 返回指定...
st_astext-GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 2,0 3))(1 row)聚合数据集：select ST_AsText(ST_Collect(t.geom))from(select(ST_DumpPoints(st_buffer('POINT(0 0)':geometry,1,'quad_segs=2'))).geom as geom)as t;st_astext-...
This topic describes the ST_CoordDim function.This function returns the coordinate dimension of a geometry object.Syntax integer ST_CoordDim(geometry geomA);Parameters Parameter Description geomA The geometry object that ...
This topic describes the ST_Perimeter function.This function calculates the perimeter of a geometry object or geography object.Syntax float ST_Perimeter(geometry g1);float ST_Perimeter(geography geog,boolean useSpheroid);...
st_astext-GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 2,0 3))(1 row)聚合数据集：select ST_AsText(ST_Collect(t.geom))from(select(ST_DumpPoints(st_buffer('POINT(0 0)':geometry,1,'quad_segs=2'))).geom as geom)as t;st_astext-...
函数分类 相关文档 描述 构造函数 ST_GeomFromText 返回与指定WKT字符串对应的Geometry对象。ST_LineFromMultiPoint 返回与指定MultiPoint对象对应的LineString对象。ST_MakePoint 返回构建的Point对象。输出函数 ST_AsText 返回指定...
AsMVT3D function and ST_AsMVTGeom3D function The ST_AsMVT3D and ST_AsMVTGeom3D functions are added to support 3D vector slices of 3D geometries.ST_AsMVT3D and ST_AsMeom3D ST_AsTableFormat function The ST_AsTableFormat ...