---
title: "how to clean up the records in Collect Earth"
url: "https://openforis.support/questions/1831/how-to-clean-up-the-records-in-collect-earth"
tags: ["collect", "earth"]
status: "answered"
score: 0
answer_count: 1
asked: "2018-06-13T19:24:21"
last_activity: "2018-06-18T21:57:16"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# how to clean up the records in Collect Earth

Asked by jinkaizhang on 2018-06-13

I have  entered  a lot of records when i did some tests in Collect earth. Is there a way to clean up these records collected from Collect Earth?  I don't need them anymore. As far as i know, these records are kept in Sqlite, but not sure what is best way to clean up the records.

thanks,

jinkai


## Answer (score 0, by collectearth on 2018-06-18)

Link: https://openforis.support/questions/1831/how-to-clean-up-the-records-in-collect-earth/1843

Dear Jinkai,

Right now there is not a very good system to do this.

The easiest option is to remove the SQLite database file and restart Collect Earth with a fresh and clean database that will be automatically generated by Collect Earth. **DISCLAIMER: IF YOU DO THIS YOU WILL OBVIOUSLY DELETE THE DATA ALREADY ON THE DATABASE!!** So in that case remember to export the data so that you keep a copy of everything you had there.

The database file is called collectEarthDatabase.db and is located in the hidden folder : *C:\Users\YOUR_USERNAME\AppData\Roaming\CollectEarth*

You can access easily this folder by clicking on **Tools->Open Data Folder**
![alt text][1]

This will open a file explorer where you can locate the collectEarthDatabase.db file. Before removing the file close Collect Earth (as otherwise the file will not be able to be removed as it is in use of the application)

Once you have done this you can restart Collect Earth and a new and completely empty database file will be automatically created created!


  [1]: http://www.openforis.org/support/upfiles/2018-06-18_21-53-15.png
