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 返回指定...
访问函数
示例 示例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_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 ...
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}],...
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_{X|Y|Z|T}Min
获取BoxNDF类型中指定维度的最小值。语法 float8 ST_XMin...st_xmin-0 select ST_zmax(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmax(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_3DIntersects
st_3dintersects-t SELECT ST_3DIntersects(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...
ST_3DIntersects
st_3dintersects-t SELECT ST_3DIntersects(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...
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_3DIntersects
st_3dintersects-t SELECT ST_3DIntersects(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...
ST_{X|Y|Z|T}Min
获取BoxNDF类型中指定维度的最小值。语法 float8 ST_XMin...st_xmin-0 select ST_zmax(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmax(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
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_GeometryType
如 ST_Linestring、ST_Polygon、ST_MultiPolygon 等。此函数与GeometryType（geometry）不同，它不显示Geometry对象是否有M值。该函数支持3D对象，并且不会删除Z坐标。该函数支持 Polyhedral Surface类型几何对象。示例 默认调用：SELECT ...
2020年
ST_{Z|T|2D|2DT|3D|3DT}Intersects ST_{2D|2DT|3D|3DT}DWithin ST_{T|2D|2DT|3D|3DT}Contains ST_{T|2D|2DT|3D|3DT}Within 对轨迹类型提供统计信息收集功能，以及根据统计信息预估扫描代价功能。无 提供新的索引方式TrajGist，提供更好的...
LIST FUNCTIONS
numpy-1.19.4-cp37-cp37m-manylinux1_x86_64.zip ST_Aggr_ConvexHull ALIYUN$@aliyun.com 2021-03-18 17:06:29 com.esri.hadoop.hive.ST_Aggr_ConvexHull esri-geometry-api.jar,spatial-sdk-hive.jar ST_Aggr_Intersection ALIYUN$@aliyun....
ST_3DContains
st_3dcontains-f SELECT ST_3DContains(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_3DContains
st_3dcontains-f SELECT ST_3DContains(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_GeometryType
如 ST_Linestring、ST_Polygon、ST_MultiPolygon 等。此函数与GeometryType（geometry）不同，它不显示Geometry对象是否有M值。该函数支持3D对象，并且不会删除Z坐标。该函数支持 Polyhedral Surface类型几何对象。示例 默认调用：SELECT ...
- 产品推荐
- 这些文档可能帮助您