We need to calculate the driving distance between students and the nearest PreK center. The issue with using the Cost Matrix is the cost. We have 250,000 students and around 2,500 centers.

I considered using the top ten nearest using the near table by filtering each layer before using the cost matrix for each student, but it will take too much time to run through so many students.

So I'm looking for an alternative. We've looked into using Google Maps Platform, but the cost is still too high. I've also explored using Find routes, but it doesn't seem to be the right tool. Or maybe I just don't understand it well enough. Can it be used to calculate distance between a series of sets of coordinates?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.