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/