Erin,
I think the sql file may have been generated from this:
http://weather.cnn.com/weather/citySearch?mode=json&filter=false&search_term=
Some of those links include some great information. These links would be
very useful to a METAR implementation if we end up having to go that route,
especially the stations.txt file. Thanks for the info!
Dustin.
On Thu, Feb 14, 2008 at 1:02 PM, Erin Garlock (CampusEAI Consortium) <
[EMAIL PROTECTED]> wrote:
> 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
>
--
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
