Hi,

It's been a while since I worked with arcGIS, and I know what I want to do should be easy, but I'm struggling.

My goal is to determine the supermarket accessibility in the Municipality of Amsterdam. I have all the files ready to go:

- the area is divided into grids of 100x100m

- the locations of all supermarkets are geocoded

- a suitable network dataset

Via the Network Dataset I want to get (from the center of the grids) for each grid

1) the distance to the nearest supermarket

2) the number of supermarkets within 1.000m

3) the mean distance to the three nearest supermarkets from different chains

The first one I managed to do simply with the Closest Facility option. With the second and the third I'm struggling. I hope somebody can help me.

Hello Bjorn. You should be able to use the Network Analyst tools to solve this problem.

1) I want from each geographic center of each grid the distance in meters to the nearest supermarket along the the network

^ Use Closest Facility, as you've already discovered.

2) I want from each geographic center of each grid the number of supermarket within 1.000 meter along the network

^ You can do this using the OD Cost Matrix tool. You would put in all the grid centroids as Origins and the supermarkets as Destinations. Use the "default cutoff" setting to set your 1000-meter limit. The results will be a list of travel distances from each origin to each supermarket within that 1000-meter cutoff, and you can just summarize the output table to calculate the number of supermarkets reached for each grid centroid.

3) I want from each geographic center of each grid the mean distance to the nearest three different-chain supermarkets.

^ This one is harder. I think you'll have to do this in multiple stages. You probably need to do a Closest Facility analysis for each supermarket chain separately. If you have 6 different chains, then you do 6 different Closest Facility analyses. Then you manually choose the three closest for each grid centroid and take the average of those three. If you're doing that analysis over and over again, you could automate that process with Model Builder or a python script.