Configure data model

Gas and Pipeline Referencing Utility Network Foundation can be used to accelerate gas and pipeline utility network implementations. ArcGIS Pipeline Referencing can optionally be added to the Utility Network implementation.

In this topic, you'll learn how to configure the model in the Gas and Pipeline Referencing Utility Network Foundation solution to meet the specific needs of your organization.

Tip:

As you configure the solution, record the configurations or alterations you make with each version in a change log. This information will be valuable if you upgrade to a new version and need to evaluate the effort required.

Install the Utility Network Package toolbox

Note:

Skip this step if the Utility Network Package toolbox (untools) is already installed.

The Utility Network Package toolbox contains tools to simplify the configuration and export of a utility network. To install the tools, complete the following steps:

1. Start ArcGIS Pro and click Settings .
2. On the left, click Package Manager.
3. In the upper right, click the Environment Manager button .
4. In the Environment Manager dialog box, locate the environment you want to clone and click the Clone environment button . Alternatively, click the Clone arcgispro-py3 button to clone the default environment.

   

   The Clone Environment dialog box appears.

5. Click the Browse button and browse to a folder to store the new environment. Alternatively, click the Destination text box and edit the default name and path.
6. Click OK.
7. Select the newly created environment and click the Refresh button to update the list of available packages.
8. Click the Active Environment drop-down arrow, and select the cloned environment.
   An environment is created. Next, you will install the tools.
9. At the top of the Package Manager window, click Add Packages to see the python packages that can be installed.
10. In the Search box, type untools to install the Utility Network Package toolbox.
11. Select untools from the list and click Install.
12. In the Install Package dialog box, review the terms and conditions, check the check box to agree, and click Install.
13. After the installation is complete, exit ArcGIS Pro.

    The next time you start ArcGIS Pro, you can access the Utility Network Package toolbox from the Geoprocessing pane under the Toolboxes tab.

Tip:

Alternatively, the toolbox can be installed through the Python Command Prompt.

Install the Utility Data Management Support Toolbox

The Utility Data Management Support (UDMS) toolbox is a comprehensive suite of tools designed to enhance the management and configuration of utility networks and pipeline referencing within ArcGIS Pro.

To install the UDMS toolbox, complete the following steps.

1. In a web browser, navigate to the UDMS GitHub repository.
2. In the download section, click on the version that corresponds with your version of ArcGIS Pro.

   Tip:

   After downloading the toolbox, consider moving it to a safe location where it won't be accidently deleted.

3. In ArcGIS Pro open an existing project, or create a new one.
4. In the catalog pane, right click on Toolboxes and select Add Toolbox.
5. Navigate to the downloaded toolbox and select OK.

The toolbox will be added to your project and available for use.

Perform data mapping

In this section, you will learn about the schema and how to explore its features. A data dictionary is included to allow you to explore the model. To generate your own, use the Generate Schema Report tool.

Map source to target datasets

You can use the Create Simple Data Mapping tool to map and understand your data migration to the utility network. The tool creates a Microsoft Excel workbook that will allow you to map your source data to asset groups and asset types in the utility network. This workbook allows you to examine how your current schema aligns. If you discover that the model requires expansion or modification, you can refer to the following section for guidance on modifying your model. To create a simple data mapping experience, complete the following steps:

1. In the Geoprocessing pane, expand Project and expand the Utility Data Management Support toolbox, and then expand Data Migration and click the Create Simple Data Mapping tool.
2. In the tool, set the following parameters:
   1. For Source Dataset, select the source dataset that you will be migrating to the utility network.
   2. For Asset Package, select the asset package you are working with.
   3. For Output Folder, select where you want to store the output file.
   4. For Output Name, select the name of the output Microsoft Excel file.
3. Click Run.
After making the necessary modifications, repeat these steps until the model can accommodate the source datasets and fulfill your organization's requirements.

Modify information model

The Gas and Pipeline Referencing Utility Network Foundation model offers a starting point for implementing your gas and pipeline network. However, you may find that your organization requires additional features or changes. This section discusses ways that the model can be modified to fit your organizational needs.

Expand the model

Several tools in the Utility Data Management Support toolbox assist you with expanding your model.

Review and modify the utility network rules

The Export Matrix tool in the Utility Data Management Support toolbox helps you visualize and modify the utility network rules, categories, association roles, and terminal assignments.

Note:

Learn more about the Export Matrix and Import Matrix toolboxes.

1. In the Geoprocessing pane, expand Project and expand the Utility Data Management Support toolbox, and then expand the Matrix toolset and click Export Matrix.
2. In the tool, set the following parameters:
   1. Select the asset package you are working with for the Input Network parameter.
   2. Select the location of the output workbook and type an appropriate name in the Matrix Workbook parameter.
   3. Under Matrix Options, check the check box next to any of the options that you would like to export.
