1. How many block groups have a population density of greater than 500 people per square mi?

346 (of a total of 390 block groups)

2a. What City Influence Areas have: [note: see hint above]

No Urban block groups? Point Magu (N. county) Only urban block groups? Port Hueneme

2b. What proportion of the area of the county are these urban block groups? [Hint: use the statistics function for both the selected block groups and for a selection of all block groups.]

Urban block groups: 217.8 sq.mi /All Block groups: 1883.43 sq.mi * 100 = 11.9 %

3. What is population of urban Fillmore compared all Fillmore block groups?

Urban Block Groups: 10683 All block groups: 17525

4. Which City has the greatest Area in urban block groups? [Hint: Use Summarize on the field Name after doing Select by Attributes for urban block groups.]

City Name Thousand Oaks Urban area 61.8 sq.mi.

5. Which City has the greatest proportion of its Area in urban block groups? [Hint: Again use Summarize on the field Name, but this time you will need to also do it for all block groups, then divide each city’s “urban” area by total area with a calculator, unless you can figure out how to join the summary tables and add a field to calculate the values.]

City Name Oxnard Urban area 61 %

[SAVE your map Document.]

EXTRA CREDIT

EC 1a. What is the ratio of elderly people (65 and over) that live in rural vs. urban areas in the county?

Rural 7113 / Urban 69691 = about 1/10

Continues next page.

EC 1b. How did you calculate these numbers?

In the Block Groups layer I Selected by Attributes for “Pop00_Sqmi > 500”, then I did statistics on the “65 and over” Field in that layer. That gave me the urban elderly population. To get the rural, I did a “switch selection” under Options in the attribute table. Then I did statistics. The ratio of those two numbers is about 1 to 10.

II. Joins, Relates, and Hyperlinks

· Create a new Map Frame titled “Ethnicity and Health”

· Drag the shapefiles, TB_96, TB_97, and Ventura_zips to this map frame.

· Symbolize these layers so you can see the difference between TB sites for each year.

A. Joining

1. Which city has the greatest percentage of Hispanic population? What is that percentage?

[hint: Join the Ethnicity.dbf table to the the Ventura_zips shapefile attribute table. Summarize on city names, finding the sum the fields total hispanic and total population. (Fields: Sum_Persons = total population. TotalH ₌ total Hispanic.) Name this table, “Hispanic.dbf” and store it with your other Lab3 data. Then add a new field o that table titled %Hispanic (can be an integer or float field). Use the Field Calculator to compute the values for this new field.]

City Name Fillmore Hispanic 59 %

B. Relates

· In ArcCatalog, make a new table titled “Region_Relate” with just one field titled “region” in your Lab3Data folder. Switch to ArcMap and with Editing ON, add 2-5 county regions (you define them, e.g., east, west, northwest, south).

· In ArcMap, copy the City Influence Area layer from the Urban Density to Ethnicity and Health. Add a new field titled “region”. For each city, fill this field with a region name.

· Now relate the two TB tables to the City Influence Area layer and then relate the City Influence Area layer to the Region_Relate table. (You should now be able to select a region in the Region_Relate table and see TB cases selected in both TB tables.)

2. Which regions did you create? (How many cities in each?) Will vary

__________( ), __________( ), __________( ), __________( ), __________( )

3. Which of your regions had the greatest increase in TB cases from 1996 to 1997? [hint: After selecting a region in your Region_Relate table, check the bottom of the TB tables for the number of selected items.]

Region with greatest increase: Will vary

[SAVE your map Document.]

C. Hyperlinking

· In the Urban Density data frame, turn off the Block Group layer. Use the attribute table for City Influence Zones to set up hyperlinking to the image files found in Lab3Data.

EC 2. Explain in detail how you got the hyperlinking to work.

Create a new field, “hyperlink”, in the City Influence Areas layer. Turn on editing and provide the full path (e.g., “Z://Lab3Data/Camarillo.gif) for each city that has an associated image (.jpg or .gif) in the Lab 3 Data folder. After making these edits, Open the Properties dialog box for City Influence Areas and click on the Display tab. Turn on Hyperlinking. Select the hyperlink field and document type. Go back to the Map Frame and use the lightning bolt tool to check your hyperlinks.

Use the Identification tool and select a feature in the City Influence Areas layer. In the information results window right click on the feature window. It will give you a hyperlink option. From there link to the image. The use the lightning bolt tool to select the feature in the map frame.

I. Queries (Select by Attribute)

II. Joins, Relates, and Hyperlinks