Thread: Where to start?

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

    Join Date
    Nov 2016
    Posts
    1
    Rep Power
    0

    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. Lazy Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,279
    Rep Power
    9645
    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