[ phpweather-Feature Requests-594304 ] ICAO <=> US Zip code mapping

[<no...@so...>]

Feature Requests item #594304, was opened at 2002-08-13 01:07
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377955&aid=594304&group_id=23245

Category: Databases
Group: CVS (bleeding edge)
Status: Open
Resolution: None
Priority: 5
Submitted By: Martin Geisler (gimpster)
Assigned to: Nobody/Anonymous (nobody)
Summary: ICAO <=> US Zip code mapping

Initial Comment:
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.

----------------------------------------------------------------------

>Comment By: Martin Geisler (gimpster)
Date: 2002-08-13 01:20

Message:
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.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377955&aid=594304&group_id=23245