Why I am not able to find any database tables of survey data in collect schema in PostgreSQL database?

  • Asked
  • Active
  • Viewed 7912 times
2

Hi Everyone!

I tried to use PostgreSQL instead of SQLite to manage my collect database. I made all the necessary changes to the configuration xml and connected collect to my PostgreSQL server running on localhost. Everything went smooth up to here. My question is Why I am not able to find any database table of survey data in that Schema ("collect" in postgresql )? I got many (around 28) database tables in that schema but I did not find tables of any data I have entered from the published Survey in collect? Doesn't collect start to create database tables as soon as we start entering data from collect desktop? Does anyone have better idea on this?

Pardon me if this is too dumb question to be asked!!

Thanks on advance Milan

0

Accepted answer

Hi Milan,
The table you are looking for is called ofc_record (the prefix ofc stays for Open Foris Collect...), under the schema Collect. Every record (a cluster or a plot, depending on your survey...) corresponds to a row in that table. You can see different interesting columns... key1, key2, key3 contain the values of the key attributes and will help you to find a record. Data1 and data2 contain the actual collected data. They are binary columns and the only way to read the real data is to use Collect. This can be seen as a limit, because the only way to read and modify the data is to use the application, but it makes the process of reading and writing of the records very fast... even if we cannot guarantee that we won't change the way the data is stored into the database soon... This fact of having the data in a sort of "black box" sometimes makes the things more difficult to manage even for us.
If you need to see and work with the raw data, you can use Collect to export it to CSV or to a relational database.
I hope that now everything looks a bit clearer.
For more information about the structure of the database, please have a look to the documentation we have on GitHub.
Many thanks,
Open Foris Team

0

Accepted answer

Hello Stefano,

Thank you for a clear explanation. I hope this 'black box' kind of thing will be changed soon.

Cheers

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.