Location-Allocation based on capacity/weight

[AndreiB]

Hi!

I have a layer with all the schools from an area and also a column with the number of pupils which exceed the maximum capacity of the school.

The other layer contains the school in the same area with fewer pupils than the maximum and there is a column with the number of spots free.

I want to use location-allocation to find where to send the excess number of people to another school based on the numbers. If I have 15 people exceeding and the closest school has only 5 free spots, then allocate 5 people there and the other 10 to the next available school.

I tried to make it using weight and capacity, but it didn't work..all the people were allocated to the other school, even if fewer spots were available.

Please help me with all the necessary settings; something is definitely missing..thank you!

[DavidPike]

I think the issue that you're seeing is that if the demand weight is higher than a capacity point can take, then that capacity point is simply skipped.

There may be some way, but it might be best to generate points for each student.  Perhaps:

Buffer the excess school points a small distance

'Create Random Points' tool -> constraining feature = the buffer, number of points = excess student field

Spatial join 'intersect' the points to the original buffer to transfer school attribute (maybe used in 'Group' field later?)

Run the analysis.