Exploring SimplyMap Data: Biking to Work in the US
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 Apr 14, 2016 by Admin
This week’s SimplyMap report will provide an overview of one of the more advanced functionalities in SimplyMap - applying multiple filter conditions. Filters can be applied to any map or ...
Posted on Jan 23, 2015 by Admin
SimplyMap offers a total of 5 unique types of reports: Standard Report, Ranking Report, Business Report, Ring Study, and Location Analysis. This brief write up will define what each repor...
Posted on Oct 23, 2009 by Admin
SimplyMap was highlighted in the Wake County, NC Public Library Business Blog today as a valuable tool for business planning. Wake County has access to SimplyMap through NC LIVE, a statew...
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 Sep 10, 2010 by Admin
SimplyMap Canada is now available at several Canadian institutions, including York University and Ryerson University, in Toronto. SimplyMap Canada has all of the great features included i...
Posted on Mar 13, 2023 by Admin
Hello readers! Today, we’re excited to officially introduce the Location Query Report in SimplyAnalytics. The Location Query Report is a powerful feature in SimplyAnalytics that allows us...
Posted on May 06, 2013 by Admin
We will be exhibiting at ALA 2013 at McCormick Place in Chicago, IL, June 28-July 1. The ALA Annual Conference programs, updates, conversations, and other events cover all of the key issu...
Posted on Feb 14, 2017 by Admin
In previous blog entries, we highlighted the value of having a mapping application to complement premium data when analyzing America's geographic preferences in credit cards, and mayonnai...
Posted on Nov 10, 2017 by Admin
Welcome to this week’s SimplyAnalytics blog post. Today we’re going to take a closer look at the options available to you when editing the map legend. Let’s get started! First, to start e...
Posted on May 26, 2020 by Admin
Hello readers! We hope you are doing well, and thank you for your continued support of SimplyAnalytics. We are excited to announce that scatterplots are officially live! Scatter plots ar...





