Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

BITC / NBD protocol - 4

0 (0 Likes / 0 Dislikes)
Our next step is to calculate the observed number of species: <i>Sobs</i>. That is addressed in this portion of the protocol. We'll go back to Excel. Go to the 'Working' sheet. Copy the whole working dataset and paste it into a new sheet. Remember, for <i>Sobs</i> we just need the total number of species known from a particular site. So, remove the time stamp. Sorry about that. Get rid of the time stamp. Now all we have is grid ID and species. Highlight the entire dataset. Go to 'Data' --> 'Advanced Filter' Check 'Unique records only'. In a moment, you will see records that appear to be the same species in the same grid square collapse. So, we eliminated the time stamp which allows us to collapse the number of records for each grid square to records of distinct species. Of course, this is taking awhile. There we go. Notice the line numbers. Line 6 goes to line 8. Line 7 disappeared because that was not a unique record. Copy the new dataset into yet another new sheet. That gives me now, only the unique records of species and grid ID. Finally, I'll do another pivot table. Count the number of records for each coarse grid cell. Species name is the only thing that makes for non-unique records within a grid cell. So, these counts should be useful. Copy and append this table to our summary table. Check that row IDs are all the same. It looks like they are. Remove column C (the duplicate column of row IDs) Rename the new column C <i>Sobs</i>. That gives us our observed number of species for each grid square. Notice that there are some grid cells where there are 2 records of 2 species; and, there are others that have many records of many species.

Video Details

Duration: 3 minutes and 22 seconds
Language: English
License: Dotsub - Standard License
Genre: None
Views: 2
Posted by: townpeterson on Aug 30, 2016

This video gives a step-by-step through the protocol being used in the course on National Biodiversity Diagnoses, an advanced course focused on developing summaries of state of knowledge of particular taxa for countries and regions. The workshop was held in Entebbe, Uganda, during 12-17 January 2015. Workshop organized by the Biodiversity Informatics Training Curriculum, with funding from the JRS Biodiversity Foundation.

Caption and Translate

    Sign In/Register for Dotsub to translate this video.