Deleting features using 'where' clause?

Question

By looking at REST API docs for /deleteFeature here:

https://developers.arcgis.com/rest/services-reference/enterprise/delete-features.htm

it seems that deletes can be performed in multiple ways:

* by giving objectid(s) of feature(s) to delete
* by specifying geometry to overlap/intersect features to delete with
* by specifying SQL-like 'where' clause which will select features to delete

However, by looking at Javadocs, it seems that ArcGIS Runtime for Java supports only first method using deleteFeature(s)Async on FeatureTable.

Are 2 and 3 unsupported or am I missing something?

MarkBaird · Answer

The service I'm using to delete features is this one https://sampleserver6.arcgisonline.com/arcgis/rest/services/DamageAssessment/FeatureServer

If you can get me a reproducer I can take a closer look at your code.

For info, I was working on a Mac using 100.14.1.  The fact that you are using Linux shouldn't make any difference.

gkresic · Answer

This was exactly my approach, but calling either ServiceFeatureTable.applyEditsAsync() or ServiceGeodatabase.applyEditsAsync() after (successful) ServiceFeatureTable.deleteFeaturesAsync(Iterable<Feature>) resulted in 'Object ID '885192' is not valid.'.

Which version or ArcGIS Runtime and on which OS did you test?

Regarding app type, I current don't have any - I'm just experimenting what is possible with this Java lib. I'll try to put up something reproducible.

BTW, we digressed into problem I described in previous post, so maybe it would be cleaner if we continue over there?

MarkBaird · Answer

The reason I'm asking what kind of application you are writing is to make sure you are not investing time in a project which can't be licensed.  If you are writing a desktop JavaFX application this is fine, but if you are writing a server side component such as a micro-service then is isn't covered in the license agreement for the ArcGIS Runtime Product and the advice I give needs to be different.

The API can delete features from a hosted feature service.  For example, I tried it as follows using the objectid of a feature in a service.  Starting by getting the feature using a where clause:

// query parameters to get a specific feature
            QueryParameters queryParameters = new QueryParameters();
            queryParameters.setWhereClause("objectid=1594564");

// get a quest result containing the feature to be deleted.
            var resultFuture = featureTable.queryFeaturesAsync(queryParameters);
            FeatureQueryResult selected = resultFuture.get();

Then I deleted it using the same techniques used in the sample.

If you explain exactly what you are doing and maybe share some code I can give you some more pointers.