Facility Reports for Gas Distribution

Overview

Utilities are required to report on their gas distribution system annually. The Facility Reports for Gas Distribution solution can be used to help summarize information needed for this annual report. In addition to summarizing the report content, the results can be published to your ArcGIS organization as a service, map, and app. The summary report can also be exported out as a CSV file.

This solution provide the follow reports:

Miles of Pipe

Miles of Services

Average Service Length

Number of Leaks

Excavation Ticket

Excavation Damage

Excess Flow Valves

Warning

Please review the known issues before configuration of this solution on your data.

A resolution to a bug in which using a custom length field in the report summary would result in incorrect results. When reporting on a custom length field, values can now be proportionally split when setting the new reclass report parameter, AdjustCountField, to true (BUG-000100918).

A new parameter in the reclass report configuration, ReportAreasOverlap, which reports when a feature is split and the sum of the parts do not equal the original feature length. The logic is similar to the Pairwise Intersect tool, which results in faster processing.

A new parameter in the reclass report configuration, ReclassType, which determines how features that span multiple reporting areas will be summarized.

June 2016

The UPDM.gdb has been removed and replaced with the NapervilleGas.gdb.

The ReportingArea parameter now uses the P_ServiceArea included with the NapervilleGas.gdb.

February 2016

An update to the data query expressions from EXTRACT(YEAR from CURRENT_DATE) to a hard coded date.

A resolution to an issue with the Mains Report Ductile Iron and Other Material fields in which the incorrect material type was defined for the report calculation.

ReplaceInfo Section now uses the following three parameters, SearchString, ReplaceString and ReplaceType

Updated configuration files to support the Utility and Pipeline Data Model

June 2014

First release of Facility Reports for Gas Distribution

Known issues

The automated setup uses ArcREST, which does not support application and enterprise logins.

When publishing to Portal for ArcGIS, the Hosting Server must use an ArcGIS Data Store as a managed geodatabase.

When publishing to Portal for ArcGIS with an ArcGIS Data Store Hosting Server, field names will be auto converted to lowercase. The tools will update the maps created, but apps are not updated to handle this conversion.

The script is delivered using relative paths. To use this without changing to absolute paths, you need to have python.exe as the default file extension for .py files and the path to Python in your systems path variable.