LAB $6\mathrm{.}2$

GIS $-$ BASIC SPATIAL ANALYSIS

Name: $1$

After this exercise, you will be able to:

Buld SQL queries in GIS

Use different selection criteria

For this exercise, you might benefit from:

Geography Eirstili

Lab $6\mathrm{.}2$ in page $222$

ANSWER THE FOLLOWING QUESTIONS $(40$ POINIS$)$:

How many countles in Callfornia had a $2010$ population of more than $500,000$ person?

$16$

How many counties in Callfornia had a $2010$ population of fewer than $50,000$ persons?

$15$

How many countries in Callfornia had a $2010$ population of more than $50,000$ persons but also fewer than $100,000$ persons?

What is the combined total $2010$ population of these three countries?

Why did you use OR Instead of AND as the Boolean connecter between the queries each fime? How would the results have been different if you had used AND instead of OR each time In the compound query?

How many people are in the Fire Stations layer?

How many people are in the Hospitals layer?

How many fire stations are in Ventura County? How many fire stations are in Sutter County?

How many hospitals are in Ventura County? How many hospltals are in Sutter County?

In what county is the Yurok Volunteer Flie Department located?

In what county is the Yurok Valley Medical Center located?

How many fire stations are within a $1-$mile radius of the hosplitals?

In which county is the Californla state capitol building?

How many hospitals are within $5$ miles of the California state capltol bullding?

How many fire stations are within $5$ miles of the California state capitol building?