IFSM 201
Name:_________________________

Using the stations.accdb again.
Many of these questions need queries to answer them.
"Bold edit" your answers. Print narrow margins, double-sided.

How many Koeppen fields are 'na'?

What countries are the three stations named Georgetown in?

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

 Which of those stations are populated?


How many stations in Iraq?

 What is the most common Koeppen classification of them?
  (this means hot desert)

 Based on the annual average temperature, what is the "coolest"
  station in Iraq and what is its elevation:

 What is the hottest place in Iraq and what is its elevation:

 What stations in Iraq get more than 1 mm of precipitation in 
  the summer months of June, July, August, and September:
  Note: the precipitation data is in tenths of millimeters.


How many of each of the veg values are there in the table?

What station names occur three times?
Hint: group by station name and a count 

How many of each of the topo values are there in the table?

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

What is the most common veg16 value and how many times does it occur:

What is the least common veg16 value and how many times does it occur:

 What is that station?


How many degrees latitude separates Arica, Chile from Punta Arenas, Chile:
(Do arithmetic with the latitudes of those places)

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

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