IFSM 201
Name:______________________

Using the stations.accdb database at the class web site: 
http://davidwills.us/ifsm201/stations.accdb
answer these by using sorting, finding, and filtering.
The database contains information for 7280 weather stations around the world.  
Read the fields' descriptions to get an idea
 of what each means and what possible values it can contain.
This is a common kind of database table: many fields with cryptic codes.
Use station name to answer the "what station" questions.
Use correct units e.g. m, cm, mm, °C.

What station has the hottest annual temperature:

What station has the coldest annual temperature:

What station has the lowest elevation:

What is the southernmost station:

What is the wettest station on Earth:

What is the driest station on Earth:

What is the elevation of La Paz, Bolivia:

What is the latitude and longitude of Kadena Air Base:
   
  What is its annual average temperature:
  
  What is its annual precipitation:
  
  What is its Koeppen climate classification:


How many United States stations are there:

Find your hometown, or a closeby station, what is it:

 What is its latitude and longitude:

 What is its annual temperature and annual precipitation:

 What is its Koeppen climate classification:



How many stations in the world are at an airport:

 Of those, how many are rural:

  Of those, how many are mountainous valleys:

   Of those, how many are in Mexico:


What is the wettest station in the USA:

What is the southernmost station in the USA:

What is the northernmost station in the USA:

Of the mountain top stations in the USA, which two have
a Koeppen classification of ET (arctic tundra):

Of the USA's BWh (hot desert) stations, the most populous is:
(it's the population of the metropolitan area)

The second-most dryest station in the USA:

Which two USA states have a tropical rain forest climate (Koeppen Af):


How many Koeppen fields are 'na'?

What countries have stations named CONCEPCION?


How many stations are above the Arctic circle (66.67 degrees north latitude)

 Which of those stations are populated?


Of the mountainous (MT) topo stations, which are lower than 1000 m in elevation:

Okinawa island is in Japan. It is bounded by latitudes 26 and 27.
What are the stations on Okinawa:

Hawaii is bounded by longitudes -154 and -178 and by latitiudes 18 and 29.
How many stations are in Hawaii:

What is the coldest annual temperature station in Japan that is not a mountain:

Brazil's most populous Aw (Koeppen tropical savanna climate) station:

What USA station has a veg16 of HOT DESERT but is not a Koeppen desert or steppe (BW- or BS-):