HTP Database Table Structure

From Poland Lab Wiki
Revision as of 14:47, 4 May 2016 by Mlucas (Talk | contribs)

Jump to: navigation, search
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_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