ST_MeshGeomFromHexEWKB

示例 select ST_AsEWKT(ST_MeshGeomFromHexEWKB(ST_AsHexEWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10...

ST_MeshGeomFromWKB

示例 select ST_AsEWKT(ST_MeshGeomFromWKB(ST_AsWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));st_asewkt-MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10...

ST_MeshGeomFromBinary

示例 select ST_AsEWKT(ST_MeshGeomFromBinary(ST_AsBinary('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom)));MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1...

ST_GeometryN

返回子对象的第N个部件。语法 meshgeom ST_NumGeometries(meshgeom geom,integer index);meshgeom ST_NumGeometries(sfmesh sfmeshObject,...MESHGEOM(PATCH(INDEXSURFACE Z(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))

注册Oracle（本地）

前提条件 本地数据库服务器的网络已经通过专线或者VPN和阿里云专有网络（VPC）及路由（线下到云上100.64.0.0/10或100.64.0.0/11、100.96.0.0/11）互通。操作步骤 登录 云备份Cloud Backup控制台。在左侧导航栏，选择 备份>数据库备份。在...

ST_MeshFrommeshGeom

从meshgeom构造sfmesh对象。...{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]}

ST_MeshGeomFromEWKT

从EWKT构造meshgeom对象。...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'));SRID=4490;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0),INDEX((0,1,2),(1,2,3)))))

ST_MeshFromHexEWKB

从HexEWKB构造sfmesh对象。...st_asewkt-{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]}

ST_Npoints

返回坐标点总数量。语法 int4 ST_NPoints(meshgeom geom);int4 ST_NPoints(sfmesh sfmeshObject);...示例 select ST_NPoints('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);4

ST_CoordDim

返回坐标维度信息。语法 int2 ST_CoordDim(meshgeom geom);int2 ST_CoordDim(sfmesh sfmeshObject);...示例 select ST_CoordDim('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);3

ST_Srid

返回对象空间参考ID信息。语法 int4 ST_Srid(meshgeom geom);int4 ST_Srid(sfmesh sfmeshObject);参数 参数名称 描述 geom meshgeom...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'));4490

ST_BoundingDiagonal

返回对象对角线信息。语法 geometry ST_...示例 select ST_AsText(ST_BoundingDiagonal('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom));LINESTRING Z(0 0 1,10 10 3)

ST_NDims

返回坐标维度信息。语法 int2 ST_NDims(meshgeom geom);int2 ST_NDims(sfmesh sfmeshObject);...示例 select ST_NDims('MESHGEOM(PATCH(INDEXSURFACE M(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);3

ST_YupToZup

返回结果：{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VE RTEX(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,"matrix":[1,0,0,-1,0,0,0,0,...

ST_ZupToYup

返回结果：{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE Z(VE RTEX(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,"matrix":[1,0,0,1,0,0,0,0,-...

ST_NumPatches

返回meshgeom或sfmesh对象构成的面的数量。语法 int4 ST_NumPatches(meshgeom geom);...示例 select ST_NumPatches('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);2

ST_SetSrid

设置对象空间参考ID信息。语法 meshgeom ST_Srid(meshgeom geom,int4 srid);sfmesh ST_Srid(sfmesh sfmeshObject,int4 srid);...MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'),4326));4326

概述

其他数据终端版本 数据迁移 V1.4.79、V2.2.30、V2.2.52、V2.2.76、V2.2.77、V3.1.x、V3.2.x、V4.0.0、V4.1.0、V4.2.0、V4.2.1、V4.2.2 MySQL/RDS MySQL/Polar MySQL：V5.5、V5.6、V5.7、V8.0 Oracle：10GR2、11GR2、12C/18C/19C CDB/PDB ...

ST_AsText

示例 select ST_AsText(ST_MeshFromText('{"version":1,"root":0,"meshgeoms":["MESHGEOM(PATCH(INDEXSURFACE(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}]...

2021年

PolarDB-X 2.0同步至阿里云消息队列Kafka PolarDB-X 2.0迁移至阿里云消息队列Kafka 升级实例配置：升级包年包月实例和按量付费实例的链路规格配置（新版控制台）。升级任务的链路规格 转换实例计费方式：包年包月实例和按量付费实例之间...

ST_IsEmpty

判断是否为空对象。...示例 示例一：select ST_IsEmpty('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))':meshgeom);f 示例二：select ST_IsEmpty('MESHGEOM EMPTY':meshgeom);t

ST_MeshFromWKT

从WKT构造sfmesh对象。语法 sfmesh ST_MeshFromWKT(text wkt);sfmesh ST_MeshFromWKT(text wkt,int4 srid);参数 参数名称 描述 wkt 基于WKT描述的sfmesh...MESH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3))))"}

ST_Transform

MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),(1,2,3)))))'),3857));SRID=3857;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 1118889.97485796 3,1113194.90793274 1118889.97485796 1,1113194....

ST_AddBBox

示例 Select ST_HasBBOX(ST_AddBBOX('{"version":1,"srid":4490,"root":0,"lod":1,"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...

ST_AsGltf

示例 select ST_AsGltf(ST_MeshFromText('{"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...

OGG插件介绍

例如0,1,2 rowIdColumn-可选 Oracle表中的rowid与DataHub相对应的字段，必须为String类型，一般在没有主键的Oracle表中使用 ctypeColumn-可选 同defaultDatahubConfigure中的ctypeColumn ctimeColumn-可选 同defaultDatahubConfigure中的...

ST_HasBBox

示例 Select ST_HasBBOX('{"version":1,"srid":4490,"root":0,"lod":1,"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":[{...

ST_AsGlb

示例 select ST_AsGlb(ST_MeshFromText('{"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}...

ST_LOD

示例 Select ST_LOD(ST_SetLod('{"version":1,"srid":4490,"root":0,"lod":1,"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":[{...

ST_SetLOD

示例 Select ST_LOD(ST_SetLod('{"version":1,"srid":4490,"root":0,"lod":1,"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":[{...

ST_AsWKB

示例 select ST_AsWKB(ST_MeshFromText('{"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}...

ST_AsEWKB

示例 select ST_AsEWKB(ST_MeshFromText('{"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...

ST_AsHexEWKB

示例 select ST_AsHexEWKB(ST_MeshFromText('{"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...

ST_AsBinary

示例 select ST_AsBinary(ST_MeshFromText('{"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...

ST_Boundary

st_astext-MULTIPOINT(1 0,2 0)(1 row)POLYGON的边界返回LINESTRING：SELECT ST_AsText(ST_Boundary('POLYGON((1 0,2 0,0 2,1 0))':geometry));st_astext-LINESTRING(1 0,2 0,0 2,1 0)(1 row)有洞的POLYGON的边界返回MULTILINESTRING：...

ST_NumGeometries

示例 Multi对象：SELECT ST_NumGeometries('MULTIPOLYGON(((1 0,0 3,3 0,1 0)),((1 0,2 0,0 2,1 0)))':geometry);st_numgeometries-2(1 row)GeometryCollection对象：SELECT ST_NumGeometries('GeometryCollection(POINT(1 0),POLYGON((1 0...

ST_GeometryN

返回给定Geometry里面...st_astext-POLYGON((1 0,2 0,0 2,1 0))(1 row)提取GeometryCollection对象：SELECT ST_AsText(ST_GeometryN('GeometryCollection(POINT(1 0),POLYGON((1 0,2 0,0 2,1 0)))':geometry,1));st_astext-POINT(1 0)(1 row)

ST_InteriorRingN

返回输入Polygon参数的第n条（从1开始计数）内部边界圈的LineString。...示例 SELECT ST_AsText(ST_InteriorRingN('POLYGON((1 0,3 0,0 3,1 0),(1 0,2 0,0 2,1 0))':geometry,1));st_astext-LINESTRING(1 0,2 0,0 2,1 0)(1 row)

支持列表

MySQL 4.1、5、5.0、5.1、5.4、5.5、5.6、5.7 Oracle Oracle 9i、Oracle 10g、Oracle 11g、Oracle 12c、Oracle 18c、Oracle 19c、Oracle Data Guard 11g、Oracle Data Guard 12c SQL Server SQL Server 2005、SQL Server 2008、SQL Server ...

ST_NumInteriorRing

返回输入Polygon对象的内边界环的个数。语法 integer ST_NumInteriorRing(geometry aPolygon);...示例 SELECT ST_NumInteriorRing('POLYGON((1 0,0 3,3 0,1 0),(1 0,2 0,0 2,1 0))':geometry);st_numinteriorring-1(1 row)
共有200条 < 1 2 3 4 ... 200 >
跳转至： GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
云服务器 ECS DDoS防护 Web应用防火墙 弹性公网IP 短信服务 人工智能平台 PAI

新品推荐

新人特惠 爆款特惠 最新活动 免费试用
新人特惠 爆款特惠 最新活动 免费试用