sql - 如何从oracle中删除多边形中的孔
问题描述
这是一个几何!
MDSYS.SDO_GEOMETRY(2003, 2400000, null,
MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1),
MDSYS.SDO_ORDINATE_ARRAY(
8432760.28444425, 4547222.21132491,
8432767.40437640, 4547207.64930884,
8432787.32577175, 4547207.51350532,
8432781.00917312, 4547223.73964561,
8432760.28444425, 4547222.21132491))
这是一个几何!
MDSYS.SDO_GEOMETRY(2003, 2400000, null,
MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1, 11, 2003, 1),
MDSYS.SDO_ORDINATE_ARRAY(
8432760.2844442501664161682128906250, 4547222.211324909701943397521972656250,
8432767.404376400634646415710449218750, 4547207.649308839812874794006347656250,
8432787.325771750882267951965332031250, 4547207.513505320064723491668701171875,
8432781.009173119440674781799316406250, 4547223.739645609632134437561035156250,
8432760.2844442501664161682128906250, 4547222.211324909701943397521972656250,
8432777.8091080002486705780029296875, 4547210.60657539963722229003906250,
8432768.0091079995036125183105468750, 4547215.702575399540364742279052734375,
8432777.9211079999804496765136718750, 4547219.79057539999485015869140625,
8432777.8091080002486705780029296875, 4547210.60657539963722229003906250))
如何去除多边形中的孔?返回我的第一个几何
解决方案
使用 sdo_util.extract 获取第一个元素的第一个环。
select sdo_util.extract(mdsys.sdo_geometry(2003
,2400000
,null
,mdsys.sdo_elem_info_array(1, 1003, 1, 11, 2003, 1)
,mdsys.sdo_ordinate_array(8432760.2844442501664161682128906250
,4547222.211324909701943397521972656250
,8432767.404376400634646415710449218750
,4547207.649308839812874794006347656250
,8432787.325771750882267951965332031250
,4547207.513505320064723491668701171875
,8432781.009173119440674781799316406250
,4547223.739645609632134437561035156250
,8432760.2844442501664161682128906250
,4547222.211324909701943397521972656250
,8432777.8091080002486705780029296875
,4547210.60657539963722229003906250
,8432768.0091079995036125183105468750
,4547215.702575399540364742279052734375
,8432777.9211079999804496765136718750
,4547219.79057539999485015869140625
,8432777.8091080002486705780029296875
,4547210.60657539963722229003906250))
,1
,1) geometry
from dual
https://docs.oracle.com/database/121/SPATL/sdo_util-extract.htm#SPATL1228
推荐阅读
- reactjs - 删除重复的 JSX 元素 | 反应 Strapi graphql
- django - 如果 ForeignKey 的值为 None,如何获取对象的类型?
- javascript - 需要帮助使用 react v17 过滤自动完成数组
- python-3.x - 在 spacy 自定义试用模型中:Config Validation error ner -> wrong_spans_key extra fields not allowed
- html - 设备屏幕宽度减小时表头消失
- opencv - Yolov5自定义对象检测模型未加载
- maven - Whitesource 扫描正在下载未使用的库,而不是通过 mvn 依赖树扫描项目使用的 jar
- anylogic - 为什么 rackstore 看不到到达托盘架的路径?
- ios - 缩放正在交互移动/重新排列的动画 UICollectionViewCell
- fortran - 编译函数和公共块同名的不同文件