AnsweredAssumed Answered

Python Update Cursor, Delete Rows Between Values

Question asked by gsipes on Dec 13, 2017
Latest reply on Feb 4, 2018 by xander_bakker

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? 

Thanks

Outcomes