GEO 353 Fall 2015

GEO 353 Fall 2015
Lab 06:
Working with Tables
aka – Attribute Data
Lab 6 Assignment
1. Open the table associated with each of the four geospatial data layers for this lab
one at a time.
a. How many records are in each of the four geospatial data layers?
2. Open the hospitals (Hospitals) table.
a. How many hospitals are in Boone County and what are the names of the
hospitals?
b. How many hospitals are in Hardin County and what are the names of the
hospitals?
c. How many hospitals are in zip code 40509 and what are the names of the
hospitals?
d. How many hospitals are in Lancaster and what are the names of the
hospitals?
3. What is the average population for Kentucky counties in 1990? In 2010? What
is the total population for Kentucky in 1980? In 2000? Use the fields POP90 and
POP10.
4. What county had the second smallest population in 1990? What county had the
lowest population density in 2000? Use fields POP90 and POP00SQ.
5. Explain what the Summarize function does. How does it work? What are some
of the summary options?
6. Hand in the table you created in the section about Summarizing Fields.
Summarize the addname field.
7. To join or link two tables, what properties must a common field have?
8. When you joined the tables for Madison_water_wells and well_data.dbf in the
Joining Tables section, what is the source table and what is the destination
table? What is the difference between the two?
Submit your answers by the beginning of next lab.