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 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 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 Dec 02, 2014 by Admin
Today we take a look at one of the more advanced features in SimplyMap - editing the map legend. Editing the map legend is a great way to not only customize how the data is distributed on...
Posted on Oct 29, 2015 by Admin
Did you know that SimplyMap allows you to search for businesses by NAICS or SIC codes? Searching by these codes is a great alternative to the general keyword search. Using the keyword sea...
Posted on Aug 02, 2016 by Admin
Did you know that you can use SimplyMap to identify which make and model of vehicle is most prevalent within any location in the United States? In this week’s SimplyMap report, we’ll take...
Posted on Feb 26, 2014 by Admin
The Statewide California Electronic Library Consortium is holding another packed week of workshops and networking during the SCELCapalooza event in March 2014. Geographic Research will b...
Posted on May 02, 2016 by Admin
Inspired by a recent support desk question, this week’s SimplyMap report will demonstrate how a user would run a business search that consists of multiple names. In short, the user was at...
Posted on Nov 03, 2017 by Admin
This week we’ll talk about one of our favorite features in SimplyAnalytics - the custom combination location. This feature is a simple and effective means to create custom geographies whe...
Posted on Mar 11, 2024 by Admin
We're thrilled to announce that SimplyAnalytics will be exhibiting at the ALA Annual Conference in San Diego! We can't wait to connect with library professionals, share insights, and show...
Posted on Jul 30, 2015 by Admin
One great feature within SimplyMap is the ability to track the same variable across multiple years. In this report, we will track the percentage of households in the US ordering items fro...





