oracle spatial下对wkt字符串操作遇到srid的解决方案
select fid from vgnss where SDO_WITHIN_DISTANCE(geom, sdo_geometry(‘wkt’, 4326),’distance=1000 unit=KM’) = ‘TRUE’
select fid from vgnss where SDO_WITHIN_DISTANCE(geom, sdo_geometry(‘wkt’, 4326),’distance=1000 unit=KM’) = ‘TRUE’