|
|
| (4 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 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.||
| + | |
| − | |}
| + | |
