Overview

Facility Reports for Gas Distribution

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.

Requirements

Facility Reports for Gas Distribution requires specific technical experience and software.

Requirement Description
Experience
  • Modifying JSON files
  • Publishing GIS services
  • Authoring maps
  • Administering groups and organizing content in an ArcGIS organization
Software
Report Generation
  • ArcMap (Standard or Advanced) 10.2.1, 10.3, 10.4, 10.5
  • Python 2.7.x
Map service hosting
  • ArcGIS Online, or
  • ArcGIS Enterprise (Standard or Advanced) 10.5, or
  • ArcGIS for Server (Standard or Advanced) 10.3, 10.4
    • Portal for ArcGIS
Application hosting
  • ArcGIS Online, or
  • ArcGIS Enterprise 10.5, or
  • Portal for ArcGIS 10.4
Applications
  • Basic Viewer (ArcGIS configurable web application template)

What you get

When you download Facility Reports for Gas Distribution, you'll find the following in the zip file:

Directory Item Description
Application A folder containing a set of Python 2.7 scripts to create and update the required services, maps, and apps in your organization. These scripts utilize the Automated Setup & Reporting tools.
Maps and GDBs DistributionReports.gdb A sample geodatabase with the report schema with sample data.
NapervilleGas.gdb A sample geodatabase with gas network and reporting data.
OneCallTickets.gdb A sample geodatabase with one call tickets.
GasDistributionReport.mxd A map document used to publish the distribution reports.

What's new

Below are the release dates and notes for Facility Reports for Gas Distribution.

Date Description
June 2017
  • Most recent version of the Automated Setup & Reporting tools that includes the following:
    • Support for ArcGIS 10.5.
    • 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.
  • The most recent Utility and Pipeline Data Model with sample data
  • Most recent version of the Automated Setup & Reporting tools. See the release notes for more details.
December 2015
  • Updates to the Mains Report and Services Report to summarize assets with material type reconditioned cast iron
  • Update to the Excavation Damage Report to summarize excavation damage by root cause
  • The most recent Utility and Pipeline Data Model with sample data
August 2015
  • Latest versions of the ArcREST tools
    • ArcREST version 3
  • Config file enhancements
May 2015
  • Data report schema compressed into 7 reporting classes.
  • Multiple configuration files merged into a single file.
  • Multiple maps merged into one.
  • Dashboard app replaced with an ArcGIS Basic Viewer configurable web application template.
  • Template renamed to Facility Reports for Gas Distribution. Original name was Annual DOT Report.
  • Latest versions of the ArcREST and SolutionReportTools
December 2014
  • The most recent UPDM.gdb with sample data
  • Latest versions of the ArcREST and ArcREST Helper tools
  • Configuration files schema changes
    • FeatureService section to FeatureServices
    • Login info only defined in the GlobalLoginInfo file
    • EnableEditTracking parameter added to FeatureServices section
    • UpdateItemContent changes to UpdateService in MapDetails
    • Portal in login section changed to Orgurl
    • ExistingService change to ExistingServices
    • ExistingServices ReportResult tag changes to FeatureClass
    • ReplaceTag added to section
    • 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.

Get started with Facility Reports for Gas Distribution

Top