Exploring SimplyMap Data: America’s Work from Home Employees

Posted on by

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 variable is titled: % Employment, Work at Home, 2014.

To get started ranking geographies, first select New Ranking at the top of the SimplyMap screen. Next, locate the variable by following this path: Census Data » In 2010 Geographies » People and Households » Employment » Travel to Work » Mode.

Lastly, to view this data by state select Locations, and set it to USA.

From the Analyze Data By dropdown, select “States” to rank the USA by all states. The results are shown below:

workathome1

 

At 7.41%, Vermont ranks first in the US for remote workers. For reference, the national percentage is 4.38. Does anyone have insight as to why Vermont ranks first? A list of the most common employment industries in Vermont is below:

vermontjobs

Lastly, we can look at the data by a different geography – change the Analyze Data By dropdown to display Cities. We can also apply a population filter to only show cities with a population greater than 100,000. Here are the results:

last_workathome

Boulder, CO ranks first in the United States for Work at Home employees. We think this could be attributed to the number of software and tech firms that have opened up or moved to that city in recent years.

We hope you found this SimplyMap report interesting. Stay tuned for more SimplyMap tips and interesting data reports.

Have you already entered for your chance to win an iPad or Kindle Fire? We will be holding the drawing on April 17, 2015. To enter, simply follow us on Twitter and Like Us on Facebook to get your name in consideration.

READ MORE

Exploring SimplyMap Data: America’s Coffee Drinkers

Posted on by

In this week’s edition of exploring SimplyMap data, we take a look at America’s coffee drinkers. SimplyMap contains more than 100 coffee related variables, including consumer spending on coffee by brand and by number of coffee cups consumed per day. For this example, lets look at a broader indicator related to coffee – whether or not a household uses coffee at all. The variable, % BEVERAGES – NON-ALCOHOLIC DRINKS | GROUND OR WHOLE BEAN COFFEE | GROUND OR WHOLE BEAN COFFEE-HH USES? | YES, 2013 can be found in the SimmonsLOCAL folder.

SimmonsLOCAL is a profiling system that provides insights into consumer behavior for 210 American media markets on a local level with 60,000+ data variables, including over 450 categories and 8,000 specific brands. It is a powerful resource that provides insight into consumer spending and behavior, and very popular with business students and researchers.

We begin by creating a ranking report, and setting the geography to USA. Next, under the Analyze Data By drop down, select states. The results are shown below:

coffeedrinkers1

At 70.24%, New Hampshire narrowly edges out Rhode Island (70.18%) and Maine (69.75%) as the top states for household coffee drinking in the US.

When we analyze by City, (by again adjusting the Analyze Data By drop down), and apply a population filter of greater than 75,000, the following cities make the top 10.

coffeedrinkers2

The residents of Lawrence, MA claim the top spot in the US (cities with population > 75k) for coffee drinkers at home. Lastly, we viewed the city of Lawrence by census tract.

coffeedrinkers3

It looks like many of the residents in Lawrence, MA drink their coffee by the Merrimack River. What insights can be drawn from this? What other questions arise? Are there specific characteristics of these States, Cities, or Census Tracts that make their residents more inclined to drink coffee at home? Let us know your thoughts in the comments!

Stay tuned for more SimplyMap tips and reports! Don’t forget to follow us on Twitter and like us on Facebook to stay up to date on all things SimplyMap (and score an entry to our iPad and Kindle Fire raffle while you are at it!).

READ MORE

Our Winter Sweepstakes has begun!

Posted on by

wintersweepstakes1

Our Winter Sweepstakes has begun! Enter to win an iPad Mini 3 or Kindle Fire.

How to Enter:

  1. Follow @SimplyMap on Twitter
  2. Like our SimplyMap Facebook Page for a 2nd Chance to Win
  3. If you are an existing Fan, you’re automatically entered

 

Official Rules: Entries must be completed during the promotion period, from January 27th, 2015 through April 15th, 2015. No purchase necessary. Available to US and Canadian residents only (excluding Quebec) age 18 and older. Void where prohibited. The odds of winning will be determined by the number of eligible entries received. The Grand Prize is an iPad Mini 3 64GB, valued at $499, and the First Prize is a Kindle Fire HDX 7, valued at $199. Winners will be determined on April 17th, 2015 by random drawing from all eligible entries received. Winners will be notified via Facebook or Twitter by April 22nd, 2015.

