Week 6 - Midterm Project - Part 1

You are to create an Excel file through Stata which requires the use of spmap, sh2dta, mqgeocode, and putexcel to combine multiple data sources and summarize findings.  See instructions in midterm_project_part1.pdf below. 

sd_info.xlsx
File Size:	280 kb
File Type:	xlsx

Download File

---

midterm_project_part_1.pdf
File Size:	101 kb
File Type:	pdf

Download File

---

---

Data: 

1. ​Use 2014 ACS 5-year estimates using American FactFinder to download data for your assigned county (with census tract information). ACS Data can also be downloaded here
   
2. Shape files for California census tracts (Select Layer: census tracts) 
3. California Brewery Data located below

CA_Breweries.dta
File Size:	67 kb
File Type:	dta

Download File

---

---

Use ACS FactFinder to double-check your work to ensure you have the correct results. See screenshot below. Top is from FactFinder Community Facts for San Diego County. The bottom is from the table in SD_Info.xlsx. 

---

Helpful Links

• ​Stata FAQ working with spmap
• spmap presentation 
• Multilayered maps
• Extra: Spatial Data Analysis presentation
• Stata putexcel 14 help