Use Coronavirus Business Reopening

The Coronavirus Business Reopening solution delivers a set of capabilities that help you continuously evaluate business locations to determine readiness, visualize the latest authoritative COVID-19 case data and health restrictions for surrounding communities, and prioritize where reopening can begin.

In this topic, you’ll learn how to use the solution by assuming the role of a user and performing the workflows below.

Update health restrictions and case information

To help businesses understand and prioritize reopenings, decision makers rely on the latest state health guidelines, as well as COVID-19 case information tabulated for counties in the United States. The layers supplied in the Coronavirus Business Reopening solution contain health restriction and case information from authoritative sources, at the state and county level. The ArcGIS Notebook included with the solution will help organizations pull the latest health restriction and case information from the following layers on a daily basis:

Update health restriction and case information

You will assume the role of a data analyst in a business. You are asked to use the Coronavirus Daily Analysis notebook to update health restriction and COVID-19 case information.

  1. In your browser, open the Coronavirus Daily Analysis notebook.
  2. Along the menu bar, click Kernel and click Restart and Run All.
    Note:

    This step must be done daily. If this step is not run, your dashboard will be blank or out of date. The notebook takes up to four minutes to finish. There will be no user message stating that the notebook is done. The notebook has finished running when all the cell indicators in the notebook have switched from * to numbers.

  3. The notebook will clear out outputs from the previous run and refresh the US Counties Coronavirus Trends and State Health Restrictions layers with the latest updated content.
    Note:

    Running this notebook may consume credits if your facilities layer has locations outside of the US, every time the notebook is run. It is recommended that you only have facilities that are located in the US in the facilities layer.

Understand health restrictions and case information

As the COVID-19 pandemic unfolds, some businesses are being required to rapidly close facilities or readjust reopening of facilities based on the latest case and health restriction information. Having visibility into the status of all facilities alongside the latest information coming out at the state and county level is a critical component in making business reopening decisions. Daily or periodic status reports from facilities help organizations make informed decisions and necessary operational changes. The Coronavirus Business Reopening Dashboard aggregates and summarizes information from authoritative sources on the latest guidelines and trends.

You will start by assuming the role of an operations manager. You are asked to explore the latest health restriction information in the Coronavirus Business Reopening Dashboard and view the overall impact that COVID-19 health restrictions and cases are having on business locations.

  1. In your browser, open the Coronavirus Business Reopening Dashboard.
  2. The Coronavirus Business Reopening Dashboard opens with an overview of the overall status of your facilities, focused on health restrictions by state.
    Note:

    • The global filters across the top allow conditions to be set, which limits data visualization in the dashboard.
    • The facility list on the left side is interactive; when an item is selected, the map will zoom to the selected facility.
    • Along the bottom are a set of tabs to focus your view based on health restrictions and case information.

  3. In the map, select the state of Colorado, where the stay-at-home restrictions have been lifted.
    Note:

    A pop-up window shows the latest restrictions and guidelines.

  4. Scrolling through the pop-up will reveal a link to an infographic with further state-level socioeconomic and demographic details as well as a link to the latest state-projected peak use of hospital resources provided by the Institute for Health Metrics and Evaluation (IHME).
  5. Along the bottom of the pop-up are three buttons. Clicking the third button will select the state and globally filter all metrics to the state of Colorado. Notice the list of facilities and metrics along the left side are filtered reflecting the selection.
    Note:

    The same filtering for all metrics can be done by selecting Colorado from the State drop-down list along the top.

  6. Along the bottom, click the Case Information tab. This reveals metrics of the latest case information by counties. All metrics are filtered down to the state of Colorado since it was selected in the previous tab.

    The metrics displayed on the right side of the panel provide context as to the number of facilities that are within each trend type. Along the bottom are a set of panels that display the overall case and mortality rate by counties for the selected state.

    Note:

    If no state is selected, an overall breakdown of the United States is shown.

  7. A key indicator that a county may be recovering is the number of consecutive days with zero new cases. Counties with zero new cases over the past 14 or more days may no longer have active cases and can indicate an important milestone in reopening facilities. The global filter along the top, Number of Days with Zero Cases, enables a number to be entered representing the number of consecutive zero case days. Entering a value filters the counties and the facilities within those counties that meet or exceed the value.
  8. The graph along the bottom, Count of Counties with Zero New Cases, provides context into the number of counties that have maintained zero cases over a period of time. Hovering over each of the dots in the graph displays the total number of counties that have consistently maintained zero cases for the given number of days. Furthermore, the chart provides additional fine-tuning capabilities by interactively selecting a range that refines your view to focus on counties that are within a given threshold range.
  9. In the map, select a county.
    Note:

    A pop-up shows the latest case information.

  10. Scrolling through the pop-up will reveal a link to an infographic with further county-level socioeconomic and demographic details.
  11. Along the bottom of the pop-up are three buttons. Click the third button to select the county and filter all metrics to the selected county.
    Note:

    Notice that the list of facilities and metrics along the left side are filtered reflecting the selection, as well as the panels along the bottom.

