如何将wkt转换为oracle sql 我正在使用:
How to convert wkt to oracle sql I am using:
SELECT SDO_GEOMETRY('POINT(-121.909315288067 37.3618668002592)',4326) as station_geom_oracle FROM dual我得到了MDSYS.SDO_GEOMETRY
运行:
Java(TM) Platform 1.8.0_151 Oracle IDE 19.1.0.094.2042 Versioning Support 19.1.0.094.2042推荐答案
我是从另一个问题来到这里的,而您做对了.查询结果只是告诉您已经创建了一个几何对象.无法在表中显示几何对象,因此只能在方括号中给出数据类型.您可以尝试使用SDO_UTILS.TO_WKTGEOMETRY(geom)函数将其转换回WKT以确认它是否正常工作.如果可以,请尝试使用SDO_UTILS.SDO_DISTANCE计算它们之间的距离.
I came here from your other question, and you've done it right. The query result is just telling you that you've created a geometry object. There's no way of showing a geometry object in a table so it just gives the data type in square brackets. You could try converting it back into WKT to confirm that it's worked using the SDO_UTILS.TO_WKTGEOMETRY(geom) function. If that looks ok try using SDO_UTILS.SDO_DISTANCE to calculate distance between them.
更多推荐
将Wkt转换为Oracle几何
发布评论