It seems that when I delete features in SDE, they remain in the database.
I built a quick damage assessment application that consists of the following steps:
- Field teams collect points
- Geoprocess deletes all existing Damaged Parcels output features using the Delete Features tool (to prevent duplicates when appending data)
- Spatial join the collected points with parcel polygons - output is Damaged Parcels
- Run Excel report that queries SQL on Damaged Parcels to generate FEMA form
I have steps 2 & 3 run in a geoprocess, but I've found that even after deleting the features, the data still shows up in my report. I verified this in SQL Server Management Studio.
Because I'm using the data offline, the feature set is not versioned, but archiving is enabled.
As a workaround I execute a delete query in SQL before running my report so that it comes out clean. Is there a way to run my delete query in Model Builder so I can incorporate it into my geoprocess?