As part of our (CampusEAI) Weather portlet distribution we have an 800k+ line
sql file, from some mysterious place, with city and zip codes for building CNN
specific URLs. I'll have to do some digging to find out how this file was
generated.
e.g.
INSERT INTO WeatherInfoCountries VALUES
('Venezuela','SVPM&zipCode=622788587623','San Cristobal');
INSERT INTO WeatherInfoCountries VALUES
('Northeast-Ohio','BROX&zipCode=44130','Cleveland');
There are also lists for all this information available online in various
places, but it seems that they only have bits and pieces of all the information
we are looking to use.
http://stuff.mit.edu/doc/weather-cities.txt
http://www.myweather.net/dataproducts/sitelist_int.txt
Depending on how much cross referencing we would like to do we can also include
all the airport IATA and ICAO codes.
http://adds.aviationweather.gov/metars/stations.txt
http://www.iata.org
http://en.wikipedia.org/wiki/ICAO_airport_code
I realize it's a big undertaking to include all this, but it might be necessary
if the search capabilities are not immediately obvious nor user friendly.
There may also be issues with getting the lists from the authoritative source
(stations.txt from NOAA seems the most complete), so things don't become
stagnant and outdated over time.
Sincerely,
Erin Garlock
CampusEAI Consortium
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions:
The Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
