Open
Description
@PieterjanVerhelst @jreubens Here's a table of the fields that we used to have in get_detections() compared with the actual fields in the detections table of the database. Can you let me know for the elements in bold what to do?
| what we used to have | what is in detections table | remarks |
|---|---|---|
| detection_id |
pk | ok |
| date_time | date_time | ok |
| receiver_id | receiver | ok |
| - | receiver_serial | redundant |
| - | deleted | |
| network_project_code | - | included via deployment |
| (acoustic_)tag_id | transmitter | ok |
| - | transmitter_name | redundant |
| - | transmitter_serial | include, but via tag |
| - | deleted | |
| animal_id | - | included via tag > animal |
| animal_project_code | - | included via tag > animal |
| scientific_name | - | included via tag > animal |
| station_name | station_name | use deployment.station_name instead |
| deploy_latitude | latitude | use deployment.deploy_lat instead |
| deploy_longitude | longitude | use deployment.deploy_long instead |
| sensor_type | no longer present | |
| sensor_value | sensor_value | ok |
| sensor_unit | sensor_unit | ok |
| - | sensor2_value | include |
| - | sensor2_unit | include |
| sensor_value_depth | no longer present | |
| sensor_value_acceleration | no longer present | |
| sensor_value_temperature | no longer present | |
| signal_to_noise_ratio | signal_to_noise_ratio | ok |
| source_file | file | ok |
| - | detection_file_id | not useful |
| qc_flag | qc_flag | ok |
| - | gain | not useful |
| - | external_id | not useful |
| deployment_id |
deployment_fk | ok |