I am a beginner in the world of GIS.

I have one table polygons with each polygon having north-east and south-west coordinates. And for every polygon, I need to find area of overlap with other polygons (e.g. 70% area of polygon A overlaps with polygon B).

I know the ST_Intersects function, but it returns boolean. What other function that I can use with putting buffer as 70%?

If anybody could get me started, that would be great!

  • 1
    What technology are you using? SQL Server? PostGIS? Oracle? Desktop GIS of some sort?
    – Alex Leith
    Aug 28, 2015 at 10:35
  • @AlexLeith this question is tagged with PostGIS, so that would be a fair assumption. Aug 28, 2015 at 10:48
  • @EvilGenius - ah, good point...
    – Alex Leith
    Aug 29, 2015 at 0:13

1 Answer 1


ST_Intersection(geomA, geomB) returns a geometry, then calculate areas with ST_Area.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.