Zip Code Radius Search That Calculates Driving Distance Not "As Crow Flies"

Posted on 2009-04-29
Last Modified: 2012-06-21
I'm performing a zip radius search for a client of mine using Long/Lat.  The problem is that this returns distances as the crow flies and not actually driving distance.  My client is complaining that the numbers are way off.  I would disagree about the "way off" part but I do see their point.   Bodies of Water, In direct highway routes, etc. etc., make the actual driving distance more than the crow flies distance.

1) can I leverage what I have and still account for driving distance (I have a DB of zip codes and long/lat)
2) if not, what "tool" can I use to do these calculations.  This is going to work against a DB of 1,000,000 records so it has to be fast.
Question by:davidcahan
    LVL 31

    Expert Comment

    have a look at
    LVL 60

    Accepted Solution

    if you use something like microsoft's mappoint, you can access the DLLs to write your own apps like that.  

    what you're trying to do w/ sql server is gong to be VERY difficult.  2008 is geographically aware, but not "road" know what I mean?

    Author Comment

    i'm trying to advise a client.  I'm sure i can use mappoint but I don't think it's going to suit her requirements which would be to enter a starting zip and then find all the leads in our system that are X driving distance miles away.  I would imagine that a process like that would take hours to return a result set.

    sound correct?
    LVL 60

    Expert Comment

    I would look into it...from what I've read about it...that is exactly what its built for.

    Author Comment


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now