Locate counties with zero new cases

To help businesses understand and prioritize reopenings, decision makers rely on the latest state health guidelines, as well as COVID-19 case information tabulated for counties in the United States. This workflow will show you how to identify the counties, in a given state, that have had zero case days for a given period of time.

Filter counties with zero new cases

You will start by assuming the role of an operations manager in a business. You are asked to use the Coronavirus Business Reopening Dashboard to find business locations in counties that have had zero new COVID-19 cases over a period of time.

  1. In the dashboard, click the Case Information tab to access county-level information.
  2. Along the top of the dashboard, select a state from the State drop-down menu.
    Note:

    The information that is now presented at the bottom of the dashboard reflects the counties for the state that is selected.

  3. In the upper right of the dashboard, filter the case information by entering a number of zero case days desired.
    Note:

    The dashboard will update to show counties with your specified number of zero case days.

  4. You can further filter this selection by selecting the days desired to view in the map.

Locate zero new cases using the case graph

Now, you will use the case graph to find business locations in counties that have had zero new cases over a period of time.

  1. In the dashboard, click the Case Information tab to access county-level information.
  2. Along the top of the dashboard, select a state from the State drop-down menu.
    Note:

    The information that is now presented at the bottom of the dashboard reflects the counties for the state that is selected.

  3. Select the number of zero case days desired; changes will be reflected in the map.
    Note:

    Notice that the list of facilities and metrics along the left side are filtered reflecting the selection, as well as the panels along the bottom.

Track facility status

As the COVID-19 pandemic develops, some organizations are being required to rapidly close facilities. Having visibility into the status of all facilities is a critical component in making business reopening decisions. Daily or periodic status reports from facilities help organizations make informed decisions and necessary operational changes.

The Coronavirus Business Reopening solution includes a Facility Status Report for facility managers to report the status of the facilities they are responsible for. Organizations deploying Coronavirus Business Reopening should review the preconfigured questions and adjust as necessary to remain in compliance with organizational policies and applicable laws.

Complete a facility status report

You will start by assuming the role of a local facility manager in a government agency, business, or utility. You were asked to use the Facility Status Reporter and Facility Status Report survey to share the status of your facility each day, or on a weekly basis.

  1. In a browser, go to the Facility Status Reporter app.
  2. Enter the name of a facility in the search box.
  3. Select the facility from the list and review the facility details.
  4. Click Submit Facility Report.
  5. In the Facility Status Report survey, fill in the following details:

    ParameterValue
    Status

    Select Closed.

    Enter the number of staff in the office, working remotely, and absent

    Type a phone number.

    Operating with essential staff only?

    Select Yes.

    Are staff required to stay overnight?

    Select No.

    Entrance staffed?

    Select Yes.

    Building secured?

    Select Yes.

    Access restricted?

    Select No, and type who is checking on the property and any additional details.

    Status of working hours

    Select Reduced, and type the new hours of operation.

    Are there any government restrictions?

    Select Yes, and type any details and references.

    • Enter any additional details you would like to share with your facility manager or operations manager.
  6. Click Submit.