View source for Phemu htp table

{|class="wikitable"
|+Table Name: phemu_htp
!style="text-align:center;"|Column Name
!Description
!Data Type
!Required? <br />(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.<br />Format: <platform>_<start_date_start_time_<end_date>_<end_time>.|| text       || Y          ||
|-
|         plot_id                  || 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.|| 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_x|| The sensor UTM x coordinate (easting).                                         || double(255,5)|| Y          ||
|-
|         absolute_sensor_position_y|| The sensor UTM y coordinate (northing).                                        || double(255,5)|| Y          ||
|-
|         absolute_sensor_position_z|| 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_gps|| The x distance offset from the sensor and the left GPS in cm.                  || double(255,5)|| Y          ||
|-
|         sensor_offset_y_from_left_gps|| The x distance offset from the sensor and the left GPS in cm.                  || double(255,5)|| Y          ||
|-
|         sensor_offset_z_from_left_gps|| 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          ||
|}