Configure Coronavirus Response

In this topic, you will learn how to configure the Coronavirus Response solution to meet specific needs in your organization.

Load public places and meal sites

Coronavirus Response can be used by Public Health Agencies and other emergency response agencies to the impact on public gathering places and inventory meal sites. In some cases, you may have this information in ArcGIS or a spreadsheet already.

Review the layers provided with the solution and determine what, if any, source data you would like to load. Then, load your existing data into the layers provided with the ArcGIS Solution before sharing the maps or applications.

Once you have determined what source data must be loaded, complete one, or more, of the data loading workflows below.

Load data from a spreadsheet

If you do not have an inventory of public gathering places in ArcGIS, you may have them in a spreadsheet. If you don’t have a spreadsheet already, you can use the sample .csv file included with the solution (FacilitySource.csv) to inventory the public gathering places, hospitals, educational facilities and meal sites. Many times, alternate data sources can be used to start your inventory. For example, the Homeland Infrastructure Foundation – Level Data (HIFLD) infrastructure data for all 50 US states, Washington D.C., US territories of Puerto Rico, Guam, American Samoa, Northern Mariana Islands, Palau, and Virgin Islands.

Tip:

If you decide to use the HIFLD data, download the data for your community and review the currency of this information. You may want to augment your facility list by adding additional facilities (ex. temporary facilities) to your spreadsheet.

To load your public gathering places or meal sites from a spreadsheet, complete the steps below:

  1. Sign in to your ArcGIS organization and browse to the FacilitySources item.
  2. On the item page, click Download.
  3. Edit the CSV and provide your facilities information.
  4. In your ArcGIS organization, browse to the PublicPlaces, Hospitals, EducationalFacilities, or MealSites feature layer.
  5. On the item page, click Update Data > Append Data to Layer.
  6. Under Filename choose your .csv file.
  7. Click Upload and Continue.
  8. From Choose the layer that you wish to append data into, choose the layer to load into.
  9. Uncheck Update existing features.
  10. Click Show field matching to map the fields.
  11. Map the Latitude field to y column and the Longitude field to the x column.
  12. Click Apply Updates.

Load data from a shapefile or file geodatabase

If you already have your public gathering places or meal sites in ArcGIS, you can load them from a shapefile or file geodatabase by following the steps below:

  1. In your ArcGIS organization, browse to the PublicPlaces, Hospitals, EducationalFacilities, or MealSites feature layer.
  2. Create a .zip file of a shapefile or file geodatabase of your facilities.
  3. On the item page, click Update Data > Append Data to layer.
  4. Under Filename choose your .zip file.
  5. Click Upload and Continue.
  6. From Choose the layer that you wish to append data into, choose the layer to load into.
  7. Uncheck Update existing features.
  8. Click Show field matching to map the fields.
  9. Click Apply Updates.
Tip:

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

Load coronavirus reporting areas

The Coronavirus Case Dashboard and Community Impact Dashboard help Public Health agencies share case metrics for a specified reporting area. The reporting areas can be a county, zip code, state, municipality, or any other geographic area you are using to tabulate results. Once you identify the specific reporting area you would like to use, the Case Reporter survey can be used to tabulate coronavirus cases for the specific reporting area.

Load data from a shapefile or file geodatabase

Reporting areas can be loaded from a shapefile or file geodatabase by following the steps below:

  1. In your ArcGIS organization, browse to the CoronavirusCases feature layer.
  2. Create a .zip file of a shapefile or file geodatabase of your facilities.
  3. On the item page, click Update Data > Append Data to layer.
  4. Under Filename choose your .zip file.
  5. Click Upload and Continue.
  6. From Choose the layer that you wish to append data into, choose the Reporting Areas layer.
  7. Uncheck Update existing features.
  8. Click Show field matching to map the fields.
    Note:

    The Reporting Areas layer includes two important fields: Name and Aggregate Area. Name stores the names of the reporting area. The Aggregate Area field is used when you’d like to report case data by differing jurisdictions. For example, a county might want to share case data tabulated by the entire county as well as broken down by zip code or municipality. In that case, the county would have a value of ‘Yes’ for the Aggregate Area field.

  9. Click Apply Updates.
Tip:

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

Modify Case Reporter reporting area choice list

To modify a Case Reporter survey reporting area choice list, complete the following steps:

  1. Install ArcGIS Survey123 Connect.
  2. Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
  3. Click on Case Reporter to download the survey.
  4. Click on Case Reporter again to open the survey.
  5. On the left pane, click Open XLSForm Spreadsheet.
  6. In the Microsoft Excel spreadsheet, click on the choices tab. This tab comprises all the selectable options for survey questions.
  7. Update the reportin_area list to reflect the reporting areas you loaded into the CoronavirusCases feature layer.
  8. Save the Microsoft Excel spreadsheet and preview your changes in Survey123 Connect.
  9. In Survey123 Connect, click Publish in the left pane to publish your changes.

