CEAMARC-CASO Event List of voyage 3 of the Aurora Australis, 2007-2008

Two components. The first component is an even log for all station and instrument deployements. The second component is a log where start and end bottom times need to be recorded for instruments for example the benthic trawl. There is one file for each of the logs. Both logs need to be ideally merged into one to have one data source of event information. The start and end bottom times need to ideally go into the event logging system on the ship.

1) Event log for stations and all instrument deployments

Stations and instrument deployments were recorded (including failures) over the progress of the voyage to provide a summary of all work carried out over voyage and and assigned an Event ID number for referencing data associated with these events.

Data_Format

Data was initially recorded in the ship board PostgreSQL database. Data was exported as a comma delimited file 'events.csv' at the end of the voyage.

Column 1 - Setcode (voyage identifier of the form 200708030 meaning year 2007-08, voyage 3)

Column 2 - Voyage Code (text voyage identifier)

Column 3 - Transect ID (transect identifier, no transects were identified this voyage)

Column 4 - Station ID (Station identifier, blank for events not associated with a station, CEAMARC project stations are pre-pended with 'CEAMARC', CASo stations are pre-pended with 'CASO', sampling near icebergs for trace metals pre-pended with 'ICEBERG', woCE SR3 transect sampling pre-pended with 'SR3').

Column 5 - Event ID (unique ID across voyage for individual events)

Column 6 - Event Type (usually the instrument deployed, self explanatory. One event type 'Plankton Water Sample' refers to mass water sampling undertaken for genomics work).

Column 7 - User Reference (id used by individual scientists to reference their data for this event. If left blank they are using the auto assigned event id from this table).

Column 8 - Start Timestamp (start timestamp of the event in UTC).

Column 9 - Start Latitude (start latitude of the event from the ship gps)

Column 10 - Start Longitude (start longitude of the event from the ship gps)

Column 11 - Start Bottom Depth (bottom depth at the start time of the event in metres from EK60 sounder bathymetry export)

Column 12 - End Timestamp (end timestamp of the event in UTC)

Column 13 - End Latitude (end latitude of the event from the ship gps)

Column 14 - End Longitude (end longitude of the event from the ship gps)

Column 15 - Duration (duration of the event in hours)

Column 16 - End Bottom Depth (bottom depth at the end time of the event in metres from EK60 sounder bathymetry export)

Column 17 - Min bottom Depth (minimum bottom depth encountered over event period from EK60 sounder bathymetry export)

Column 17 - Avg Bottom Depth (average bottom depth encountered over event period from EK60 sounder bathymetry export)

Column 18 - Max Bottom Depth (maximum bottom depth encountered over event period from EK60 sounder bathymetry export)

Column 19 - Author (person who entered event details into logging system)

Column 20 - Notes (notes peculiar to the event, may be blank)

2) Log of instrument bottom times.

Excel spreadsheet 'Trawl_log_18_Jan_08_final.xls'

Column A - Station number, these are all CEAMARC station numbers, matching stations in the event log pre-pended by 'CEAMARC'.

Column B - Event ID (matching event log, sometimes blank as this log an contain entries on intended events that did not get carried out for some reason or another)

Column C - Trawl Name (labelled trawl name, actually event type as the log started off with just trawl start/end bottom times, but was expanded to encompass other event types like grabs etc.)

Column D - Date of the event.

Column E - Ship Speed (in knots from displays of gps speed).

Column F - Time instrument hit the water in utc

Column G - Time instrument reached the bottom in utc.

Column H - Time instrument left the bottom (i.e. hauling started) in utc.

Column I - Time instrument on the deck (ie out of the water)

Column J - Depth in meters read of EK60 sounder display (could be any time during event).

Column K - Comments pertaining to the event.

本数据集包含两个组成部分。第一部分为所有站位与仪器部署的完整日志；第二部分为需记录仪器（例如底拖网设备）的水底作业起止时间的日志。两类日志各对应一个单独文件，理想情况下应将两份日志合并为单一事件信息数据源，且水底作业起止时间最好录入船舶端的事件记录系统。

