Multiple selection with a limit

Question

Good day folks.

I have a polygon shapefile with some data on closest ED to individual schools. I also know the population served by each school but I want to select the closest EDs with the total population amounting to the school capacity.

Any help on this would be appreciated

cheers,

Walter

WalterWilliams · Answer

All the EDs are associated with a school already using the closest facility tool. I will post a screenshot asap, but your last recommendation is what I'd like to do. Select from the ED associated with a school the closest ones that would add up to the school's capacity.

WalterWilliams · Answer

EDs are enumeration districts. I can do this manually by sorting on the distance field and manually select the EDs that add up to the school capacity. I was wondering since I have all the data in a single table if a query could be used to select the closest EDs to each school until the school capacity is met.

DavidPike · Answer

What's an ED?  The first few results of a google search probably aren't what you mean.

Are we talking about some kind of expanding radius of selection, selecting ED's A, B, C.. in order of proximity until the school capacity reaches the sum of the ED values?

If that's the case, I think it would be quite difficult, as the initial school chosen, and the subsequent ones etc. will affect which EDs are subsequently selected for other schools (unless you can have an ED assigned to another school or more?).