Configure Civil Support

The Civil Support solution delivers a set of capabilities that help the National Guard identify an emergency incident, manage missions, allocate personnel and resources, and communicate status to internal stakeholders.

Load installations and resource data from a spreadsheet

After the Civil Support Management Center is deployed in your environment, you can import the included Example Installation and Resources Microsoft Excel file into the Resource Management feature layer by completing the following steps:

1. Sign in to your ArcGIS organization and browse to the Example Installation and Resources Microsoft Excel file.
2. From the item page, click Download.
3. After the Example Installation and Resources Microsoft Excel file has been downloaded, browse to the Resource Management Feature Layer.
4. From the item page, click Update Data > Append Data to Layer.
5. Click Choose File, browse to the Example Installation and Resources Microsoft Excel file containing the formatted installation and resources, and click Open.
6. Click Upload and Continue.
7. Click the Choose the layer to update drop-down arrow and choose Installations.
8. Uncheck Update existing features.
9. Click Show field matching to map the fields from the file to the fields in the layer.
10. Match the Latitude field to the y match field and the Longitude field to the x match field.
11. Click Apply Updates.

    Tip:

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

12. Repeat steps 1 through 9 to load resources into the Resource Management feature layer.

Note:

To ensure the solution works correctly, follow the data structure in the file headers included in the attached empty layer.

Modify surveys

The Civil Support solution includes the Personnel Tasker and Resource Tasker surveys. To prevent mistakes and ensure data quality, several fields in the surveys can use lookup lists generated from the unique values contained in a field from a separate layer. To complete the setup of this capability in the Personnel Tasker and Resource Tasker surveys, you must edit the surveys using ArcGIS Survey123 Connect and then republish them. In addition, you can modify the Personnel Readiness Report and Personnel Readiness Batch Report to fit the naming conventions of your unit.

Update Personnel Tasker

To improve data quality, you can update several fields in the Personnel Tasker survey with a dynamic list of values based on fields found in other layers. The Event and Mission fields in the Personnel Tasker survey are updated by a lookup list containing the events that have been created using the Create Event page or Event Entry survey in Operations Dashboard. Once a user selects the Event or Mission field, a choice list is populated to provide a list of created events and missions to select from.

To add dynamic field lookup lists to the Personnel Tasker survey, complete the following steps:

1. Install ArcGIS Survey123 Connect.
2. Start ArcGIS Survey123 Connect and sign into your ArcGIS organization.
3. Click Personnel Tasker.
4. Click Download and click OK.
5. Click Personnel Tasker again.
6. Click XLSForm.

   A Microsoft Excel spreadsheet opens.

7. Click the survey tab.
8. Delete the text in the type column of row 23 (event_id) and type select_one Event.

   Note:

   When saving, you may see the following warning message: Please select yes if you are using a select_one or select_multiple XLS. Click Yes.

9. Delete the text in the type column of row 24 (mission_id) and type select_one Mission.
10. Paste the expression autocomplete search("events?url={your clipboard URL}/0") into the appearance column of row 23.

    Note:

    Example: autocomplete search("events?url=https://services6.arcgis.com/1U29tEKcAxIIDXRf/arcgis/rest/services/service_ 5b2c738c88234542bc7a683cd919d918_1/FeatureServer/0")

11. Paste the expression autocomplete search("events?url={your clipboard URL}/1") into the appearance column of row 24.
12. Sign in to your ArcGIS organization.
13. Search for and click Operations Management hosted Feature Layer.
14. Scroll to the bottom of the Overview page for the Operations Management item, and in the URL section, click the Copy button.

    The layer service URL is copied to your clipboard.

15. In row 23, replace {your clipboard URL} with the URL in your clipboard. Be sure the /0 remains at the end of the URL. Repeat this for row 24.
16. Save and close the spreadsheet.

    Note:

    When saving, you may see the following warning message: The appearance value you gave is not one of the standard supported appearance types. If you’re attempting to combine two different appearance types, ensure that they’re separated by a space. Click Yes.

17. In ArcGIS Survey123 Connect, click Publish.

    Note:

    After you click Publish, you should see a modal window that says The survey will be updated without affecting the existing data. If you see a different message or ArcGIS Survey123 Connect displays an error before you click Publish, you have made an error in editing the XLSForm and should review steps 5 through 17 for errors.