1）站位与全仪器部署事件日志
本日志记录了航次执行全程中所有站位布设、仪器部署情况（含作业失败案例），旨在汇总航次全部作业内容，并为各事件分配唯一事件编号（Event ID），以便关联引用该事件相关的数据。

数据格式
数据最初录入船舶端PostgreSQL数据库，航次结束后导出为逗号分隔格式文件"events.csv"。

各列说明如下：
第1列：Setcode（航次标识符，格式如"200708030"，代表2007年8月，第3航次）
第2列：Voyage Code（文本型航次标识符）
第3列：Transect ID（断面标识符，本次航次未设置断面）
第4列：Station ID（站位标识符，未关联站位的事件留空。CEAMARC项目站位前缀为"CEAMARC"，CASo项目站位前缀为"CASO"；冰山附近重金属采样站位前缀为"ICEBERG"；woCE SR3断面采样站位前缀为"SR3"）
第5列：Event ID（本次航次内各事件的唯一编号）
第6列：Event Type（事件类型，通常为布设的仪器类型，含义直观。其中"Plankton Water Sample"事件类型指用于基因组学研究的批量水体采样作业）
第7列：User Reference（科学家个人用于引用本次事件数据的自定义编号，若留空则使用本表自动分配的事件编号）
第8列：Start Timestamp（事件开始时间戳，采用协调世界时（UTC））
第9列：Start Latitude（事件开始时的纬度，取自船舶GPS数据）
第10列：Start Longitude（事件开始时的经度，取自船舶GPS数据）
第11列：Start Bottom Depth（事件开始时刻的水底深度，单位为米，数据取自EK60测深仪的水深导出结果）
第12列：End Timestamp（事件结束时间戳，采用协调世界时（UTC））
第13列：End Latitude（事件结束时的纬度，取自船舶GPS数据）
第14列：End Longitude（事件结束时的经度，取自船舶GPS数据）
第15列：Duration（事件持续时长，单位为小时）
第16列：End Bottom Depth（事件结束时刻的水底深度，单位为米，数据取自EK60测深仪的水深导出结果）
第17列：Min bottom Depth（作业时段内遇到的最小水底深度，单位为米，数据取自EK60测深仪的水深导出结果）
第18列：Avg Bottom Depth（作业时段内遇到的平均水底深度，单位为米，数据取自EK60测深仪的水深导出结果）
第19列：Max Bottom Depth（作业时段内遇到的最大水底深度，单位为米，数据取自EK60测深仪的水深导出结果）
第20列：Author（将事件详情录入记录系统的人员姓名）
第21列：Notes（本次事件的专属备注，可留空）

2）仪器水底作业时长日志
数据文件为Excel电子表格"Trawl_log_18_Jan_08_final.xls"。

各列说明如下：
列A：Station number（站位编号，均为CEAMARC项目站位编号，与事件日志中前缀为"CEAMARC"的站位匹配）
列B：Event ID（与事件日志中的编号匹配，部分条目留空，因本日志可包含因故未实际执行的计划作业）
列C：Trawl Name（拖网名称标签，实际为事件类型，因本日志最初仅记录拖网的水底作业起止时间，后扩展至包含拖网、采泥器等其他事件类型）
列D：Date of the event（事件发生日期）
列E：Ship Speed（船舶航速，单位为节，取自GPS航速显示数据）
列F：Time instrument hit the water in utc（仪器入水时间，采用协调世界时（UTC））
列G：Time instrument reached the bottom in utc（仪器抵达水底时间，采用协调世界时（UTC））
列H：Time instrument left the bottom (i.e. hauling started) in utc（仪器离开水底的时间，即开始起吊的时间，采用协调世界时（UTC））
列I：Time instrument on the deck (ie out of the water)（仪器回到甲板的时间，即脱离水体的时间）
列J：Depth in meters read of EK60 sounder display（EK60测深仪显示屏读取的水深值，可为作业时段内任意时刻的读数）
列K：Comments pertaining to the event（本次事件相关备注）