0

I have used the network analyst to calculate service areas of varying facilities. Additionally I have points which represent buildings.

To make it short, I have the following data:

  • Polygons - which represent service areas
  • Points - which represent buildings

Is there a possbility to determine which buildings have access to zero, one, two, etc. etc. facilities?

In my understatement that would mean to to count the number of polygons in which a certain point is located.

How can I do that?

I am using ArcMap 10.6 with an advanced desktop license.

1

There is Spatial join for this.

Your data are in database or on PC?

If first, I would recommend you to use ST_Contains, this is the most natural way to realise your idea. The query to run is smth like

with new_values as 
(SELECT count(poly), poi.id from your_schema.polygons_with_facilities as poly 
JOIN your_schema.buildings as poi on 
    st_contains(poly.geom, poi.geom) group by poi.id)
UPDATE your_schema.buildings as b
SET field_for_counted_polys = nv.count from new_values nv where nv.id = b.id;

if your data are not in DB, try this approach

  • My data are on my own PC. I think the solution here is to first use the spaghetti and meatballs approach and then perform a spatial join. First the spaghetti and meatballs approach delivers me the information how many areas overlap in each polygon. – Max Sep 28 '18 at 10:19
  • There is a Esri Blog post on that topic: "More adventures in overlay: counting overlapping polygons with spaghetti and meatballs". Afterwards a spatial join with the points provides the information I am looking for. The information I am looking for is which household are within one, two, etc. etc. service areas. I am not done yet, let's see if it works. – Max Sep 28 '18 at 10:25
1

The above mentioned Esri Blog Post with the Spaghetti and Meatballs (More adventures in overlay: counting overlapping polygons with spaghetti and meatballs by Dan Honeycutt) approach delivered exactly what I needed and was very convenient. With the help of the Esri Support I was able to rebuild the model and it worked. The result in the end looked like this: Result of Spaghetti and Meatball Toolbox: Join_Count describes the number of overlapping polygons

With a spatial join I should now be able to add the inhabitants to each polygon.

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.