search

inbo / fish-tracking

🐟 Collection of scripts for processing and analysing fish tracking data
3 stars 0 forks source link

Receivers without project #34

Open peterdesmet opened 9 years ago

peterdesmet commented 9 years ago

A number of receivers have no project. In receiver_code it is indicated:

uitgehaald BH; kan ingezet worden op nieuw project

  1. Wouldn't this be better placed in remarks?
  2. The projectname can be kept
  3. removed_at should be populated
  4. Do we have latitude/longitudes for these?
PieterjanVerhelst commented 9 years ago

Indeed, however, when selecting receivers from a certain study, this can become difficult as some receivers will switch project (which will happen more often in the future as new projects arise). For example, project Boekhoute has finished, so the receivers are used for another project. As such, the project name of the respective receiver will be changed to the new project name. When one would like to export the spreadsheet with all receivers from Boekhoute, he has to trace back were translocated receivers came from. Therefore, it might be interesting to put removed receivers in a new row, adding the project name 'NONE' so we know these receivers are available for other projects. Here, all columns can be filled in as FALSE or just blanks.

IPauwels commented 9 years ago

Sorry for interfering, but I agree that it would be better to keep an overview of which receivers were used in each project. From the moment a receiver is removed from the field, it gets a new row in the dataset as Pieterjan proposes. Subsequently, the column removed_at in the "old row" should be completed and column is_active should be changed from TRUE to FALSE. From the moment the receiver is used in the field again (in a new project or even in the same project but at a different location), the column of the project name can be changed from 'NONE' to the new project name and all other columns can be completed.

This allows us to make maps of (and keep the info on) the receiver network of projects that were already finished and for which the receivers were already removed from the field.

peterdesmet commented 9 years ago

@IPauwels, I agree completely: that way we can keep historic information (which is useful for analysis). Would it be possible to update the metadata as such?

karenrobberechts commented 9 years ago

I added 'NONE' in the column 'project' and updated the data.