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 Aug 15, 2013 by Admin
Anyone who has traveled to Seattle hoping for a sunny day could fairly estimate that it is one of the rainiest states with the highest level of precipitation each year. SimmonsLOCAL varia...
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 Sep 08, 2016 by Admin
One of our favorite uses of SimplyMap is to find data that validates our general assumptions and observations. For example, in a previous blog we wrote about the growth of tablet ownershi...
Posted on Apr 10, 2015 by Admin
In this week’s SimplyMap report, we explore one of the newer datasets available: Retail Market Power®. What is it? In short, the Retail Market Power® dataset helps users identify opportun...
Posted on Jun 02, 2016 by Admin
Three weeks ago we utilized the SimmonsLOCAL data set to visualize contiguous America’s mayonnaise brand preference. Staying with the American visualization theme, this week’s report will...
Posted on Nov 19, 2019 by Admin
Hello readers! Today we are bringing you a new blog entry inspired by a recent Help Desk question. If you ever have any questions about SimplyAnalytics, please do not hesitate to reach ou...
Posted on Sep 21, 2009 by Admin
The North Carolina Library Association will hold its annual conference in Greenville, NC at the Greenville Convention Center from October 6-8, 2009. Geographic Research, Inc. will be exhi...
Posted on Oct 22, 2008 by Admin
Excerpt from University of Iowa Library blog: In your marketing class, you may be developing a marketing plan for a pre-made meals restaurant specializing in vegetarian menus in Chicagola...
Posted on Dec 11, 2015 by Admin
With the final week of the college football season in the books, and bowl game selections having just taken place, we wanted to search within SimplyMap to see if any data pertaining to co...
Posted on Nov 06, 2014 by Admin
With over 75,000 variables in SimplyMap, you can find virtually any information you want. This week, we take a look at which U.S. locations spend the most money eating at restaurants or c...





