I was looking for a database (or web service) that would translate zip
codes into the neareast ICAO airport codes. I've looked around, and
have found plenty of longitude/latitude databases, but I specifically
need to search on zip code. |
Clarification of Question by
idvanx-ga
on
27 Apr 2005 11:50 PDT
I could also work with a city/state to nearest ICAO lookup.
|
Request for Question Clarification by
pafalafa-ga
on
27 Apr 2005 12:12 PDT
Is this the sort of information resource that you're looking for:
https://pilotweb.nas.faa.gov/qryhtml/icao/USA.html
Let me know..and if it's not, perhaps you can add a bit more detail in
terms of what you need.
Thanks,
pafalafa-ga
|
Clarification of Question by
idvanx-ga
on
27 Apr 2005 13:14 PDT
Right now, I have two databases:
The first has city, state, and zip of certain locations.
The second is one of the METAR databases (for weather stations) that
has city, state, and ICAO. However, the city/state combo doesn't
neccessarily match up with the city/states that we have. For example,
we could have Cambridge, MA in the first database, but only Boston, MA
shows up in the METAR db, so no match there.
So I'm looking for something that ideally would take in a list of zip
codes (or the city/state combos that we have) and return the *nearest*
ICAO airport code.
|
Request for Question Clarification by
pafalafa-ga
on
27 Apr 2005 15:59 PDT
I see what you mean...these weather folk aren't very big on zip codes, are they.
I came across a database that may be partially useful to you:
ftp://ftp.ncdc.noaa.gov/pub/data/inventories/COOP-ACT.TXT
This lists ALL the active weather stations in the US -- ICAO or
otherwise -- and though it doesn't have zips, it does include
counties, making it possible to readily identify nearby stations that
are in the same county.
You may find some way to make use of it, or maybe not. But I just
want to make sure you were aware of it...
pafalafa-ga
|
