I am analyzing parcels in land use zones.
Some parcels overlap 3 or more zones = I am interested in selecting only those records (i.e. the purple-colored parcels)
At this point I have a query that joins zones in
zoning to parcels in
parcels when an intersection occurs
SELECT t.*, m.* FROM parcels AS t LEFT JOIN zoning AS m ON ST_Intersects(t.geom, m.geom)
ST_Intersection() only returns
false . Is there a way to "count" the intersections and specify 3 or more?