I hope this is the right place to post this.
I work for a sanitary sewer utility and we use linear referencing for CCTV inspection defects along gravity mains. We also are performing daily updates to our sewer data that sometimes will require to update our routes that are gcreated from our gravity mains. I am searching for documentation that addresses the need for such updating and if there are specific procedures to perform an update that could be scheduled for automation. MY main questions are storage of the route in SDE, is it a roccomendation that this be stored within SDE in a feature data set containing the gravity main data or should it be stored outside the dataset. What does ESRI reccomend for this procedure? I haven't been able to find any documentation on this as of yet. Any help would be appreciated.
Thanks in advance,