READ MORE

Exploring SimplyMap Data: America’s Bookworms

Posted on by

In this week’s report exploring SimplyMap data, we take a look at where America’s bookworms reside. To find this data, we used the variable, Reading (Household Average), 2014 found in the Consumer Expenditure folder. This variable encompasses all expenses used on magazine subscriptions, newspaper subscriptions, and books.

To make this report, we chose to utilize a Ranking Report. First, we took a look at the top 10 states:

ce_reading2

At a yearly household average of $133.60, the state of New Hampshire ranks first in the United States in spending on reading material. For reference, the United States at large totaled $116.85. Next, we applied a data filter to view cities with a population of more than 75,000. The results are as follows:

ce_reading3

San Jose, CA ranks first in the United States for household spending on reading materials. California is also well represented in the top 10 with San Diego (2), San Francisco (3), and Los Angeles (7) also ranking in the top 10.

Stay tuned for more SimplyMap data reports and tips!

READ MORE

SimplyMap Tip – Choosing the Correct Report

Posted on by

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 report does, and provide a real-world example of each.

Standard Report definition – a table comparing multiple variables across several locations/location types.

Standard Report real-world use – you are applying for a grant for your city, and would like to analyze some socioeconomic variables to compare your city against the county, state, and United States.

choosingreports1

Ranking Report definition – a table ranking up to 250 locations within a single geography (ex. zipcodes within a city) and single data variable.

Ranking Report real-world use – you are looking for a target area to open up a social program for low income areas and want to rank ZIP Codes in Atlanta, GA from lowest median income up.

choosingreports2

Business Report definition – generates a report showing all businesses that meet your search criteria within a given location.

Business Report real-world use – you are thinking of opening up a pizza restaurant in a city, so you want to see a list of how many pizza restaurants already exist close to your desired location.

choosingreports3

Ring Study definition – a demographic analysis of a target area based on a 1, 3, or 5 mile (or kilometer) radius around a location.

Ring Study real-world use – use to compare different variables in the immediate area, within a specified radius around the selected location.

choosingreports4

Location Analysis definition – view & compare data for all counties in a state, ZIP codes in a city, census tracts in a county, etc.

Location Analysis real-world use – A medical equipment provider may review health data in a Location Analysis to identify cities in the state to consider visiting to market equipment for an ailment.

choosingreports5

Stay tuned for more SimplyMap tips, and don’t forget to follow us on Twitter and like us on Facebook!

READ MORE

Exploring SimplyMap Data: America’s Historic Homes

Posted on by

In this week’s exploration of SimplyMap data, we set out to find which cities in the United States have the highest percentage of older houses. To determine this, we used the variable “% Housing, Built 1939 or Earlier”. The metadata for this variable is shown below:

hhouses1

The ranking report allows SimplyMap users to analyze the data by different geographies. For example, if you select the United States as your location, you may rank the data by: USA, States, Congressional Districts, Counties, Cities, ZIP Codes, and Census Tracts.

hhouses2

First, we’ll take a look at the top 10 states. For reference, 12.71% of all of the housing stock in the USA was built before 1939.

hhouses3

Not surprisingly, the majority of the states with the highest percentage of older homes are located in the northeast. When we switched to cities and applied a population filter > 50,000 we were left with the following cities:

hhouses4

At 67.53% of homes built in 1939 or earlier, Cicero, IL ranks first among cities with populations greater than 50,000 in the United States. We then used the feature to make a map directly from the results page by hovering over Cicero, IL and selecting “Create Map” from the action drop down.

hhouses5

It looks like Cicero, IL is located about 10 miles west from the heart of Chicago.

hhouses6

Want more tips and examples of SimplyMap reports? Follow us on Twitter and like us on Facebook to stay informed!

READ MORE

SimplyMap Tip: Creating a Custom Location

Posted on by

