Saturday, April 19, 2008

GTK ArcGIS Chapter 11 Preparing data for analysis






GTK ArcGIS Chapter 10 Selecting features by location


When selecting feature by location, there are four types of spatial relationships:
  1. distance
  2. containment
  3. intersection
  4. adjacency

We're scouting to locate a new store in the Riverside, CA area for a chain of gourmet food stores.

  • select neighborhoods(polygons) within 0.5 miles of a freeway(lines)
  • from selected neighborhoods, select those containing shopping centers (points)
  • select census tracts with more than 4000 households and average income over $65000
  • select from subset of neighborhoods, theose with centroid in the upscale census tracts previously selected
  • The Canyon Crest neighborhood has a shopping center (this is our target)
  • query the CCzoning layer using a Definition Query (only features satisfying definition query "zoned commercial"records will be displayed in map while the rest are hidden)
  • zoom in on the one area zonned commercial that also has a shopping center
  • display the buildings footprint layer, which we can query attribute table for a square footage betwen 4000 and 6000 square feet.
You can also join attribute tables by location

GTK ArcGIS Chapter 9 Joining and relating tables



GTK ArcGIS Chapter 8 Querying data




Let’s go shopping for a house in Redlands as if Jack Dangermond himself had just hired us to work at ESRI. We want a house on a corner lot (sweet!), three bedrooms and we’re willing to spend $175,000 (signing bonus?). Either real estate prices in this database are really old (1980's) or the real estate bubble burst baddly in Redlands.

We started with a map of streets and of land parcels shaded by for sale or nor for sale.
  • used identify tool
  • interactively selected corner parcels for sale using selection tool
  • in attribute field, added hyperlink to photo of house
  • viewed attribute table for parcels, then just for selected records
  • queried by attributes ((for sale "status" ='y' ), ("BD_RMS"='3') and ("Sale_Price"=<175000)
  • created a basic report

The report generating capabilities built into ArcGIS are very limited. Fortunately, it comes with a version of Crystal Reports that allows creating more robust reports.

Oregon Map

This map was the product of a basic ArcGIS 9.2 skills exercise from the book:

Mastering ArcGIS
Third Edition
by Maribeth Price

This is a text Pete has used in the past. While not quite as clear as the step-by-step cookbook provided by Getting to Know ArcGIS desktop (GTK ArcGIS), this book integrates GIS concepts within the context of a tutorial which is followed by a series of problem solving exercises challenges the user to draw on skills presented earlier. This is a more advanced integrative approach than GTK ArcGIS, a good resource for continuing study.

Georeferencing Bent Creek Map


GTK ArcGIS Chapter 16 Editing features and attributes