Difference between revisions of "HTP Database"

From Poland Lab Wiki
Jump to: navigation, search
Line 1: Line 1:
The High-Throughput Phenotyping database consists of a set of platform-specific tables for each data collection platform: pheMU, phenocart and phenocam. Each platform has am images table, an htp table and a run table.
+
The High-Throughput Phenotyping database consists of a set of platform-specific tables for each data collection platform: pheMU, phenocart and phenocam. Each platform has an images table, an htp table and a run table.
  
The images table stores metadata about the images that were collected during each data collection run.
+
*The images table stores metadata about the images that were collected during each data collection run.
  
The htp table stores metadata about sensor measurements (observations) that were collected during each run.
+
*The htp table stores metadata about sensor measurements (observations) that were collected during each run.
  
The run table stores information about each data collection run such as date/time and geographical extent of the run.
+
*The run table stores information about each data collection run such as date/time and geographical extent of the run.
  
 
Each set of platform-specific tables also relates to the plot_map table and the htp_instrument table.
 
Each set of platform-specific tables also relates to the plot_map table and the htp_instrument table.
  
The plot_map table contains information about the geographical coordinates of each plot associated with an experiment (field).
+
*The plot_map table contains information about the geographical coordinates of each plot associated with an experiment (field).
  
The htp_instrument table contains information about cameras and sensors used on each platform.
+
*The htp_instrument table contains information about cameras and sensors used on each platform.
  
 
The diagram below illustrates the generalized set of HTP tables and their relationships.
 
The diagram below illustrates the generalized set of HTP tables and their relationships.
  
 
[[File:HTP_Database_Tables.png]]
 
[[File:HTP_Database_Tables.png]]

Revision as of 19:46, 26 April 2016

The High-Throughput Phenotyping database consists of a set of platform-specific tables for each data collection platform: pheMU, phenocart and phenocam. Each platform has an images table, an htp table and a run table.

  • The images table stores metadata about the images that were collected during each data collection run.
  • The htp table stores metadata about sensor measurements (observations) that were collected during each run.
  • The run table stores information about each data collection run such as date/time and geographical extent of the run.

Each set of platform-specific tables also relates to the plot_map table and the htp_instrument table.

  • The plot_map table contains information about the geographical coordinates of each plot associated with an experiment (field).
  • The htp_instrument table contains information about cameras and sensors used on each platform.

The diagram below illustrates the generalized set of HTP tables and their relationships.

HTP Database Tables.png