{"id":522202,"date":"2024-05-06T16:42:55","date_gmt":"2024-05-06T16:42:55","guid":{"rendered":"https:\/\/uat.esri.com\/en-us\/industries\/blog\/?post_type=blog&#038;p=522202"},"modified":"2024-05-06T18:58:30","modified_gmt":"2024-05-06T18:58:30","slug":"migrating-at-scale-a-ten-database-utility-network-case-study","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study","title":{"rendered":"Migrating at Scale: A Ten-Database Utility Network Case Study"},"content":{"rendered":"<p class=\"undefined block-editor-paragraph\"><em>By: Jamie Patterson, GIS Manager, EPCOR and Ally Kennedy, Principal-Geospatial Utilities, Timmons Group<\/em><\/p>\n\n<p class=\"undefined block-editor-paragraph\">EPCOR USA Inc. (EPCOR USA) owns, operates, and builds water, wastewater, and natural gas infrastructure in Arizona, New Mexico, and Texas. As one of the largest private water utilities in the Southwest, it serves more than 800,000 people across 44 communities. EPCOR USA is an indirect, wholly owned subsidiary of EPCOR Utilities Inc. based in Edmonton, Alberta, Canada.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"h-managing-scale\">Managing Scale<\/h2>\n\n<p class=\"undefined block-editor-paragraph\">For the better part of two decades, the Arizona-based GIS team has leveraged Esri products to deliver geospatial services to water and wastewater operations, engineering, and other functions of the US business. EPCOR USA\u2019s portfolio covers a range of systems\u2014including a large presence in the Phoenix metropolitan area with some of the fastest growing communities in the nation, wholesale water pipelines supplying portions of greater Austin and San Antonio, and small to medium sized rural communities across Arizona and New Mexico. Through organic development, system acquisitions, and new business ventures, EPCOR USA has consistently grown and evolved over the last decade. One of the key questions we face is\u2014how do we continue to deliver high-quality geospatial services across an expanding footprint? In other words, <em>how do we manage scale?<\/em><\/p>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg\" alt=\"\" class=\"wp-image-522232\" srcset=\"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg 1024w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCORUSA_MAP2023-300x168.jpg 300w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCORUSA_MAP2023-768x431.jpg 768w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCORUSA_MAP2023-1536x862.jpg 1536w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCORUSA_MAP2023-2048x1149.jpg 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">The above image illustrates EPCOR USA\u2019s operations.<\/figcaption><\/figure>\n\n<p class=\"undefined block-editor-paragraph\"><strong>\u201cOne of the key questions we face is\u2014how do we continue to deliver high-quality geospatial services across an expanding footprint? In other words, <em>how do we manage scale?\u201d<\/em><\/strong><\/p>\n\n<p class=\"undefined block-editor-paragraph\">In 2020, EPCOR USA partnered with Timmons Group to assess our current GIS, gather program needs, and develop a future state plan with the primary requirements to<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Modernize the GIS platform with long-term success in mind.<ul><li>Fully migrate to ArcGIS Pro.<\/li><\/ul>\n<ul class=\"wp-block-list\">\n<li>Retain geometric network type functionality.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n<p class=\"undefined block-editor-paragraph\">EPCOR USA continued to team with Timmons Group, an Esri Network Management Specialty partner, for the implementation of ArcGIS Utility Network. This included a full ArcGIS Enterprise platform upgrade with new architecture, including Portal for ArcGIS.<br><br>To minimize spatial distortion and align linear asset records with tax parcel boundaries and right of ways, EPCOR USA uses the coordinate systems adopted by its local jurisdictions\u2014in most cases, State Plane coordinates. The datasets identified for migration to ArcGIS Utility Network fall within five State Plane coordinate system zones\u2014two in Arizona, two in New Mexico, and one in Texas. Each mix of coordinate system and utility schema (i.e., water, wastewater, or non-potable water) triggered a new database. Accordingly, Timmons Group migrated EPCOR USA\u2019s geometric network datasets into nine new Utility Network SQL databases. We leveraged a tenth database, coined \u201cEPCORUSA\u201d, to overcome the limitations of the fragmented datasets. For a multi-state view and ease of use with web applications, this read-only database contains three Utility Network schemas projected to a Web Mercator spatial reference. A single repository is useful for asset reporting and dashboard configurations that pull information from across the organization.<\/p>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"781\" src=\"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCOR-Enterprise-GIS-Databases-1024x781.png\" alt=\"\" class=\"wp-image-522242\" srcset=\"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCOR-Enterprise-GIS-Databases-1024x781.png 1024w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCOR-Enterprise-GIS-Databases-300x229.png 300w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCOR-Enterprise-GIS-Databases-768x586.png 768w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCOR-Enterprise-GIS-Databases.png 1265w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">EPCOR USA\u2019s ten Utility Network databases\u2014A scheduled job using Safe Software\u2019s FME refreshes the regional EPCORUSA database content from the nine local databases nightly.<\/figcaption><\/figure>\n\n<h2 class=\"wp-block-heading\" id=\"h-migrating-at-scale\">Migrating at Scale<\/h2>\n\n<p class=\"undefined block-editor-paragraph\">In order to ensure our migration into Utility Network could be as seamless as possible, Timmons Group delivered ArcGIS Data Reviewer files that allowed EPCOR USA editors to navigate to and fix data errors. While we were not able to build out all our subnetworks from day one in Utility Network, this process got us a lot closer to that functionality. Given the large number of EPCOR USA systems, progress continues to complete subnetworks for all systems.<\/p>\n\n<p class=\"undefined block-editor-paragraph\">Esri solutions for water and wastewater were used as the basis for the data models for EPCOR USA. Following workshops with the GIS users and feedback from other end users like engineering and on-site crews, Foundation data models were customized to meet EPCOR USA\u2019s specific business needs. The customized Water data model was used as the basis for the non-potable data model and then underwent several additional changes.<\/p>\n\n<p class=\"undefined block-editor-paragraph\">All the regions used the same data model for each utility (e.g., the New Mexico Water data model is the same as the Arizona Water data model) aside from coordinate systems. The Texas water transmission system also used the same water data model, plus the addition of several unique feature classes and non-spatial, related tables. The large wholesale water pipeline does not require heavy network edits and, therefore, was implemented without the network object itself.<\/p>\n\n<p class=\"undefined block-editor-paragraph\">The data was migrated from the source databases into the customized Utility Network asset packages with FME. Additional workbenches were created to QA the output of each migration and ensure the deployments of Utility Network would succeed. The output of these QA workbenches was reviewed by stakeholders prior to implementation to ensure all features migrated as expected.<\/p>\n\n<h4 class=\"wp-block-heading\" id=\"h-configuration\">Configuration<\/h4>\n\n<p class=\"undefined block-editor-paragraph\">Attribute rules were configured to streamline editing as much as possible. These included calculation rules to populate fields based on intersecting polygons, ID generation rules, and modified rules from the Utility Network Foundation solutions. Validation attribute rules were also created to ensure high data quality. The combination of these attribute rules and Utility Network\u2019s connectivity rules allows EPCOR USA to easily find data that needs attention, and therefore become more confident in our data quality. <\/p>\n\n<p class=\"undefined block-editor-paragraph\">Data editing was further streamlined with the configuration of group editing templates. EPCOR USA staff received training and guidance from Timmons Group on how to set these new template types and then configured them as needed. These templates allow staff to create many features, such as a hydrant with its laterals and valves, with very few clicks.<\/p>\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"558\" src=\"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/UN_editing-1024x558.png\" alt=\"\" class=\"wp-image-522252\" srcset=\"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/UN_editing-1024x558.png 1024w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/UN_editing-300x164.png 300w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/UN_editing-768x419.png 768w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/UN_editing-1536x838.png 1536w, https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/UN_editing-2048x1117.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">ArcGIS Pro document configured for EPCOR USA\u2019s GIS team with Utility Network editing templates.<\/figcaption><\/figure>\n\n<p class=\"undefined block-editor-paragraph\">Following Timmons Group\u2019s guidance, EPCOR USA pushed each editing map, including its editing templates, to Portal as map packages. This allows all our editors to work from common templates and easily receive new group templates as they are created.<\/p>\n\n<p class=\"undefined block-editor-paragraph\">The new editing tools, combined with branched versioning yield efficiencies compared to the previous traditional versioned workflow. Branched versioning also removed the occasional performance lags seen by users interacting with our most heavily transacted databases and eliminated the administrative overhead of scheduling compress and reindex jobs.<\/p>\n\n<h4 class=\"wp-block-heading\" id=\"h-integrations\">Integrations<\/h4>\n\n<p class=\"undefined block-editor-paragraph\">Prior to this project, EPCOR USA\u2019s Cityworks AMS implementation was using two domains, one for the Texas wholesale system and one for the regulated Arizona and New Mexico systems. Aligning the Texas data model with the other water systems allowed us to maintain the current asset configuration and asset work history within Cityworks, as both Texas and the rest of the network were published in the same feature service in the GIS. Iterative testing of both the Cityworks settings and the map used to publish the feature services was used to ensure that front-end users of Cityworks experienced as few changes as possible. EPCOR USA also undertook change management tasks so that Cityworks users would know what to expect. The result of the combined efforts of Timmons Group and EPCOR USA was a smooth Cityworks transition with minimal disruption to end user experience, despite the radically changed underlying GIS schema.<\/p>\n\n<p class=\"undefined block-editor-paragraph\">The project culminated with the GIS team leveraging Portal for ArcGIS to reinvent one of EPCOR USA\u2019s most heavily used mapping applications. Developed by a third party, the previous application accessed geometric network content published from EPCOR USA\u2019s ArcGIS Server instance. The new platform, developed in-house by our GIS staff with ArcGIS Web AppBuilder, delivers Utility Network content to users across the business.<\/p>\n\n<h4 class=\"wp-block-heading\" id=\"h-results\">Results<\/h4>\n\n<p class=\"undefined block-editor-paragraph\">All the goals of the original project were completed; EPCOR USA fully migrated to ArcGIS Pro with ArcGIS Utility Network and minimal downtime.<\/p>\n\n<p class=\"undefined block-editor-paragraph\">Benefits gained from the project include:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>More efficient editing workflows<\/li>\n\n<li>Cleaner datasets and better quality control tools<\/li>\n\n<li>Richer data model, capable of tracking finer details<\/li>\n\n<li>Easier sharing of GIS content through a modernized enterprise GIS platform<\/li>\n<\/ul>\n\n<p class=\"undefined block-editor-paragraph\">Keys to our successful implementation include:<\/p>\n\n<ul class=\"wp-block-list\">\n<li>Comprehensive planning from a long-term perspective<\/li>\n\n<li>Working with a trusted and qualified partner in Timmons Group to plan and execute a complex migration<\/li>\n\n<li>Finding a solution that meets the specific needs of our organization<\/li>\n<\/ul>\n\n<p class=\"undefined block-editor-paragraph\">We have a geospatial data management solution that can handle a large, varied, and expanding footprint and positions EPCOR USA to remain on the leading edge of GIS solutions.<\/p>\n\n<h2 class=\"has-text-align-center wp-block-heading\">Stay Connected with Esri&#8217;s Water Team<\/h2>\n\n<p class=\"has-text-align-center block-editor-paragraph\">ArcGIS is an extensive information system that enables modernization of workflows with easy-to-use applications for the field and office. Strengthen your organization with smart water solutions that will increase efficiency and provide insight for decision-makers.<\/p>\n\n<p class=\"has-text-align-center block-editor-paragraph\">Visit the&nbsp;<a href=\"https:\/\/www.esri.com\/en-us\/industries\/water-utilities\/overview\" target=\"_blank\" rel=\"noreferrer noopener\">Esri Water Utilities<\/a>&nbsp;web site for more information.<\/p>\n\n<p class=\"has-text-align-center block-editor-paragraph\">Learn more about <a href=\"https:\/\/www.esri.com\/en-us\/industries\/water-utilities\/network-utilities\">network management<\/a>. <\/p>","protected":false},"author":131,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1762],"tags":[451,5172,652,961,2202],"class_list":["post-522202","blog","type-blog","status-publish","format-standard","hentry","category-water-utilities","tag-arcgis","tag-geospatial-services","tag-infrastructure","tag-network-management","tag-utility-network","industry-water"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Migrating at Scale: A Ten-Database Utility Network Case Study<\/title>\n<meta name=\"description\" content=\"ArcGIS Utility Network provides EPCOR USA a geospatial data management solution that can handle their large, varied, and expanding footprint.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrating at Scale: A Ten-Database Utility Network Case Study\" \/>\n<meta property=\"og:description\" content=\"EPCOR USA fully migrated multiple geometric network datasets to ArcGIS Pro with ArcGIS Utility Network with minimal downtime.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study\" \/>\n<meta property=\"og:site_name\" content=\"Industry Blogs\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-06T18:58:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/UN_editing.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2556\" \/>\n\t<meta property=\"og:image:height\" content=\"1394\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"EPCOR USA fully migrated multiple geometric network datasets to ArcGIS Pro with ArcGIS Utility Network with minimal downtime.\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study\",\"url\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study\",\"name\":\"Migrating at Scale: A Ten-Database Utility Network Case Study\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#primaryimage\"},\"thumbnailUrl\":\"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg\",\"datePublished\":\"2024-05-06T16:42:55+00:00\",\"dateModified\":\"2024-05-06T18:58:30+00:00\",\"description\":\"ArcGIS Utility Network provides EPCOR USA a geospatial data management solution that can handle their large, varied, and expanding footprint.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#primaryimage\",\"url\":\"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg\",\"contentUrl\":\"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrating at Scale: A Ten-Database Utility Network Case Study\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/#website\",\"url\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/\",\"name\":\"Industry Blogs\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/#\/schema\/person\/63b299b98844293e8c561496264c0a03\",\"name\":\"Christa Campbell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2021\/01\/ChristaCampbell_2020-150x150.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2021\/01\/ChristaCampbell_2020-150x150.jpg\",\"caption\":\"Christa Campbell\"},\"description\":\"Christa is an experienced water industry professional with 20 years of success using and promoting technology to solve problems in the water industry. Recognized for Industry thought leadership, strategic thinking, and building success with organizations across the globe. She is a passionate GIS advocate, lifelong learner and collaborator. Builds success jointly with teammates, peers, and customers. Christa is a certified GIS Professional and holds a graduate degree in Geography.\",\"sameAs\":[\"https:\/\/www.esri.com\/en-us\/industries\/water\/overview\",\"https:\/\/www.linkedin.com\/in\/crstacampbell\/\",\"https:\/\/x.com\/CrstaCampbell\"],\"gender\":\"Female\",\"jobTitle\":\"Director Industry Solutions, Water\",\"worksFor\":\"Esri\",\"url\":\"\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Migrating at Scale: A Ten-Database Utility Network Case Study","description":"ArcGIS Utility Network provides EPCOR USA a geospatial data management solution that can handle their large, varied, and expanding footprint.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study","og_locale":"en_US","og_type":"article","og_title":"Migrating at Scale: A Ten-Database Utility Network Case Study","og_description":"EPCOR USA fully migrated multiple geometric network datasets to ArcGIS Pro with ArcGIS Utility Network with minimal downtime.","og_url":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study","og_site_name":"Industry Blogs","article_modified_time":"2024-05-06T18:58:30+00:00","og_image":[{"width":2556,"height":1394,"url":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/UN_editing.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_description":"EPCOR USA fully migrated multiple geometric network datasets to ArcGIS Pro with ArcGIS Utility Network with minimal downtime.","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study","url":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study","name":"Migrating at Scale: A Ten-Database Utility Network Case Study","isPartOf":{"@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#primaryimage"},"image":{"@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#primaryimage"},"thumbnailUrl":"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg","datePublished":"2024-05-06T16:42:55+00:00","dateModified":"2024-05-06T18:58:30+00:00","description":"ArcGIS Utility Network provides EPCOR USA a geospatial data management solution that can handle their large, varied, and expanding footprint.","breadcrumb":{"@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#primaryimage","url":"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg","contentUrl":"https:\/\/uat.esri.com\/en-us\/industries\/blog\/wp-content\/uploads\/2024\/05\/EPCORUSA_MAP2023-1024x574.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/articles\/migrating-at-scale-a-ten-database-utility-network-case-study#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/en-us\/industries\/blog"},{"@type":"ListItem","position":2,"name":"Migrating at Scale: A Ten-Database Utility Network Case Study"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/#website","url":"https:\/\/www.esri.com\/en-us\/industries\/blog\/","name":"Industry Blogs","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/en-us\/industries\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/#\/schema\/person\/63b299b98844293e8c561496264c0a03","name":"Christa Campbell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/en-us\/industries\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2021\/01\/ChristaCampbell_2020-150x150.jpg","contentUrl":"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2021\/01\/ChristaCampbell_2020-150x150.jpg","caption":"Christa Campbell"},"description":"Christa is an experienced water industry professional with 20 years of success using and promoting technology to solve problems in the water industry. Recognized for Industry thought leadership, strategic thinking, and building success with organizations across the globe. She is a passionate GIS advocate, lifelong learner and collaborator. Builds success jointly with teammates, peers, and customers. Christa is a certified GIS Professional and holds a graduate degree in Geography.","sameAs":["https:\/\/www.esri.com\/en-us\/industries\/water\/overview","https:\/\/www.linkedin.com\/in\/crstacampbell\/","https:\/\/x.com\/CrstaCampbell"],"gender":"Female","jobTitle":"Director Industry Solutions, Water","worksFor":"Esri","url":""}]}},"text_date":"May 6, 2024","author_name":"Esri Water","author_page":false,"custom_image":"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCOR_Banner_2.jpg","primary_product":"Water","tag_data":[{"term_id":451,"name":"ArcGIS","slug":"arcgis","term_group":0,"term_taxonomy_id":451,"taxonomy":"post_tag","description":"","parent":0,"count":71,"filter":"raw"},{"term_id":5172,"name":"Geospatial services","slug":"geospatial-services","term_group":0,"term_taxonomy_id":5172,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":652,"name":"Infrastructure","slug":"infrastructure","term_group":0,"term_taxonomy_id":652,"taxonomy":"post_tag","description":"","parent":0,"count":42,"filter":"raw"},{"term_id":961,"name":"network management","slug":"network-management","term_group":0,"term_taxonomy_id":961,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":2202,"name":"utility network","slug":"utility-network","term_group":0,"term_taxonomy_id":2202,"taxonomy":"post_tag","description":"","parent":0,"count":10,"filter":"raw"}],"category_data":[{"term_id":1762,"name":"Water Utilities","slug":"water-utilities","term_group":0,"term_taxonomy_id":1762,"taxonomy":"category","description":"","parent":147,"count":45,"filter":"raw"}],"product_data":{"errors":{"invalid_taxonomy":["Invalid taxonomy."]},"error_data":[]},"primary_product_link":"https:\/\/www.esri.com\/en-us\/industries\/blog\/industry\/water","short_description":"EPCOR USA fully migrated multiple geometric network datasets to ArcGIS Pro with ArcGIS Utility Network with minimal downtime. ","image":"https:\/\/www.esri.com\/en-us\/industries\/blog\/app\/uploads\/2024\/05\/EPCOR_Card.jpg","_links":{"self":[{"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/article\/522202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/users\/131"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/article\/522202\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/media?parent=522202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/categories?post=522202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/en-us\/industries\/blog\/wp-json\/wp\/v2\/tags?post=522202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}