There’s plenty of data in this dataset to splice and dice. NextĪre you a data-nerd and like pinball? Stay tuned. I tweaked the distance decay parameters a bit to get a heat map that made sense for the distribution of my points and the area of interest (i.e., the entire U.S.). ![]() I simply put the x,y coordinates of all the pinball locations with a count of pinball machines in each establishment as the “heat” value. Chris Love put together a really useful macro to do nearly all the work here. Alteryx is an excellent spatial data tool, and it’s possible to set up the heat map data in Alteryx to display in Tableau. Though, the data prep can be a little cumbersome, even in traditional GIS tools. Heat maps are fun and a good way to visualize relative geographic distribution of a phenomena. This download is real handy if you need quick access to 2010 Census tables and geometry but don’t want to mess around with Census American Factfinder. For you Alteryx users out there, you don’t need the spatial data package to access 2010 Census data with their Allocate tools. I also use Metropolitan Statistical Areas for my unit of analysis. In the viz, I calculate pinball machines per capita, which requires the inclusion of Census population data. Clip the points to the boundary of the U.S.Spatial match (or spatial join in the GIS world) the pinball locations to Census CBSA’s to bring in population data and provide a geographic unit of analysis.Cross tabulate the data to get a unique record for each pinball machine.Point to the directory with the 93 JSON files and union together with Alteryx’s Wildcard feature inside the Input tool.I needed to spatial join (or spatial match) pinball locations to Census geometry and population values.The JSON format played well the Alteryx’s JSON parser.Here’s what that looks like:īy all means, the data could be prepped in Python. Though, for a few reasons, I turned to my favorite data Swiss army knife, Alteryx. So, I wrote a quick python script to find all the regions and programmatically download all regions. I could take the time to download each region manually, but that’s way too much work. The data is divided into 93 separate regions, which can be individually downloaded. I used a combination of Python and Alteryx for the data prep – Python to get the data and Alteryx for the rest. Union a bunch of JSON files together and transform to a usable form.Lucky for me, they also provide a handy API for accessing their wealth of data. ![]() They collect user-driven data on pinball machines, locations and quality. ![]() If I’m traveling to a new city and want to pin? I consult PinballMap to help me find the best arcade in town. I want to play The Addam’s Family? I consult PinballMap to tell me where to find one. is the perfect resource for navigating the pinball world. ![]() Here’s how to get started making a viz in the tooltip. In my case, I wanted the user to see the most popular pinball machines were still around plotted by the manufacture year, without excessively bogging down the viz. Viz in Tooltip: Ah, the long-awaited Viz in Tooltip.The Heat Map: Yes, proper geographic heat maps (or density maps) will eventually be native in Tableau as announced at #TC17 (possibly in 2018?).What are the best pinball cities? What are the most popular pinball machines? From a Tableau perspective, nothing crazy fancy going on here except for maybe two features: through all the known pinball machines in public places. This viz is meant to let you explore the current state of pinball in the U.S.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |