Water Taste Complaint App

[SSMIC3038]

We have a client looking to develop something in our GIS that tracks taste complaints from customers, just curious if anyone can point out some literature or case studies for various options or approaches (for inspiration), perhaps some info based on an existing utilities response to the problem.

Can't be ArcGIS server based, were about 1 year out from incorporating ArcGIS server.

[SSMIC3038]

What we ended up implementing:
- front end form with a decision tree for Customer Service Reps (CSR's), so questions/answers are standardized
- responses stored in SDE table
- since this relies on non-GIS staff the front end form is all attribute - none spatial
- when an incident is finalized we used arcobjects to automatically create a spatial feature within a seperate feature class which links to the related table
- this allows non-GIS staff to collect the info > code creates the spatial feature > GIS staff can then see and analyze where complaints are coming from and the nature of those complaints
- we maintain the municipalities official address and street names so this standard was used in the form and allowed the auto creation of a spatial feature within the proper parcel
- the user feeds standardized address and street data into the app, the auto point function our dev team made shrinks the parcel fabric by 75% to ensure the point is randomly located within the fabric

I think this function of office staff collecting attribute data that is then automatically turned into spatial data is incredibly powerful and we anticipate a strong need for non-GIS staff to collect attribute data that is then translated into spatial data for the wider audience.