Custom Locations allow SimplyMap users to combine several locations into one larger region. For example, you can use this feature to combine three adjacent ZIP Codes to create your study area.

In this example, we will take a look at neighborhoods (at the block group level) surrounding a university in Chicago.

To get started creating your custom location from the map, use the i-tool and select a location. There will be a drop down to “Add to Combination” with an option to “Create New Combination”.

combo1

This will open up a box to create your combination. Enter a name, and Save.

combo2

Once saved, your combination location will be available to have additional locations added to it. To add more locations, use the i-tool over a location once more, and select “Add to Combination” while choosing the combination that was just created.

combo3

Repeat this process with all locations you would like to include. Selecting the locations panel, and going to “Custom” will allow you to access your new location.

combo4

Below is a map representing the new custom location.

combo5

One of the additional features of creating a custom location, is that this location can be utilized throughout your reports. SimplyMap will combine the data from each individual location, and present the total for the combined custom location.

combo6

Method #2

The second method of creating a custom combination does not require the user to have the location in a recent or favorites, as described above.

1. Go to locations, and select your geography.

2. Check the box for Custom Location, as shown below:

combo7

3. Select “Combination Location” (by default the Radius Location will be checked)

4. If you don’t already have a custom area, select “Create Combination” and give the target area a name, as shown below:

combo8

5. Save

6. Now you can select the drop down of locations and add them into your new custom combination that you created.

combo8

When you’re ready to use your new location, select “Use This Combination”

Stay tuned for more SimplyMap tips and tricks! And don’t forget to follow us on Twitter @SimplyMap.

READ MORE

GRI Exhibiting at OLA Super Conference, January 28-31 [Booth #T8]

Posted on by

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 Convention Centre.

The Ontario Library Association is Canada’s largest library organization and OLA’s Super Conference is Canada’s largest continuing education event in librarianship, with the country’s largest library tradeshow hosting 5,000 attendees.

Stop by our booth, #T8, for a demonstration of SimplyMap Canada and to view the latest tips, tricks and exciting new content.

ola

READ MORE

GRI Exhibiting at ALA Midwinter Meeting in Chicago [Booth #2824] – See you on January 30th!

Posted on by

Visit the SimplyMap team at the ALA Midwinter Meeting in Chicago late January. We will be at booth #2824 offering product demonstrations, tips & tricks, and of course Ghirardelli Chocolate!

Exhibit Hours

Friday, January 30th – 5:30pm-7:30pm

Saturday, January 31st – 9:00am-5:00pm

Sunday, February 1st – 9:00am-5:00pm

Monday, February 2nd – 9:00am-2:00pm

alachicago2015

READ MORE

American Household Spending on Pets

Posted on by

In this week’s SimplyMap blog post, we set out to discover which large US cities spend the most money per year on their pets. To find this out we used the variable, “Pets, Household Average” found in the consumer expenditure category in SimplyMap.

pets1

The national quantiles (by counties) in our legend ranged from a low of $190.35 to a high of $751.84. Using the “Create Ranking from Map” feature, we were presented with the following unfiltered results:

pets2

Creating a ranking report from a map using the US as the location will present county level data by default. Because we wanted to find larger US cities, we had to do two things: change the geography that the data was analyzed by, and create a population filter to show cities with a population greater than 100,000.

Changing How the Data is Analyzed

Changing the geographies of your ranking report is a simple two step process. First, select the “analyze data by” drop down menu and then select a new geographic unit. SimpyMap will present your new data immediately.

pets3

Creating and Applying a Filter

To create and apply a filter to only show cities with a population > 100,000:

Select “Data filters” then “Create new filter” from the top right of your screen.

pets4

At the filter creation screen, we used a recent variable # Population. We then set the condition to be greater than and typed in the value of 100,000. Lastly, we created a name and saved the filter.

pets5

Final Results Presented

Using the Display Options menu located near the top right of SimplyMap, we chose to hide results that did not meet our criteria of a city population greater than 100,000. The final results are below:

pets6

At a yearly average of $737.86, Highlands Ranch, CO ranks #1 in the United States in yearly average household spending on pets.

Stay tuned for more reports and SimplyMap tips & tricks!

READ MORE