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@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@geodetic.xyz

On Jan 23, 2020, at 7:54 AM, Vince Post <vince.post@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@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@mailman.chrispy.net; ctpp-news@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>
Sent: Thursday, January 23, 2020 8:29 AM
To: ctpp-news@mailman.chrispy.net; ctpp-news@chrispy.net
Subject: [CTPP] Re: Troubles with data.census.gov

 

+1

 


From: Bob Schwartz <schwartz@spcregion.org>
Sent: Thursday, January 23, 2020 7:12:23 AM
To: ctpp-news@mailman.chrispy.net <ctpp-news@mailman.chrispy.net>; ctpp-news@chrispy.net <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
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@mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave@mailman.chrispy.net
_______________________________________________
ctpp-news mailing list -- ctpp-news@mailman.chrispy.net
To unsubscribe send an email to ctpp-news-leave@mailman.chrispy.net