{"id":2918232,"date":"2025-08-20T07:00:24","date_gmt":"2025-08-20T14:00:24","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2918232"},"modified":"2025-08-21T05:45:23","modified_gmt":"2025-08-21T12:45:23","slug":"load-data-into-a-utility-network-foundation","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/utility-network\/data-management\/load-data-into-a-utility-network-foundation","title":{"rendered":"Loading associations into a Utility Network Foundation"},"author":304562,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851,25741,23051],"tags":[780552,780542,767482,775812],"industry":[],"product":[36571,36561,515312],"class_list":["post-2918232","blog","type-blog","status-publish","format-standard","hentry","category-data-management","category-electric-gas","category-water","tag-create-migration-workspace","tag-create-simple-data-mappings","tag-data-loading-tools","tag-utility-network-foundation","product-arcgis-enterprise","product-arcgis-pro","product-utility-network"],"acf":{"short_description":"Learn how to migrate features and relationships to a Utility Network Foundation using tools provided by Esri.","flexible_content":[{"acf_fc_layout":"image","image":{"ID":2921222,"id":2921222,"title":"E-commerce, delivery and packaging service concept. Cardboard bo","filename":"AdobeStock_222792278-scaled.jpg","filesize":180413,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-scaled.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/utility-network\/data-management\/load-data-into-a-utility-network-foundation\/e-commerce-delivery-and-packaging-service-concept-cardboard-bo","alt":"","author":"304562","description":"","caption":"","name":"e-commerce-delivery-and-packaging-service-concept-cardboard-bo","status":"inherit","uploaded_to":2918232,"date":"2025-08-05 15:34:59","modified":"2025-08-05 15:38:45","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":2560,"height":853,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-scaled.jpg","medium-width":464,"medium-height":155,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-scaled.jpg","medium_large-width":768,"medium_large-height":256,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-scaled.jpg","large-width":1920,"large-height":640,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-1536x512.jpg","1536x1536-width":1536,"1536x1536-height":512,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-2048x683.jpg","2048x2048-width":2048,"2048x2048-height":683,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-826x275.jpg","card_image-width":826,"card_image-height":275,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/AdobeStock_222792278-1920x640.jpg","wide_image-width":1920,"wide_image-height":640}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Introduction<\/h1>\n

In this walkthrough, you assume the role of a GIS analyst at a small municipal organization who is tasked with implementing your utility network. You want to migrate your data to a utility network so you can leverage its ability to trace and manage your network data. Your organization also integrates your GIS data with analysis tools used by your engineering and operations departments. As a result, you decided to implement a standard model supported by multiple vendors, such as one of Esri\u2019s Utility Network Foundations<\/a>.<\/p>\n

While reviewing the data model, you noticed that the Utility Network Foundations allow you to create associations between different types of features in the network. You know that associations are important because they allow you to represent the relationships between features in a way that allows them to be easily included in tracing and analysis. This tutorial shows you how to migrate existing relationship classes to associations, if you want to use spatial analysis and proximity to create associations you can use the Create Association Records<\/a> tool and the B_Rules<\/a> table to create associations.<\/p>\n

This tutorial includes instructions and sample data from several different industries, allowing you to follow along with the dataset that you feel most comfortable with. This tutorial will show you how you can migrate data and relationships from your source database to a utility network. The main focus of this tutorial is on how to create associations using existing relationship classes. If you are more interested in the detailed mappings for features and fields, you can find tutorials covering those topics in the additional resources included at the end of this tutorial.<\/p>\n

You will find a collection of additional Utility Network data migration resources at the end of this article.<\/p>\n

\n
Create a data migration<\/a><\/dt>\n
Create a data mapping workbook<\/a><\/dd>\n
Map feature classes<\/a><\/dd>\n
Map associations<\/a><\/dd>\n
Create a data migration workspace<\/a><\/dd>\n
Conclusion<\/a><\/dd>\n
Make containment associations<\/a><\/dt>\n
Map associations fields<\/a><\/dd>\n
Migrate associations<\/a><\/dd>\n
Lesson conclusion<\/a><\/dt>\n
Additional resources<\/a><\/dd>\n<\/dl>\n"},{"acf_fc_layout":"sidebar","content":"

If an image in the tutorial appears small you can click it to open a full-sized version of the image in a new tab.<\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"image","image":{"ID":2826592,"id":2826592,"title":"Utility Network Horizontal Rule","filename":"Picture1.png","filesize":7270,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/utility-network\/data-management\/un-at-the-uc-2025\/picture1-123","alt":"","author":"322562","description":"","caption":"","name":"picture1-123","status":"inherit","uploaded_to":2826552,"date":"2025-06-10 14:35:38","modified":"2025-07-08 14:30:11","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":623,"height":78,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1-213x78.png","thumbnail-width":213,"thumbnail-height":78,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","medium-width":464,"medium-height":58,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","medium_large-width":623,"medium_large-height":78,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","large-width":623,"large-height":78,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","1536x1536-width":623,"1536x1536-height":78,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","2048x2048-width":623,"2048x2048-height":78,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","card_image-width":623,"card_image-height":78,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Picture1.png","wide_image-width":623,"wide_image-height":78}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Part 1: Create a data migration<\/h2>\n

The first step to migrating your data to a standard, preconfigured data model like a Utility Network Foundation is to create high-level data mappings that show how all the data in your source database is migrated to the target model. You will learn how to use tools provided by Esri to create these mappings and turn them into a data migration workspace that can be used with the Esri Data Loading tools.<\/p>\n

Section 1: Create a data mapping workbook<\/h3>\n

In this section you will use the Utility Data Management Support tools<\/a>\u00a0to create initial, high-level mappings. The classes you migrate will depend on the industry you select<\/p>\n