_______________________________________________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.-JamiJami DennisGeodetic Analysis, llcOn 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
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