Mapgis与ArcGIS的装换,Oracle Spatial的相关selsct

今天没时间,贴两个链接

 

比较相同图元的sql语句.select Objectid 结果集数目多于一个时,运算速度巨慢

SELECT A.*

FROM temp_tudi_1 A, temp_tudi_1 B

WHERE B.Objectid in (select objectid from temp_tudi_1 where objectid =1 or objectid =2) and
  SDO_EQUAL(A.shape, B.shape) = 'TRUE';

 

 

http://www.cnblogs.com/upDOoGIS/archive/2009/05/20/1469871.html

 

 

http://zhidao.baidu.com/question/53845186.html