Create get_cpod_deployments()

[peterdesmet]

• [x] SQL: define field names
• [ ] SQL: define field order
• [x] ~SQL: make use of view~
• [x] Function: include SQL
• [x] Function: update parameters (queries)
• [x] Function: update documentation
• [x] Tests: new order
• [x] Tests: coverage
• [x] Tests: pass

[peterdesmet]

@jreubens @PieterjanVerhelst or someone else: can you confirm the columns the get_cpod_deployments() should return? I started with all the columns returned by get_acoustic_deployments() plus some specific cpod ones. Especially the remarks in bold are important.

column	example value	action
deployment_id	12739	include
receiver_id	POD-3330	include
cpod_project_code	cpod-lifewatch	include
station_name	AP_bpns-Grafton	include
station_description	empty for all	include? seems like this might get used
station_manager	empty for all	include? seems like this might get used
deploy_date_time	2021-07-05 08:00:00	include
deploy_latitude	51.40645	include
deploy_longitude	2.818500	include
intended_latitude	empty for all	remove
intended_longitude	empty for all	remove
mooring_type	bottom-mooring	include
bottom_depth	empty for all	remove
riser_length	empty for all	remove
deploy_depth	empty for all	remove
battery_installation_date	empty for all	remove
battery_estimated_end_date	2014-10-17 10:00:00	include
activation_date_time	2014-07-16 15:54:00	include
recover_date_time	2014-09-22 00:00:00	include
recover_latitude	empty for all	remove
recover_longitude	empty for all	remove
download_date_time	2017-03-31 08:32:00	include
download_file_name	empty for all	remove
valid_data_until_date_time	2014-09-19 19:25:00	include
sync_date_time	empty for all	remove
time_drift	empty for all	remove
ar_battery_installation_date	empty for all	remove
ar_confirm	empty for all	remove
transmit_profile	empty for all	remove
transmit_power_output	empty for all	remove
log_temperature_stats_period	empty for all	remove
log_temperature_sample_period	empty for all	remove
log_tilt_sample_period	empty for all	remove
log_noise_stats_period	empty for all	remove
log_noise_sample_period	empty for all	remove
log_depth_stats_period	empty for all	remove
log_depth_sample_period	empty for all	remove
comments	60m rope multipurpose frame	include
acoustic_release_number	12744	include is this a foreign key?
hydrophone_cable_length	1	include
hydrophone_sensitivity	-170	include
amplifier_sensitivity	3.16 mV	include
sample_rate	192000	include
recording_name	\archive\other_platforms\b&k\COVID-19\20200608_SailingTrip\Nautica Ena_3.16	include? is this useful?

Any advice on a logical order for the columns acoustic_release_number to recording_name and where to insert them compared to the other columns would be useful too.

[PieterjanVerhelst]

No expertise on this, so will leave this one to @jreubens. Or actually Elisabeth could answer this.

[peterdesmet]

@debusscheree as mentioned on the LifeWatch Biodiversity Day, I’m tagging you here to give feedback on the table above. See the ”action” column.