2.9. ArcGIS 对 SFS 的支持¶

ArcGIS 10 之前的全系列产品都支持 SFS 标准，版本为 1.1。下面通过几个ArcSDE（Oracle）的空间 SQL 操作看一下：

select st_astext(st_geometry('POINT(116 39)',0)) from dual;

select shape from TEST where st_envintersects(shape,40251885,4019516,40255159,4021607)=1;

select shape from TEST where st_intersects(shape, st_geometry('POLYGON((0 0,180 -90,180 90,0 0))',2))=1;

select st_relate (g1, g2, 'T*F**FFF*') equals, st_relate (g1, g3, 'T*F**FFF*') not_equals from RELATE_TEST;

select sum (st_area (st_difference (lot, footprint))) from FOOTPRINTS bf, LOTS where bf.building_id = lots.lot_id;