I am taking AVL data and attempted to delete out where Street Sweeping is not occuring. That is, between events "Brushes Off" and "Brushes On". I only care about the rows between events "Brushes On" and Brushes Off".
Here is my table structure:
I want to write a simple python script that will delete the rows with event = "GPS Update" that are between event = "Brushes Off" and "Brushes On".
I know this is a simple UpdateCursor and a For Loop. I just do not have the Python experience yet.
Can anyone suggest a solution?