可以使用SQL Server中的STIntersects函数来判断两个多边形是否相交或重合,并获取重合面积。语句如下:SELECT STIntersects(polygon1, polygon2) AS overlap, STArea(STIntersection(polygon1, polygon2)) AS overlapArea;
可以使用SQL Server中的STIntersects函数来判断两个多边形是否相交或重合,并获取重合面积。语句如下:SELECT STIntersects(polygon1, polygon2) AS overlap, STArea(STIntersection(polygon1, polygon2)) AS overlapArea;