I'm new on PostGIS

I have this enter image description here

The orange ones are buffers, the red dots are the centroids of each brown polygon

So I've tried to cover the brown polygons by making buffers of the centroids (red dots) and the results are this enter image description here

How can I get the pink buffers that cover the most parts of the red dots?.

I made something on QGIS picking it by myself manually.

enter image description here

I'm looking for something like this, but no idea how to start the sentence.

  • 2
    Are you looking for the minimal set of green buffers which covers all the centroids? What does most parts mean? – Zoltan Apr 21 at 6:25
  • Seems similar to the closed question? What is you goal? gis.stackexchange.com/questions/393476/spatial-analysis-issues – Mapperz Apr 21 at 13:44
  • @Zoltan The pink buffers are the originals buffers, the green buffers I choose it manually on QGIS as example. I looking at the sentence that allows me to keep only the pink buffers that contains the most quantity of red dots inside them. As you can see are a lot of pink buffers that intersect each other, maybe it's like a simplification where I can keep the simplification. – Jeff_Barahona Apr 21 at 19:08
  • @Mapperz no like that, don't need to use the hexagons here. – Jeff_Barahona Apr 21 at 19:10
  • 1
    @robinloche The yellow dots on the 1st pic are schools, the orange buffer is the cover of each school in a 20km area. A minimum number of buffer to cover for example 80% of the red dots that could work. The green buffers have the same size (20km). I'm looking for new places for schools, so the red dots are zones that fit well with ubication criteria. That's why I'm tried to keep just the buffers that contain the most number of the red dots and don't intersect with the orange ones. – Jeff_Barahona Apr 22 at 21:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.