|
There is no such function built-in, but you can try to construct one. Eg: --SQL9 FUNCTION GeomAdjacentBoundary(@g1 GEOM, @g2 GEOM, @e FLOAT64) BOOLEAN AS GeomAdjacent(@g1, @g2, @e) AND GeomCoordCount(GeomIntersectLines( GeomConvertToLine(@g1), GeomConvertToLine(@g2), @e )) > 1 END; SELECT d1.[mfd_id], d1.[adj_mfd_id], d1.[Geom], d2.[geom] as d2_Geom, d2.[mfd_id] as d2_mfd_id FROM [Drw_1 TABLE] AS d1 LEFT JOIN ( SELECT [mfd_id], [geom] FROM [Drw_2 TABLE] ) AS d2 ON GeomAdjacentBoundary(d1.[Geom], d2.[geom], 0); This will fail when two areas touch in, say, two point locations, not along a line. But for simple cases, this will be enough.
|