Configure Stormwater Data Management

The Stormwater Data Management solution can be configured to meet specific needs in your organization. The sections below outline some administrative tasks to update and manage the solution to fit your organization's needs.

Load data

In some cases, you may need to load existing data into the solution before sharing the maps or applications. Review the maps or applications provided with the solution and determine what, if any, source data you want to load. Stormwater Data Management also includes a data model to store information about typical storm water system assets. To explore the schema, view the data dictionary.

Tip:

If you have to load data into the solution, you may want to develop a source-target matrix to track how your source data will be loaded into the target layer or layers used in the solution.

Depending on the format of your source data, you may choose to append your source data to the new layers. Once you have determined what source data must be loaded, complete one of the data loading workflows below:

Use the Append tool

In ArcGIS Pro, the Append tool can be used to append multiple input datasets to an existing target dataset. Input datasets can be tables; rasters; or point, line, polygon, annotations, or dimensions feature classes.

To append features to the target layer or layers using the Append tool, complete the steps below:

1. In ArcGIS Pro, sign in to your ArcGIS organization.
2. To open the Stormwater Data Manager project, click Open another project, click My Content under Portal, double-click the Stormwater Data Management folder, and click Stormwater Data Manager.
3. Add your existing source layers to a new map. To add the target feature layers from the StormwaterSystem feature service, click My Content under Portal, double-click the Stormwater Data Management folder, and add the StormwaterSystem feature service to the map.
4. On the Analysis tab, in the Geoprocessing group, click Tools to open the Geoprocessing pane.
5. In the search bar, type Append and click to open the Append tool.
6. Add your existing storm water data from the map to the Input Datasets parameter.
7. For Target Datasets, use the StormwaterSystem features in the map.
8. In the Schema Type parameter, use the drop-down menu to choose Use the Field Map to reconcile schema differences to perform field mapping.
9. Update your field mapping and click Run.
10. Repeat this process as needed to load all your existing data into the target storm water schema.

Use the Data Loading Tools

The Data Loading toolbox can be used in ArcGIS Pro to streamline loading data from a source to a target dataset and provide the ability to perform in-process data transformation. Setup the Data Loading toolbox before getting started with the steps below.

1. In ArcGIS Pro, open the Stormwater Data Manager project and sign in to your ArcGIS organization.
2. On the Project tab, click Package Manager.
3. In the upper right corner, click the Environment Manager button.
4. Click the Clone environment button on the row representing the environment you want to clone. Alternatively, click the Clone arcgispro-py3 button to clone the default environment.

   The Clone Environment dialog box appears.

5. Select your newly cloned environment and click OK.

   Cloning an environment may take several minutes. You can close the Clone Environment dialog box while you wait. You can monitor progress in the Tasks section of the Package Manager page.

6. In the Python Package Manager, click Add Packages to see the Python packages available for installation.
7. In the Search box, type dltsolutions to find the Data Loading toolbox.
8. Select the dltsolutions package and click the drop-down arrow to update the version.
9. Click Install to open the Install Package dialog box.
10. Review the terms and conditions and check the check box to agree.
11. Click Install to install the package.
12. Once complete, close ArcGIS Pro.

    The Data Loading toolbox is now installed. The next time you start ArcGIS Pro, you can access it from the list of geoprocessing toolboxes.

13. Review An overview of the Data Loading toolbox to learn more about the tools and how to use them to load data into the StormwaterSystem layers.

Configure the Stormwater Data Manager ArcGIS Pro project

The Stormwater Data Manager project includes a Stormwater Data Manager map with broken links.

1. Sign in to your ArcGIS organization and browse to the Stormwater Data Manager item.
2. From the item page, click Download.
3. Unzip and open the downloaded Stormwater Data Manager ArcGIS Pro project.

1. In ArcGIS Pro, sign in to your ArcGIS organization.
2. Click
3. To open the Stormwater Data Manager project, click Project > Open > Open another project.
4. Under Portal, click My Content, double-click the Stormwater Data Management folder, and click Stormwater Data Manager to open the map.
5. In the Catalog pane, expand Maps and double-click Stormwater Data Manager to open the map.
6. In the Contents pane, click the red exclamation point next to the Map Notes layer.

   The Change Data Source dialog box appears.

