Configure Coronavirus Vaccine Distribution Dashboard

Learn how to configure the Coronavirus Vaccine Distribution Dashboard solution to meet specific needs in your organization.

Load vaccine distribution reporting areas

The Coronavirus Vaccine Distribution Dashboard solution helps public health agencies visualize and share vaccine distribution metrics for a given set of reporting areas. The reporting areas can be a county, ZIP Code, state, municipality, or any other geographic area you are using to tabulate metrics. Once you identify the specific reporting area or areas you want to use, you can use the Vaccine Distribution Reporter to tabulate coronavirus disease 2019 (COVID-19) distribution metrics for the specific reporting area.

The Reporting Areas layer includes several important fields. The Name field stores the names of the reporting area and is used in the Reporting Area Category Selector in the Vaccine Distribution Reporter app. Use the Aggregate Area field to report distribution metrics by differing jurisdictions. For example, a county may want to share distribution metrics tabulated by the entire county as well as broken down by ZIP Code or municipality. In that case, the county has a value of Yes for the Aggregate Area field. The Points of Distribution (POD) field is used to store the number of locations where the vaccine can be accessed per reporting area. This metric is shown on the Vaccine Distribution Dashboard.

Reporting Areas also contains several population fields such as Total population and Healthcare workers population. These fields are used in the Vaccine Distribution Reporter app to calculate vaccine coverage rates. Populating each population field ensures vaccine coverage rates are calculated accurately in the Vaccine Distribution Reporter app and visualized properly in the Vaccine Distribution Dashboard.

To learn about enriching your data with information, for example, demographic data, see About Data Enrichment.

Load data from a shapefile or file geodatabase

To load reporting areas from a shapefile or file geodatabase, complete the following steps:

  1. Create a .zip file of a shapefile or file geodatabase of your reporting areas.
  2. Sign in to your ArcGIS organization and browse to the VaccineDistribution feature layer.
  3. Open the item page and click Update Data > Append Data to layer.
  4. Click Choose File, browse to your .zip file, and click OK.
  5. Click the Contents drop-down arrow and choose the appropriate file type.
  6. Click Upload and Continue.
  7. Click the Choose the layer that you wish to append data into drop-down arrow and choose Reporting Areas.
  8. Uncheck Update existing features.
  9. Click Show field matching to map the fields.
  10. Click Apply Updates.
    Tip:

    To make additional updates to a hosted feature layer, see Append data to layers.

Load vaccine distribution metrics information

Vaccine Distribution Dashboard can be used by public health agencies and other emergency response agencies to visualize and monitor COVID-19 vaccine distribution metrics. The solution includes a Vaccine Distribution Reporter app that you can use to enter updated vaccine distribution metrics at a regular interval. In some cases, you may find it easier to manage this information in a spreadsheet and load it into the solution as you receive new information.

To load your vaccine distribution information from a spreadsheet, complete the following steps:

  1. Sign in to your ArcGIS organization and browse to the VaccineDistributionSource item.
  2. Open the item page and click Download.
  3. Edit the .csv file and provide your vaccine distribution metrics information.
  4. In your ArcGIS organization, browse to the VaccineDistribution feature layer.
  5. Open the item page and click Update Data > Append Data to layer .
  6. Click Choose File, browse to your .csv file, and click OK.
  7. Click Upload and Continue.
  8. Click the Choose the layer that you wish to append data into drop-down arrow and choose Metrics.
  9. Uncheck Update existing features.
  10. Click Apply Updates.
    Tip:

    To make additional updates to a hosted feature layer, see Append data to layers.

Extend the Vaccine Distribution Reporter app

The Vaccine Distribution Dashboard solution includes the Vaccine Distribution Reporter app that you can use to tabulate vaccine distribution information.

Review the preconfigured questions and adjust as necessary to remain in compliance with your organizational policies. In addition, ensure that you secure the app and underlying layers and only share the content with appropriate members of your organization.

Update feature layer views

The Coronavirus Vaccine Distribution Dashboard solution includes a series of views created from the VaccineDistribution feature layer provided with the solution. Organizations may want to modify the Vaccine Distribution Reporter app by first adding new fields to the feature layer and then configuring the Vaccine Distribution Form to use the newly created fields. When doing so, you must expose the new fields in the appropriate views. Additionally, the VaccineDistribution_current view is created by joining two sources together, and you must re-create it with the same name and URL after a new field is added.

