Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Find Zip Codes Within Driving Distance Using Google Maps API

Posted on 2009-05-16
2
Medium Priority
?
629 Views
Last Modified: 2012-05-07
Has anyone seen or written a script, either application layer or possible running directly inside of sql server, which uses a starting zip code and then finds all the zip codes that are a specific DRIVING DISTANCE (not great-circle or crow flys) from iit, utilizing google maps api?  

I have a client and she is not satisfied with the great-circle search we have provided for her to query all leads within a specific distance of a zip code.  Her complaint (which has validity) is that the radius distance and actual driving distances are completely different and in her case the driving distance is the most important aspect.
0
Comment
Question by:davidcahan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 2000 total points
ID: 24404533
I have looked around and there does not seem to be a direct API for this but I have found a possible workaround at http://groups.google.com/group/Google-Maps-API/msg/4dc2fad4f74e3314 that I have tried on a limited basis to return the aproximate driving distance from one zip code to another.  Be careful of the limits on access though.  In the example url in this post, I just substituted zips for A and B like http://maps.google.com/maps?q=from+90210+to+90201&output=kml, if you first limited your zips to the great circle set and then checked for driving distance and were not doing this on a massive scale, you might not violate the access limit.  I tried to find what that limit is again, I have seen it before but no luck this time, but it is reasonable for most applications.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

688 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