<div dir="ltr"><div><div><div>Ezra, thanks a lot for your quick response -- duh, I
suspected it was something as simple as that, but couldn't figure it out
myself!<br><br></div>I really appreciate your work on this package!<br><br></div>Best,<br></div> Harald.
<br><br><div class="gmail_quote"><div dir="ltr">On Tue, Apr 17, 2018 at 6:56 AM Ezra Haber Glenn <<a href="mailto:eglenn@mit.edu">eglenn@mit.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
Thanks for your email, and for using the package. The issue you've<br>
run into here is that even though you set the "span=1" when you saved<br>
the variables, you didn't set it for acs.fetch, which means that<br>
acs.fetch used span=5 as a default.<br>
<br>
If you use this instead, I think you'll see the same numbers as<br>
FactFinder:<br>
<br>
###########<br>
## set geography to city of Madison, Wisconsin<br>
Madison <- geo.make(state="WI", place = 48000)<br>
<br>
## select only the total, car/truck/van, public transport, bicycle,<br>
walk variables from table B08006<br>
TransitVars <- acs.lookup(2016, span = 1, table.number = "B08006",<br>
dataset = "acs")[c(1,2,8,14,15)]<br>
<br>
#fetch data for 2016 year and return them into acs object<br>
<br>
###### ADD "span = 5" for acs.fetch()<br>
<br>
ACSData2016 <- acs.fetch(2016, span = 5, geography = Madison,<br>
variable = TransitVars,<br>
col.names = c("Total", "Motor Vehicle", "Public<br>
transit", "Bicycle", "Walked"))<br>
##########<br>
<br>
Best,<br>
Ezra<br>
<br>
On Sun, 15 Apr 2018 15:19:18 -0400, Harald Kliems wrote:<br>
> <br>
> For our bike advocacy organization, I have been looking into commuting<br>
> data from the ACS. Until recently, I used the FactFinder to download<br>
> tables and then manipulate and analyze the data in LibreOffice Calc.<br>
> I've now tried using the very useful ACS.r package to improve my work<br>
> flow, but looking at the retrieved data, there seem to be differences<br>
> between what I get through the ACS.r/API and what I download through<br>
> the web interface from FactFinder.<br>
> <br>
> For example, for 2016 ACS 1-year data from table B08006 for Madison (WI):<br>
> <br>
> ###########<br>
> ## set geography to city of Madison, Wisconsin<br>
> Madison <- geo.make(state="WI", place = 48000)<br>
> <br>
> ## select only the total, car/truck/van, public transport, bicycle,<br>
> walk variables from table B08006<br>
> TransitVars <- acs.lookup(2016, span = 1, table.number = "B08006",<br>
> dataset = "acs")[c(1,2,8,14,15)]<br>
> <br>
> #fetch data for 2016 year and return them into acs object<br>
> <br>
> ACSData2016 <- acs.fetch(2016, geography = Madison,<br>
> variable = TransitVars,<br>
> col.names = c("Total", "Motor Vehicle", "Public<br>
> transit", "Bicycle", "Walked"))<br>
> ##########<br>
> <br>
> Just looking at the "total" column, I get 140,435 through ACS.r but<br>
> 146715 when looking up the same table and geography through<br>
> FactFinder. Similar differences exist for other years and the other<br>
> variables.<br>
> <br>
> I'm pretty new to R, and so it's entirely possible that I'm doing<br>
> something wrong, but I don't see an obvious explanation for the<br>
> discrepancy.<br>
> <br>
> Any hints would be appreciated.<br>
> <br>
> Thanks,<br>
> Harald.<br>
> _______________________________________________<br>
> acs-r mailing list<br>
> <a href="mailto:acs-r@mit.edu" target="_blank">acs-r@mit.edu</a><br>
> <a href="http://mailman.mit.edu/mailman/listinfo/acs-r" rel="noreferrer" target="_blank">http://mailman.mit.edu/mailman/listinfo/acs-r</a><br>
<br>
--<br>
Ezra Haber Glenn, AICP<br>
Department of Urban Studies and Planning<br>
Massachusetts Institute of Technology<br>
77 Massachusetts Ave., Room 7-346<br>
Cambridge, MA 02139<br>
<a href="mailto:eglenn@mit.edu" target="_blank">eglenn@mit.edu</a> <br>
<a href="http://dusp.mit.edu/faculty/ezra-glenn" rel="noreferrer" target="_blank">http://dusp.mit.edu/faculty/ezra-glenn</a><br>
<a href="tel:(617)%20253-2024" value="+16172532024" target="_blank">617.253.2024</a> (w)<br>
<a href="tel:(617)%20721-7131" value="+16177217131" target="_blank">617.721.7131</a> (c)<br>
</blockquote></div></div>