Ball-Diamonds used FIELDNAME while Splash Pads were labeled by PARKNAME, and others just used NAME. This was to remediate the issue caused by different naming conventions from the different files. Instead of having different fields for COURT_TYPE,” “FIELD_TYPE or RINK_TYPE, I decided to create one common column called FACILITY_TYPE. Step 3: Rename the main descriptor for each field.
This helped me distinguish the basketball court from the sledding hill from the skating rinks and so on.
This adds another field naming the type of park it was based on the file it came from. Thanks to Alteryx, I was able to take these 14 different data sets, with varying amounts of detail and information, to make one, clean, analyzable dataset. You can keep reading to learn about the process or you can jump directly to the viz. Just 14 different sets for 14 different types of parks.įortunately, I had both the tools and the knowledge to blend these data sets and visualize the results. No big, clean, fun list of Ottawa’s play structures, skating rinks and tennis courts. I thought, “What if I l used a list of all their recreational facilities and made a viz out of that!” So, I started looking for the compiled list of all their recreational facilities. Alright, it’s maybe not the most exciting thing about Ottawa, but it’s definitely exciting to a data dweeb like me.Īfter browsing the Ottawa Data Catalogue, I found some awesome datasets on sports fields, skateparks, beaches and other recreational facilities. Full of information on contracts, budgets, population elections, you name it. But most exciting of all, Ottawa is home to an excellent open data catalogue. The University of Ottawa educated the greatest game show host of all time, Alex Trebek, who studied philosophy (presumably because he couldn’t major in trivia). Home to astronauts, comedians, musicians and more. Ottawa: Capital city to our neighbor to the north, Canada.
0 kommentar(er)
