This document is a brief report of the trees that will be affected by the current road widening project in Naga City. The data presented is part of the partial tree inventory/census along the main roads in Naga City.The data described in this paper came from the data generated by fieldwork activities conducted from December 05, 2017 to May 23, 2019 and included portions of the 17 barangays in Naga City.
The past fieldwork activities for this Citizen Science project were participated by volunteers from They Grey We Green, SULOG (Sumaro sa Salog), private individuals, environmental management students, citizen scientists, and headed by the Institute for Environmental Conservation and Research of the Ateneo de Naga University (ADNU-INECAR).
Tree census was facilitated using a Kobo Collect android application developed in part by the INECAR team. Using the application, the volunteers geotag the trees and input important information from each of the trees, like the species or local name and the barangay where it is located. In addition, the volunteers also took pictures of the trees to aid in the validation of species. After fieldwork, the volunteers sent their files online, to a cloud server that can be accessed through a web application, the KoboToolbox.
For this report, data from the server was exported and downloaded for very basic data cleaning and processing using R and RStudio. Please note that the data presented only refers to the trees in Barangays Liboton, San Felipe, and Pacol that will be affected by the current road widening project in Naga City. Please understand that this is a beta version of a future more comprehensive visualization of Trees in the City, as the author is still not done cleaning and cross checking the current 2082 tree entries. Furthermore, this document was also created using the said software.
Data Summary
Here is a sample of tree data that the Project has:
## V1 latitude longitude date barangay local_name
## 1: 1 13.65725 123.2418 2019-05-17 Pacol Others, pls. specify
## 2: 2 13.65723 123.2420 2019-05-17 Pacol Others, pls. specify
## 3: 3 13.65183 123.2346 2019-05-02 Pacol Others, pls. specify
## 4: 4 13.65187 123.2347 2019-05-02 Pacol Others, pls. specify
## 5: 5 13.65671 123.2410 2019-05-17 Pacol Others, pls. specify
## 6: 6 13.65676 123.2410 2019-05-17 Pacol Others, pls. specify
## initial_id gbh height canopy_spread tree_condition
## 1: Phyll 0.07 NA NA
## 2: Calachuchi 0.11 0.1 NA
## 3: Malunggay 0.25 NA NA
## 4: Bunliw 0.80 NA NA With vines
## 5: Phyllanthaceae 0.10 NA NA Forked, 0.07
## 6: Acanthaceae 0.03 NA NA
## maintenance_needs watering_needs pruning_needs
## 1: NA NA
## 2: Needs watering TRUE FALSE
## 3: Needs watering Needs pruning/trimming TRUE TRUE
## 4: NA NA
## 5: NA NA
## 6: NA NA
## other_maintenance_needs mnspecified special_characteristics fruiting
## 1: NA With epiphytes/vines/orchids FALSE
## 2: FALSE NA
## 3: FALSE NA
## 4: NA With epiphytes/vines/orchids FALSE
## 5: NA Fruiting TRUE
## 6: NA With epiphytes/vines/orchids FALSE
## flowering host habitat other_special_characteristics scspecified
## 1: FALSE TRUE FALSE 0
## 2: NA NA NA NA
## 3: NA NA NA NA
## 4: FALSE TRUE FALSE 0
## 5: FALSE FALSE FALSE 0
## 6: FALSE TRUE FALSE 0
## characteristics
## 1: Phyllanthus
## 2: Kalachuchi
## 3: Malunggay
## 4: Bunliw
## 5: Phyllanthus
## 6: Acanthaceae
Liboton
Please note that these may no longer reflect the actual number of trees found in Liboton as of today, as some of the trees had already been removed since the census was conducted at least a year ago.
## characteristics N
## 1: Mango 6
## 2: Gmelina 6
## 3: Acacia 5
## 4: Coconut 5
## 5: Talisay 4
## 6: Pili 4
## 7: Narra 3
## 8: Palmera 3
## 9: Bunliw 2
## 10: Mahogany 2
## 11: Santol 2
## 12: Baligang 1
## 13: Lubi lubi 1
## 14: Kamachile 1
## 15: Dita 1
## 16: Langka 1
## 17: Unidentified 1
## 18: Lemonsito 1
## 19: Tabog 1
## 20: Malunggay 1
## 21: Lukban 1
## 22: Miracle Plant 1
## characteristics N
Total affected roadside trees in Liboton:
## [1] 53
Aside from the whole stretch of Liboton, the current tree-cutting permits include portion of the Pacol Road starting from the corner of the entrance of Cokeville in Barangay San Felipe, to the portion of the road that took a sharp curve towards Barangay Pacol,and up until the area around MNWD’s pumping station in the same barangay.
San Felipe
## characteristics N
## 1: Mango 30
## 2: Narra 22
## 3: Anabiong 18
## 4: Talisay 17
## 5: Acacia 17
## 6: Malunggay 16
## 7: Minunga 13
## 8: Pili 12
## 9: Palmera 12
## 10: Gmelina 11
## 11: Unidentified 10
## 12: Tabog 10
## 13: Langka 8
## 14: Indian Tree 8
## 15: Golden Shower 7
## 16: Cacao 5
## 17: Ipil-ipil 5
## 18: Caimito 4
## 19: Guyabano 4
## 20: Coconut 3
## 21: Bayawas 3
## 22: Baligang 3
## 23: Santol 3
## 24: Papaya 3
## 25: Lukban 2
## 26: Kamias 2
## 27: Mahogany 2
## 28: Balete 2
## 29: Avocado 2
## 30: Fire Tree 2
## 31: Kayo 2
## 32: Agoho 2
## 33: Aranghita 1
## 34: Sampaloc 1
## 35: Bamboo 1
## 36: Ogob 1
## 37: Sinigwelas 1
## 38: Kamagong 1
## 39: Lamio 1
## 40: Sterculia 1
## 41: Kalachuchi 1
## 42: Balingbing 1
## 43: Chaya 1
## characteristics N
Total affected roadside trees in San Felipe:
## [1] 271
Pacol
## characteristics N
## 1: Malunggay 91
## 2: Tabog 65
## 3: Cacao 64
## 4: Kayo 61
## 5: Unidentified 57
## 6: Mango 45
## 7: Gmelina 45
## 8: Caimito 43
## 9: Narra 43
## 10: Santol 32
## 11: Ipil-ipil 30
## 12: Acacia 29
## 13: Langka 29
## 14: Minunga 22
## 15: Coconut 22
## 16: Palmera 19
## 17: Phyllanthus 17
## 18: Papaya 14
## 19: Pili 12
## 20: Batag Kabalang 9
## 21: Malubago 9
## 22: Bunliw 8
## 23: Lamio 7
## 24: Atis 7
## 25: Guyabano 7
## 26: Kalachuchi 6
## 27: Ogob 6
## 28: Acanthaceae 5
## 29: Bayawas 5
## 30: Amugis 5
## 31: Chaya 4
## 32: Talisay 4
## 33: Kamias 4
## 34: Lubi lubi 4
## 35: Lemonsito 3
## 36: Lukban 3
## 37: Baligang 3
## 38: Kamagong 3
## 39: Balingbing 2
## 40: Schefflera 2
## 41: Golden Shower 2
## 42: Bugnay 2
## 43: Sampaloc 2
## 44: Urticaceae 1
## 45: Anabiong 1
## 46: Bamboo 1
## 47: Mahogany 1
## 48: Chesa 1
## 49: Anonang 1
## 50: Rubber Tree 1
## 51: Balete 1
## 52: Mabolo 1
## 53: Libas 1
## 54: Palomaria 1
## 55: Adgao 1
## 56: Cassava 1
## 57: Pine Tree 1
## 58: Tindalo 1
## characteristics N
Total affected roadside trees in Pacol:
## [1] 867
Map of Plotted Trees in the Three Barangays:
The author would like to thank all of the volunteers and citizen scientists who helped in the data gathering and the sponsors who have extended assistance to the researchers. The work in this project is still not done as we take on the task to continue to maintain and protect the Trees in Naga. The Writ of Continuing Mandamus ordered by the Court strengthens our call for sustainable development and resilient future, most importantly, in this time of Climate Emergency.
Volunteer as a citizen scientist!
This report was generated using the rudimentary coding skills that the author has. Help us make a better visualization. Send a pull request at link**
REFERENCES
R Core Team (2017). R: A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria. URLhttps://www.R-project.org/
packages used: dplyr, data.table, lubridate, reshape2, stringr, rmarkdown, and leaflet
H. Wickham. ggplot2: Elegant Graphics for Data Analysis. Springer-Verlag New York, 2016
JJ Allaire and Yihui Xie and Jonathan McPherson and JavierLuraschi and Kevin Ushey and Aron Atkins and Hadley Wickham and Joe Cheng and Winston Chang and Richard Iannone (2020).rmarkdown: Dynamic Documents for R. R package version 2.1. URLhttps://rmarkdown.rstudio.com.
Hadley Wickham, Romain Fran?ois, Lionel Henry and Kirill M?ller (2020). dplyr: A Grammar of Data Manipulation. R package version 1.0.0.https://CRAN.R-project.org/package=dplyr
Garrett Grolemund, Hadley Wickham (2011). Dates and Times Made Easy with lubridate. Journal of Statistical Software, 40(3), 1-25. URL http://www.jstatsoft.org/v40/i03/
Yihui Xie (2020). knitr: A General-Purpose Package for Dynamic Report Generation in R. R package version 1.29.
Yihui Xie (2015) Dynamic Documents with R and knitr. 2nd edition. Chapman and Hall/CRC. ISBN 978-1498716963
Yihui Xie (2014) knitr: A Comprehensive Tool for Reproducible Research in R. In Victoria Stodden, Friedrich Leisch and Roger D. Peng, editors, Implementing Reproducible Computational Research. Chapman and Hall/CRC. ISBN 978-1466561595