AS As it takes longer to write the manual step-by-step explanation I have just released a new version of Collect Earth that includes the utility to delete plots from the database. ***UPDATE TO VERSION 1.7.0 or later*** **WARNING: BEFORE DELTEING DELETING ANYTHING I ADVISE YOU TO MAKE A BACKUP OF YOUR DATA** Basically you need to identify the plot IDs that you want to delete from the DB. Then you put them into a CSV file where the header is the name (or names) of the key attributes of the survey. So if you have a survey where the plot have only one key attribute called *id* and you want to delete plots with ids 1,2,3 and 10 you would create a CSV like this: id 1 2 3 10 Then you go to Collect Earth menu *Tools->Utilities->Delete plots from Database* ![alt text][1] This opens a dialog where you choose the CSV file with the IDs to be removed (the dialog will validate that the CSV file has the expected headers with the name of the key attributes) ![alt text][2] At the end you will get a window that lets you know how many plots were deleted, how many plots in the CSV were actually not in the Database and how many plots were in the database but for some reason there was an exception and could not be deleted. deleted (you can find the exception message in the Collect Earth logs *Help->Open Application Log file*) [1]: http://www.openforis.org/support/upfiles/notepad++_2018-08-09_17-23-26.png [2]: http://www.openforis.org/support/upfiles/javaw_2018-08-09_17-26-16.png

AS it takes longer to write the manual step-by-step explanation I have just released a new version of Collect Earth that includes the utility to delete plots from the database. ***UPDATE TO VERSION 1.7.0 or later*** **WARNING: BEFORE DELTEING ANYTHING I ADVISE YOU TO MAKE A BACKUP OF YOUR DATA** Basically you need to identify the plot IDs that you want to delete from the DB. Then you put them into a CSV file where the header is the name (or names) of the key attributes of the survey. So if you have a survey where the plot have only one key attribute called *id* and you want to delete plots with ids 1,2,3 and 10 you would create a CSV like this: id 1 2 3 10 Then you go to Collect Earth menu *Tools->Utilities->Delete plots from Database* ![alt text][1] This opens a dialog where you choose the CSV file with the IDs to be removed (the dialog will validate that the CSV file has the expected headers with the name of the key attributes) ![alt text][2] At the end you will get a window that lets you know how many plots were deleted, how many plots in the CSV were actually not in the Database and how many plots were in the database but for some reason there was an exception and could not be deleted. [1]: http://www.openforis.org/support/upfiles/notepad++_2018-08-09_17-23-26.png [2]: http://www.openforis.org/support/upfiles/javaw_2018-08-09_17-26-16.png