Arcgis通过SQL查几何图形相交记录和求相交范围及面积

Arcgis通过SQL查几何图形相交记录和求相交范围及面积
1、Arcgis通过SQL查DISTRICT图层中与TEST图层中objectid=44的几何图形相交的记录
select d.NAME, t.objectid
  from SDE.DISTRICT d, SDE.TEST t
 where sde.st_intersects(d.shape, t.shape) = 1
   and t.objectid = '44'
2、Arcgis通过SQL求DISTRICT图层中与TEST图层中objectid=44的几何图形相交的范围坐标和相交的面积
SELECT d.NAME, t.objectid, sde.st_astext (sde.st_intersection (d.shape, t.shape)) Intersection, 
sde.st_area (sde.st_intersection (d.shape, t.shape)) Area
 FROM SDE.DISTRICT d, SDE.TEST t
 WHERE sde.st_astext (sde.st_intersection (d.shape, t.shape)) NOT LIKE '%EMPTY%'
   and t.objectid = '44';

参考文档： 与 ST_Geometry 配合使用的 SQL 函数

http://resources.arcgis.com/zh-cn/help/main/10.1/index.html#/na/006z0000003n000000/