<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Thanks. Also, maybe you noticed my slight typo/oversight: if you want the 1-year acs data, you should say "span=1" in the acs.fetch below, not span=5.<br>
<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
--<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Ezra Haber Glenn, AICP <br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Department of Urban Studies and Planning<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Massachusetts Institute of Technology<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
77 Massachusetts Ave., Room 7-346<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
Cambridge, MA 02139<br>
</div>
<div dir="auto" style="direction: ltr; margin: 0; padding: 0; font-family: sans-serif; font-size: 11pt; color: black; ">
eglenn@mit.edu <a href="http://dusp.mit.edu/faculty/ezra-glenn">http://dusp.mit.edu/faculty/ezra-glenn</a> 617.253.2024 (w) 617.721.7131 (c)</div>
<br>
</div>
<br>
<br>
<br>
<div class="gmail_quote">On Tue, Apr 17, 2018 at 8:39 AM -0400, "Harald Kliems" <span dir="ltr">
<<a href="mailto:harald@madisonbikes.org" target="_blank">harald@madisonbikes.org</a>></span> wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="3D"ltr"">
<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>
</div>
</blockquote>
</div>
</body>
</html>