Tuesday, June 27, 2017

HealthLandscape Tip: Isolating a Geography

One of our most frequent questions from users is, “Can I make a map that shows only my state or only my county?”  While there is not an official way to isolate an area like this, we did come up with one way you might do it.  Keep in mind that we do not recommend isolating geography in this manner because state and county boundaries, while they have implications for health policy and health spending, are just imaginary lines.  Things occur just on the other side of those lines that may affect the health of the area you are highlighting.  This includes providers from whom people in your area of interest may be seeking health care services, environmental effects, etc.  That said today, I'd like to share a technique for isolating a geography in our Population Health Mapper using the QuickThemes tool.  The same steps can be taken in any HealthLandscape tool.

The QuickThemes tool in the HealthLandscape platform allows users to color in states, counties, ZCTAs, etc. based on data in a table.  Each area that is included in your table will be colored in based on the value in the column you choose to map.  For example, if I had a data table like this that has a list of areas at least one column of data that has a number, percent or qualitative data in it:

Qualitative Information
District of Columbia
West Virginia

With this table, I can add color to the map for these six states based on the information in either the number, percent or qualitative information columns.  The process I describe below takes advantage of this by instructing you to add a column of data with identical values for all the areas you want to mask.  Let’s get started.

The Population Health Mapper first prompts you to select a state; for the purposes of this demonstration I will choose Maryland. When you do this, the Mapper will zoom you to the area you have selected and automatically center the map for you, as it did for me.

Next, I need a list of states with their respective FIPS codes. FIPS stand for Federal Information Processing Series. The US Census Bureau maintains several pages related to FIPS codes, including an explanation of the codes and tables with state FIPS codes and county FIPS codes.


Using the state table provided by the Census Bureau, I will cut and paste the data into an Excel spreadsheet and delete the row for Maryland. By deleting Maryland from the list, it will create a “hole” in my map layer that I am adding.  In order to have the other states colored in, I have to add a column and insert an identical value to each state. For the purposes of this blog, I will name my column "Value for Monochrome" and will insert the numeral 5 for each state, but keep in mind that these values will appear on your map, so you may want to name them things and select values that blend in with the theme of your map better.


Back in the Population Health Mapper, I will start the QuickThemes tool by going to the top right "Tools" button (gray), clicking it and selecting "QuickThemes".  The QuickThemes tool will open and be added to the Tools Accordion on the right. Read the instructions and then go back to the spreadsheet to highlight and copy the rows and columns that have the information you want to include on the map; this will include your header row.  When ready, in the QuickThemes tool click the "Click here to begin" button to get to the screen where you will paste your data.

Click anywhere in the white area and then hit Ctrl+v or Command+v to paste your data.


You will have to give the QuickThemes tool some information.  First , tell it the type of geographic code you are using; I will select "State by FIPS".  You will also have to tell it which column in your dataset has the geographic identifiers in the ID selection box.  In my case, I will select FIPS Code. Last, under Group/Category selection box, select the column that has the single value in it for all states, in my case, "Value for Monochrome". Finally, hit the blue "Load" button.  Hint: If you forget to do the Group/ Category selection before you hit load, you can always do it later.

Using the Zoom Bar at the top left I will zoom to a good level to view states and grab the map with my mouse (left click and hold) and drag the map so that Maryland will be centered. The resulting map has my state of focus, Maryland, uncolored (and ready for the application of points, labels, and other data) and the surrounding states are visible but monochromatic in the background. Note this method can be applied within a state at the county level using the county FIPS codes.

I hope this is helpful in your work. You can contact me for assistance using the chat feature on this tool or the "Contact Us" feature if you are working in the UDS Mapper.

Keith Gardner
User Engagement Specialist


No comments:

Post a Comment