Organizations may want to modify the Vaccine Distribution Form by adding new survey questions. When adding new questions, begin with the Update feature layer views steps below. For changes such as removing questions or formatting the survey, proceed to the Modify response surveys section.

To add one or more fields to a layer and expose the field to feature layer views, complete the following steps:

  1. Sign in to your ArcGIS organization, if necessary.
  2. Add a new field to the Reporting Areas or Metrics layer in the VaccineDistribution hosted feature layer.
  3. Browse to the VaccineDistribution_public or VaccineDistribution_reporter views in your contents.
  4. Open the item page and click the Visualization tab.
  5. Click More Options More options and click Set View Definition > Define Fields.
  6. Check the check box next to the new field or fields.
  7. Click Apply.

    The new field is added to the view’s definition.

To update a join view, complete the following steps:

  1. Browse to the VaccineDistribution_current join view.
  2. Open the item page and scroll to the URL section. Click the Copy button.
  3. Paste the copied URL into Microsoft Notepad or another text editor for reference.
    Note:

    The feature layer name will be used below when re-creating the join. You can find the name after services in the URL structure. It may also contain a unique GUID—for example, VaccineDistribution_current_a45f71a48587425c9b90ee5527cd26d1.

  4. Browse to the existing VaccineDistribution_current join view.
  5. Open the item page and click the Settings tab.
  6. Click the Delete Item button and click Delete.
  7. Browse to the VaccineDistribution feature layer.
  8. Open the item page and click Open in Map Viewer.
  9. Click the Analysis button and click Summarize Data > Join Features.
  10. When populating the Join Features tool, do the following:
    • Click the Choose target layer drop-down arrow and choose VaccineDistribution.
    • Click the Choose layer to join to the target layer drop-down arrow and choose VaccineDistribution-Metrics.
    • Click Choose the fields to match as the type of join.
    • Click the Targe field drop down arrow and choose name, and click the Join field drop-down arrow and choose name.
    • Click the Choose join operation drop-down arrow and choose Join one on one.
    • Under the Define which record is kept drop-down arrow, click Order by, click the Field drop-down arrow and choose Date reported, and click the Sort by drop-down arrow and choose Newest.
      Note:

      Ensure the new join view uses the names defined in the table above. If you use the same name, the layers in the map and the existing dashboard widgets do not have to be reconfigured. If your join view contained a unique GUID, you must name the new join view with the unique GUID.

    • In the Result layer text box, enter VaccineDistribution_current.
    • Uncheck Use current map extent, if checked.
    • Check Create results as hosted feature layer view.
  11. Update the Vaccine Distribution Desktop and Mobile Dashboards account for the new fields you added to the layers.

Modify response surveys

To modify the Vaccine Distribution Form survey, complete the following steps:

  1. Install ArcGIS Survey123 Connect.
  2. Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
  3. Click Vaccine Distribution Form to download the survey.
  4. Click Vaccine Distribution Form again to open the survey.
  5. In the Download window, click Download and click OK.
  6. On the side toolbar, click Open XLSForm Spreadsheet.
  7. Revise the survey to reflect your needs.
  8. Save and close the Microsoft Excel spreadsheet and preview your changes in ArcGIS Survey123 Connect.
  9. In ArcGIS Survey123 Connect, click Publish on the side tool to publish your changes.

Configure vaccination goals

The Vaccine Distribution Dashboard vaccination coverage charts contain preconfigured goals to visualize progress toward vaccination goals. Organizations may want to modify the goals to better reflect their community’s vaccination goals.

To modify the vaccination goal, complete the following steps:

  1. Sign in to your ArcGIS organization and browse to the Vaccine Distribution Desktop Dashboard or Vaccine Distribution Mobile Dashboard item.

    The following steps can be used to configure vaccination goals in both the desktop and mobile dashboards.

  2. Open the item page and click Edit Dashboard.
  3. Hover over the upper left corner of the Vaccine Coverage by Total Population serial chart element and click Configure.
  4. Click the Guides tab.

    The chart contains a preconfigured goal of 67%.

  5. Using a decimal value, change the Value to your community’s vaccination goal. For example, a goal of 70% would be .7.
  6. Change the Label to reflect the updated goal and click Done.
  7. Repeat steps 3 through 6 to modify the goal for the Full Series Coverage Priority Population, Full Series Coverage Age, Full Series Coverage Race & Ethnicity, and Full Series Coverage Gender serial chart elements.
  8. Click the Save button to save the dashboard.

