>I'm working on a program where a user wants to enter a town into the system and receive a listing of records based upon 20 miles or so (user configurable) radius of that zip code. I assume(?) there is a logical layout to zip codes to make this possible as I see it on websites all the time. Has anyone worked out a procedure or resources to accomplish this?
>
>Example: enter Denver, CO
>returns: all records for Denver, nearby Aurora, Centennial, Englewood, etc.
>
>
>If there's a plugin that accomplishes this that could be embedded in VFP, that would work too.
>
>Thanks in advance.
>
>Steve Howie, owner
>DaSH Technology, LLC
Please check this link
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-zipcode-latitude-longitude-pr - It is in SQL Server, but perhaps you would be able to adapt the ideas - it doesn't seem hard.
If it's not broken, fix it until it is.
My Blog