Dear friends, I sometimes use the SQL export to get a build statement for the database structure resulting from the survey definition (for example to create a database or to visualize it). In this export, however, the species list is missing. E.g. if you use DBschema (as free software to visualize it) and parse the CREATE TABLE statement with the SQL exported from collect, my species list is missing. For completeness it would be nice to include this in the export, if possible.

Cheers, Lutz

asked 28 Apr '23, 09:19

Fehrmann's gravatar image

accept rate: 0%

Dear Lutz,
Good suggestion, I think that the species list tables could be added, maybe using a prefix species_list_ followed by the species list name.
Also the code list tables could be added to that export.
What columns do you need in those tables?
Let us know, many thanks,
Open Foris Team

permanent link

answered 05 May '23, 09:02

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
accept rate: 20%

Using the SQL export in Collect already includes all code tables, they come out nicely with all relations. Adding the species list would complement this. Even the sampling point data could potentially be included, at least the level_1 to level_x code and label which might be related to the plot entity. It should be no problem to include all columns of the species list (if users have additional fields), but in fact the species code (which is the key field relating to other tables) and species name (Latin and common) would already be fine. There are people who like to bypass the complex Collect and Calc database and use other techniques, like dynamical data models to analyze data, for them such a simpler structure might be helpful as basis. Thank you! Lutz

permanent link

answered 05 May '23, 12:59

Fehrmann's gravatar image

accept rate: 0%

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]( "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: 28 Apr '23, 09:19

question was seen: 3,166 times

last updated: 05 May '23, 12:59