Add vaccination coverage categories

The Vaccine Distribution Dashboard solution helps public health agencies and interested stakeholders visualize full series vaccination coverage by priority population, age, race & ethnicity, and gender. Agencies may want to modify or extend the values within those categories. For example, data may be reported using different age ranges than those preconfigured. The VaccineDistribution hosted feature layer contains several custom fields that provide configuration flexibility.

The Reporting Areas layer contains two Custom priority population fields, Custom gender population, Custom age range population, and Custom race population fields. The Metrics layer contains two associated Custom priority population fields, Custom gender population, Custom age range population, and Custom race population fields. Additionally, the Metrics layer contains two Custom priority vaccinated coverage fields, Custom gender vaccination coverage, Custom age range vaccination coverage, and Custom race vaccination coverage fields that can be used to store coverage rates for additional categories.

To utilize a custom field, complete the following steps:

  1. Sign in to your ArcGIS organization and browse to the VaccineDistribution hosted feature layer.
  2. Open the item details page and click the Data tab. If necessary, choose Reporting Areas from the Layer drop-down arrow.
  3. Click the Fields button.
  4. Locate and click the Custom priority population field.

    In the following steps, the priority1pop and associated fields are used as an example. The same process can be followed to use any of the included custom fields.

  5. Click Edit to replace Custom priority population’s alias with an alias of your choosing. For example, First Responder population.
  6. Click Save.
  7. Click the Layer drop-down arrow and choose Metrics.

    Locate the associated fields, in this case, priority1 and priority1coverage.

  8. Click each field and modify the alias. For example, priority1 would be First Responders vaccinated and priority1coverage would be First Responders (this alias will be used below in the Vaccine Distribution Dashboard serial chart).

    In this example, be sure to populate the priority1pop field in the Reporting Areas layer. These fields are used in the Vaccine Distribution Reporter app to calculate vaccine coverage rates. Populating each population field ensures vaccine coverage rates are calculated accurately in the Vaccine Distribution Reporter app and visualized properly in the Vaccine Distribution Dashboard.

  9. Repeat steps 5 and 6 for each set of custom fields you want to use in the Vaccine Distribution Dashboard.

To modify the Vaccine Distribution Reporter app to use the custom fields configured above, complete the following steps:

  1. Install ArcGIS Survey123 Connect, if necessary.
  2. Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
  3. Click Vaccine Distribution Form to open the survey.
  4. On the side toolbar, click Open XLSForm Spreadsheet.
  5. In the name column, locate the priority1 field. In the type column, click the drop-down arrow to change the type from hidden to integer.
  6. Update the label to use the field alias defined in the section above.
  7. Repeat step 5 for each custom field you want to use in the Vaccine Distribution Dashboard.
  8. Save and close the Microsoft Excel spreadsheet and preview your changes in ArcGIS Survey123 Connect.
  9. In ArcGIS Survey123 Connect, click Publish on the side toolbar to publish your changes.

To modify the Vaccine Distribution Dashboard to use the custom fields configured above, complete the following steps:

  1. Sign in to your ArcGIS organization and browse to the Vaccine Distribution Desktop Dashboard or Vaccine Distribution Mobile item.

    The following steps can be used to configure both the Desktop and Mobile dashboards.

  2. Open the item page and click Edit Dashboard.
  3. Hover over the upper left corner of the Full Series Coverage by Priority Population serial chart element and click the Configure button.
  4. If necessary, click the Data tab.
  5. Click the +Series button, and click the Series 6 Field drop-down arrow and choose the First Responders decimal field configured above.
  6. Click the Series tab. Modify the newly created series to match the existing series and according to your needs.
  7. Click Done.
  8. Repeat steps 3 through 7 for additional custom fields configured above to use them in the Full Series Coverage by Priority Population, Full Series Coverage by Age, Full Series Coverage by Race & Ethnicity, and Full Series Coverage by Gender serial charts.
  9. Click the Save button to save the dashboard.