Lab 7 Report Template (1)
pdf
keyboard_arrow_up
School
University of California, Santa Cruz *
*We aren’t endorsed by this school
Course
215A
Subject
Geography
Date
Dec 6, 2023
Type
Pages
3
Uploaded by JusticeScorpion20152
GEOG 4203/5103 Fundamentals of Geographic Information Systems
Lab 7, week 10: Attribute Data
Name:
Janelly Salgado
Date of submission:
10/31/2023
Due date:
November 6, 2023 at 11:59pm
Lab questions (Indent and provide an answer in a complete sentence, 20 points in total)
Questions from lab tutorial
Question 1
How many Hispanics and Blacks live in the United States (2 points)? (Be sure to report the
answers using an appropriate number of significant figures.)
There are 50,477,594 Hispanics that live in the United States. There are 38,929,319
blacks that live in the United States.
Question 2
Which subregion has the most Blacks? Which one has the most Hispanics (2 points)?
The subregion with the most blacks is the South Atlantic. The subregion with the
most Hispanics is the Pacific.
Question 3
How many Democratic districts are there (1 point)?
There are 190 democratic districts.
Question 4
Is this new table an attribute table or a standalone table (1 point)?
This new table is an attribute table.
Question 5
What is the best potential key field in this table (1 point)?
The best potential key field in this table is the District ID.
1
Question 6
What is the cardinality between subregions and districts (1 point)? Which is the join table, and
which is the target table (1 point)?
The cardinality between subregions and districts is a one-to-many relationship. The
source table is the districts and the destination table is the states.
Question 7
How many representatives come from New England states (1 point)?
21 representatives come from New England states.
Question 8
Notice the spatial distribution of stations with values in the high 40’s. Suggest an explanation for
why the western values scatter so far from the latitude band (1 point).
Western values scatter so far from the latitude band because the elevation decreases
the cooler it is. The further away from the equator, the cooler it gets.
Question 9
Why won’t we use any of the other fields with LAT or LON in their names (1 point)?
We won’t use any other fields with LAT or LON in their names because we only
want numeric values.
Question 10
What is the common field in these two tables (1 point)?
The common field in these two tables is the station name and the object ID.
Question 11
What is the latitude and longitude of the station having the highest annual precipitation (1 point)?
The latitude is 44.4 degrees and the longitude is -123.75 degrees.
2
Question 12
Describe the spatial pattern of annual precipitation in Oregon (1 point)?
The spatial pattern of annual precipitation in Oregon is clumped towards the west side of
the state and the rest of the state has random dispersion of annual precipitation.
Questions from practice exercises
Question 2
How many stores are there (1 point)? When and where did the first one open (1 point)?
There are 3,176 stores. The first one opened in Rogers, AR.
Question 5
Determine the number of stores per 100,000 people in each state, using the POP2014 field.
Which state has the most stores per capita? Which has the least? (
Hint
: Use Frequency tool to
get the number of stores in each state and then join the resulted frequency table with states table.)
3 points
The state with the most stores per capita is West Virginia. The state with the least stores is
Arizona.
3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help