I have prepared US national census tract data using the 2010-2014 ACS data for a number of socio-economic and other demographic variables.
See my website at: www.thedemographics.com - "Data for Tableau"
Also, if you have specific variables that you do not see in what I have done, or have questions about how to use the data, please let me know. It comes with Mapbox background maps as well.
1 of 1 people found this helpful
This may be irrelevant now, but I wanted to let you know that I created a web data connector that allows you to import Census Tract shapefiles and link them to Census Data. I also created a web data connector for the 5 year ACS profile 2010-2014.
The ACS profile WDC is at http://bigbytes.mobyus.com/tableau/censuswdc11.aspx
The census tract shapes are at http://bigbytes.mobyus.com/tableau/censustractshapeswdc11.aspx
I have a blog post on how to use the ACS connector, but haven't yet posted one on the census tract shapefiles. You might be able to figure it out. You can choose a state, county, or a specific tract. Once the data is imported, relate on the GEOID. In the sheet, select the marker as "polygon" and drag and drop "point order" onto the "path" icon of the Marker toolbar. Change PointLatitude and PointLongitude to be type geography (Latitude and Longitude respectively) and then double-click each to add to the sheet.
Add GEOID, SubPolygon to the Marker as dimensions and then your variable(s) of choice. This should get you there, but let me know if questions.
Has anyone tried the 10.2 native shapefile/KLM support?
Is there a simple way to get shapefiles for all states plus DC at the census tract level (Census 2010 or ACS 2015 5 Year)?
Can Tableau 10.2 use them without the row amplification inherent in Allan's solution?
Hi Tom, I'm looking forward to trying the direct access to ESRI shapefiles and MapInfo TAB files in 10.2 later this week. But I think your choice is either build a national file from state census tract files or purchase a national file from a vendor. The Census Bureau, as you know, only provides state level tract files; see table under "file availability" here: TIGER/Line® - Geography - U.S. Census Bureau The 2016 Tigerline files are the latest. The beauty of the direct link in 10.2, of course, is not having to construct individual polygons, with potential slivers and so forth, because the shapefiles and TAB files would be pre-built and presumed topologically correct. That's a huge step forward for Tableau and mapping enthusiasts.
Tom, just tested in 10.2 California census tracts sourced as an ESRI shapefile (from Census Bureau) and a MapInfo TAB file (converted from said Census Bureau shapefile) and all seems to work fine. They are selectable as "background maps" but can be linked to data for various mark formats like filled maps and circles (sized and shaded with data). Initially, the boundary files are overlaid on OpenStreetMap but I intend to test as well the Mapbox backgrounds which can be more stunning, shall we say.
By the way, elsewhere I have argued for the utility of census tract demographics for spatial analysis using ACS data, which works quite well in Tableau. Now, with 10.2 that will be a lot easier and necessary given that the background demographics are still offered only at state, county, Zip Code, and block group.
Tom - I did an export of all census tract data in my table to a csv file. I hope this is helpful to you or others. It is just over 72MB in size.
To download this csv file, go to:
Thanks! I was dreading doing this.