Hello, I want to edit the db of collect, in order to eliminate entries that can be noisy in the analysis in saiku and leave in each operator, only those of its corresponding grid.

I have tried to open the db with several programs, but none can open it.

Can i modify the db?

asked 31 Jan '17, 23:34

francisco_lillo_r's gravatar image

accept rate: 25%

Hi Francisco!

The database file used by Collect Earth when using the single user version (SQLite) is located in the file:


This is an SQLite database. In order to open the SQLite file then you need to use an application such as SQLite Browser.

NOW : The problem is that the data of the plots is stored in a table called ofc_record in a format that is not completely readable...you can find the ID of the plot in the column key1 but other than that you cannot really see what the information for the plot is as it is stored in a binary format in the column data1

So you can only remove data if you know what are they IDs of the plots that you want to delete, using a query like :

DELETE FROM ofc_record WHERE key1 IN ( ID_1, ID_2,ID_3 ... ID_N)


This is probably what you are looking for as you want to remove/edit plots but want to query the data and search for specific rows but not by ID.

This is an option that is present in the Collect (in the main page) . A video will come shortly explaining how this works as it is a bit complex....

The first step is to import the plots though the Data management option, after that you can start defining the cleaning steps...

alt text

permanent link

answered 01 Feb '17, 13:16

collectearth's gravatar image

collectearth ♦
accept rate: 17%

Here is a video on how to use the Collect Data Cleansing functionality : LINK TO VIDEO

Also there is more info on the manual LINK (page 42)

permanent link

answered 03 Feb '17, 16:50

Open%20Foris's gravatar image

Open Foris ♦♦
accept rate: 9%


In fact, I am now reviewing the manual, thank you very much !!

Something happens to the video, it fails to reproduce.

permanent link

answered 03 Feb '17, 17:28

francisco_lillo_r's gravatar image

accept rate: 25%

permanent link

answered 03 Feb '17, 17:30

collectearth's gravatar image

collectearth ♦
accept rate: 17%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 31 Jan '17, 23:34

question was seen: 4,017 times

last updated: 03 Feb '17, 17:30