Solved

Find Zip Codes Within Driving Distance Using Google Maps API

Posted on 2009-05-16
2
621 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 26

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

Independent Software Vendors: 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!

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

752 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