Difference between revisions of "HTP Database Table Structure"

From Poland Lab Wiki
Jump to: navigation, search
(Blanked the page)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{|class="wikitable"
+
 
|+Table Name: phemu_htp
+
!style="text-align:center;"|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.<br />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.<br /> Note that this may be null if the observation was taken in a position not over a plot.
+
|-
+
|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_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||The UTC time that the sensor observation was recorded.|||
+
|-
+
|sampling_date||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 the 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.||
+
|}
+

Latest revision as of 16:24, 12 May 2016