Deleting duplicate features
As you may have figured out, there are duplicate features in the corresponding feature layers when using this method. This is due to the python script copying events from feed at 4-minute intervals; whilst an event (accident, road closure, traffic jam, etc) may stay on the Waze XML feed for a much longer time.
- Add feature layers into a local Geodatabase using the copy features Geoprocessing tool in ArcGIS Pro.
- Use delete identical Geoprocessing tool to delete duplicate features.Please make sure to select UUID field for the Traffic Alerts feature layer, and select fields UUID, Speed, Delay and Length for the Traffic Jams feature layer - whose values will be compared to delete identical records.
- Publish these as web layers back into ArcGIS Online for analysis.
- Use the following ArcGIS Insights Models against newly created web layers (Traffic Alerts & Traffic Jams).
Cheers! - Gee Fernando
Click on the video below to view some insights of our findings (Canberra, Australia).