[CTPP] Re: Troubles with data.census.gov

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 &lt;vince.post(a)movrc.org&gt; 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 &lt;vince.post(a)movrc.org&gt;* *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 &lt;catala(a)cutr.usf.edu&gt; *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 &lt;schwartz(a)spcregion.org&gt; *Sent:* Thursday, January 23, 2020 7:12:23 AM *To:* ctpp-news(a)mailman.chrispy.net &lt;ctpp-news(a)mailman.chrispy.net&gt;et>; ctpp-news(a)chrispy.net &lt;ctpp-news(a)chrispy.net&gt; *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 &lt;jlupton(a)Metroplan.org&gt;] *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