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 - 6

0 (0 Likes / 0 Dislikes)
Okay, we're ready to calculate our summary statistics. We're going to calculate the expected number of species via this formula. And, the completeness of the inventory via this one. Then, we will save our worksheet and our data file, and import it into QGIS for visualization. Here we go. Create a column for expected number of species: 'Sexp'. That will be equal to the observed number (Sobs) plus the square of the singletons (A) divided by two times the number of doubletons (B). Sexp will be undefined when there are no doubletons (B=0). Extend that formula down the length of the column. Now, let's calculate the completeness index (C). C is the ratio of observed (Sobs) and expected (Sexp). Extend that formula down the length of the column. Again, a number of those are undefined. But, there are some that are defined. This is a statement that this inventory is projected to be 47% complete. Those are the final calculations in Excel. Save the workbook. The summary sheet will be used for analyses in QGIS. I'm going to remove those rows that have an undefined Sexp or C. We can do this because they won't be visible. Also, they may confuse the GIS program. So, I'm going to get rid of those rows completely. And, I'll export this particular table as a CSV file. Go to QGIS. Import that CSV file as a table. Check 'No geometry' And, there we have our table. Link grid ID of the table to grid ID in the ½ degree aggregation grid. Open the ½ degree grid layer properties. Go to 'Joins' Add a join. Join layer is the table you just added. There are the two fields. Join field is the field in the join layer. And, target field is in the ½ degree grid. Check that the join is correct. Okay. Now, we can visualize by the values of those metrics, such as the completeness indices (C). I can specify a color ramp. And, I can classify the value range. Let's this. There we go. And, there you have a map of the degree of knowledge in terms of completeness. That essentially gives us a view of inventory quality.

Video Details

Duration: 4 minutes and 21 seconds
Language: English
License: Dotsub - Standard License
Genre: None
Views: 1
Posted by: townpeterson on Jul 26, 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.