时空几何函数参考

ST_Area Double st_area(Geometry g)返回Geometry的面积 ST_Centroid Point st_centroid(Geometry g)返回Geometry的几何中心 ST_ClosestPoint Point st_closestPoint(Geometry a,Geometry b)返回a与b距离最近的POINT对象 ST_Distance ...

Ganos函数列表

Raster SQL参考 功能 函数 说明 Raster创建 ST_CreateRast 创建一个基于阿里云对象存储服务(OSS)的raster对象。导入导出 ST_ImportFrom 将一个OSS文件导入到数据库。ST_ExportTo 将一个raster对象导出为OSS文件。金字塔操作 ST_...

空间几何函数

查询和分析语句*|SELECT ST_Difference(ST_GeometryFromText('multipolygon(((10 10,10 20,20 20,0 15,0 10),(50 40,50 50,60 50,60 40,50 40)))'),ST_GeometryFromText('multipolygon(((10 10,10 20,20 20,20 15,10 10),(50 40,50 50,60 ...

PostGIS地理信息分析

select st_astext(geom)from holo_gis_2 where ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(116,39),ST_Point(117,40)),4326),geom);多边形相交判定(在内部或在边界上)不指定SRID值。select st_astext(geom)from holo_gis_1 where ST_...

UDF(地理空间)

本文为您介绍如何使用开源地理空间UDF分析空间数据。前提条件 请确认您已完成以下操作:已安装Git。已安装Maven并设置环境变量。已安装MaxCompute客户端。更多安装MaxCompute客户端信息,请参见 安装并配置MaxCompute...CREATE FUNCTION ST_...

ST_{T|2D|2DT|3D|3DT}Contains

st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains-+-+-+-+-+-+-+-+-+-+-+-t|t|t|t|t|t|f|f|f|f|f|f

ST_{T|2D|2DT|3D|3DT}Contains

st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains-+-+-+-+-+-+-+-+-+-+-+-t|t|t|t|t|t|f|f|f|f|f|f

ST_{T|2D|2DT|3D|3DT}Contains

st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains-+-+-+-+-+-+-+-+-+-+-+-t|t|t|t|t|t|f|f|f|f|f|f

ST_{T|2D|2DT|3D|3DT}Contains

st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains|st_2dcontains|st_3dcontains|st_2dtcontains|st_3dtcontains-+-+-+-+-+-+-+-+-+-+-+-t|t|t|t|t|t|f|f|f|f|f|f

时空数据库版本发布记录

性能优化 GeomGrid SQL 增强 ST_AsGeometry、ST_AsText、ST_AsBinary、ST_Level 函数支持h3grid类型。Raster SQL 增强 ST_Statistics 函数支持任意几何类型统计。FDW SQL 增强支持基于UTF-8编码的文件名称或字段名称。Scene SQL 增强 ST_...

时空数据库版本发布记录

性能优化 GeomGrid SQL 增强 ST_AsGeometry、ST_AsText、ST_AsBinary、ST_Level 函数支持h3grid类型。Raster SQL 增强 ST_Statistics 函数支持任意几何类型统计。FDW SQL 增强支持基于UTF-8编码的文件名称或字段名称。Scene SQL 增强 ST_...

时空引擎版本发布记录

性能优化 GeomGrid SQL 增强 ST_AsGeometry、ST_AsText、ST_AsBinary、ST_Level 函数支持h3grid类型。Raster SQL 增强 ST_Statistics 函数支持任意几何类型统计。FDW SQL 增强支持基于UTF-8编码的文件名称或字段名称。Bug修复 GeomGrid SQL...

st7789(LCD)

API说明 st7789硬件初始化 int st7789_hw_init(st7789_dev_t*st7789_dev)args description st7789_dev st7789设备结构体,注意以指针形式访问 st7789硬件去初始化 int st7789_hw_uninit(st7789_dev_t*st7789_dev)args description st7789_...

ST_IsRing

st_isring|st_isclosed|st_issimple-+-+-t|t|t(1 row)返回false的情况:SELECT ST_IsRing(geom),ST_IsClosed(geom),ST_IsSimple(geom)FROM(SELECT 'LINESTRING(0 0,0 2,0 0)':geometry AS geom)AS test;st_isring|st_isclosed|st_issimple-...

ST_IsRing

st_isring|st_isclosed|st_issimple-+-+-t|t|t(1 row)返回false的情况:SELECT ST_IsRing(geom),ST_IsClosed(geom),ST_IsSimple(geom)FROM(SELECT 'LINESTRING(0 0,0 2,0 0)':geometry AS geom)AS test;st_isring|st_isclosed|st_issimple-...

ST_MakeLine

从Point、MultiPoint或者Line等...st_astext-LINESTRING Z(1 2 3,4 5 6)(1 row)通过数组构建:SELECT ST_AsText(ST_MakeLine(ARRAY[ST_MakePoint(1,2),ST_MakePoint(3,4),ST_MakePoint(5,6)]));st_astext-LINESTRING(1 2,3 4,5 6)(1 row)

ST_MakeLine

从Point、MultiPoint或者Line等...st_astext-LINESTRING Z(1 2 3,4 5 6)(1 row)通过数组构建:SELECT ST_AsText(ST_MakeLine(ARRAY[ST_MakePoint(1,2),ST_MakePoint(3,4),ST_MakePoint(5,6)]));st_astext-LINESTRING(1 2,3 4,5 6)(1 row)

ST_MakeLine

从Point、MultiPoint或者Line等...st_astext-LINESTRING Z(1 2 3,4 5 6)(1 row)通过数组构建:SELECT ST_AsText(ST_MakeLine(ARRAY[ST_MakePoint(1,2),ST_MakePoint(3,4),ST_MakePoint(5,6)]));st_astext-LINESTRING(1 2,3 4,5 6)(1 row)

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 2020年10月 对轨迹类型提供统计信息收集功能,以及根据统计信息预估扫描代价功能。无 2020年10月 提供新的索引方式...

ST_MakePoint

语法 geometry ST_MakePoint(double precision x,double precision y);geometry ST_MakePoint(double precision x,double precision y,double precision z);geometry ST_MakePoint(double precision x,double precision y,double precision...

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_IsRing

st_isring|st_isclosed|st_issimple-+-+-t|t|t(1 row)返回false的情况:SELECT ST_IsRing(geom),ST_IsClosed(geom),ST_IsSimple(geom)FROM(SELECT 'LINESTRING(0 0,0 2,0 0)':geometry AS geom)AS test;st_isring|st_isclosed|st_issimple-...

ST_MakePoint

语法 geometry ST_MakePoint(double precision x,double precision y);geometry ST_MakePoint(double precision x,double precision y,double precision z);geometry ST_MakePoint(double precision x,double precision y,double precision...

ST_MakePoint

语法 geometry ST_MakePoint(double precision x,double precision y);geometry ST_MakePoint(double precision x,double precision y,double precision z);geometry ST_MakePoint(double precision x,double precision y,double precision...

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

访问函数

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

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...
共有75条 < 1 2 3 4 ... 75 >
跳转至: GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
威胁情报服务 弹性公网IP 短信服务 人工智能平台 PAI 物联网平台 对象存储
新人特惠 爆款特惠 最新活动 免费试用