ST_{2D|2DT|3D|3DT}DWithin

b,ST_PGEpochToTS(0),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...

ST_Union

示例 对比ST_Union和ST_Collect:SELECT ST_Union(g1,g2),ST_Collect(g1,g2)from(select 'POLYGON((0 0,1 0,1 2,0 2,0 0))':geometry as g1,'POLYGON((1 0,3 0,3 1,1 1,1 0))':geometry as g2)as t;指定gridsize和options:指定gridsize ...

ST_Union

示例 对比ST_Union和ST_Collect:SELECT ST_Union(g1,g2),ST_Collect(g1,g2)from(select 'POLYGON((0 0,1 0,1 2,0 2,0 0))':geometry as g1,'POLYGON((1 0,3 0,3 1,1 1,1 0))':geometry as g2)as t;指定gridsize和options:指定gridsize ...

ST_Contains

查询网格对象代表的空间范围和几何对象是否是包含关系。语法 boolean ST_Contains(geomgrid grid,geometry ...st_intersects-f select st_contains(ST_gridfromtext('G00133103221330'),ST_gridfromtext('G001331032213300013'))st_contains-t

ST_Contains

查询网格对象代表的空间范围和几何对象是否是包含关系。语法 boolean ST_Contains(geomgrid grid,geometry ...st_intersects-f select st_contains(ST_gridfromtext('G00133103221330'),ST_gridfromtext('G001331032213300013'))st_contains-t

ST_Union

示例 对比ST_Union和ST_Collect:SELECT ST_Union(g1,g2),ST_Collect(g1,g2)from(select 'POLYGON((0 0,1 0,1 2,0 2,0 0))':geometry as g1,'POLYGON((1 0,3 0,3 1,1 1,1 0))':geometry as g2)as t;指定gridsize和options:指定gridsize ...

ST_OffsetCurve

示例 不同弧段分段数对比:select st_curvetoline(ST_OffsetCurve(g,1,'quad_segs=2')),st_curvetoline(ST_OffsetCurve(g,1.1,'quad_segs=3')),st_curvetoline(ST_OffsetCurve(g,1.2))g from(select 'LINESTRING(0 0,0 1,1 1)':geometry as...

ST_AsText

返回给定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)

ST_Within

查询网格对象代表的空间范围和几何对象是否是被包含关系。语法 boolean ST_Within(geomgrid grid,geometry geom);...st_within-f select st_within(ST_gridfromtext('G001331032213300013'),ST_gridfromtext('G001331032213300'))st_within-t

ST_Within

查询网格对象代表的空间范围和几何对象是否是被包含关系。语法 boolean ST_Within(geomgrid grid,geometry geom);...st_within-f select st_within(ST_gridfromtext('G001331032213300013'),ST_gridfromtext('G001331032213300'))st_within-t

时空函数

函数分类 相关文档 描述 输出函数 ST_AsText 返回指定Geometry对象的WKT(Well-known Text)格式。构造函数 ST_GeomFromText 返回与指定WKT字符串对应的Geometry对象。ST_LineFromMultiPoint 返回与指定MultiPoint对象对应的LineString对象...

ST_OffsetCurve

示例 不同弧段分段数对比:select st_curvetoline(ST_OffsetCurve(g,1,'quad_segs=2')),st_curvetoline(ST_OffsetCurve(g,1.1,'quad_segs=3')),st_curvetoline(ST_OffsetCurve(g,1.2))g from(select 'LINESTRING(0 0,0 1,1 1)':geometry as...

ST_OffsetCurve

示例 不同弧段分段数对比:select st_curvetoline(ST_OffsetCurve(g,1,'quad_segs=2')),st_curvetoline(ST_OffsetCurve(g,1.1,'quad_segs=3')),st_curvetoline(ST_OffsetCurve(g,1.2))g from(select 'LINESTRING(0 0,0 1,1 1)':geometry as...

ST_AsText

返回给定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)

ST_Contains

查询网格对象代表的空间范围和几何对象是否是包含关系。语法 boolean ST_Contains(geomgrid grid,geometry ...st_intersects-f select st_contains(ST_gridfromtext('G00133103221330'),ST_gridfromtext('G001331032213300013'))st_contains-t

ST_Contains

查询网格对象代表的空间范围和几何对象是否是包含关系。语法 boolean ST_Contains(geomgrid grid,geometry ...st_intersects-f select st_contains(ST_gridfromtext('G00133103221330'),ST_gridfromtext('G001331032213300013'))st_contains-t

ST_Within

查询网格对象代表的空间范围和几何对象是否是被包含关系。语法 boolean ST_Within(geomgrid grid,geometry geom);...st_within-f select st_within(ST_gridfromtext('G001331032213300013'),ST_gridfromtext('G001331032213300'))st_within-t

ST_Within

查询网格对象代表的空间范围和几何对象是否是被包含关系。语法 boolean ST_Within(geomgrid grid,geometry geom);...st_within-f select st_within(ST_gridfromtext('G001331032213300013'),ST_gridfromtext('G001331032213300'));st_within-t

ST_AsText

返回给定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)

时空栅格函数参考

round(Tile tile)st_exp Tile st_exp(Tile tile)st_exp2 Tile st_exp2(Tile tile)st_exp10 Tile st_exp10(Tile tile)st_abs Tile st_abs(Tile tile)st_log Tile st_log(Tile tile)st_log10 Tile st_log10(Tile tile)st_sqrt Tile st_sqrt...

ST_AsMVTEx

功能同 ST_AsMVT,但是相较于 ST_AsMVT,基于不同矢量要素之间的关系,过滤对显示效果影响较小的矢量要素,从而减小MVT大小,提升可视化效率。过滤的效果由新增参数scale_factor控制。新增参数 mvt_size_limit,限制一个MVT可以包含的矢量...

ST_AsMVTEx

功能同 ST_AsMVT,但是相较于 ST_AsMVT,基于不同矢量要素之间的关系,过滤对显示效果影响较小的矢量要素,从而减小MVT大小,提升可视化效率。过滤的效果由新增参数scale_factor控制。新增参数 mvt_size_limit,限制一个MVT可以包含的矢量...

关系函数

ST_Contains 函数是 ST_Within 的反函数,即 ST_Contains(A,B)=ST_Within(B,A)。示例 示例1 SELECT ST_Contains(ST_GeomFromText('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GeomFromText('POINT(5 5)'))AS iscontain;返回结果:+-+|...

ST_AsMVTEx

功能同 ST_AsMVT,但是相较于 ST_AsMVT,基于不同矢量要素之间的关系,过滤对显示效果影响较小的矢量要素,从而减小MVT大小,提升可视化效率。过滤的效果由新增参数scale_factor控制。新增参数 mvt_size_limit,限制一个MVT可以包含的矢量...

函数概览

函数分类 相关文档 描述 构造函数 ST_GeomFromText 返回与指定WKT字符串对应的Geometry对象。ST_LineFromMultiPoint 返回与指定MultiPoint对象对应的LineString对象。ST_MakePoint 返回构建的Point对象。输出函数 ST_AsText 返回指定...

函数概览

函数分类 相关文档 描述 构造函数 ST_GeomFromText 返回与指定WKT字符串对应的Geometry对象。ST_LineFromMultiPoint 返回与指定MultiPoint对象对应的LineString对象。ST_MakePoint 返回构建的Point对象。输出函数 ST_AsText 返回指定...

访问函数

示例 示例1 SELECT ST_AsText(ST_Centroid(ST_Collect(ST_MakePoint(1,1),ST_MakePoint(-1,-1))))AS astext;返回结果:+-+|astext|+-+|POINT(0 0)|+-+示例2 SELECT ST_AsText(ST_Centroid(ST_GeomFromText('LINESTRING(0 0,0 1,1 2)')))AS ...

访问函数

示例 示例1 SELECT ST_AsText(ST_Centroid(ST_Collect(ST_MakePoint(1,1),ST_MakePoint(-1,-1))))AS astext;返回结果:+-+|astext|+-+|POINT(0 0)|+-+示例2 SELECT ST_AsText(ST_Centroid(ST_GeomFromText('LINESTRING(0 0,0 1,1 2)')))AS ...

ST_Collect

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_Collect

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-...

访问函数

示例 示例1 SELECT ST_AsText(ST_Centroid(ST_Collect(ST_MakePoint(1,1),ST_MakePoint(-1,-1))))AS astext;返回结果:+-+|astext|+-+|POINT(0 0)|+-+示例2 SELECT ST_AsText(ST_Centroid(ST_GeomFromText('LINESTRING(0 0,0 1,1 2)')))AS ...

ST_Collect

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_Parent

获取H3编码的地理网格在指定层级的父网格。语法 h3grid ST_Parent(h3grid code,integer level);...st_astext-874a12668ffffff-指定第二层 select st_astext(st_parent(st_h3fromtext('884a126689fffff'),2));st_astext-824a17fffffffff

关系函数

ST_Contains 函数是 ST_Within 的反函数,即 ST_Contains(A,B)=ST_Within(B,A)。示例 示例1 SELECT ST_Contains(ST_GeomFromText('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GeomFromText('POINT(5 5)'))AS iscontain;返回结果:+-+|...

关系函数

ST_Contains 函数是 ST_Within 的反函数,即 ST_Contains(A,B)=ST_Within(B,A)。示例 示例1 SELECT ST_Contains(ST_GeomFromText('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GeomFromText('POINT(5 5)'))AS iscontain;返回结果:+-+|...

ST_Parent

获取H3编码的地理网格在指定层级的父网格。语法 h3grid ST_Parent(h3grid code,integer level);...st_astext-874a12668ffffff-指定第二层 select st_astext(st_parent(st_h3fromtext('884a126689fffff'),2));st_astext-824a17fffffffff

ST_3DWithin

st_3dwithin-f SELECT ST_3DWithin(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom":0}],...

ST_3DWithin

st_3dwithin-f SELECT ST_3DWithin(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom":0}],...

ST_AsBinary

示例 with g as(select unnest(st_asgrid(ST_geomfromtext('POINT(116.31522216796875 39.910277777777778)',4490),15))as grid)select ST_asBinary(grid)from g;st_asbinary-\x0102000f74271236 select st_asbinary(unnest(st_as3dgrid('...

ST_3DWithin

st_3dwithin-f SELECT ST_3DWithin(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom":0}],...
共有137条 < 1 2 3 4 ... 137 >
跳转至: GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
弹性公网IP 短信服务 人工智能平台 PAI 金融分布式架构 对象存储 物联网平台
新人特惠 爆款特惠 最新活动 免费试用