News

Exploring SimplyMap Data: America’s Bookworms

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!

Posted in SimplyMap Leave a comment

SimplyMap Tip – Choosing the Correct Report

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!

Posted in SimplyMap Leave a comment

Exploring SimplyMap Data: America’s Historic Homes

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!

Posted in SimplyMap Leave a comment

SimplyMap Tip: Creating a Custom Location

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.

Posted in SimplyMap Leave a comment

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

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

Posted in SimplyMap Leave a comment

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

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

Posted in SimplyMap Leave a comment

American Household Spending on Pets

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!

Posted in SimplyMap Leave a comment

SimplyMap Tip – Editing the Map Legend

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 the map, but to also change the look and feel of the map.

First, you can customize the map by changing the geographic unit shown and the variable year from the legend.

maplegend1

Data can be displayed by State, Congressional District, County, City, ZIP Code, Census Tract, or Census Block Group. The geographic unit can be chosen manually, or you can check the box labeled “Auto-select Geo Unit,” and SimplyMap will automatically display the most appropriate geography based on the zoom level of the map. Zooming into an area will result in increasingly smaller geographic units and present the data in greater detail.

To edit other aspects of the map legend, select “Edit Legend” at the bottom of the legend. The Legend Editor will open. The image below details this dialog, along with an explanation of what can be edited:

maplegend2

1. Classification Method: This dropdown determines how the data in your map is grouped. There are multiple methods for calculating break values for the data. You can select any of the following from the Classification Method menu:

•Quantiles (Local)
•Quantiles (National)
•Natural Breaks (Local)
•Natural Breaks (National)
•Equal Intervals

Changing from Quantiles (National) to Quantiles (Local) will reconfigure your data ranges to reflect a sample of locations from the current view, as opposed to viewing it on a national scale.

You can learn more about each of the classification methods in the FAQ.

2. Number of Categories: Determines the number of data ranges you would like to see. This will also impact the number of colors you see on the map. By default, this will show 5.

maplegend3

3. Color Scheme: Changes the map’s color scheme. Alternatively, if you select an individual box in the legend, you can apply your color of choice for each.

maplegend4

4. Data Values: Allows the user to manually enter new category break values and create custom data ranges.

maplegend5

5. Outline Color/Outline Thickness: Changes the color and thickness of your map’s outline. The image below shows a map’s color outline and thickness set to a darker grey, and 2 respectively.

maplegend6

This is what the final map would look like with the edited color outline and thickness:

maplegend7

Stay tuned for more SimplyMap tips and tricks!

 

Posted in SimplyMap Leave a comment

Exploring SimplyMap Data: America’s Most Educated Cities

In this week’s report, we research America’s most educated cities. SimplyMap contains a total of 111 educational attainment variables, including general population and by race.

We used the variable “% Education, College, Master’s or Doctorate Degree” to account for all populations possessing at least a bachelor’s degree. This variable can be found using the following path: Census Data >> 2010 Geographies >> People and Households >> Education >> Attainment. The image below details this path.

educationattainment1

The following US map was then created, shown by county:

educationattainment2

Using the Make Ranking from Map feature while viewing the US, the report will rank county level data by default.

rankingfrommap

We then utilized the Analyze data by tool found at the top of the results, and changed the geographies to display cities.

analyzedataby3

Lastly, we applied a data filter to only show cities with populations greater than 50,000 (read our entry on using the data filter here). In the end, we were left with the following results:

edattain3

It looks like Cupertino, CA ranks #1 in the US for having the most college graduates at 70.5%, narrowly beating out Palo Alto, CA (70.41%) and Hoboken, NJ (69.28%).

Is there a variable you’re interested in seeing mapped or ranked? Let us know!

Posted in SimplyMap Leave a comment

SimplyMap Tip – Creating a Map from a Ranking Report

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 create a map directly from the ranking results.

After creating a ranking report in SimplyMap, you can quickly create a map using any of the locations in your ranking. Let’s look at an example.

Our November 6 Report, “Which US Locations Dine Out the Most?” identified ZIP code 95035 in Milpitas, CA as the ZIP Code with the highest average spending on restaurant and carry out meals. We can find out exactly where it is located by mapping the location directly from the report by hovering over the location and selecting “Create Map” from the action dropdown, as shown below:

milpitas

A map using the ranked variable (Meals at restaurants, carry outs and other (Household Average), 2014) will then be created. The image below shows an exported image of ZIP code 95035 in Milpitas, CA.

milipitaslocation

Stay tuned for more SimplyMap tips and tricks!

Posted in SimplyMap Leave a comment