[FEATURE] (Map) Filter by "experiment" & year

[Guilhembp]

• Filter expeditions by "experiment" and year

Here is the one file (produced by Noé and respecting his labelling system) that gathers all the sampling event sorted by country, date, experiment, region, and site.

On this file, the various projects are:

3D = 3D mapping
eDNA
MP = Marine Pollution
SG = Seascape genomics
Sam = Symbiont diversity
echi = echinoderms

We will use this file to show for each country all the sites that we explored and which project were done where.

It would therefore be good for you to use it to display the sampling site for Djibouti in 2022 and 2023, for 3D, eDNA and SG for now. You will have to split the table for each subcategories probably like we discussed with Manon (ex: 3D_2022, 3D_2023, eDNA_2022, eDNA_2023, SG_2022, SG_2023)

All_projects_timeline.xlsx

[charlottegiseleweil]

Hi @Guilhembp - (playing the role of data manager here ^^)
the file All_projects_timeline.xlsx replaces the old "Expeditions.xls" ? (If so, should be named and formatted the same for coherence, and to avoid re-formatting the code on our end every time).

[Guilhembp]

Hi @charlottegiseleweil,

I would rather have this new file only (All_projetcs_timeline.xlsx, made by Noé with the standard labelling system), which we will update from then on with new expeditions, and other activities like monitoring work.

Thanks

[charlottegiseleweil]

@QuentinEschmann can't access Noe's latest standard labeling system, and the new file doesn't match the format of the previous standard defined. Can you share again @Guilhembp the new standard? thank you !

[QuentinEschmann]

Changes between the old and the new dataset

• column name changed
  • Event_ID becomes event_id
  • Reef becomes reef_area
  • Site_Name becomes sampling_site_name
  • Project_Code becomes experiment
  • Team_Members becomes team_members
• deleted column
  • Project_Name
• added column
  • country
  • country_abbr
  • expe_name
  • region_name
• data format
  • hour : hh:mm or hh:mm:ss
  • date : dd.mm.yyyy or yyyy-mm-dd
• other
  • comments are not in the same row
  • event_id isnt unique anymore

[Guilhembp]

Hi @QuentinEschmann , good job on spotting the error! Indeed, lines where moved down, and now it is fixed (after careful inspection)

Here is therefore the corrected file with all experiments:

All_projects_timeline.xlsx

I uploaded the new version of this file on the OneDrive.

[QuentinEschmann]

Hi @Guilhembp, thank you for the data correction ! Are you sure that the comments are at the right place though ? When comparing to Expeditions.xlsx file, I think comments near the end of All_projects_timeline.xlsx are also one row above where they were.

[Guilhembp]

Hi @QuentinEschmann , yes no worries - I did not check by the comments (which are irrelevant for the webmap anyway), I checked by the timestamp and GPS coordinates of each dive.

Therefore, I am 99.9% confident the table is now fixed.

Regarding the visualisation of the sampling sites on the map, I would suggest in the legend to allow the user to select the site per year and / or per experiments

for example, I could only visualise the sampling sites for 3D mapping in Djibouti, or only for SG or eDNA.

Also I could only visualise the site of 2022 or of 2023.

[Guilhembp]

Hey guys, sorry but after checking, I found to more small mistakes in the All_projects_timeline.xlsx, so I am working hard now to fix all and to make sure the file of 3D mapping data which @guilbep is using for the data visualisation.

Sorry for the delay, will be fixed once we have a data manager.

[Guilhembp]

Hi all,

here are the new versions of the files (which I am also uploading to the OneDrive):

All_projects_timeline.xlsx

DJI_3D_mapping_all_results.xlsx

We have triple checked them, and I have made sure the two files have unified format