Title Card: Creator: Parisa Setayesh | Level: Beginner–Intermediate | Category: Data: Data, Space and Place

Why this matters
A huge amount of mapping depends on joining a non-spatial table to a spatial layer. The Census Bureau explicitly notes that TIGER/Line shapefiles contain geographic entity codes, or GEOIDs, that can be linked to Census demographic data. QGIS’s join documentation makes the same principle concrete inside the software: a join associates features in one layer with records in another using a shared attribute field.

Key ideas

• A join connects attributes to geometry.
• Shared keys matter.
• Geography files and data tables often come separately.
• If the key is wrong, the map will be wrong.

Lesson
This is one of the most empowering lessons for beginners because it shows how ordinary tabular data becomes mappable. A spreadsheet of neighborhood statistics, survey results, or census measures cannot appear on a map until it is linked to a geography. That geography might be tracts, ZIP codes, boroughs, districts, blocks, or parcel boundaries. Once the join is made correctly, the map becomes possible.

It is also a good place to teach caution. A join only works when the shared field is truly shared: the same format, the same level of geography, and the same units of analysis. This is where many misleading maps are born — not through dramatic error, but through mismatched identifiers and assumptions about place.

Example Project or GCDI resource
Getting Started with Social Explorer: A GC Resource for Spatializing Demographic Data is again a very strong GCDI anchor here, because demographic mapping almost always depends on matching attribute tables to geography. It makes the logic of joining much less abstract.

Open reading / resource
Pair Census Mapping Files with the QGIS documentation on Joining features between two layers. The first explains why geographic identifiers matter; the second shows how a join actually works in practice.

Reflection / mini activity
Imagine you have a CSV with neighborhood-level indicators and a shapefile of census tracts. Write a short paragraph explaining why those may or may not be joinable, and what you would need to verify before proceeding.