Lab Exercise: Spatial Queries and
Analysis with ArcGIS
The objective of this exercise is to perform standard queries and spatial
analyses of graphic and attribute databases using ArcGIS.
It is assumed that you are familiar with opening and moving around
in/between ArcCatalog and ArcMap as a result of your experience in
previous lab exercises.
Please answer the questions based on your exploration of the provided
data for lab #5. The data is located in zip files on the doc sharing section
of the E-College site.
Part I. Quering Attributes by Map Feature
Using ArcCatalog, load the cntry94, latlong, cities, and lakes layers into a
new ArcMap document.
A. Identification Exercise
Zoom in on Africa and identify Lake Tanganyika. Using the tools
available to you through ArcMap, fill in the following table
describing the attributes associated with Lake Tanganyika.
Data Item Value
Identify the city at the northern end of Lake Tanganyika.
In Northern Europe, identify the two lakes just east of Finland.
Identify the name and depth of each lake.
Part II. Querying Features by Attribute Value.
A. Using the FIND tool, find Issyk Kul. Once located, right click on the
found feature to bring up the selection menu.
Identify the city on the northern shore of Lake Issyk Kul.
B. Build a logical query using the “Select by Attributes” function
located in the Selections drop down menu.
Select all the cities that are capital cities and have a population >=
1,005,000. From your selected cities, provide the NAME and COUNTRY
for the following cities.
a. City at the southern end of the Caspian Sea.
b. City on Sri Lanka off the southeast coast of India.
c. What two capital cities on the North Africa coast are in your
new data set?
Close this ArcMap document.
Part III. Creating a New Feature
In this part of the lab exercise, you will create a new map feature by
merging many polygons. Specifically, you’ll merge the 13 states that
represent the original thirteen U.S. colonies into one region.
In a new ArcMap session, add the states data layer to your document.
Right click on the layer and select copy. Paste the layer in the document.
Rename the copied layer (in the layer properties) to “Colonies”.
Turn off or remove the states layer from your document.
For reference purposes, open the attribute table for the layer and note
how the attributes and values for each of the fifty states, plus the District of
Columbia are displayed.
Close the table.
From the edit tool bar, select Start Editing.
Note: If the Start Editing menu is not available to you, or you get an
error message, go into Windows Explorer and remove the Read
Only properties for all of the files that comprise the layer.
Select each of the following 13 states and merge into one feature.
Delaware Virginia Maryland
Connecticut New Jersey New York
Rhode Island Pennsylvania Georgia
New Hampshire Massachusetts South Carolina
How to merge features from the same layer
1. Click the Edit tool.
2. Click the features that you want to merge.
3. Click the Target Layer dropdown arrow and click the layer that
you want the new feature to belong to.
4. Click the Editor menu and click Merge.
The selected features are merged into one.
1. What changes occurred in the map?
2. What changes occurred in the Table regarding number of
3. Are any records missing?
4. Are there any new records?
5. Part III. Spatial Analysis
IN this section, you’ll explore the following types of spatial analysis using
the greater Atlanta area.
1. Point-in-polygon selection
2. Line-in-polygon selection
3. Select within a certain distance
4. Adjacent area selection
Create a new ArcMap document for the Atlanta Region.
All the following layers from your data set for lab #5.
You will be selecting shopping centers that are within a certain county in
the greater Atlanta area.
Locate and select Dekalb County.
Using the select by location dialog box under the selections tab, select
the shopping centers that are completely within your selected county
1. How many shopping centers are located in Dekalb County?
2. What is Address1of Outlet Square Mall?
3. How many square feet in the Shops at Dunwoody?
You will be selecting all counties in the greater Atlanta area through
which Interstate 75 runs.
1. Through how many counties does Interstate 75 run? (Hint: build a
query where route=interstate 75 and create a new set. Then
intersect highways through the counties to get your count).
2. Which of the selected counties has the greatest area?
Select Within a Distance
You will be selecting banks that are within .5 miles of Interstate 75 in the
greater Atlanta area. Using the tools available under the selection tab on
the toolbar, answer the following questions.
1. How many Banks have been are within the distance of .5 miles of
2. What is the sum for the Deposits 94 filed for the selected banks?
(Use the statistics function available under the “selection” section in
Adjacent Area Selection
Locate and select Fulton County. Use the selection tools in ArcMap to
answer the following question.
1. How many counties are adjacent to Fulton County? (Hint: Se;ect
the county and determine how many counties are within the
distance of 0)