postgresql - 如何计算重叠区域 - postgis，postgres？

Question

如何计算重叠面积？

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

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

标签： postgresqlpostgisoverlaparea

Answer 1

ST_OVERLAPS返回一个布尔值，指示几何是否相互重叠。要获得交叉点的几何形状，您可以使用ST_INTERSECTION

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