Utility Reporting Tools for ArcGIS Pro for the City of Wenatchee
City of Wenatchee Public Works has annual reporting requirements for the stormwater utility and for grease trap inspections. Due to the complexity of the data model, generating these reports with out-of-the-box GIS tools was difficult. To streamline and improve the reporting process Jeff created utility reporting tools for ArcGIS Pro written in Python. The tools allow the use to query stormwater facilities or grease trap facilities based on certain criteria, select those features on the map, and generate an Excel report with the results. The toolset simplifies the query of multiple related tables and the export of the results, allowing non-GIS specialists to generate the reports as required.