US Population Growth Disparity - Net Population Change 2000 - 2016

Asana Project

Goal

Reproduce the map featured on this page of a report:

Contents

Data Sources
Methodology
Outcome & Products

• Maps, Charts, and Graphics
• Written Material
• Feature Classes & CSVs

Data Sources

2000 US County Census Estimates SF1

• Decennial Census API

2016 US County Census Population Estimates

• Population Estimates and Projections API
• 2010 TIGER/Line County Shapefile

Methodology

US Population Growth Disparity Python Script

1. Pulled 2000 county population data from Decennial Census API & 2016 population esimates from PopulationEstimates and Projections API
2. Convert to pandas dataframe (DF)
3. Join 2000 Census Population DF with 2016 Census Population Estimate DF
4. Calculate net different of population between 2016 and 2000
5. Export to excel table
6. Join table to 2010 TIGER/Line County Shapefile

Outcome & Products

Maps, Charts, and Graphics

• Image Files
  • motm_9_19_17.pdf (Website Version)
  • motm_9_19_17.png (Website Version)
  • motm_9_19_17_ED.pdf (Executive Director’s Report Version)
    • motm_9_19_17_ED.png (Executive Director’s Report Version)
• Illustrator Files
• Commission Presentation Files

Written Material

September 2017 Map of the Month Write-Up

Feature Classes & CSVs

• Population Change 2000 - 2016 Census