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
It is best to either define acronyms or avoid them, "ED" can mean a whole lot of different things to people from different fields or backgrounds.
Sample or example data is always good, screenshots can be useful too.
What have you tried already?
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?).