Does ESRI have an off the shelf schema or template for feature class/table for tracking water customer complaints? I need a way to track the locations of customer complaints and the subsequent response by my utility such as inspection, findings, actions taken to remedy legitimate issues, etc. Even a schema/template for other customer complaints like sewer would be good too.
Specifically I would like feature classes or tables I can integrate into my enterprise SDE. Thanks everyone!
You can use Citizen Problem Reporter, Citizen Problem Manager and Citizen Problem Dashboard. It includes schema for common water quality and water service complaints - Citizen Problem Reporter | ArcGIS Solutions for Local Government
You can deploy the solution to your organization/portal using the instructions here:
Deploy solution - Citizen Problem Reporter | ArcGIS Solutions for Local Government
Once the layers are built, you can export them as file geodatabases: