postgresql - 如何计算重叠面积 - postgis，postgres？

Question

如何计算重叠面积？

select ST_Area(ST_Overlaps(geometrya, geometryb)::geometry) from table_name;

错误消息无法将类型 boolean 转换为几何

Answer 1

ST_OVERLAPS返回一个 bool 值，指示几何图形是否相互重叠。要获取交叉口的几何形状，您可以使用 ST_INTERSECTION

select ST_Area(ST_INTERSECTION(geometrya, geometryb)) from table_name
 WHERE ST_Overlaps(geometrya, geometryb);