Difference between revisions of "Phemu htp table"

From Poland Lab Wiki
Jump to: navigation, search
(Created page with "{|class="wikitable" |+Table Name: phemu_htp !style="text-align:center;"|Column Name !Description !Data Type !Required? <br />(Y/N) !Constraints |- | record_id...")
 
m
 
Line 9: Line 9:
 
|        record_id                || A sequential number generated when record is inserted. Used as a synthetic prim|| integer    || Y          || Unique sequential integer
 
|        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.<br />Format: <platform>_<start_da|| text      || Y          ||
+
|        run_id                  || An ID used to identify a data collection run.<br />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.<br /> Note|| char(10)  || N          ||
+
|        plot_id                  || 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.|| 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_id                || The identifier associated with the sensor used in the data collection.        || text      || Y          || Should match sensor_id in the htp_instrument table

Latest revision as of 18:41, 12 May 2016

Table Name: phemu_htp
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