2

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 '15 at 10:35
  • @AlexLeith this question is tagged with PostGIS, so that would be a fair assumption. – Evil Genius Aug 28 '15 at 10:48
  • @EvilGenius - ah, good point... – Alex Leith Aug 29 '15 at 0:13
7

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, privacy policy and cookie policy

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