Oraclespatial周边查询SQL

Oracle spatial周边查询SQL

 

查询距某一点某一距离的所有要素（即我们通常说的周边查询）sql:

  www.2cto.com  

select t.objectid,t.comp_type,t.datatype,t.comp_name,t.health_lic,t.shape.SDO_POINT.X as x,t.shape.SDO_POINT.Y as y,t.reg_addr,t.bus_addr from t_publicplaces t where 1=1 and substr(t.comp_type,0,2)=&＃39;01&＃39; and sdo_within_distance(t.SHAPE,SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(116.4,39.9,NULL),
NULL,NULL),&＃39;distance=1500.0 unit=m&＃39;)=&＃39;TRUE&＃39;

 

//其中sdo_within_distance是oracle  spatial空间查询 这个函数的具体参数与用法可以到
oracle官网上去搜索