Saturday, April 19, 2008

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








GTK ArcGIS Chapter 15 Creating features



Exercise focussed on the Editor toolbar for:
  • drawing features
  • using various feature construction/modification tools
  • define task
  • select target layer
  • snapping tollerance
  • entering segment length and direction (useful for survey data)
  • making a line parallel to another, etc...

GTK ArcGIS Chapter 14 Building geodatabases

Geodatabases, as the latest and most sophisticated spatial data format for ArcGIS offers advantages over coverages and shapefiles. Advantages include:
  • ability to store multiple feature classes
  • ability to store labels as annotation
  • ability to create domains for attributes

A domain establishes valid values or ranges of values for an attribute field and minimizes data entry mistakes by prohibiting invalid entries (some may be due to simple typing errors). For example the attribute field for "Trail use" may be restricted to three valid entries: hiking, hiking and biking, hiking biking and equestrian.

We created a personal geodatabase, a type that is retricted in size to 2Gb with attribute tables stored in Microsoft Access format. This geodatabase included features for a city: fire hydrants(points), parcels (polygons), waterlines (lines) and valves (points). For features stored in a geodatabase, ArcGIS creates and maintains measurement fields such as the length of a line or area of a polygon. We added fields to attribute tables and created domains for the attributes.

A big advantage of a domain is that it can be applied to more than one field in a feature class and to more than one feature classs in a geodatabase.

We uploaded the geodatabase file we created.

GTK ArcGIS Chapter 19





This exercise, "Making maps for presentations," focussed on the set of tools available in the Layout View of ArcGIS. We used:

  • page and print setup dialog to define the page size and orientation,
  • guides for alligning page elements such as, data frames and text,
  • resized and arranged data frames,
  • added standard map elements including a scale bar, north arrow, legend, title, additional text, and a neatline
  • alligned and grouped elements

Many of the basic tools available graphics progams such as, Macromedia Freehand and Fireworks are available in the Layout View with the addition of cartographic functions related to scale, legends and data frames.