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 Mar 22, 2016 by Admin
Inspired by some recent support desk questions, this week’s SimplyMap report will provide some useful tips and tricks to help make the most out of your maps. Let’s get started! First, let...
Posted on Jun 02, 2017 by Admin
We will be exhibiting at SLA in Phoenix, AZ on June 18th-20th. You can find the SimplyAnalytics team at Booth #905. Stop by and check out our groundbreaking new interface, have a chocolat...
Posted on Mar 02, 2009 by Admin
ACRL's 14th National Conference will be held at the Washington State Trade and Convention Center in downtown Seattle, March 12-15, 2009. Every other year, ACRL offers its premier profe...
Posted on Feb 25, 2020 by Admin
SimplyAnalytics will be exhibiting at the PLA Conference, held this year at the Music City Center in Nashville, TN on February 26 - 28. Visit the team at Booth 1444 with your questions, f...
Posted on Nov 04, 2013 by Admin
SimplyMap 3.0 is here, and uses the latest technology to provide better performance, improved reliability, and powerful new features. There are many improvements designed to make it easie...
Posted on Oct 24, 2014 by Admin
At times it can be useful to apply filters to the data in SimplyMap as a means of focusing on specific characteristics, or preforming a query. For example, a map showing household income ...
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 Dec 15, 2014 by Admin
Stop by the Geographic Research booth at the Ontario Library Association Super Conference to check out SimplyMap Canada. The conference will take place January 28-31 at the Metro Toronto ...
Posted on Feb 20, 2018 by Admin
We are looking forward to attending the annual SCELC (Statewide California Electronic Library Consortium) Vendor day, at Loyola Marymount University in Los Angeles on March 8th. In additi...
Posted on Mar 04, 2014 by Admin
March 11-15 Indianapolis, Indiana The Public Library Association is prepared for another week of events, workshops and special appearances for librarians and authors. Visit our exh...





