Phemu htp table
From Poland Lab Wiki
| 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_date_start_time_<end_date>_<end_time>. |
text | Y | |
| plot_id | 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. |
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 |
