Thread: Where to start?

  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2016
    Rep Power

    Where to start?

    I want to make a program where I input an address and it'll calculate the distance between the input and a database of ~100 other addresses.

    The output will be the closest database address.

    How should I go about doing this?

    I know a little Excel VBA and I read that I can use a Google Maps API but in general, I don't know how to approach?
  2. #2
  3. Backwards Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Washington, USA
    Rep Power
    Get the latitude and longitude of every location, then calculate the distance between points using whichever method you want; if the addresses are all close (say, an hour's drive) then the simple √(∆lat+∆long) may be enough for simply comparing distances, otherwise you'll have to use the great-circle distance for accuracy.

IMN logo majestic logo threadwatch logo seochat tools logo