Difference between revisions of "HTP Database Table Structure"
From Poland Lab Wiki
| Line 19: | Line 19: | ||
| position || GIS spatial representation of the x,y UTM coordinates of the sensor. || point || 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_time_utc || The UTC time that the sensor observation was recorded. || time || Y || | ||
| Line 57: | Line 57: | ||
| right_utm_y || 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 || | | note || Optional notes related to the observation. || longtext || N || | ||
|} | |} | ||
Revision as of 14:47, 4 May 2016
| 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_da |
text | Y | |
| plot_id | The name of the plot that the sensor observation is associated with. Note |
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 |
