- Geography 5224 -
Project 6 / 7: Working with Tables and Performing Queries

Objective:
learn to manipulate ArcView tables and their underlying data; understand how to
select records with queries; learn to add, delete, and update records


This customized application demonstrates a procedure which highlights suitable cities for opening
an icea cream store. Sites must follow the selection criteria below:

> 500 farms for milk production
labor pool of at least 25,000 individuals between the ages of 18 and 64 years
interstate within 20 miles
a low crime index (less than or equal to 0.02)
at least one recreation area within 10 miles
a population of less than 150 individuals per square mile
located near a university or college

The cities highlighted below in the attribute table matched the criteria.


The code written for this selection procedure is easily modified to fit different criteria
and the analysis can be easily re-run.


back to gis coursework