How should I combine the data collected by different operators?

  • Asked
  • Active
  • Viewed 14095 times
0
1

We are using Collect Earth for an assessment where several operators are collecting data at the same time.

Collect Earth is set-up so that it uses SQLite so that each operator has its own database in his computer.

How do I combine the data collected by the users so that we can run the Saiku analysis using all the collected data?

0

Accepted answer

So the process to achieve the integration of all the collected data is quite simple:

  • First you ask the users that are participating on the assessment to export the data as an XML file (actually the results of the export is a ZIP file containing the collected data as XML files inside it)

alt text

  • Then they should send the exported files to a shared network or dropbox folder or an e-mail address so that everyone has access to them. You should probably ask the users to rename the exported files to something meaningful like the regions they have assessed or the plot id ranges, otherwise the standard name of the exported ZIP file is collectDataExport_FULL_ZIP_WITH_XML.zip which is not so descriptive if you have 20 files like it.

  • Finally the last step is to import the data. You can just go to Tools->Data Import/Export->Import data from XML and after that select the files (the dialog allows you to select multiple files) that contained the exported data.

alt text

So know all the data that was collected from the different computers is integrated on the database of the computer where the data was imported. Obviously you can do this import process on one or several of the PCs.

Afterwards you will be able to start Saiku (using Tools->Start Saiku Analysis) and analyze all of the collected data.

IMPORTANT!!! The order in which you import the data matters. If you have been using a province or a set of data as the training plots for the users make sure to import the file that contains the " good data" for those plots last! If you then are prompeted if you want to overwrite the data on the database with this data click yes, as you know that this last file contains the data that was assessed correctly and not data that was just filled as a test.

IMPORTANT 2!!!! If you want to make sure that there are no data overlaps you should probably delete the database file ( see this answer ) after you have completed the training of the users and before you start the real assessment.

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.