18. Click Publish survey.
19. When publishing is complete, click OK.

Update Resource Tasker

To improve data quality, several fields in the Resource Tasker survey can be updated with a dynamic list of values based on fields found in other layers. The Event ID field in the Resource Tasker survey is updated by a lookup list containing the events that have been created using the Create Event page or Event Entry survey in Operations Dashboard. Once a user selects the Event ID field, a choice list is populated to provide a list of created events to select from.

To add dynamic field lookup lists to the Resource Tasker survey, complete the following steps:

1. Install ArcGIS Survey123 Connect.
2. Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
3. Click Resource Tasker.
4. Click Download and click OK.
5. Click Resource Tasker again.
6. Click XLSForm.

   A Microsoft Excel spreadsheet opens.

7. Click the survey tab.
8. Delete the text in the type column of row 8 (event_id) and type select_one Event.

   Note:

   When saving, you may see the following warning message: Please select yes if you are using a select_one or select_multiple XLS. Click Yes.

9. Delete the text in the type column of row 9 (mission_id) and type select_one Mission.
10. Paste the expression autocomplete search("events?url={your clipboard URL}/0") into the appearance column of row 8.

    Note:

    Example: autocomplete search("events?url=https://services6.arcgis.com/1U29tEKcAxIIDXRf/arcgis/rest/services/service_ 5b2c738c88234542bc7a683cd919d918_1/FeatureServer/0")

11. Paste expression autocomplete search("events?url={your clipboard URL}/1") into the appearance column of row 9.
12. Sign in to your ArcGIS organization.
13. Search for and click Operations Management hosted Feature Layer.
14. Scroll to the bottom of the Overview page for the Operations Management item, and in the URL section, click the Copy button.

    The layer service URL is copied to your clipboard.

15. In row 8, replace {your clipboard URL} with the URL in your clipboard. Be sure the /0 remains at the end of the URL. Repeat for row 9.
16. Save and close the spreadsheet.

    Note:

    When saving, you may see the following warning message: The appearance value you gave is not one of the standard supported appearance types. If you’re attempting to combine two different appearance types, ensure that they’re separated by a space. Click Yes.

17. In ArcGIS Survey123 Connect, click Publish.

    Note:

    After you click Publish, you should see a modal window that says The survey will be updated without affecting the existing data. If you see a different message or ArcGIS Survey123 Connect displays an error before you click Publish, you have made an error in editing the XLSForm and should review steps 5 through 17 for errors.

18. Click Publish survey.
19. When publishing is complete, click OK.

Modify readiness surveys

Included with Civil Support is a series of surveys that can be used to understand the capacity of your workforce.

To modify the Personnel Readiness Report or Personnel Readiness Batch Report survey, complete the following steps:

1. Install ArcGIS Survey123 Connect.
2. Start ArcGIS Survey123 Connect and sign in to your ArcGIS organization.
3. Click Personnel Readiness Report to download the survey.

Note:

Steps 4 through 9 apply to both the Personnel Readiness Report and Personnel Readiness Batch Report surveys.

4. Click the Personnel Readiness Report survey again to open it.
5. In the left pane, click Open XLSForm Spreadsheet.
6. In the Microsoft Excel spreadsheet, click the Choices tab. This tab contains the selectable options for survey questions.
7. Revise the survey to reflect your personnel readiness needs.

Caution:

Do not make any modifications to domain values that were not first updated in the feature layer.

8. Save the Microsoft Excel spreadsheet and preview your changes using the ArcGIS Survey123 Connect form preview.
9. In ArcGIS Survey123 Connect, click Publish in the left pane to publish your changes.

Note:

To view your changes in the Survey123 field app, open Survey123 and browse to the Download Surveys page. Click Download to download the updated survey.

To modify the Battalion or Company names in the Personnel Readiness Report or Personnel Readiness Batch Report, you will need to also account for the modification of the calculation in the choice_filter column of the Survey123 Connect XLSForm. The choice_filter column controls the cascading select functionality associated with each of the battalions and companies that fall within it.

For example, in the Personnel Readiness Report, if you select 1st Battalion, the next question asking for Company will be limited to only those companies in the 1st Battalion (A through D). Likewise, if you select 2nd Battalion, you see companies in the 2nd Battalion (E through H).

Learn more about how to work with cascading selects.