AnsweredAssumed Answered

When I delete features in SDE, they remain in the database.

Question asked by saadj on Oct 22, 2014
Latest reply on Oct 23, 2014 by saadj

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:

 

  1. Field teams collect points
  2. Geoprocess deletes all existing Damaged Parcels output features using the Delete Features tool (to prevent duplicates when appending data)
  3. Spatial join the collected points with parcel polygons - output is Damaged Parcels
  4. 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?

Outcomes