Difference between revisions of "HTP Database Table Structure"
From Poland Lab Wiki
Line 1: | Line 1: | ||
{|class="wikitable" | {|class="wikitable" | ||
|+Table Name: phemu_htp | |+Table Name: phemu_htp | ||
− | !style="text-align:center;"| | + | !style="text-align:center;"|Column Name |
− | ! | + | !Description |
− | ! | + | !Data Type |
− | ! | + | !Required? <br />(Y/N) |
+ | !Constraints | ||
|- | |- | ||
− | |record_id | + | | record_id || A sequential number generated when record is inserted. Used as a synthetic prim|| integer || Y || Unique sequential integer |
|- | |- | ||
− | |run_id | + | | run_id || An ID used to identify a data collection run.<br />Format: <platform>_<start_da|| text || Y || |
|- | |- | ||
− | |plot_id | + | | plot_id || The name of the plot that the sensor observation is associated with.<br /> Note|| char(10) || N || |
|- | |- | ||
− | |sensor_id | + | | sensor_id || The identifier associated with the sensor used in the data collection. || text || Y || Should match sensor_id in the htp_instrument table |
|- | |- | ||
− | |sensor_observation | + | | sensor_observation || The measurement value recorded by the sensor. || double(255,5)|| Y || |
|- | |- | ||
− | |position | + | | position || GIS spatial representation of the x,y UTM coordinates of the sensor. || point || Y || |
|- | |- | ||
− | | | + | | absolute_sensor_position_|| The sensor UTM x coordinate (easting). || double(255,5)|| Y || |
|- | |- | ||
− | | | + | | absolute_sensor_position_|| The sensor UTM y coordinate (northing). || double(255,5)|| Y || |
|- | |- | ||
− | | | + | | absolute_sensor_position_|| The sensor altitude (above mean sea level) in meters. || double(255,5)|| Y || |
|- | |- | ||
− | |sampling_time_utc | + | | sampling_time_utc || The UTC time that the sensor observation was recorded. || time || Y || |
|- | |- | ||
− | |sampling_date | + | | sampling_date || The UTC date that the sensor observation was recorded || date || Y || |
|- | |- | ||
− | |left_utc | + | | left_utc || The UTC time on the left GPS when the sensor observation was recorded. || double(255,5)|| Y || |
|- | |- | ||
− | |left_elevation | + | | left_elevation || The left GPS altitude (above mean sea level) in meters. || double(255,5)|| Y || |
|- | |- | ||
− | |left_long||double(255,7)|| | + | | left_long || The left GPS longitude. || double(255,7)|| Y || |
|- | |- | ||
− | |left_lat||double(255,7)|| | + | | left_lat || The left GPS latitude. || double(255,7)|| Y || |
|- | |- | ||
− | |long_zone | + | | long_zone || The longitude zone of the left GPS e.g. 14. || text || Y || |
|- | |- | ||
− | |lat_zone | + | | lat_zone || The latitude zone of teh left GPS e.g. S. || text || Y || |
|- | |- | ||
− | |left_utm_x | + | | left_utm_x || The UTM x position of the left GPS. || double(255,5)|| Y || |
|- | |- | ||
− | |left_utm_y | + | | left_utm_y || The UTM y position of the left GPS. || double(255,5)|| Y || |
|- | |- | ||
− | |right_utc | + | | right_utc || The UTC time on the right GPS when the sensor observation was recorded. || double(255,5)|| N || |
|- | |- | ||
− | |right_elevation | + | | right_elevation || The right GPS altitude (above mean sea level) in meters. || double(255,5)|| N || |
|- | |- | ||
− | |right_long||double(255,7)|| | + | | right_long || The right GPS longitude. || double(255,7)|| N || |
|- | |- | ||
− | |right_lat||double(255,7)|| | + | | right_lat || The right GPS latitude. || double(255,7)|| N || |
|- | |- | ||
− | |right_utm_x | + | | right_utm_x || The UTM x position of the right GPS. || double(255,5)|| N || |
|- | |- | ||
− | |right_utm_y | + | | right_utm_y || The UTM x position of the right GPS. || double(255,5)|| N || |
|- | |- | ||
− | | | + | | sensor_offset_x_from_left|| The x distance offset from the sensor and the left GPS in cm. || double(255,5)|| Y || |
|- | |- | ||
− | | | + | | sensor_offset_y_from_left|| The x distance offset from the sensor and the left GPS in cm. || double(255,5)|| Y || |
|- | |- | ||
− | | | + | | sensor_offset_z_from_left|| The z distance offset from the sensor and the left GPS in cm. || double(255,5)|| Y || |
|- | |- | ||
− | |note | + | | note || Optional notes related to the observation. || longtext || N || |
|} | |} |
Revision as of 14:43, 4 May 2016
Column Name | Description | Data Type | Required? (Y/N) |
Constraints |
---|---|---|---|---|
record_id | A sequential number generated when record is inserted. Used as a synthetic prim | integer | Y | Unique sequential integer |
run_id | An ID used to identify a data collection run. Format: <platform>_<start_da |
text | Y | |
plot_id | The name of the plot that the sensor observation is associated with. Note |
char(10) | N | |
sensor_id | The identifier associated with the sensor used in the data collection. | text | Y | Should match sensor_id in the htp_instrument table |
sensor_observation | The measurement value recorded by the sensor. | double(255,5) | Y | |
position | GIS spatial representation of the x,y UTM coordinates of the sensor. | point | Y | |
absolute_sensor_position_ | The sensor UTM x coordinate (easting). | double(255,5) | Y | |
absolute_sensor_position_ | The sensor UTM y coordinate (northing). | double(255,5) | Y | |
absolute_sensor_position_ | The sensor altitude (above mean sea level) in meters. | double(255,5) | Y | |
sampling_time_utc | The UTC time that the sensor observation was recorded. | time | Y | |
sampling_date | The UTC date that the sensor observation was recorded | date | Y | |
left_utc | The UTC time on the left GPS when the sensor observation was recorded. | double(255,5) | Y | |
left_elevation | The left GPS altitude (above mean sea level) in meters. | double(255,5) | Y | |
left_long | The left GPS longitude. | double(255,7) | Y | |
left_lat | The left GPS latitude. | double(255,7) | Y | |
long_zone | The longitude zone of the left GPS e.g. 14. | text | Y | |
lat_zone | The latitude zone of teh left GPS e.g. S. | text | Y | |
left_utm_x | The UTM x position of the left GPS. | double(255,5) | Y | |
left_utm_y | The UTM y position of the left GPS. | double(255,5) | Y | |
right_utc | The UTC time on the right GPS when the sensor observation was recorded. | double(255,5) | N | |
right_elevation | The right GPS altitude (above mean sea level) in meters. | double(255,5) | N | |
right_long | The right GPS longitude. | double(255,7) | N | |
right_lat | The right GPS latitude. | double(255,7) | N | |
right_utm_x | The UTM x position of the right GPS. | double(255,5) | N | |
right_utm_y | The UTM x position of the right GPS. | double(255,5) | N | |
sensor_offset_x_from_left | The x distance offset from the sensor and the left GPS in cm. | double(255,5) | Y | |
sensor_offset_y_from_left | The x distance offset from the sensor and the left GPS in cm. | double(255,5) | Y | |
sensor_offset_z_from_left | The z distance offset from the sensor and the left GPS in cm. | double(255,5) | Y | |
note | Optional notes related to the observation. | longtext | N |