Load coronavirus case information

Coronavirus Response can be used by Public Health Agencies and other emergency response agencies to tabulate and monitor coronavirus cases. The solution includes a Case Reporter survey that can be used to enter updated case information for each day. 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 coronavirus case information from a spreadsheet, complete the steps below:

  1. Sign in to your ArcGIS organization and browse to the CoronavirusCaseSources item.
  2. On the item page, click Download.
  3. Edit the CSV and provide your coronavirus case information.
  4. In your ArcGIS organization, browse to the CoronavirusCases feature layer.
  5. On the item page, click Update Data > Append Data to layer.
  6. Under Filename choose your .csv file.
  7. Click Upload and Continue.
  8. From Choose the layer that you wish to append data into, choose the Cases table.
  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 response surveys

The Coronavirus Response solution includes a series of surveys (Case Reporter, Meal Site Report) that can be used to tabulate coronavirus case information and meal site counts.

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

Update feature layer views

The Coronavirus Response solution includes a series of views created from feature layers provided with the solution. Organizations may want to modify the Case Reporter survey by first adding new fields to the feature layers then configuring the surveys to utilize the newly created fields. When doing so, the new fields must be exposed in the appropriate views. Additionally, some views are created by joining two sources together and these views must be recreated with the same name and url after a new field is added.

Organizations may want to modify the Case Reporter survey by adding new survey questions. When adding new questions, begin with the Update feature layer views section 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 recreate the views, complete the following steps:

  1. Add a new field to a layer in the CoronavirusCases hosted feature layer.
  2. Browse to the CoronavirusCases_public or CoronavirusCases_reporter views in your contents.
  3. Click the Open in Map View > Add to new map.
  4. Click the More Options on the appropriate layer or table, then click Set View Definition. Click Define Fields.
  5. Scroll to the newly created field, check the box. 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 join view in your contents (for example, CoronavirusCases_current).
  2. Open the item page, 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 recreating the join. The name can be found after services in the URL structure and may also contain a unique guid. For example, CoronavirusCases_current_a45f71a48587425c9b90ee5527cd26d1.

  4. Delete the existing join view (for example, CoronavirusCases_current).
  5. Add the CoronavirusCases hosted feature layer to a new web map.
  6. Click Analysis, Summarize Data, Join Features.
  7. Configure the join using the below table.

    Name of JoinTarget layerLayer to join to the target layerFields to matchJoin OperationDefine which record is kept

    CoronavirusCases_current

    Reporting Areas

    Cases

    name = name

    Join one to one

    Order by Date Reported / Newest

    Note:

    Ensure each new join view uses the names defined in the table above. If you use the same names, the layers in the map and the existing dashboard widgets will not have to reconfigured. If your join view contained a unique guid, the new join view will need to be named with the unique guid.

  8. If necessary, uncheck Use current map extent. Check Create results as hosted feature layer view.
  9. Update the Coronavirus Case Dashboard or Community Impact Dashboard to account for the new fields you added to the layers.

Modify response surveys

To modify a Coronavirus Response survey, complete the following steps:

  1. Install ArcGIS Survey123 Connect.
  2. Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
  3. Click on Case Reporter to download the survey.
    Note:

    The Case Reporter survey is an example. The steps below are the same for the Meal Site Report survey.

  4. Click on Case Reporter again to open the survey.
  5. On the left pane, click Open XLSForm Spreadsheet.
  6. In the Microsoft Excel spreadsheet, click on the choices tab. This tab comprises all the selectable options for survey questions.
  7. Revise the survey to reflect your needs.
  8. Save the Microsoft Excel spreadsheet and preview your changes in Survey123 Connect.
  9. In Survey123 Connect, click Publish in the left pane to publish your changes.

Configure directions

Follow the steps below to connect to a routing service and configure the widget to enable directions in the app.

Configure widget

To configure an app to use routes and provide directions, complete the following steps:

  1. Sign in to your ArcGIS Online organization.
  2. Browse to the ArcGIS Web AppBuilder app item page and click Edit Application.
  3. Browse to the Near Me widget and click the Edit button.
  4. Click the Direction Settings tab, click Set, and choose a routing service.
  5. Click Next and choose one or more route layers, click OK, and click OK again.
  6. Save the app and share it with everyone.
  7. Open the app.

Esri premium content

The app draws routes and provides directions using the ArcGIS Online World Route Service. This service requires subscriber access because it consumes credits. Before generating routes, open the Attributes tab of the configuration of your ArcGIS Web AppBuilder app and configure Subscriber content access with the URL of the routing service used by your widget.

Learn more about credit usage when creating simple routes