Table T28. PWS3 query with output raw data option.
Item name
Janus table
Janus column name and calculation
Leg SECTION Leg
Site SECTION Site
Hole SECTION Hole
Core SECTION Core
Type SECTION Core_type
Section SECTION Section_number
Top (cm) PWS3_SECTION_DATA PP_Top_Interval x 100
Bottom (cm) PWS3_SECTION_DATA PP_Bottom_Interval x 100
Depth (mbsf) DEPTH_MAP, PWS3_SECTION_DATA DEPTH_MAP.Map_Interval_Top + PWS_SECTION_DATA.PP_Top_Interval
Direction PWS3_SECTION Direction
Velocity (m/s) PWS3_SECTION_DATA PWS3_Velocity
Run Number PWS3_SECTION Run_Num
Run Date/Time PWS3_SECTION Run_Date_Time (yyyy-mm-dd hh:mm)
Core Temp (C) PWS3_SECTION_DATA Core_temperature
Raw Data PWS3_SECTION Raw_data_collected
Measurement No. PWS3_SECTION_DATA Measurement_no
Separation Mean (mm) PWS3_SECTION_DATA Meas_separation_mean
Time Mean (µs) PWS3_SECTION_DATA Meas_time_mean
Calib. Date/Time PWS3_CALIBRATION Calibration_Date_Time (yyyy-mm-dd hh:mm)
Liner Correction PWS3_SECTION Liner_Correction
Standard PHYSICAL_PROPERTIES_STANDARD Standard_name
Standard Set PHYSICAL_PROPERTIES_STANDARD Standard_set_name
Standard Expected PHYSICAL_PROPERTIES_STD_DATA Property_value
Contact Pressure (kPa) PWS3_SECTION_DATA Contact_pressure
Liner thickness (mm) PWS3_SECTION_DATA Liner_thickness
Calib. Delay M0 PWS3_CALIBRATION Delay_m0
Calib. Delay 1/M1 PWS3_CALIBRATION Delay_1_over_m1
Calib. Delay Mean Square Error PWS3_CALIBRATION Delay_mse
Calib. Separation M0 PWS3_CALIBRATION Separation_m0
Calib. Separation M1 PWS3_CALIBRATION Separation_m1
Calib. Separation Mean Square Error PWS3_CALIBRATION Separation_mse