概述
错误信息:
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;
最后
以上就是乐观冬日为你收集整理的Error generating shape from text: Invalid text used to construct geometry (-1)的全部内容,希望文章能够帮你解决Error generating shape from text: Invalid text used to construct geometry (-1)所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复