22 Jan
2020
22 Jan
'20
3:22 p.m.
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my personal experience
is that data.census.gov is capricious, inconsistent, and inadequate. The potential is
(probably) there but to my view it's not yet ready for prime time - yet it is the only
way you can access the 2018 ACS. American Factfinder is going away in a matter of months,
so soon the shaky and unstable data.census.gov system will be all that we have.
Perhaps there's some magic bullet I have yet to find. Or an alternative that provides
the professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner - Publications
Metroplan
Little Rock AR
23 Jan
23 Jan
6:12 a.m.
I agree with Jonathan. I HATE data.census.gov. Bring back American
FactFinder.
From: jonathan lupton [mailto:jlupton@Metroplan.org]
Sent: Wednesday, January 22, 2020 4:22 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my
personal experience is that data.census.gov is capricious, inconsistent,
and inadequate. The potential is (probably) there but to my view it's
not yet ready for prime time - yet it is the only way you can access the
2018 ACS. American Factfinder is going away in a matter of months, so
soon the shaky and unstable data.census.gov system will be all that we
have.
Perhaps there's some magic bullet I have yet to find. Or an alternative
that provides the professional reliability the data community needs.
API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner - Publications
Metroplan
Little Rock AR
7:28 a.m.
+1
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Bob Schwartz <schwartz(a)spcregion.org>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>et>;
ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net>
Subject: [CTPP] Re: Troubles with data.census.gov
This email originated from outside of USF. Do not click links or open attachments unless
you recognize the sender or understand the content is safe.
I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder.
From: jonathan lupton [mailto:jlupton@Metroplan.org]
Sent: Wednesday, January 22, 2020 4:22 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my personal experience
is that data.census.gov is capricious, inconsistent, and inadequate. The potential is
(probably) there but to my view it’s not yet ready for prime time – yet it is the only way
you can access the 2018 ACS. American Factfinder is going away in a matter of months, so
soon the shaky and unstable data.census.gov system will be all that we have.
Perhaps there’s some magic bullet I have yet to find. Or an alternative that provides the
professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner – Publications
Metroplan
Little Rock AR
9:48 a.m.
Hard to believe they could have produced something worse than FactFinder. I could never
imagine missing it. Alan E Pisarski
Alan E. Pisarski Consultancy
Landline 703 941-4257
Cell 703 650-8925
From: Catala, Martin <catala(a)cutr.usf.edu>
Sent: Thursday, January 23, 2020 8:29 AM
To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov
+1
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Bob Schwartz <schwartz@spcregion.org<mailto:schwartz@spcregion.org>>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>
<ctpp-news@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>>;
ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
<ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>>
Subject: [CTPP] Re: Troubles with data.census.gov
This email originated from outside of USF. Do not click links or open attachments unless
you recognize the sender or understand the content is safe.
I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder.
From: jonathan lupton [mailto:jlupton@Metroplan.org]
Sent: Wednesday, January 22, 2020 4:22 PM
To: ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
Subject: [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my personal experience
is that data.census.gov is capricious, inconsistent, and inadequate. The potential is
(probably) there but to my view it's not yet ready for prime time - yet it is the only
way you can access the 2018 ACS. American Factfinder is going away in a matter of months,
so soon the shaky and unstable data.census.gov system will be all that we have.
Perhaps there's some magic bullet I have yet to find. Or an alternative that provides
the professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner - Publications
Metroplan
Little Rock AR
9:54 a.m.
Alan,
Truer words have not been spoken.
_________________________________________________
Vincent Post, III
Transportation/GIS Specialist
Mid-Ohio Valley Regional Council
Wood-Washington-Wirt Interstate Planning Commission
709 Market Street
P.O. Box 247
Parkersburg, WV 26101
E-mail: vince.post@movrc.org<mailto:vince.post@movrc.org>
Phone: 304.422.4993 ext. 106
Fax: 304.422.4998
From: Alan Pisarski [mailto:alanpisarski@alanpisarski.com]
Sent: Thursday, January 23, 2020 10:48 AM
To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov
Hard to believe they could have produced something worse than FactFinder. I could never
imagine missing it. Alan E Pisarski
Alan E. Pisarski Consultancy
Landline 703 941-4257
Cell 703 650-8925
From: Catala, Martin <catala@cutr.usf.edu<mailto:catala@cutr.usf.edu>>
Sent: Thursday, January 23, 2020 8:29 AM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>;
ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
Subject: [CTPP] Re: Troubles with data.census.gov
+1
Get Outlook for iOS<https://aka.ms/o0ukef>
________________________________
From: Bob Schwartz <schwartz@spcregion.org<mailto:schwartz@spcregion.org>>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: ctpp-news@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>
<ctpp-news@mailman.chrispy.net<mailto:ctpp-news@mailman.chrispy.net>>;
ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
<ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>>
Subject: [CTPP] Re: Troubles with data.census.gov
This email originated from outside of USF. Do not click links or open attachments unless
you recognize the sender or understand the content is safe.
I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder.
From: jonathan lupton [mailto:jlupton@Metroplan.org]
Sent: Wednesday, January 22, 2020 4:22 PM
To: ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
Subject: [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my personal experience
is that data.census.gov is capricious, inconsistent, and inadequate. The potential is
(probably) there but to my view it's not yet ready for prime time - yet it is the only
way you can access the 2018 ACS. American Factfinder is going away in a matter of months,
so soon the shaky and unstable data.census.gov system will be all that we have.
Perhaps there's some magic bullet I have yet to find. Or an alternative that provides
the professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner - Publications
Metroplan
Little Rock AR
10:03 a.m.
Totally agree! I ended up downloading the summary files and importing them into ms sql
databases. Then just query what i want from there. If anyone wants those i have the files
exported by state so should be easily imported into SQL. You will need to know sql and
understand the summary file and geography relationships but it isnt too difficult and i
can provide sample queries if needed.
-Jami
Jami Dennis
Geodetic Analysis, llc
Jami(a)geodetic.xyz
On Jan 23, 2020, at 7:54 AM, Vince Post
<vince.post(a)movrc.org> wrote:
Alan,
Truer words have not been spoken.
_________________________________________________
Vincent Post, III
Transportation/GIS Specialist
Mid-Ohio Valley Regional Council
Wood-Washington-Wirt Interstate Planning Commission
709 Market Street
P.O. Box 247
Parkersburg, WV 26101
E-mail: vince.post(a)movrc.org
Phone: 304.422.4993 ext. 106
Fax: 304.422.4998
From: Alan Pisarski [mailto:alanpisarski@alanpisarski.com]
Sent: Thursday, January 23, 2020 10:48 AM
To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov
Hard to believe they could have produced something worse than FactFinder. I could never
imagine missing it. Alan E Pisarski
Alan E. Pisarski Consultancy
Landline 703 941-4257
Cell 703 650-8925
From: Catala, Martin <catala(a)cutr.usf.edu>
Sent: Thursday, January 23, 2020 8:29 AM
To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov
+1
Get Outlook for iOS
From: Bob Schwartz <schwartz(a)spcregion.org>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>et>;
ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net>
Subject: [CTPP] Re: Troubles with data.census.gov
This email originated from outside of USF. Do not click links or open attachments unless
you recognize the sender or understand the content is safe.
I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder.
From: jonathan lupton [mailto:jlupton@Metroplan.org]
Sent: Wednesday, January 22, 2020 4:22 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my personal experience
is that data.census.gov is capricious, inconsistent, and inadequate. The potential is
(probably) there but to my view it’s not yet ready for prime time – yet it is the only way
you can access the 2018 ACS. American Factfinder is going away in a matter of months, so
soon the shaky and unstable data.census.gov system will be all that we have.
Perhaps there’s some magic bullet I have yet to find. Or an alternative that provides the
professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner – Publications
Metroplan
Little Rock AR
_______________________________________________
ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net
10:22 a.m.
Everyone should check out Kyle Walker's tidycensus package for R. It's a
wrapper for the various census APIs and makes
downloading/importing/mapping/visualizing a breeze:
https://walkerke.github.io/tidycensus/articles/basic-usage.html
I no longer access census data using any other method.
On Thu, Jan 23, 2020 at 10:04 AM Jami Dennis <jami(a)geodetic.xyz> wrote:
Totally agree! I ended up downloading the summary
files and importing
them into ms sql databases. Then just query what i want from there. If
anyone wants those i have the files exported by state so should be easily
imported into SQL. You will need to know sql and understand the summary
file and geography relationships but it isnt too difficult and i can
provide sample queries if needed.
-Jami
Jami Dennis
Geodetic Analysis, llc
Jami(a)geodetic.xyz
On Jan 23, 2020, at 7:54 AM, Vince Post <vince.post(a)movrc.org> wrote:
Alan,
Truer words have not been spoken.
*_________________________________________________*
*Vincent Post, III*
*Transportation/GIS Specialist*
*Mid-Ohio Valley Regional Council*
*Wood-Washington-Wirt Interstate Planning Commission*
*709 Market Street*
*P.O. Box 247*
*Parkersburg, WV 26101*
*E-mail: vince.post(a)movrc.org <vince.post(a)movrc.org>*
*Phone: 304.422.4993 ext. 106*
*Fax: 304.422.4998*
*From:* Alan Pisarski [mailto:alanpisarski@alanpisarski.com]
*Sent:* Thursday, January 23, 2020 10:48 AM
*To:* ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
*Subject:* [CTPP] Re: Troubles with data.census.gov
Hard to believe they could have produced something worse than FactFinder.
I could never imagine missing it. Alan E Pisarski
Alan E. Pisarski Consultancy
Landline 703 941-4257
Cell 703 650-8925
*From:* Catala, Martin <catala(a)cutr.usf.edu>
*Sent:* Thursday, January 23, 2020 8:29 AM
*To:* ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
*Subject:* [CTPP] Re: Troubles with data.census.gov
+1
Get Outlook for iOS <https://aka.ms/o0ukef>
------------------------------
*From:* Bob Schwartz <schwartz(a)spcregion.org>
*Sent:* Thursday, January 23, 2020 7:12:23 AM
*To:* ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>et>;
ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net>
*Subject:* [CTPP] Re: Troubles with data.census.gov
This email originated from outside of USF. Do not click links or open
attachments unless you recognize the sender or understand the content is
safe.
I agree with Jonathan. I HATE data.census.gov. Bring back American
FactFinder.
*From:* jonathan lupton [mailto:jlupton@Metroplan.org
<jlupton(a)Metroplan.org>]
*Sent:* Wednesday, January 22, 2020 4:22 PM
*To:* ctpp-news(a)chrispy.net
*Subject:* [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my
personal experience is that data.census.gov is capricious, inconsistent,
and inadequate. The potential is (probably) there but to my view it’s not
yet ready for prime time – yet it is the only way you can access the 2018
ACS. American Factfinder is going away in a matter of months, so soon the
shaky and unstable data.census.gov system will be all that we have.
Perhaps there’s some magic bullet I have yet to find. Or an alternative
that provides the professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner – Publications
Metroplan
Little Rock AR
_______________________________________________
ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net
_______________________________________________
ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net
11:03 a.m.
This is wonderful! Thanks for sharing it!
On Jan 23, 2020, at 8:23 AM, Alex Karner
<alex.karner(a)gmail.com> wrote:
Everyone should check out Kyle Walker's tidycensus package for R. It's a wrapper
for the various census APIs and makes downloading/importing/mapping/visualizing a breeze:
https://walkerke.github.io/tidycensus/articles/basic-usage.html
I no longer access census data using any other method.
On Thu, Jan 23, 2020 at 10:04 AM Jami Dennis
<jami(a)geodetic.xyz> wrote:
Totally agree! I ended up downloading the summary files and importing them into ms sql
databases. Then just query what i want from there. If anyone wants those i have the files
exported by state so should be easily imported into SQL. You will need to know sql and
understand the summary file and geography relationships but it isnt too difficult and i
can provide sample queries if needed.
-Jami
Jami Dennis
Geodetic Analysis, llc
Jami(a)geodetic.xyz
_______________________________________________
ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net
_______________________________________________
ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net On Jan
23, 2020, at 7:54 AM, Vince Post <vince.post(a)movrc.org> wrote:
Alan,
Truer words have not been spoken.
_________________________________________________
Vincent Post, III
Transportation/GIS Specialist
Mid-Ohio Valley Regional Council
Wood-Washington-Wirt Interstate Planning Commission
709 Market Street
P.O. Box 247
Parkersburg, WV 26101
E-mail: vince.post(a)movrc.org
Phone: 304.422.4993 ext. 106
Fax: 304.422.4998
From: Alan Pisarski [mailto:alanpisarski@alanpisarski.com]
Sent: Thursday, January 23, 2020 10:48 AM
To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov
Hard to believe they could have produced something worse than FactFinder. I could never
imagine missing it. Alan E Pisarski
Alan E. Pisarski Consultancy
Landline 703 941-4257
Cell 703 650-8925
From: Catala, Martin <catala(a)cutr.usf.edu>
Sent: Thursday, January 23, 2020 8:29 AM
To: ctpp-news(a)mailman.chrispy.net; ctpp-news(a)chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov
+1
Get Outlook for iOS
From: Bob Schwartz <schwartz(a)spcregion.org>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: ctpp-news(a)mailman.chrispy.net <ctpp-news(a)mailman.chrispy.net>et>;
ctpp-news(a)chrispy.net <ctpp-news(a)chrispy.net>
Subject: [CTPP] Re: Troubles with data.census.gov
This email originated from outside of USF. Do not click links or open attachments unless
you recognize the sender or understand the content is safe.
I agree with Jonathan. I HATE data.census.gov. Bring back American FactFinder.
From: jonathan lupton [mailto:jlupton@Metroplan.org]
Sent: Wednesday, January 22, 2020 4:22 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Troubles with data.census.gov
Am I the only user having chronic problems with data.census.gov?
After nearly a year of constant attempts at use and self-training, my personal experience
is that data.census.gov is capricious, inconsistent, and inadequate. The potential is
(probably) there but to my view it’s not yet ready for prime time – yet it is the only way
you can access the 2018 ACS. American Factfinder is going away in a matter of months, so
soon the shaky and unstable data.census.gov system will be all that we have.
Perhaps there’s some magic bullet I have yet to find. Or an alternative that provides the
professional reliability the data community needs. API?
Can anybody in the data community offer insights?
Thanks!
Jonathan Lupton AICP
Senior Planner – Publications
Metroplan
Little Rock AR
_______________________________________________
ctpp-news mailing list -- ctpp-news(a)mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave(a)mailman.chrispy.net
1797
days inactive
1798
days old
7 comments
7 participants
participants (7)
-
Alan Pisarski -
Alex Karner -
Bob Schwartz -
Catala, Martin -
Jami Dennis -
jonathan lupton -
Vince Post