• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 781
  • Last Modified:

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

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.
0
davidcahan
Asked:
davidcahan
  • 2
  • 2
1 Solution
 
RiteshShahCommented:
have a look at

http://xionetic.com/
0
 
chapmandewCommented:
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" aware...you know what I mean?
0
 
davidcahanAuthor Commented:
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?
0
 
chapmandewCommented:
I would look into it...from what I've read about it...that is exactly what its built for.
0
 
davidcahanAuthor Commented:
thanks....
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now