Deleting ALL Test Survey Records in Survey123

1230
4
Jump to solution
08-03-2021 05:39 AM
Irena_Householder
New Contributor III

Hi. I need to delete ALL test records in my survey in preparation for going live. I know how to delete individual records in ArcGIS Online by opening the feature layer in the map viewer, but deleting individual records will take too long. Is there a way to delete all records at once?

Thanks!

Irena

0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

Hi @Irena_Householder ,

1.  Go to the item details of the feature service

2.  Scroll to the bottom and click View for the URL:

JakeSkinner_1-1627994690607.png

 

3.  Click on the layer you wish to delete features for:

JakeSkinner_2-1627994742642.png

4.  Scroll to the bottom and choose Delete Features for Supported Operations

JakeSkinner_3-1627994770204.png

5.  Specify 1=1 for the Where clause and click Delete Features

JakeSkinner_5-1627994838453.png

 

Another option would be to use the Delete Features tool in ArcGIS Pro.  You can browse to feature services as if they were feature classes.

 

View solution in original post

4 Replies
JakeSkinner
Esri Esteemed Contributor

Hi @Irena_Householder ,

1.  Go to the item details of the feature service

2.  Scroll to the bottom and click View for the URL:

JakeSkinner_1-1627994690607.png

 

3.  Click on the layer you wish to delete features for:

JakeSkinner_2-1627994742642.png

4.  Scroll to the bottom and choose Delete Features for Supported Operations

JakeSkinner_3-1627994770204.png

5.  Specify 1=1 for the Where clause and click Delete Features

JakeSkinner_5-1627994838453.png

 

Another option would be to use the Delete Features tool in ArcGIS Pro.  You can browse to feature services as if they were feature classes.

 

Irena_Householder
New Contributor III

Fantastic, this worked! Thank you!

0 Kudos
PanGIS
by
Regular Contributor

To add another option to @JakeSkinner  ones:

I sometimes prefer to overwrite with the empty feature service from ArcGIS PRO so that also the ObjectID will be wiped.

 

BUT

This is not an option if this is the only layer you have and you have already set a symbology or pop up in the map, otherwise you will lose also that. 

Furthermore, do not do it if you have added fields in ArcGIS Online.

Irena_Householder
New Contributor III

Thank you for adding another solution! This is the only layer and the pop-up and symbology are set, but this might be useful in other situations. Thank you!

0 Kudos