Difference between revisions of "HTP Database Table Structure"

From Poland Lab Wiki
Jump to: navigation, search
Line 24: Line 24:
 
|absolute_sensor_position_z||double(255,5)||NOT NULL||The sensor altitude (above mean sea level) in meters.||
 
|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_time_utc||time||NOT NULL|The UTC time that the sensor observation was recorded.|||
 
|-
 
|-
|sampling_date||date||NOT NULL||||
+
|sampling_date||date|NOT NULL||The UTC date that the sensor observation was recorded||
 
|-
 
|-
|left_utc||double(255,5)||NOT NULL||||
+
|left_utc||double(255,5)||NOT NULL||The UTC time on the left GPS when the sensor observation was recorded.||
 
|-
 
|-
|left_elevation||double(255,5)||NOT NULL||||
+
|left_elevation||double(255,5)||NOT NULL||The left GPS altitude (above mean sea level) in meters.||
 
|-
 
|-
|left_long||double(255,7)||NOT NULL||||
+
|left_long||double(255,7)||NOT NULL||The left GPS longitude.||
 
|-
 
|-
|left_lat||double(255,7)||NOT NULL||||
+
|left_lat||double(255,7)||NOT NULL||The left GPS latitude.||
 
|-
 
|-
|long_zone||text||NOT NULL||||
+
|long_zone||text||NOT NULL||The longitude zone of the left GPS e.g. 14.||
 
|-
 
|-
|lat_zone||text||NOT NULL||||
+
|lat_zone||text||NOT NULL||The latitude zone of teh left GPS e.g. S.||
 
|-
 
|-
|left_utm_x||double(255,5)||NOT NULL||||
+
|left_utm_x||double(255,5)||NOT NULL||The UTM x position of the left GPS.||
 
|-
 
|-
|left_utm_y||double(255,5)||NOT NULL||||
+
|left_utm_y||double(255,5)||NOT NULL||The UTM y position of the left GPS.||
 
|-
 
|-
|right_utc||double(255,5)||DEFAULT NULL||||
+
|right_utc||double(255,5)||DEFAULT NULL||The UTC time on the right GPS when the sensor observation was recorded.||
 
|-
 
|-
|right_elevation||double(255,5)||DEFAULT NULL||||
+
|right_elevation||double(255,5)||DEFAULT NULL||The right GPS altitude (above mean sea level) in meters.||
 
|-
 
|-
|right_long||double(255,7)||DEFAULT NULL||||
+
|right_long||double(255,7)||DEFAULT NULL||The right GPS longitude.||
 
|-
 
|-
|right_lat||double(255,7)||DEFAULT NULL||||
+
|right_lat||double(255,7)||DEFAULT NULL||The right GPS latitude.||
 
|-
 
|-
|right_utm_x||double(255,5)||DEFAULT NULL||||
+
|right_utm_x||double(255,5)||DEFAULT NULL||The UTM x position of the right GPS.|||
 
|-
 
|-
|right_utm_y||double(255,5)||DEFAULT NULL||||
+
|right_utm_y||double(255,5)||DEFAULT NULL||The UTM x position of the right GPS.||
 
|-
 
|-
|sensor_offset_x_from_left_gps||double(255,5)||DEFAULT NULL||||
+
|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_y_from_left_gps||double(255,5)||DEFAULT NULL||||
+
|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_z_from_left_gps||double(255,5)||DEFAULT NULL||||
+
|sensor_offset_z_from_left_gps||double(255,5)||DEFAULT NULL||The z distance offset from the sensor and the left GPS in cm.||
 
|-
 
|-
|note||longtext||||
+
|note||longtext||Optional notes related to the observation.||
 
|}
 
|}

Revision as of 21:18, 3 May 2016

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 The UTC time that the sensor observation was recorded.
sampling_date NOT NULL The UTC date that the sensor observation was recorded
left_utc double(255,5) NOT NULL The UTC time on the left GPS when the sensor observation was recorded.
left_elevation double(255,5) NOT NULL The left GPS altitude (above mean sea level) in meters.
left_long double(255,7) NOT NULL The left GPS longitude.
left_lat double(255,7) NOT NULL The left GPS latitude.
long_zone text NOT NULL The longitude zone of the left GPS e.g. 14.
lat_zone text NOT NULL The latitude zone of teh left GPS e.g. S.
left_utm_x double(255,5) NOT NULL The UTM x position of the left GPS.
left_utm_y double(255,5) NOT NULL The UTM y position of the left GPS.
right_utc double(255,5) DEFAULT NULL The UTC time on the right GPS when the sensor observation was recorded.
right_elevation double(255,5) DEFAULT NULL The right GPS altitude (above mean sea level) in meters.
right_long double(255,7) DEFAULT NULL The right GPS longitude.
right_lat double(255,7) DEFAULT NULL The right GPS latitude.
right_utm_x double(255,5) DEFAULT NULL The UTM x position of the right GPS.
right_utm_y double(255,5) DEFAULT NULL The UTM x position of the right GPS.
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_y_from_left_gps double(255,5) DEFAULT NULL The x distance offset from the sensor and the left GPS in cm.
sensor_offset_z_from_left_gps double(255,5) DEFAULT NULL The z distance offset from the sensor and the left GPS in cm.
note longtext Optional notes related to the observation.