Solved

Find Zip Codes Within Driving Distance Using Google Maps API

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

830 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