Ressources naturelles Canada - Natural ressources Canada
Canada

TreeSource

 Zoom
»

Connection «

  • Login

Menu

  • Home
  • Tutorial
  • Map of sites
  • Tree rings
  • FAQ
  • Contact us

FAQ

Data format

Q: Data are not formatted in a useful way for me. Is there a way to have them formatted differently?

A: Yes! We are aware that data might not always be in a suitable format (e.g. date, lines vs columns, crosstabs, etc.). Hence, if you would like to have a view specifically designed for your needs, please contact Sébastien Clément.

Data access

Q: Who owns data and who can access them?

A: Most data come from the Canadian Forest Service (Government of Canada) and the Ministère des Forêts, de la Faune et des Parcs (Government of Québec). They are public in nature, and can be viewed by all.

However, some public data, which are currently in the process of being published in scientific journals, might not be immediately available. They will become available as soon as the publications are completed.

Finally, some other data are private in nature, because they originate from non-public organizations. Their access is thus restricted to members of those organizations.

Q: Who decides who has access to data, and how is access controlled?

A: The person or organization providing data decides who can have access to them. The database administrator then grants access privileges to users or groups having the right to access those data. Then, data is displayed on a user-specific manner.

No anonymous connection is allowed with TreeSource.

Technical questions

Q: What is TreeSource's infrastructure?

A :

Database server
Database management system
PostgreSQL 11.6
Operating system
CentOS 7.7.1908
Machine
VMware Virtual Platform
Width
64 bits
Processor
Intel® Xeon® E5620 Dual Core Processor @ 2.4 GHz
TreeSource database (as of 27/01/2020)
Size: >10.7 Gb
Objects: 161 tables, 217 views, 93 PL/pgSQL functions
Total records count: > 50 millions
External programs
Several scripts (Linux bash) interact with the database for tasks automation such as:
  • Backups;
  • Data export and formatting;
  • Field and table description updates.
Web server
TreeSource application language
PHP
Operating system
Red Hat 4.8.5
Machine
VMware Virtual Platform
Width
64 bits
Processor
Intel® Xeon® E7-4879 v2 @ 2.30Ghz (Quad Core)

Q: Who created TreeSource?

R: The database was created and is administered by Sébastien Clément, biologist and bioinformatician at the Canadian Wood Fibre Centre. The Web interface was developed by Maurice Lebon, Web programmer at Natural Resources Canada.

Created by the Canadian Wood Fibre Centre (CWFC) of the Canadian Forest Service (CFS).