Appalachia Data Portal Quick Sta rt Guide 1 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Background HealthLandscape (an Innovation of the American Academy of Family Physicians [AAFP]) and the Robert Graham Center for Policy Studies in Family Medicine and Primary Care are pleased to present the Appalachia Data Portal. The Appalachia Data Portal was created as an online tool for exploring demographic, education, income, and health disparities for the 420 counties in the Appalachian region. The data included in the Appalachia Data Portal come from a variety of sources, including the American Community Survey, the Appalachian Regional Commission, the Robert Wood Johnson County Health Rankings, and the Centers for Medicare & Medicaid. The tool allows users to visualize economic, demographic, and other types of data for the Appalachian region using maps, graphs, and trend charts. Users also have the ability to examine the relationship between two indicators (for example, Diabetes and Poverty) with side-by-side maps and a comparison tool that uses percentiles to visualize the relationship between variables. The Appalachia Data Portal provides multiple methods for exploring population indicator disparities throughout the Appalachian region, and is a helpful tool for identifying health disparities and bright spots within the region. To access the Appalachia Data Portal, please visit http://www.healthlandscape.org/AppalachiaDataPortal/map.cfm More information about the data sources are available at: Appalachian Regional Commission http://www.arc.gov/research/RegionalDataandResearch.asp RWJ County Health Rankings http://www.countyhealthrankings.org/rankings/data 2 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Table of Contents Welcome Screen ........................................................................................................................................... 4 Creating a Map ............................................................................................................................................. 5 Thematic Map View ..................................................................................................................................... 6 Threshold Map View .................................................................................................................................... 7 Adding a Secondary Indicator ...................................................................................................................... 8 Side-by-Side Maps ..................................................................................................................................... 8 Comparison Map ....................................................................................................................................... 9 Appalachian Regional Commission – Economic Status ............................................................................. 10 Data Table ................................................................................................................................................... 11 Bar Chart ..................................................................................................................................................... 12 Trend Graph ................................................................................................................................................ 13 Printing ....................................................................................................................................................... 14 Reset Button ............................................................................................................................................... 15 3 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Welcome Screen When you enter the Appalachia Data Portal, a welcome screen displays general information about the tool’s data sources. It also presents four topic areas in boxes. Move your cursor over a topic to get more information about the indicators it includes. Click on one of the topic boxes to access indicators and create a map. 4 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Creating a Map Topic Zoom Bar Indicator Group/Category Create a map by doing the following: (1) Select a topic by clicking on a topic box (2) Select an indicator by clicking the radio button next to the desired indicator (3) Select a group/category from the drop-down menu Once you have selected a group/category, a county-level map of the Appalachian region with different shades of blue will be displayed. Zoom in on the map by doing one of the following: • Double-click on the area of interest • Hold down the Shift key while you click and drag with your mouse to draw a box on the map • Click the (+) on the zoom bar in the upper left-hand corner of the screen Zoom out by clicking the (-) on the zoom bar in the upper left-hand corner of the screen. 5 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Thematic Map View Tool-tip Legend Legend Controls The initial map you create will display a thematic map view. In addition to your map, you will see a legend and legend controls at the bottom of the screen. The legend indicates the range of values represented by each shade of color on the map. The legend controls allow you to change the map’s color scheme and color palette, the number of value categories into which the data is grouped, and the distribution (i.e., quantile or equal interval). When you mouse over a county, a pop-up window called a tool-tip will appear. It shows data for the selected indicator in all available groups/categories for the highlighted county. 6 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Threshold Map View Threshold Change to a threshold map view by clicking the radio button next to “Threshold” in the legend controls at the bottom of the screen. On a threshold map, you can click and drag the slider bar at the bottom of the screen to the left or right and set a threshold value so that you will only see counties with values between your two threshold points. This allows you to pinpoint counties that have high values (or low values) for specific indicators. 7 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Adding a Secondary Indicator (Side-by-Side Maps) Add Secondary Indicator View two indicators at the same time on side-by-side maps by doing the following: (1) Click on “Add Secondary Indicator” in the bottom right-hand corner of the screen (You may need to scroll down to see this text.) (2) Select a topic by clicking on a topic box (3) Select a secondary indicator by clicking the radio button next to the desired indicator (4) Select a group/category from the drop-down menu Once you have selected a group/category, you will see two maps side-by-side. The map on the left-hand side of the screen displays the primary indicator, and the map on the right-hand side of the screen displays the secondary indicator. When you mouse over a county on one map, it is highlighted with a dark red outline on both maps (if data for the selected indicator are available). 8 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm Adding a Secondary Indicator (Comparison Map) Comparison Tool Merge side-by-side maps together by clicking the radio button next to “Comparison” in the legend controls at the bottom of the screen. This will merge the primary and secondary indicators together by percentile. Click and drag the slider bar at the bottom of the screen to select the break points for your percentiles. A comparison map displays counties in the following colors, which correspond to the break points: • Blue = High/High • Red = High/Low • Light blue/green = Low/High • Yellow = Low/Low For example, if your break points are 20/80, then blue counties have both primary and secondary indicators at the 80th percentile or above; red counties have the primary indicator at the 80th percentile or above and the secondary indicator at the 20th percentile or below. Light blue/green counties have the primary indicator below the 20th percentile and the secondary indicator above the 80th percentile, while yellow counties have both indicators at the 20th percentile or below. 9 | P age www.healthlandscape.org/AppalachiaDataPortal/map.cfm