7. Click My Content under Portal, double-click the Stormwater Data Management folder, double-click the StormwaterMapNotes_managing feature service, and double-click the Map Notes layer.
8. In the Contents pane, click the red exclamation point next to the Manhole layer.

   The Change Data Source dialog box appears.

9. Click My Content under Portal, double-click the Stormwater Data Management folder, double-click the StormwaterSystem_editing feature service, and double-click the Manhole layer.

   Once you have repaired the data layers, you will need to update the coordinate system of the map to match your layers.

10. In the Contents pane, right-click the Stormwater Data Manager map and click Properties.
11. Click the Coordinate Systems tab. In the XY Coordinate Systems Available section, select the coordinate system that matches the layers in the map.

    Note:

    Ensure that the coordinate system of the map matches that of the feature layers deployed in the solution. If these do not match, there may be discrepancies in which units are displayed in the map.

12. Click Save to save the project.

Add members to groups in your organization

Included with Stormwater Data Management are four groups designed to help managers organize their members based on their privileges and their work. The solution includes the following groups: Stormwater Editors, Stormwater Field Users, Stormwater Map Notes Managers, and Stormwater Office Users.

To add members to the groups, complete the following steps:

1. In a browser, sign in to your ArcGIS organization.
   Confirm that you have privileges to manage member groups before continuing.
2. Click Groups at the top of the site.
3. Click the name of the group to open the group details pages.
4. On the Settings tab, edit and update the properties of the group, including access, sharing properties, and group ownership.
5. Click the Overview tab and click Invite users.
6. Select the members you want to add and click Add to group.
7. Repeat steps 3 through 6 for each group you need to add members to.

The provided groups are intended to be used by members with a minimum of the following user types to fully use the provided maps and apps:

Group name	User type
Stormwater Editors	Editor GIS Professional Basic with ArcGIS Pro (minimum of one license recommended)
Stormwater Field Users	Mobile Worker
Stormwater Map Notes Managers	Editor
Stormwater Office Users	Editor

Set the default map extent to your service territory

When the Stormwater Data Management solution is deployed to your organization, it uses the map default set in your organization. If this property has not been set, you may want to quickly update a few maps and apps to your service territory manually to avoid having to pan and zoom to your area each time you open a map. Complete the following steps to update the initial extent of the maps and apps provided with this solution:

1. In a browser, sign in to your ArcGIS organization.
2. To set the default map extent for the Stormwater Viewer application, browse to the Stormwater Viewer item page and click Edit Application.
3. On the Map tab, zoom the map to the desired extent and click Use current map view under Set initial extent. Click Save.
4. Repeat steps 2 and 3 to set the default map extent for the Stormwater Editor and Stormwater Map Notes Manager applications.
5. To set the default map extent for the Stormwater Asset Collector map, open the Stormwater Asset Collector map.
6. Zoom the map to the desired extent and save it.
7. Repeat steps 5 and 6 for the Stormwater Mobile Viewer map.

Configure the dashboard

When you deploy the Stormwater Data Management solution to your organization, you have the option to change the spatial reference. If you selected a spatial reference with a linear unit other than meters, you will need to revise the dashboard by completing the following steps:

1. In a browser, sign in to your ArcGIS organization.
2. To set the default map extent for the Stormwater Dashboard application, browse to the Stormwater Dashboard item page and click Edit Dashboard.
3. Browse to the General tab and click the configure button on the Miles of Open Channel indicator.
4. On the Data tab, change the Factor setting to the correct conversion.

   The dashboard Factor setting is configured to convert meters to miles. Learn more about how to Convert Values.

5. Update the Statistic field to Sum and Field to Shape_Length to display miles of channels.
6. Repeat steps 3 and 4 for the Miles of Pipe indicator.
7. Click Done and click Save .