LDafner-esristaff

Configuring COVID-19 Dashboard for Municipalities in Montgomery County, PA

Blog Post created by LDafner-esristaff Employee on Apr 16, 2020

Data and geography are an important part of addressing and informing the public about COVID-19. That is certainly evident on the COVID-19 GIS Hub where we have access to a variety of datasets from Global COVID cases to bed availability across the US.

Local Governments are also participating in this sharing effort. Including, Montgomery County, Pennsylvania who has a regularly updated Hub site dedicated to informing the public about COVID-19 in their community! Many of the maps and apps you see on their site are fed by ArcGIS Online layers that you can use for your own purposes.

Like their COVID-19 Cases layer that is feeding this map display all positives cases across the Municipalities and Townships in Montgomery County…

 

 

In this blog, we are going to show you how to take Montgomery County cases layer and create your own simple dashboard. We’ll be using Upper Gwynedd Township as an example. Earlier this week, they configured the dashboard below. Completely new to GIS, they were able to get the dashboard stood up in under an hour. Now it is displayed on their website so citizens can get up to date COVID-19 case information!

 

 

Let’s get started, follow the instructions below to make your own COVID-19 Cases dashboard using data from Montgomery County, Pennsylvania!

 

What You’ll Need

  • AGOL organization
  • AGOL named user with publishing privileges
  • Montgomery County PA cases feature layer

 

Step 1: Login to your ArcGIS Online Organization

 

NOTE: make sure you have privileges to be able to publish content. If you don’t, contact your ArcGIS Online administrator

 


Step 2: Create a map

  • Now that you’re signed in. Click the ‘map’ button in the header

 

Next, the map viewer will load – this is where you will add data and configure a map to get it ready to be displayed in a Dashboard

  • Choose a basemap by selecting the ‘basemap’ button and click on the ‘Light Gray Canvas’ basemap from the gallery

NOTE: it’s helpful to use a minimalist style basemap like the Light or Dary Gray Canvas basemaps when creating simple map/app

 

Next, let’s find and add the Montgomery County Cases dataset to the map

  • Click on the ‘add’ data button
  • In the drop down select ‘Search for Layers’

  • Next, click the drop down and select ‘ArcGIS Online’

  • In the search bar type ‘Montgomery County ncov cases by Municipality’ and add it to the map

 

  • The dataset get’s added to the map with pre-configured symbology and pop-ups. Click on the map to view a pop-up…

 

Our final step in this map configuration phase, is to save and share the map

  • Click the ‘save’ button at the top of the map

  • The ‘Save map’ dialog opens… enter a title, tags and a summary and click ‘save map’ button

 

  • Next, click the ‘Share’ button at the top of the map

  • In the share dialog select share with ‘Everyone’ and then click ‘Create a Web App’

 

  • The ‘Create a New Web App’ dialog opens. Click the ArcGIS Dashboards tab and then select ‘Done’

 

You will be launched in to the edit mode of a Dashboard.

We just completed the configuration of your web map. Next, we will configure your dashboard!

 

Step 4: Configure dashboard

We are going to configure the dashboard with 3 Indicator widgets to show the number of COVID-19 total cases, active cases, and deaths in Upper Gwynedd Township.

  • Click the button and select ‘Indicator’ from the drop down

 

  • Select the cases layer

 

  • Now we will configure the Indicator to display ‘Total Confirmed Cases’
    • Data tab: filter the dataset to Upper Gwynedd Township and display total counts… See screenshot below…

            

 

  • Indicator tab: 

            

  • At the bottom click 

 

Now the ‘Total Cases’ Indicator has been added to your dashboard. We have 2 more indicators to add.

  • Follow the same instructions as above. But, this time to display ‘Total Active Cases’…
    • Data Tab:
      • Select the Indicator widget from the drop down
      • Click the Montgomery County Cases layer
      • Create a Filter for ‘Name’ equals ‘Upper Gwynedd’
      • ‘Value Type’ select ‘Feature’
      • ‘Value Field’ select ‘Active_Total’
    • Indicator Tab:
      • ‘Top Text’ enter ‘Total Active Cases’
    • Click ‘Done’

 

  • For the last Indicator ‘Total Deaths’ follow the same instructions do the following for…
    • Data Tab:
      • ‘Value Field’ select ‘Total_Deaths’
    • Indicator Tab:
      • Top Text’ enter ‘Total Deaths’
    • Click ‘Done’

Your Dashboard may look like this…

 

We can clean this up by adjusting the format of the widgets…

  • Hover over the top left of the ‘Total Cases’ Indicator
  • Click and hold the ‘Drag Item’ button and drag it above the ‘Total Deaths’ Indicator and dock ‘Total Cases’. See below…

 

  • Do the same with the ‘Total Active Cases’ Indicator but dock it under ‘Total Cases’

 

  • Your Dashboard may look like this. You can grab and drag the lines between widgets to adjust their sizing to make the Indicators more even and the map widget larger…

 

  • Play around with the widget sizing until you get a format you like...

 

The next thing to do is to enable the Map Widget capabilities

  • Hover over the top left of the map widget and click the ‘Configure’ Button

 

  • Update the settings (see below) and click 'Done'

 

  • The map will be updated in the dashboard...

 

The last thing to do is add a header with a title

  • Click on the menu and select 'Header'

  • Enter a title and Click 'Done'

 

Your Dashboard is now complete! Don't forget to hit save!

 

All that's left to do is to share the dashboard!

 

If you click on the 3 dots in the top right of the dashboard, there you'll find the URL to your new dashboard. You can share this link out and/or paste it into your web browser to see your finish product!

 

If you would like to get more COVID-19 related resources for the Mid-Atlantic region please visit the Esri Philadelphia COVID-19 Resources page.

Outcomes