23. Tabular joins

Author

Lucy Block

Video Tutorial

In this tutorial

How to join tabular data from a CSV to a shapefile using a common identifier

Timestamps (Click a link to start that segment in a new window)

0:00-2:37: Add community districts shapefile. Add a table of healthcare facilities and population by community district as a delimited text layer with no geometry.

2:37-5:11: Conduct the tabular join

5:11-8:01: View the data and export the temporary layer as a permanent shapefile with the joined data

Data downloads

Community Districts shapefile

CSV containing healthcare facilities and population by community district

Sources to create CSV

NYC Facilities database filter: FACDOMAIN = HEALTH AND HUMAN SERVICES, then count by community district

Population by community district: Most recent ACS 5-Year, Demographic variable = Pop_1E