---
title: "deleting plots from analysis"
url: "https://openforis.support/questions/1901/deleting-plots-from-analysis"
tags: ["collectearth"]
status: "answered"
score: 0
answer_count: 3
asked: "2018-08-07T11:29:18"
last_activity: "2018-08-10T09:52:14"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# deleting plots from analysis

Asked by bstedham on 2018-08-07

Hi there, 

I have deleted several plots from my collect earth analysis. These plots are no longer in the csv file that is referenced by google earth when collecting the data, nor in the sample data in the properties of the project. 

However, when I export the excel file output to csv...they are still there with all of the data, and also when Saiku runs the analysis these deleted plots are still referenced. 

Please can someone tell me how to stop these deleted plots from being referenced still?

Thank you

Becky


## Answer (score 0, by collectearth on 2018-08-07)

Link: https://openforis.support/questions/1901/deleting-plots-from-analysis/1902

Hello Becky,

We are right now developing a small utility within Collect Earth to do just that!

If you **cannot wait for a few days** let me know and I will guide you through the manual process to remove plots.


## Answer (score 0, by svaccari on 2018-08-08)

Link: https://openforis.support/questions/1901/deleting-plots-from-analysis/1905

Hello @collectearth, 
i'm on the same boat as Becky - it would be much apprecaited if you could please post the step-by-step process to manually remove such plots from the analysis. 

thanks very much,
simone


## Answer (score 0, by collectearth on 2018-08-09)

Link: https://openforis.support/questions/1901/deleting-plots-from-analysis/1908

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 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 (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