4 Easy access to the database

If you just want to review or download data after using basic filters, but don’t want to do any administrative tasks, data upload or SQL queries this options is the way to go. When connecting using the links:

at http://woodcar.boku.ac.at/ you will be forwarded to a login page where only the input of your username and password is necessary. After a successful login you can choose a parameter on the left panel to get to the data.

4.1 Filtering a data set

You can query the database to only return data satisfying certain conditions. Use “Search” to select a column, an operator, and a value to compare it to.

You have three different operators: " “,”<=" and “>=” You can use the first one (empty) to filter strings, this allows also partial matching (which is powerful and dangerous at the same time, so be careful!!). The latter two are self-evident using numerical data.

To subset all data matching “Populus” in the species column, with measured values <= 0.5 you can do the following

and then press select. If you need more operators you need to connect through the much more powerful DB Admin client described in this section.

4.2 Show more results

You probably recognized that you only see a certain amount of rows on one page. In databases there is potentially much more information stored than would fit into the available memory of your computer (or the server where the front-end runs on). Therefore you can limit the shown information to a certain number of rows using “Limit”. Press the “Select” button after changing this value to update your query. The total number of rows matching your query (“Search”) is shown on the left below the table. You can also navigate through your results by clicking on the respective page.

4.3 Sort the table

You can easily sort the table ascending and descending by clicking on the particular column name.

4.4 Download data to use it outside the database

After sub-setting the data as described in this section you can download the data using “Export”. Therefore you select the intended output format

  • TSV for tabstopp separated value
  • CSV, for comma separated value using a comma to separate the values and a dot as decimal point
  • CSV; for comma separated value (German version) using a semicolon to separate the values and a comma as decimal separator

and press “Export” to save the data to your file system.