The Water Inventory Reports solution is used to calculate network information for a utility's service area or reporting areas. These reports can be created using the Python script provided on an annual or bi-annual basis to inform executives about network infrastructure.

The following inventory reports are calculated and published to an ArcGIS organization:

  • Assets by Material
  • Assets by Decade Installed
  • Hydrant Status
  • Number of Laterals by Material
  • Miles of Mains by Material


Water Inventory Reports requires specific technical experience and software.

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

What you get

When you download the Water Inventory Reports, you'll find the following in the zip file:

Directory Item Description
Application 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 WaterDistributionNetwork.gdb The geodatabase contains sample water network data.
WaterUtilityReports.gdb The geodatabase contains the water inventory reports schema with sample data.
WaterInventoryReport.mxd The ArcMap document with sample cartography used when publishing the report map and app.

What's new

Below are the release dates and notes for Water Inventory Reports.

Date Description
February 2016
August 2015
  • Latest versions of the ArcREST tools.
    • ArcREST version 3.
  • Config file enhancements.
July 2015
  • The most recent sample water network data from the Local Government Information Model
May 2015
  • Multiple configuration files merged into a single file and updated to support current enhancements to reporting tools
  • Sample data reduces to only service area
  • Dashboard replaced with sample viewer app
  • Latest versions of the ArcREST tools and SolutionReportTools
December 2014
  • Latest versions of the ArcREST and ArcREST Helper tools
  • Config 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
August 2014
  • First release of Water Inventory Reports

Known issues

  • This solution uses the Intersect geoprocessing tool. If you have line features in the same layer that overlap (for example, in a 3d view the line would look like a "Z") and using a field other than Shape Length for reporting, the results will be incorrect.
  • If you are using a field other than Shape Length to calculate a report summary and your data is being split by your reporting district, the results will be incorrect as this field is not being adjusted by the percentage that record falls into the reporting zone.
  • The automated setup utilizes 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 Water Inventory Reports

Solution Report Tools preview release

The next release of the Solution Report tools solves the known issues relating to Intersect and the Shape Length field. A preview of this next release is available on GeoNet.