Solved

Find Zip Codes Within Driving Distance Using Google Maps API

Posted on 2009-05-16
2
622 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 500 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

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…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

624 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