Map Address Points, View Underlying Data

Example 3 - Mapping address points on a thematic map

Other features illustrated: Viewing underlying records, clearing one dimension, changing universe from the spreadsheet

Background: If a dataset has correctly-defined address point information, points can be mapped on top of a thematic map from a separate dataset.

Goals:

  1. Show the locations of all the public schools in DC on top of a thematic map showing the median household income by tracts from SF3.
  2. Show how you can view the underlying records from the spreadsheet to see all the information for the universe of the selected cell(s).

Steps: Goal 1 Show the locations of all the public schools in DC on top of a thematic map showing the median household income by tracts from SF3

  1. Create our underlying thematic map on which we will lay our school locations. Open the Ferrett Session File (or saved data basket) named point_map_theme_sf3_median_income.fsf.
  2. Go to the Step 2 tab to see the variables in the data basket - median household income and tracts (all tracts in DC).
  3. "Make a Table"
  4. Drag the tract variable to column 1 to define the rows.
  5. Drag the income variable to C2, R1 and "Go Get Data".
  6. Highlight the data cells in column 2 and click on the "Map" button in the toolbar. The map window showing the income by tract opens. DO NOT CLOSE the map window.
  7. Go back to the spreadsheet window and CLOSE it.
  8. Go back to the Step 1 tab.
  9. Clear the data basket by clicking on the "Empty Data Basket" button on the right side.
  10. Open the Ferrett Session File (or saved data basket) named point_ccd_schools.fsf.
  11. Go to the Step 2 tab to see the variables in the data basket - county (DC) and some information about the public schools, including address, phone, number of students, teachers, and level of the school.
  12. "Make a Table"
  13. Drag the county variable to column 1 to define the rows.
  14. Drag the "MEMBER - Total students..." variable to C2, R1 and "Go Get Data".
  15. Highlight the C2,R3 data cell.
  16. Click on the "Point Map" button in the toolbar (US with a flag on it).
  17. After a few seconds, a dialog box appears asking if you want to create a new map or add to an existing map. Select the "Add to existing map" option and the theme map we created is shown and highlighted. Click the "Ok" button. Screenshot of the dialog box for adding point to a theme map
    Screenshot of the dialog box for adding point to a theme map:
  18. Find your map window in your taskbar and open it.
  19. In the map window's "View" menu, select "Layers", and then from that select "Red Dot". The school location points will appear on your map. These dots represent the schools for those students in the selected table cell.
    Screenshot of point map showing schools on median income theme in DC:
    Screenshot of point map showing schools on median income theme in DC

Steps: Goal 2 Show how you can view the underlying records from the spreadsheet to see all the information for the universe of the selected cell(s).

  1. Back in your spreadsheet window, clear ONLY the column dimension - go to the "Edit" menu, select "Clear", then select "All Columns".
  2. Drag the LEVEL variable into C2, R1 to re-define the columns, then "Go Get Data".
  3. Highlight the data cells in R3, C4 and C5, middle and high schools.
  4. Click on the "View Underlying Records" button in the toolbar (looks like a spreadsheet with a magnifying glass on it). This brings up a new window showing all the variables for the records with the values highlighted. The output can be sorted by any variable column by clicking in the header.
  5. Close the underlying record window.
Additional Table Manipulation - Changing Universes in the Spreadsheet
  1. 1. You can change your table to show some other set of counties.
  2. Clear your row dimension - "Edit" menu - "Clear" - "All Rows".
  3. Double click on the County variable in your spreadsheet variable list on the right side. This will bring up the Geography Codebook window.
  4. Highlight "District of Columbia" shown on the right side and press the "Delete" button.
  5. Highlight the FIPS county code on the left side and then press the "Next" button.
  6. Highlight the FIPS state code on the left side and press the "Next" button.
  7. Select "California" and press the "Next" button. This moves California to the right side.
  8. Press the "Next" button again. This will show all the counties in the state.
  9. Highlight the "Select All" at the top of the list and press the "Next" button. This moves all counties to the right side.
  10. Press the "Finish" button. You should return to your spreadsheet window.
  11. Drag the county variable to C1 to define the rows with all the counties in California. Press the "Go Get Data" button.