Difference between revisions of "HTP Database Table Structure"
From Poland Lab Wiki
| Line 12: | Line 12: | ||
|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. | |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|||| | + | |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|||| | + | |sensor_observation||double(255,5)||NOT NULL||The measurement value recorded by the sensor.|| |
|- | |- | ||
| − | |position|| | + | |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|||| | + | |absolute_sensor_position_x||double(255,5)||NOT NULL||The sensor UTM x coordinate (easting). || |
|- | |- | ||
| − | |absolute_sensor_position_y||double(255,5)||NOT NULL|||| | + | |absolute_sensor_position_y||double(255,5)||NOT NULL||The sensor UTM y coordinate (northing). || |
|- | |- | ||
| − | |absolute_sensor_position_z||double(255,5)||NOT NULL|||| | + | |absolute_sensor_position_z||double(255,5)||NOT NULL||The sensor altitude (above mean sea level) in meters.|| |
|- | |- | ||
|sampling_time_utc||time||NOT NULL|||| | |sampling_time_utc||time||NOT NULL|||| | ||
Revision as of 21:08, 3 May 2016
| 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 | ||
| sampling_date | date | NOT NULL | ||
| left_utc | double(255,5) | NOT NULL | ||
| left_elevation | double(255,5) | NOT NULL | ||
| left_long | double(255,7) | NOT NULL | ||
| left_lat | double(255,7) | NOT NULL | ||
| long_zone | text | NOT NULL | ||
| lat_zone | text | NOT NULL | ||
| left_utm_x | double(255,5) | NOT NULL | ||
| left_utm_y | double(255,5) | NOT NULL | ||
| right_utc | double(255,5) | DEFAULT NULL | ||
| right_elevation | double(255,5) | DEFAULT NULL | ||
| right_long | double(255,7) | DEFAULT NULL | ||
| right_lat | double(255,7) | DEFAULT NULL | ||
| right_utm_x | double(255,5) | DEFAULT NULL | ||
| right_utm_y | double(255,5) | DEFAULT NULL | ||
| sensor_offset_x_from_left_gps | double(255,5) | DEFAULT NULL | ||
| sensor_offset_y_from_left_gps | double(255,5) | DEFAULT NULL | ||
| sensor_offset_z_from_left_gps | double(255,5) | DEFAULT NULL | ||
| note | longtext |
