HTP Database Table Structure
From Poland Lab Wiki
| 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 | 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. |
