Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I create a polygon overlay that correctly handles holes? This answer provides a method of creating a polygon overlay that does not handle holes. Can it be modified to correctly handle holes?

Software Versions:

  • PostgreSQL 9.2.1
  • PostGIS 2.0.1 r9979
  • Windows Server 2008 R2
share|improve this question
use ST_MakePolygon… – Mapperz Feb 3 '13 at 4:09
I don't think that's correct. When a polygon has holes, another polygon can fall into the area of the whole, and that should result in a polygon inside the area of the hole. The function you recommend is for generating polygons that contain holes. That will not help in the case I describe. – jpmc26 Feb 12 '13 at 23:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.