Menu

#6 ICAO <=> US Zip code mapping

CVS_(bleeding_edge)
open
nobody
Databases (3)
5
2014-01-17
2002-08-12
No

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.

Discussion

  • Anonymous

    Anonymous - 2002-08-12

    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

    blumenthal - 2005-01-13

    Logged In: YES
    user_id=1110264

    has this yet been integrated into PHPWeather?

     
  • EKleiner

    EKleiner - 2005-01-17

    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

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.