This week's topics include spmap and putexcel

Example using spmap with line option:​

spmap using cacoord, id(_ID) line(data(directions)  ///
    color(eltblue) size(.8)) title("SDSU to Humboldt State")  /// 
    note("~12h 38min via Google")

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. 

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.