Tabulate coronavirus cases

The Community Impact Dashboard helps Public Health agencies share case metrics for a specified reporting area. The Case Reporter survey can be used to tabulate the case information the specific reporting area. The reporting areas can be a county, state, or any other jurisdiction.

In this workflow, you will learn how to load your reporting areas, modify the Case Reporter survey, and begin tabulating coronavirus cases.

  1. In a browser, go to the Cases feature layer item details in your ArcGIS Online Organization.
  2. Create a .zip file of a shapefile or file geodatabase of your reporting areas. Make sure there is a field that defines the name of the boundary.
  3. Click the Update Data button and choose Append Data to Layer.
  4. Click Choose File.
  5. Browse to your .zip file.
  6. Click Upload and Continue.

Next, add your reporting areas to the Case Reporter survey.

  1. Verify you are signed in to your ArcGIS organization.
  2. At the top of the site, click Content.
  3. On the My Content tab, type Case Reporter in the search box.
  4. Click the Case Reporter form.
  5. On the item page, click the Open in Survey drop-down arrow and choose Edit in Survey123 Connect.
  6. Click Open Survey123 Connect for ArcGIS.
  7. If you receive an Error with URL request message, click OK, and then click the Settings button . Click Add Portal and Type your ArcGIS Organizations’s URL in the URL of your PORTAL for ArcGIS box, and then click Add Portal. For example, Click OK.
  8. Click Sign in.
  9. Sign in using your ArcGIS organization credentials.
  10. Click the Case Reporter.
  11. Click Yes to download the Case Reporter.
  12. Click OK.
  13. Click the Case Reporter again to open it.
  14. One the left pane, click Open XLS Form Spreadsheet, the editable spreadsheet opens.
  15. If necessary, click the Choices tab. Update the values Choice 1, Choice 2 and Choice 3 to match the boundaries you loaded earlier. For your deployment, you will likely want to define boundaries such as counties, or city boundaries. You can also just report for one reporting area such as one county.
  16. Save and close the spreadsheet.
  17. In Survey123 Connect for ArcGIS, click Update survey from XLSForm spreadsheet in the left pane to preview your changes.
  18. In the left pane, click Publish.
  19. Close Survey123 Connect for ArcGIS.

Coronavirus cases can be quickly tabulated with the Case Reporter survey. Current and historical results can then be seen in the Community Impact Dashboard. New case information can be added as frequently as you have it.

  1. In a browser, go to the Case Reporter survey.
  2. Click the Reporting Area dropdown and choose the appropriate reporting area.
  3. Enter your case information and click Submit.
  4. Repeat this process for each additional reporting reporting area.
  5. Review the case information in the Community Impact Dashboard.