[FEATURE]Improve validation for noven

[damhuonglan]

noven appears to be insufficient in validating values added to array and event tables. Users thinks it should be helpful to catch as many as possible the errors when the values are entered so the effort and time to run commands between noven and ph5validate will not be wasteful.

Current value checks in noven

• Check if all required columns are present. Error message: Missing column . Help:
  • Required columns for receivers: Array, id_s, deploy_time/ascii_s, pickup_time/ascii_s, das/serial_number_s, channel_number_i
  • Required columns for shots: id_s, location/X/value_d, location/Y/value_d, time/ascii_s
• Check each row to see if any column missing on that row. Error message: : Value of column does not match re/type/range. Help:<format/type/range>
• Check RE (format), type, range if available in the definition of that field. Error message: : Value of column does not match re/type/range. Help:<format/type/range>
• Some other warnings:
  • Distance between deployment and pickup locations seems large for station
  • time between deployment and pickup unusual for station

[hrotman-pic]

Thank you for looking up these checks, Lan. These checks look like they are older standards.

Suggestions of column checks to add for receivers: SEED channel name, SEED station name, location/X/value_d, location/Y/value_d, location/Z/value_d. I also think sensor manufacturer, sensor model, das manufacturer, and das model should be required, but some of these 4 checks may currently be only warnings in ph5_validate. Sensor model and das model are used in resp_load so I would think resp_load would not run correctly if those were missing.

Suggestions of column checks to add for shots: Array, location/Z/value_d.

I think it would also be good to discuss using the name station in place of receiver and the name event in place of shot. The PH5 documentation has moved this direction. The use of receiver is most likely to cause confusion because there is a Receiver_t that has a different function than the station/receiver table(s) Array_t.