#6 ICAO <=> US Zip code mapping

Helge Weissig compiled this file ages ago, but it never
got used in PHP Weather :-/ This is the mail he sent to
the PHP Weather development list little over a year ago:

Hi,

I thought it would be nice to add some "weather
by zip code functionality to phpweather. I realize that
this is completely US centric and does not appeal to
veryone. However, I did the work anyways and put
together two tables that contain a mapping between ICAO
stations and US Zip codes and vice versa. The mapping
was done by locating the closest weather station for
each geographic center of each zip code and conversely
by locating the closest zip code geographic center for
each station.

There are some problems with the direct query by zip
code as not all stations are reliable enough. This
could be circumvented by querying for the closest
stations and retrieving weather information for the
first one with information available.

Send me e-mail if you have any questions. I am not
subscribed to this list, so make sure to address the
e-mail directly to me.

cheers,
h.

[Anonymous]

Logged In: YES
user_id=104098

Hmm... I couldn't upload a 544Kb file here, so I've placed
it at the PHP Weather homepage instead:

http://phpweather.net/downloads/zipcodes.sql.gz

It will be removed when it is integrated into PHP Weather
and put in CVS so check there if you cannot find the file
using the above link.

[blumenthal]

Logged In: YES
user_id=1110264

has this yet been integrated into PHPWeather?

[EKleiner]

Logged In: YES
user_id=1198625

there is atleast one city that has wrong indormation on the list

Zipcode: 18612
City it should be listed as: Dallas
ICAO it should use: KAVP