Go up
Exploring SimplyMap Data: Biking to Work in the US
Posted on Jul 09, 2015 by Admin
In this week’s SimplyMap report, we set out to find which cities have the highest percentages of people who use their bike as their mode of transportation to work in the US. Let’s get started!
1. Create a new Ranking Report by selecting “New Ranking” at the top of Simply Map:
2. Select the variable to rank. Follow this path to find the % Employment, Bicycle to Work, 2014 variable: Census Data » People and Households » Employment » Travel to Work » Mode. Image below for reference.
3. Open the Locations panel and choose USA as your geography. Close out the Locations panel to generate your report. Use the “Analyze data by” tool to select cities.
Because our variable is using a percentage, the ranking report may produce results skewed towards cities with a smaller population. To address this, we can quickly apply a data filter to only show cities with a population greater than 50,000.
Favorite the variable titled, # Population (Pop). This can be found here: Census Data » People and Households » Age » Total. Return to your report, and select Create New Filter from the Data Filters Dropdown towards the top right. Follow the steps below to create and apply the filter:
- Scroll down on the variables dropdown to the Favorites list. Select # Population (Pop)
- Set the second dropdown to be “is greater than”.
- Enter 50,000 into the value field.
- Name the filter
- Save
Once applied, your new report will be generated to show only cities that have a population greater than 50,000. Cities that don’t meet this criteria will be displayed with a strikethrough. To hide this, click on Display Options > Filtered Locations > Hide to see your final list.
Davis, CA takes home the distinction of having the most bike to work commuters in the United States. A little research on Wikipedia reveals that Davis, CA’s motto is: Most Bicycle Friendly Town in the World. Our results here seem to prove that motto (at least in the US)!
Stay tuned for more SimplyMap reports and tips!
More from SimplyAnalytics
Posted on May 16, 2022 by Admin
Hello readers! We hope you are having a wonderful day. Today we feature a question from the help desk that we think many users would find useful. Let’s get started. The question: How can ...
Posted on Jun 21, 2019 by Admin
Come visit the SimplyAnalytics booth (#3010) at the upcoming ALA 2019 show in Washington, D.C.! Our team will be on hand offering quick demos of SimplyAnalytics, answering questions and s...
Posted on Feb 01, 2009 by Admin
Want to know the top 10 wealthiest ZIP codes in your state? How about the top 25 counties with the most elderly residents? Duke University students can now easily answer these questions a...
Posted on Feb 27, 2015 by Admin
SimplyMap is an excellent tool for market research, and it’s made even more powerful by Nielsen PRIZM data. Nielsen PRIZM is the highest quality market segment data available. Every house...
Posted on Jul 30, 2018 by Admin
Hello readers! Welcome to this week’s blog. This week we will feature the Related Data Table view and how you can use it to maximize your productivity in SimplyAnalytics. What is it? The ...
Posted on Jul 22, 2015 by Admin
In this week’s SimplyMap report, we take a look at one of our newly available data packages - ConneXions® from Nielsen. The ConneXions® segmentation system integrates consumer behavior an...
Posted on Jul 14, 2009 by Admin
Men's Health continues to utilize SimplyMap to identify and rank U.S. cities. This time they are studying "sports-obsessed citizenry," and here is how they did it: Our stat showdown began...
Posted on Dec 15, 2014 by Admin
Custom Locations allow SimplyMap users to combine several locations into one larger region. For example, you can use this feature to combine three adjacent ZIP Codes to create your study ...
Posted on Sep 05, 2019 by Admin
We are pleased to be exhibiting again at the Charleston Library Conference, on Tuesday November 5th, 2019. The Vendor Showcase will be held in the Gaillard Center Grand Ballroom (95 Calho...
Posted on Jan 29, 2016 by Admin
In a previous blog entry, we highlighted the benefits of having multiple years of data available for the same variable. This allows users to identify trends over time. Keeping with the sa...