---
title: "Where are the database files located?"
url: "https://openforis.support/questions/16/where-are-the-database-files-located"
tags: ["collectearth"]
status: "accepted"
score: 0
answer_count: 1
asked: "2014-10-03T12:10:51"
last_activity: "2015-08-31T17:28:37"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Where are the database files located?

Asked by Open Foris on 2014-10-03

If I want to remove the SQLite file where the Collect data is located, how can I find it?


## Accepted answer (score 0, by sanchez_paus on 2014-10-03)

Link: https://openforis.support/questions/16/where-are-the-database-files-located/18

When using Collect Earth with the SQLite Operation mode active ( one can use PostgreSQL for multi-user connection or SQLite for single user access ) the database file (called collectEarthDatabase.db ) are located in the folder :


**Windows** : C:\Users\\*USER_NAME*\\AppData\Roaming\CollectEarth

   ***AppData*** is a hidden folder. If you cannot see it then you need to activate the hidden files visualization. [See here how to show hidden files][1] !



**Linux** : ~/CollectEarth

**Mac OS X** : ~/Library/Application Support/Collect Earth ( tip , to get to this folder : Open Finder, Click *Apple Key + Shift + G*, you get a dialog, type *~* in the text field and click Ok (this will take you to your User’s home folder) Then browse to Library->Application Support->Collect Earth )

**The structure within this folder is :**

 - **backupSqlite** folder ( each time Collect Earth ends a backup file of the database is stored here, only the 10 last files are stored )
 - **generated** folder ( where the files that are automatically generated by Collect Earth reside. This would include the KML and KMZ files that are generated when the Collect Earth properties are changed )
 - **projects** folder. This folder holds a copy of the extracted contents of each of the projects that have been imported into Collect Earth.
 -  **webapps** folder.
 -  **collectEarthDatabase.db** (if the SQLite option is enabled). This file contains all of the data that has been collected within Collect Earth in this computer ( for all the projects that the user has worked on )
 - **collectEarthDatabase.dbSaiku** (if the SQLite option is enabled ) This is the database file that is generated before the Saiku analysis can run. If the contents of the Collect Earth database change this database should be refreshed.
 - **earth.properties** file where all the possible properties to set Collect Earth are stored.
 - **earth_error.log** the log file where the error messages generated by Collect Earth are stored.


  [1]: http://www.howtogeek.com/howto/windows-vista/show-hidden-files-and-folders-in-windows-vista/