?
Solved

Zip Codes of nearest large city

Posted on 2013-10-22
3
Medium Priority
?
220 Views
Last Modified: 2014-03-31
I have all the zip codes of the cities I want, but now I need to find the zip codes of the nearest large city.

Any ideas?
0
Comment
Question by:rrhandle8
3 Comments
 
LVL 15

Expert Comment

by:Giovanni Heward
ID: 39592617
Do you have additional data, such as population or metro area codes?
0
 
LVL 10

Accepted Solution

by:
ecarbone earned 2000 total points
ID: 39593002
I think you'll need to update your zip code database to also include the latitude and longitude of each city's "center".

There are a few online resources where you can download this data for free (such as www.geonames.org) and there are also some paid services. (Even APIs).

Once you have your database updated with this new information, write some code to calculate distances.

Here's a nice website that demonstrates various ways of calculating the distance between two lat/long points on the Earth, along with some accompanying JavaScript code. Well done.

http://www.movable-type.co.uk/scripts/latlong.html
0
 

Author Comment

by:rrhandle8
ID: 39593021
ecarbone, this looks interesting.  Will dive into it tomorrow.  Thanks for the lead.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

In this article, I will show how to use the Ribbon IDs Tool Window to assign the built-in Office icons to a ribbon button.  This tool will help us to find the OfficeImageId that corresponds to our desired built-in Office icon. The tool is part of…
This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

840 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