HTP Database Table Structure

From Poland Lab Wiki
Revision as of 21:08, 3 May 2016 by Mlucas (Talk | contribs)

Jump to: navigation, search
Table Name: phemu_htp
column data type constraints description
record_id integer Unique sequential integer A sequential number generated when record is inserted. Used as a synthetic primary key.
run_id text NOT NULL An ID used to identify a data collection run.
Format: <platform>_<start_date>_<start_time>_<end_date>_<end_time>
plot_id char(10) The name of the plot that the sensor observation is associated with.
Note that this may be null if the observation was taken in a position not over a plot.
sensor_id text NOT NULL
Should match sensor_id in the htp_instrument table
The identifier associated with the sensor used in the data collection.
sensor_observation double(255,5) NOT NULL The measurement value recorded by the sensor.
position point NOT NULL GIS spatial representation of the x,y UTM coordinates of the sensor.
absolute_sensor_position_x double(255,5) NOT NULL The sensor UTM x coordinate (easting).
absolute_sensor_position_y double(255,5) NOT NULL The sensor UTM y coordinate (northing).
absolute_sensor_position_z double(255,5) NOT NULL The sensor altitude (above mean sea level) in meters.
sampling_time_utc time NOT NULL
sampling_date date NOT NULL
left_utc double(255,5) NOT NULL
left_elevation double(255,5) NOT NULL
left_long double(255,7) NOT NULL
left_lat double(255,7) NOT NULL
long_zone text NOT NULL
lat_zone text NOT NULL
left_utm_x double(255,5) NOT NULL
left_utm_y double(255,5) NOT NULL
right_utc double(255,5) DEFAULT NULL
right_elevation double(255,5) DEFAULT NULL
right_long double(255,7) DEFAULT NULL
right_lat double(255,7) DEFAULT NULL
right_utm_x double(255,5) DEFAULT NULL
right_utm_y double(255,5) DEFAULT NULL
sensor_offset_x_from_left_gps double(255,5) DEFAULT NULL
sensor_offset_y_from_left_gps double(255,5) DEFAULT NULL
sensor_offset_z_from_left_gps double(255,5) DEFAULT NULL
note longtext