Homework

• Hands-on Exercises from Textbook

  Chapter 8: Querying Data

  • Ormsby Exercise 8a: Identifying, Selecting, Finding, and Hyperlinking Features
    • Step 15: the context menu appears when you right-click on the SALE_PRICE field.
    • Show map at step 16, with the selected parcel in yellow, as on p. 213.

  • Ormsby Exercise 8b: Selecting Features by Attribute
    • Show map at step 8, top of p. 222.

  • Ormsby Exercise 8c: Creating Reports
    • Warning: In class the printer may be set to an incorrect printer or even to fax. Before doing a report, from the main menu select File, Page Setup, and change the printer. If you have already entered a report, then in Report Properties, select Report in the Settings area, then click on the ellipsis for Page Setup to bring up the Page Setup dialog. In that dialog click on the Printer button and set the printer to what you want.
    • Show the Report Viewer as in step 20, bottom of p. 231.

    
    

  Chapter 9: Joining and Relating Tables
  • Ormsby Exercise 9a: Joining Tables
    • Step 18: if color scheme is graphic rather than words, right click and uncheck Graphics, then select Basic Random.
    • Show step 20 map, bottom of p. 246.

  • Ormsby Exercise 9b: Relating Tables
    • Step 2: The state map with the red rectangle is just in the textbook; it is not supposed to show in ArcMap. '
    • Step 8: Carefully read and be sure you understand the last paragraph on p. 251.
    • Show step 29 map, p. 258.

  
  

• Be prepared to answer the following questions from Ormsby, Chapter 8 (Querying Data) and 9 (Joining and Relating Tables):

  CHAPTER EIGHT: QUERYING DATA
  1. Differentiate identifying, selecting, and querying to get 
  feature information. P. 206
  2. What is the icon for the Identify tool? P. 208
  3. What is the Select Features tool? What is its icon? 
  Why and how to set selectable layers? Pp. 209-210
  4. How do you un-select? P. 210
  5. What color are selected features? Pp. 211-212
  6. What is the yellow color for in selection? P. 213
  7. How do you enable hyperlinks in a map? Pp. 214-215
  8. How do you create hyperlinks? Pp. 214-216
  9. What is the Find tool? P. 216
  10. How do you do a query by attributes? Pp. 219-221
  11. How do you create a report of your query? Pp. 223-231
  
  CHAPTER 9: JOINING AND RELATING TABLES
  1. Why join tables? P. 234-236
  2. What is the difference between joining and relating tables? Pp. 235-236
  3. How do you associate a non-spatial .dbf table with a spatial geodatabase?
  Pp. 238-239
  4. What happens if the non-spatial (dbf) table does not have as many records 
  as the spatial file? P. 241
  5. Once attributes have been added to a layer, how do you get a particular 
  added attribute to show on the map? Pp. 244-246
  6. Does the link field have to be spelled the same in the source and destination 
  databases? P. 247
  7. What was the "relate" example in the book? Pp. 247-259
  8. How do you relate a non-spatial dbf to a spatial layer? P. 252 
  9. For a given feature in a layer, how can you see related information? 
  Pp. 253-256
  10. How do you select all features in a layer matching a value in a related table 
  (in the example, all Pits with lead, where lead is in the related Metals dbf)?
  Pp.  256-259
  

Explore

Census Sites

•  TIGER Mapping Service, U.S. Census

   TIGER 1990/1998 Maps, U.S. Census

  The "Coast to Coast" Digital Map Database, the TIGER Map Service is a project sponsored by the U.S. Bureau of the Census. The goal of this service is to provide a public resource for generating high-quality, detailed maps of anywhere in the United States, using public geographic data.

•   QuickFacts

•   American FactFinder Thematic Maps.
  Click on "Maps" on the left. Note that American Factfinder also has other services beside thematic mapping.

• Data Ferrett. Find federal data on the web.

• CenStats Databases

• Online Census Population Pyramids for Nations of the World

• Integrated Public Use Microdata (not a Census site)