Intro to IHGIS Webinar - Demo Steps

  1. Get an extract from the data access system
    1. Apply Filter, Datasets: DO2010pop
    2. Select Tables: AAJ - AAM (3 building material tables & kitchen area)
    3. From Data Options page, select tabulation geographies g3 (Municipalities) and g4 (Municipal Districts)
    4. Note the number of tables (4) and files (5) requested
    5. Download to R project directory as DO2010pop_building.zip
    6. Unzip the downloaded file
  2. Working with extract data & metadata in R
    1. Open R project, webinar_examples.Rproj
    2. Step through script, ihgis_webinar_demo.R
  3. Get GIS files
    1. Go to Geography & GIS page
    2. Download DO2010pop Municipalities (g3) & Municipal districts (g4)
  4. Mapping data in QGIS
    1. Add Vector Layer: DO2020pop_g3.zip
    2. Add Delimited Text: DO2010_floor_g3.csv (exported from R)
    3. Join CSV to shapefile
      1. Right click on shapefile in layer listing
      2. Properties > Joins
      3. Add join
        • Join layer: DO2010_floor_g3
        • Join field: GISJOIN
        • Target field: GISJOIN
        • Custom field name prefix: data_
    4. Change symbology
      • Graduated
      • Value: data_prop_soil
      • Color ramp: YlOrBr
      • Mode: Natural breaks (Jenks)
      • Switch to data_prop_detached
    5. Map g4 units
      1. Add Vector Layer: DO2010pop_g4.zip
      2. Add Delimited Text: DO2010popAAM_g4.csv (directly from extract)
      3. Join data file to shapefile as above
      4. View variables in codebook
      5. Change symbology
        • Expression: AAM003 / AAM001 (proportion with coo0king area outside dwelling)
        • Color ramp: Greens
        • Mode: Jenks