3. Click Run.
4. Review the exported workbook.

   Note:

   To make changes to the utility network rules, categories, association roles, or terminal assignments, the exported workbook can be modified and the Import Matrix tool can be used to apply the changes.

Copy fields and domains

Use the Copy Fields and Domains tool in the Utility Data Management Support toolbox to copy existing fields and domains from other source datasets.

1. In the Geoprocessing pane, expand Project and expand the Utility Data Management Support toolbox, and then expand the Schema toolset and click Copy Fields and Domains.
2. In the tool, set the following parameters:
   1. Under Source Classes, select all of the feature classes that you want to use as sources to copy fields and domains from.
   2. Under Target Class, select the target class that fields and domains will be copied to.

      Note:

      You can select multiple sources but only one target. If you are trying to copy fields and domains for more than one target, you will need to run the tool multiple times.

      After the source and target classes have been populated, a field mapping dialog box appears.

   3. Use the dialog box to decide which fields to copy and what their parameters should be.
   4. To copy fields as lower case, check the Copy All Fields as Lower Case check box.
   5. Use the Assign Domains and Default Values to Subtypes option to apply domains and default values at the subtype level.
3. Click Run.

Modify asset package

The asset package offers opportunities to subset configurations and rename different components of your implementation, which aids in configuring the model to fit your needs and allows for localization support in varying languages. This configuration is accomplished by using the D_Configurations and D_Rename tables. These tables are created using the Create Configuration Table and Create Rename Table tools. After they are configured, the changes will be applied when creating your utility network database or applying the asset package.

Create the configurations table

The D_Configurations table in the asset package can be used to group items into configurations that can be included or excluded when applying the asset package to the utility network. This ability allows you to create a subset of the original asset package. You can use the Create Configurations Table tool to create a configuration table.

Note:

Learn more about the properties that define the D_Configuration table schema.

1. In the Geoprocessing pane, expand System and expand the Utility Network Package Tools toolbox, and then expand the Asset Package toolset and click the Create Configurations Table tool.
2. In the tool, set the following parameters:
   1. Select the asset package you are working with for the Asset Package parameter.

      Note:

      These names will be added to the table as fields with a category_ prefix.

   2. Type the name or names of the configuration categories in the Configuration Fields parameter.
3. Click Run.

   Note:

   If a D_Configurations table already exists, it will be recreated with the new configuration categories, maintaining the existing schema and values.

Properties of the asset package can be assigned to different configuration categories.

Note:

To learn more about the configuration categories, see the Create Configurations Table help page.

Modify the configurations table

Once you have created the configurations table, follow these steps to associate a property with a category.

1. In the Catalog pane, browse to the asset package, right-click the D_Configurations table and select Add to New, and then choose Map.
2. From the View tab, click Contents to open the Contents pane.
3. Right-click the Configuration Table and choose Open to view the attribute table.
4. Set the appropriate column values for the properties for each added category.

Note:

After you have assigned the desired values to the categories, the table can be referenced in the Apply Asset Package or Asset Package to Geodatabase tools by referencing the modified table in the Configuration options parameter.

Create the rename table

To rename items in the utility network, you can use the Create Rename Table tool to create a D_Rename table in the asset package.

Note:

Learn more about the properties that define the D_Rename table properties.

1. In the Geoprocessing pane, expand System and expand the Utility Network Package Tools toolbox, and then expand the Asset Package toolset and click Create Rename Table.
2. In the tool, set the following parameters:
   1. Select the asset package you are working with for the Asset Package parameter.
   2. Type the names of the rename fields in the Rename Fields parameter.

      Note:

      These parameters will be added to the table as fields with a rename_ prefix.

3. Click Run.

   Note:

   If a D_Rename table already exists, it will be recreated with the new rename fields, maintaining the existing schema and values.

Properties of the asset package can be renamed using the D_Rename table. The table can be used to provide a translation of the database or provide a different name for a select set of items. When applying the asset package, the values from the selected rename value are applied to all properties that use that value in the target geodatabase.

Modify the rename table

Once you have created the rename table, follow these steps to provide a new name to a property.

1. Browse to the asset package, right-click the D_Rename and select Add to New, and then choose Map.
2. From the View tab, click Contents to open the Contents pane.
3. Right-click the rename table and select Open to view the attribute table.
4. For a property that will have an alternate name, use the rename column you added in the previous step and specify a new value.

Note:

After you have assigned the desired values to the renaming columns, the table can be referenced in the Apply Asset Package or Asset Package to Geodatabase tools by referencing the modified table in the Rename using parameter.

Consider model units

All components for this solution have been configured in imperial units. Also included are metric fields and domains. These options allow you to convert your workflows to metric only or to a combination of imperial and metric. You can update map layer pop-ups and field references to use the desired fields. If you convert to a singular unit of measure, the unused fields can be deleted from the geodatabase.

Configure utility network environment

After you have completed the mapping and modification of your model, you can continue to the Configure utility network environment topic to create your single-user utility network geodatabase.