Error generating shape from text: Invalid text used to construct geometry (-1)

最新推荐文章于 2025-03-27 07:30:00 发布

原创最新推荐文章于 2025-03-27 07:30:00 发布 · 6.8k 阅读

0 ·

CC 4.0 BY-SA版权

ArcSDE 专栏收录该内容

40 篇文章

订阅专栏

本文详细解释了在使用ArcSDE空间SQL时遇到的错误信息，即Polygon点串坐标的第一个点的X，Y坐标需要与最后一个点的X，Y坐标一致的问题。通过给出的解决方法，演示了如何正确闭合Polygon来避免此错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误信息:

SQL> select SDE.ST_GEOMETRY (‘POLYGON ((503433.822 294306.924, 503514.177
294339.956, 503531.789 294297.311, 503524.894 294272.889, 503481.474 294257.
951, 503450.539 294265.595, 503433.794 294306.914))’,2436) from dual;

ERROR at line 1:
ORA-20004: Error generating shape from text: Invalid text used to construct
geometry (-1).

Text: POLYGON ((503433.822 294306.924, 503514.177
294339.956, 503531.789 294297.311, 503524.894 294272.889, 503481.474 294257.
951, 503450.539 294265.595, 503433.794 294306.914))
ORA-06512: at “SDE.ST_GEOMETRY_SHAPELIB_PKG”, line 12
ORA-06512: at “SDE.ST_GEOMETRY”, line 55

原因:

ArcSDE空间SQL要求Polygon点串坐标的第一个点的X，Y坐标需要和最后一个点的X，Y坐标的坐标需要一致。

解决方法:

select SDE.ST_GEOMETRY (‘POLYGON ((503433.822 294306.924, 503514.177 294339.956, 503531.789 294297.311, 503524.894294272.889, 503481.474 294257.951, 503450.539 294265.595, 503433.794 294306.914, 503433.822294306.924))’,2436) from dual;
6.924))’,2436) from dual;