ST_Boundary
st_astext-LINESTRING(1 0,2 0,0 2,1 0)(1 row)有洞的POLYGON的边界返回MULTILINESTRING：SELECT ST_AsText(ST_Boundary('POLYGON((1 0,3 0,0 3,1 0),(1 0,2 0,0 2,1 0))':geometry));st_astext-MULTILINESTRING((1 0,3 0,0 3,1 0),(1 0,2 ...
ST_Boundary
st_astext-LINESTRING(1 0,2 0,0 2,1 0)(1 row)有洞的POLYGON的边界返回MULTILINESTRING：SELECT ST_AsText(ST_Boundary('POLYGON((1 0,3 0,0 3,1 0),(1 0,2 0,0 2,1 0))':geometry));st_astext-MULTILINESTRING((1 0,3 0,0 3,1 0),(1 0,2 ...
ST_Boundary
st_astext-LINESTRING(1 0,2 0,0 2,1 0)(1 row)有洞的POLYGON的边界返回MULTILINESTRING：SELECT ST_AsText(ST_Boundary('POLYGON((1 0,3 0,0 3,1 0),(1 0,2 0,0 2,1 0))':geometry));st_astext-MULTILINESTRING((1 0,3 0,0 3,1 0),(1 0,2 ...
ST_3DPerimeter
返回给定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)
ST_3DPerimeter
返回给定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)
ST_3DPerimeter
返回给定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)
按量付费
vCPU 内存（GB）参考价格（元/时）通用型g5 1 4 0.76 通用型g6 1 4 0.428 计算型c5 1 2 0.532 计算型c6 1 2 0.333 内存型r5 1 8 0.969 内存型r6 1 8 0.565 表3：美国（弗吉尼亚）实例规格族 vCPU 内存（GB）参考价格（元/时）通用型g5 1 4 ...
ST_AsX3D
返回给定Geometry对象的X3D表示。语法 text ST_AsX3D(geometry g1,integer maxdecimaldigits,integer options);...st_asx3d-<IndexedFaceSet convex='false' coordIndex='0 1 2 3'><Coordinate point='1 10 1 2 0 2 2 0 2 1 0 '/>(1 row)
ST_AsX3D
返回给定Geometry对象的X3D表示。语法 text ST_AsX3D(geometry g1,integer maxdecimaldigits,integer options);...st_asx3d-<IndexedFaceSet convex='false' coordIndex='0 1 2 3'><Coordinate point='1 10 1 2 0 2 2 0 2 1 0 '/>(1 row)
ST_AsX3D
返回给定Geometry对象的X3D表示。语法 text ST_AsX3D(geometry g1,integer maxdecimaldigits,integer options);...st_asx3d-<IndexedFaceSet convex='false' coordIndex='0 1 2 3'><Coordinate point='1 10 1 2 0 2 2 0 2 1 0 '/>(1 row)
ST_Perimeter2D
返回给定Geometry对象的二维周长。目前与ST_Perimeter相同。语法 float ST_Perimeter2D(geometry geomA);参数 参数名称 描述 ...示例 默认调用：SELECT ST_Perimeter2D('POLYGON((0 0,0 2,2 2,2 0,0 0))':geometry);st_perimeter-8(1 row)
ST_Perimeter2D
返回给定Geometry对象的二维周长。目前与ST_Perimeter相同。语法 float ST_Perimeter2D(geometry geomA);参数 参数名称 描述 ...示例 默认调用：SELECT ST_Perimeter2D('POLYGON((0 0,0 2,2 2,2 0,0 0))':geometry);st_perimeter-8(1 row)
ST_Perimeter2D
返回给定Geometry对象的二维周长。目前与ST_Perimeter相同。语法 float ST_Perimeter2D(geometry geomA);参数 参数名称 描述 ...示例 默认调用：SELECT ST_Perimeter2D('POLYGON((0 0,0 2,2 2,2 0,0 0))':geometry);st_perimeter-8(1 row)
混流布局
3 id x y width height zorder 0 0.2547 0.00625 0.4906 0.4906 0 1 0.00625 0.5031 0.4906 0.4906 0 2 0.5031 0.5031 0.4906 0.4906 0 画廊模式_4 id x y width height zorder 0 0.013 0.013 0.4805 0.4805 0 1 0.5065 0.013 0.4805 0....
排序、去重、采样、数据变换
id name f1 f2 f3 f4 0 0 name1 1.0 NaN 3.0 4.0 1 1 name1 2.0 NaN NaN 1.0 2 2 name1 3.0 4.0 1.0 NaN 3 3 name1 NaN 1.0 2.0 3.0 4 4 name1 1.0 NaN 3.0 4.0 5 5 name1 1.0 2.0 3.0 4.0 6 6 name1 NaN NaN NaN NaN 使用 dropna，删除 ...
ST_Intersection
示例 默认调用：SELECT ST_AsText(ST_Intersection('POLYGON((0 0,0 2,2 2,2 0,0 0))':geometry,'POLYGON((0 0,3 0,3 1,0 1,0 0))':geometry));st_astext-POLYGON((0 0,0 1,2 1,2 0,0 0))(1 row)聚合裁剪 create table agg_result(id ...
ST_Intersection
示例 默认调用：SELECT ST_AsText(ST_Intersection('POLYGON((0 0,0 2,2 2,2 0,0 0))':geometry,'POLYGON((0 0,3 0,3 1,0 1,0 0))':geometry));st_astext-POLYGON((0 0,0 1,2 1,2 0,0 0))(1 row)聚合裁剪 create table agg_result(id ...
ST_Intersection
示例 默认调用：SELECT ST_AsText(ST_Intersection('POLYGON((0 0,0 2,2 2,2 0,0 0))':geometry,'POLYGON((0 0,3 0,3 1,0 1,0 0))':geometry));st_astext-POLYGON((0 1,2 1,2 0,0 0,0 1))(1 row)聚合裁剪 create table agg_result(id ...
PyODPS的排序
setosa 3 5.8 4.0 1.2 0.2 Iris-setosa 4 5.4 3.9 1.3 0.4 Iris-setosa Sql compiled:CREATE TABLE tmp_pyodps_97b080bb_e014_48e8_a310_4b45fcd6a2ed LIFECYCLE 1 AS SELECT*FROM WB_BestPractice_dev.`pyodps_iris` t1 ORDER BY ...
ST_SwapOrdinates
交换meshgeom或sfmesh对象指定坐标轴后...{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(2 0 0,3 10 0,1 10 10,1 0 10),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
ST_SwapOrdinates
交换meshgeom或sfmesh对象指定坐标轴后...{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(2 0 0,3 10 0,1 10 10,1 0 10),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]}
ST_{T|2D|2DT|3D|3DT}Within
示例 WITH traj AS(SELECT(' {"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"2000-01-01 03:15:42","end_time":"2000-01-01 05:16:43",'|'"spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47....
ST_{T|2D|2DT|3D|3DT}Within
示例 WITH traj AS(SELECT(' {"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"2000-01-01 03:15:42","end_time":"2000-01-01 05:16:43",'|'"spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47....
ST_{T|2D|2DT|3D|3DT}Within
示例 WITH traj AS(SELECT(' {"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"2000-01-01 03:15:42","end_time":"2000-01-01 05:16:43",'|'"spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47....
ST_{T|2D|2DT|3D|3DT}Within
示例 WITH traj AS(SELECT(' {"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"2000-01-01 03:15:42","end_time":"2000-01-01 05:16:43",'|'"spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47....
SAP系统云盘扩容指南
datavg-lvhdata 254:2 0 50G 0 lvm/hana/data└─datavg-lvhlog 254:3 0 10G 0 lvm/hana/log vdc 253:32 0 40G 0 disk├─datavg-lvhshared 254:1 0 20G 0 lvm/hana/shared├─datavg-lvhdata 254:2 0 50G 0 lvm/hana/data└─datavg-...
容器镜像版本
Node.js 性能平台容器镜像版本与运行时版本关系 说明：版本 x 和 x.y 对应最新的 x.y.z 版本，例如 4 和 4.6 都对应 4.x 的最新版本 4.6.0；后缀 stretch/slim/jessie/alpine：基础镜像不同；x.y.z：默认镜像，与-stretch 版本相同；...
产品定价
包年包月 Master资源规格 元/每月 2 0 4 0 8 0 16 1756.3 32 5268.9 按量付费 Master资源规格 元/每小时 2 0 4 0 8 0 16 3.658958332 32 10.976875 计算资源 高可用 系列 包年包月 计算节点规格 元/每个节点/每月 最低购买节点数量 2C16G ...
数仓版（3.0）产品定价
本文介绍 云原生数据仓库...包年包月集群的存储价格 计费项 按量付费价格 每月费用估算 ② 热存储数据 云盘等级PL0 0.0017元/GB/小时 1.224元/GB/月 云盘等级PL1 0.0042元/GB/小时 3.024元/GB/月 云盘等级PL2 0.0084元/GB/小时 6.048元/GB/月...
PMI
word1 word2 word1_count word2_count co_occurrences_count pmi w0 w0 2 2 1 2.0794415416798357 w1 w1 10 10 1-1.1394342831883648 w1 w2 10 3 1 0.06453852113757116 w1 w3 10 7 2-0.08961215868968704 w1 w5 10 8 1-0.916290731874155 ...
虚拟键码清单
（分隔键）VK_SUBTRACT 0x6D-（减键）VK_DECIMAL 0x6E 十进制键 VK_DIVIDE 0x6F/（除键）VK_F1 0x70 F1键 VK_F2 0x71 F2键 VK_F3 0x72 F3键 VK_F4 0x73 F4键 VK_F5 0x74 F5键 VK_F6 0x75 F6键 VK_F7 0x76 F7键 VK_F8 0x77 F8键 VK_F9 0x78 ...
ST_MeshGeomFromText
示例 select ST_AsEWKT(ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX(...
ST_MeshGeomFromText
示例 select ST_AsEWKT(ST_MeshGeomFromText('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX(...
ST_MeshGeomFromWKT
示例 select ST_AsEWKT(ST_MeshGeomFromWKT('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0...
ST_MeshGeomFromWKT
示例 select ST_AsEWKT(ST_MeshGeomFromWKT('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))',4326));SRID=4326;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0...
ST_NumGeometries
示例 示例一：select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);1 示例二：select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,...
ST_NumGeometries
示例 示例一：select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);1 示例二：select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,...
ST_AsWKT
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsWKT(ST_MeshGeomFromText...
ST_AsWKT
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsWKT(ST_MeshGeomFromText...
ST_AsEWKT
{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))"],"primitives":[{"meshgeom":0}],"nodes":[{"primitive":0}]} select ST_AsEWKT(ST_...
- 产品推荐
- 这些文档可能帮助您