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 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 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 sta...
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 17, 2014 by Admin
Our recent series Exploring SimplyMap Data Reports has focused on creating ranking reports for unique variables. Accordingly, we thought it would be helpful to write a quick tip on how to...
Posted on Jun 02, 2017 by Admin
We can't wait for ALA Annual this Summer, and the opportunity to share SimplyAnalytics with the ALA community. Stop by the SimplyAnalytics booth (1339) and take a peak at what we've been ...
Posted on May 06, 2013 by Admin
The GRI team is looking forward to exhibiting at SLA 2013 at the San Diego Convention Center, June 9th through the 11th. The Special Libraries Association (SLA) is a nonprofit global orga...
Posted on Mar 30, 2016 by Admin
In previous blog entries we highlighted the usefulness of viewing multiple years of data for the same variable. In short, analyzing the same variable across multiple years allows users to...
Posted on Sep 01, 2008 by Admin
The King County Library System in Washington State now subscribes to SimplyMap, and has published a brief review on their blog, Library Talk.
Posted on Jun 16, 2016 by Admin
This week’s SimplyMap report is a quick tip that we hope you find useful and time saving. Did you know that SimplyMap will save all recently searched business queries for future usage? Le...
Posted on Feb 13, 2015 by Admin
In this week’s report exploring SimplyMap data, we want to find out where America’s remote workers reside. To find this, we can tap into the Census data in SimplyMap. The specific variabl...