Back to Top

Network Information Management System: Electric Utility (PostgreSQL)

This test study was conducted in January 2023 and evaluates the Reference Architecture for a Network Information Management System with:

  • Workflows representative of an electric utility
  • An enterprise geodatabase configured with PostgreSQL
  • Amazon Web Services (AWS) cloud infrastructure

The system presented in this test study was designed at a physical level, and incorporates several design choices that are described in detail. The system was deployed and tested for both performance and end-user experience, with a target design load of 15 ArcGIS Pro editors and 200 ArcGIS web users (general user personas). Learn more about test studies to gain important context.

Note:

It is important that you become familiar with the reference architecture before the test study, as there is important information and resources that are not duplicated here.

Overview of capabilities

A foundational Network Information Management System delivers the following capabilities as defined in the data editing and management system pattern:

  • Service-based editing of relational data, including geometry and attributes.
  • Data collection workflows using forms and/or maps.
  • Complex utility network information management using the ArcGIS Utility Network as an advanced data model.
  • Viewing and querying network assets through web applications.
  • Performing upstream & downstream trace analytics.

Software list

The system capabilities are delivered through the following software with all available patches applied:

The design was deployed on virtual machines based on a Microsoft Windows operating system.

Note:

The software versions listed above were the latest available when this system test study was deployed and tested. Esri strongly recommends using the latest available software versions when possible.

Data characteristics

This test study tested a 100 GB electric utility dataset with a geographic extent of roughly 275,000 square miles. It contained about twenty million features, 2,000 subnetworks, and 650,000 electric meters at customer locations.

Top