Configure Sewer Data Management

Sewer Data Management can be used to map sewer assets, edit data, view system maps in the field and office, view asset reports, and collaborate with map notes.

In this topic, you'll learn how to configure the Sewer Data Management solution to meet specific needs of your organization.

Note:

This solution is designed with Map Viewer Classic. Not using Map Viewer Classic to configure the maps can impact functionality.

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. Sewer Data Management also includes a data model to store information about typical sewer system assets. To explore the schema, view the data dictionary.

Tip:

If you do 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 point, line, or polygon 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 Sewer Data Manager project, click Open another project, click My Content under Portal, double-click the Sewer Data Management folder, and click Sewer Data Manager.
3. Add your existing source layers to a new map. To add the target feature layers from the SewerSystem feature service, click My Content under Portal, double-click the Sewer Data Management folder, and add the SewerSystem 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 sewer data from the map to the Input Datasets parameter.
7. For Target Datasets, use the SewerSystem 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 sewer schema.

Use the Data Loading toolset

The Data Loading toolset contains tools to streamline data loading from a source schema to a target schema. The tools help reduce the time and complexity of migrating to a new data schema.

Note:

If using ArcGIS Pro 3.0 - 3.1 install the toolbox and review the Data Loading Tools documentation to learn more.

If using ArcGIS Pro 3.2 or later to load data in to the solution, complete the steps below:

1. Open the Sewer Data Manager project.
2. Click Tools in the Geoprocessing group on the Analysis tab of the ribbon.
3. Expand the Data Management Tools then expand the Data Loading toolset.
4. Review the Data Loading toolset documentation to understand how to load data into the SewerSystems layer.

Configure the Sewer Data Manager ArcGIS Pro project

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

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

   The Change Data Source dialog box appears.

5. Click My Content under Portal, double-click the Sewer Data Management folder, double-click the MapNotes_managing feature service, and double-click the Map Notes layer.
6. In the Contents pane, click the red exclamation point next to the Manhole layer.

   The Change Data Source dialog box appears.

7. Click My Content under Portal, double-click the Sewer Data Management folder, double-click the SewerSystem_editing feature service, and double-click the Manhole layer.

   The data source is repaired for the remaining layers.

8. In the Contents pane, right click the Sewer Data Manager map and click Properties.
9. 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 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 what units are displayed in the map.

10. Click Save to save the project.

Add members to groups in your organization

Included with Sewer 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: Sewer Editors, Sewer Field Users, Sewer Map Notes Managers, and Sewer Office Users.

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

1. In a browser, sign in to your ArcGIS organization.
   Verify that you have privileges to manage member groups before continuing.
2. Click Groups at the top of the site.
3. Locate the name of the group and click View details to open the details page.
4. On the Overview tab, click Invite members.
5. Check the check box next to the members that you want to add and click Add members to group.
6. Repeat these steps for each group that you need to add members to.

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

Group name	User type
Sewer Editors	Contributor Creator
Sewer Field Users	Mobile Worker
Sewer Map Notes Managers	Contributor
Sewer Office Users	Contributor

Set the default map extent to your service territory

When the Sewer Data Management solution is deployed into 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. Follow the steps below 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 Sewer Viewer application, browse to the Sewer 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 Sewer Editor and Sewer Map Notes Manager applications.
5. To set the default map extent for the Sewer Asset Collector map, open the Sewer Asset Collector map.
6. Zoom the map to the desired extent and save it.
7. Repeat steps 5 and 6 for the Sewer Mobile Viewer map.

Configure the dashboard

When you deploy the Sewer Data Management solution to your organization you have the option to change 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 Sewer Dashboard application, browse to the Sewer Dashboard item page and click Edit Dashboard.
3. Navigate to the General tab and click the configure button on Miles of Gravity Main 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. Repeat steps 3 through 4 for the Miles of Forced Main indicator.
6. Click the save button .