Difference between revisions of "HTP Database Table Structure"

From Poland Lab Wiki
Jump to: navigation, search

Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/customer/www/wiki.wheatgenetics.k-state.edu/public_html/includes/diff/DairikiDiff.php on line 434

Deprecated: assert(): Calling assert() with a string argument is deprecated in /home/customer/www/wiki.wheatgenetics.k-state.edu/public_html/includes/diff/DairikiDiff.php on line 437
Line 1: Line 1:
 
{|class="wikitable"
 
{|class="wikitable"
 
|+Table Name: phemu_htp
 
|+Table Name: phemu_htp
!style="text-align:center;"|column
+
!style="text-align:center;"|Column Name
!data type
+
!Description
!constraints
+
!Data Type
!description
+
!Required? <br />(Y/N)
 +
!Constraints
 
|-
 
|-
|record_id||integer||Unique sequential integer||A sequential number generated when record is inserted. Used as a synthetic primary key.
+
|         record_id               || A sequential number generated when record is inserted. Used as a synthetic prim|| integer    || Y          || Unique sequential integer
 
|-
 
|-
|run_id||text||NOT NULL||An ID used to identify a data collection run.<br />Format: <platform>_<start_date>_<start_time>_<end_date>_<end_time>
+
|         run_id                   || An ID used to identify a data collection run.<br />Format: <platform>_<start_da|| text      || Y          ||
 
|-
 
|-
|plot_id||char(10)||||The name of the plot that the sensor observation is associated with.<br /> Note that this may be null if the observation was taken in a position not over a plot.
+
|         plot_id                 || The name of the plot that the sensor observation is associated with.<br /> Note|| char(10)  || N          ||
 
|-
 
|-
|sensor_id||text||NOT NULL<br /> Should match sensor_id in the htp_instrument table||The identifier associated with the sensor used in the data collection.
+
|         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||double(255,5)||NOT NULL||The measurement value recorded by the sensor.||
+
|         sensor_observation       || The measurement value recorded by the sensor.                                 || double(255,5)|| Y          ||
 
|-
 
|-
|position||point||NOT NULL||GIS spatial representation of the x,y UTM coordinates of the sensor.||
+
|         position                 || GIS spatial representation of the x,y UTM coordinates of the sensor.           || point      || Y          ||
 
|-
 
|-
|absolute_sensor_position_x||double(255,5)||NOT NULL||The sensor UTM x coordinate (easting). ||
+
|         absolute_sensor_position_|| The sensor UTM x coordinate (easting).                                         || double(255,5)|| Y          ||
 
|-
 
|-
|absolute_sensor_position_y||double(255,5)||NOT NULL||The sensor UTM y coordinate (northing). ||
+
|         absolute_sensor_position_|| The sensor UTM y coordinate (northing).                                       || double(255,5)|| Y          ||
 
|-
 
|-
|absolute_sensor_position_z||double(255,5)||NOT NULL||The sensor altitude (above mean sea level) in meters.||
+
|         absolute_sensor_position_|| The sensor altitude (above mean sea level) in meters.                         || double(255,5)|| Y          ||
 
|-
 
|-
|sampling_time_utc||time||NOT NULL||The UTC time that the sensor observation was recorded.|||
+
|         sampling_time_utc       || The UTC time that the sensor observation was recorded.                         || time      || Y          ||
 
|-
 
|-
|sampling_date||date||NOT NULL||The UTC date that the sensor observation was recorded||
+
|         sampling_date           || The UTC date that the sensor observation was recorded                         || date      || Y          ||
 
|-
 
|-
|left_utc||double(255,5)||NOT NULL||The UTC time on the left GPS when the sensor observation was recorded.||
+
|         left_utc                 || The UTC time on the left GPS when the sensor observation was recorded.         || double(255,5)|| Y          ||
 
|-
 
|-
|left_elevation||double(255,5)||NOT NULL||The left GPS altitude (above mean sea level) in meters.||
+
|         left_elevation           || The left GPS altitude (above mean sea level) in meters.                       || double(255,5)|| Y          ||
 
|-
 
|-
|left_long||double(255,7)||NOT NULL||The left GPS longitude.||
+
|         left_long               || The left GPS longitude.                                                        || double(255,7)|| Y          ||
 
|-
 
|-
|left_lat||double(255,7)||NOT NULL||The left GPS latitude.||
+
|         left_lat                 || The left GPS latitude.                                                        || double(255,7)|| Y          ||
 
|-
 
|-
|long_zone||text||NOT NULL||The longitude zone of the left GPS e.g. 14.||
+
|         long_zone               || The longitude zone of the left GPS e.g. 14.                                   || text      || Y          ||
 
|-
 
|-
|lat_zone||text||NOT NULL||The latitude zone of the left GPS e.g. S.||
+
|         lat_zone                 || The latitude zone of teh left GPS e.g. S.                                     || text      || Y          ||
 
|-
 
|-
|left_utm_x||double(255,5)||NOT NULL||The UTM x position of the left GPS.||
+
|         left_utm_x               || The UTM x position of the left GPS.                                           || double(255,5)|| Y          ||
 
|-
 
|-
|left_utm_y||double(255,5)||NOT NULL||The UTM y position of the left GPS.||
+
|         left_utm_y               || The UTM y position of the left GPS.                                           || double(255,5)|| Y          ||
 
|-
 
|-
|right_utc||double(255,5)||DEFAULT NULL||The UTC time on the right GPS when the sensor observation was recorded.||
+
|         right_utc               || The UTC time on the right GPS when the sensor observation was recorded.       || double(255,5)|| N          ||
 
|-
 
|-
|right_elevation||double(255,5)||DEFAULT NULL||The right GPS altitude (above mean sea level) in meters.||
+
|         right_elevation         || The right GPS altitude (above mean sea level) in meters.                       || double(255,5)|| N          ||
 
|-
 
|-
|right_long||double(255,7)||DEFAULT NULL||The right GPS longitude.||
+
|         right_long               || The right GPS longitude.                                                      || double(255,7)|| N          ||
 
|-
 
|-
|right_lat||double(255,7)||DEFAULT NULL||The right GPS latitude.||
+
|         right_lat               || The right GPS latitude.                                                        || double(255,7)|| N          ||
 
|-
 
|-
|right_utm_x||double(255,5)||DEFAULT NULL||The UTM x position of the right GPS.|||
+
|         right_utm_x             || The UTM x position of the right GPS.                                           || double(255,5)|| N          ||
 
|-
 
|-
|right_utm_y||double(255,5)||DEFAULT NULL||The UTM x position of the right GPS.||
+
|         right_utm_y             || The UTM x position of the right GPS.                                           || double(255,5)|| N          ||
 
|-
 
|-
|sensor_offset_x_from_left_gps||double(255,5)||DEFAULT NULL||The x distance offset from the sensor and the left GPS in cm. ||
+
|         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_gps||double(255,5)||DEFAULT NULL||The x distance offset from the sensor and the left GPS in cm.||
+
|         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_gps||double(255,5)||DEFAULT NULL||The z distance offset from the sensor and the left GPS in cm.||
+
|         sensor_offset_z_from_left|| The z distance offset from the sensor and the left GPS in cm.                 || double(255,5)|| Y          ||
 
|-
 
|-
|note||longtext||||Optional notes related to the observation.||
+
|         note                     || Optional notes related to the observation.                                     || longtext  || N          ||
 
|}
 
|}

Revision as of 14:43, 4 May 2016

Table Name: phemu_htp
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