Plant Pathogens of Hawaii

##This checklist database is a collection of reports from 16 sources referenced in the "data_set" parameter. They consist of:

1. bishop museum: Data from the Bishop museum fungal database
2. board report: From National Agricultural Pest Information System (NAPIS) board reports
3. [bugwood](https://www.bugwood.org/plantdiseases.cfm): Widely prevalent Fungi, Bacteria, and Virues in Hawaii from bugwood database
4. CAPS survey data: Cooperative Agriculture Pest Survey databases (negative data)
5. [crop knowledge master](http://www.extento.hawaii.edu/kbase/crop/cropmenu.htm): crop knowledge master website
6. CTAHR New Pest reports: Collected by Dr. Michael Melzer
7. [Don Gardner](http://www.hear.org/pph/database/#dongardnerlegacydatabase): Data from Don Gardner’s legacy database
8. First report: First reports found from literature search of scientific journals (Google Scholar, Web of Science, PubMed)
9. [GBIF](https://www.gbif.org/): Global Biodiversity Information Facility
10. [hawaii checklist](https://scholarspace.manoa.hawaii.edu/items/43c51984-f009-40ff-851c-107f0269a6d5): The “2009 Checklist of Plant Diseases in Hawaii”
11. Hawaii NPDN data: National Plant Diagnostic Data from Hawaii (detections from Hawaii and dignosed at labs in AZ, FL, HI, NC, NY, OR, SC, and WI).
12. [HDOA new pest advisory](https://hdoa.hawaii.gov/pi/ppc/new-pest-advisories/): Hawaii Department of Agriculture new pest advisory 
13. miscellaneous: personal literature search
14. NAPIS data: National Agricultural Pest Information System database 
15. [UH extension articles](https://www.ctahr.hawaii.edu/site/PubList.aspx?key=Plant%20Disease): University of Hawaii extension articles
16. USDA_confirmations: USDA National Agricultural Statistics Service

This is a compile of detections and not negative data. The exception would be the CAPS data, in which negative data would represent the entire state. Negative CAPS data are represented by zero values in the island columns.

##The database consist of 23 columns. Below is a discription of each column. Number of unique values are in parentheses.

1. host_family (186): Scientific family name of plant host
2. host_genus (675): Scientific genus name of plant host
3. host_species (839): Scientific species name of plant host
4. host_scientific_name (1361): Scientfic binomial noenclature of plant host
5. host_common_name (921): Plant host common name from [Forest & Kim Starr](http://www.starrenvironmental.com/images/) and USDA PLANTS Database
6. pathogen_genus (3378): Scientific genus name of plant pathogen genus name of plant pathogen
7. pathogen_species (3397): Scientific species name of plant pathogen
8. pathogen_scientific_name (7007): Scientfic binomial noenclature of pathogen host
9. pathogen_group (16): Seperates organisms in pathogen name columns into nematode, entomopathogenic fungi, saprophytic fungi, bacteria, amoeba, unknown, virus, fungi, and parasitic plant
10. pathogen_status (2): Consit of sources that determine organism in pathogen name columns as a plant-pathogen or not (manual research, hawaii checklist pathogen, fungus-host database pathogen, based on name - for viruses only, and NPDN database pathogen)
11. data_set (16): Source of report (details above)
12. status: The status of pathogen present in Hawaii (absent or present)
13. year: Date of report (117 years)
14. Hawaii: Presence of pathogen in the island of Hawaii (1=present, 0=absent, blank=unknown)
15. Maui: Presence of pathogen in the island of Maui (1=present, 0=absent, blank=unknown)
16. Lanai: Presence of pathogen in the island of Lanai (1=present, 0=absent, blank=unknown)
17. Molokai: Presence of pathogen in the island of Molokai (1=present, 0=absent, blank=unknown)
18. Oahu: Presence of pathogen in the island of Oahu (1=present, 0=absent, blank=unknown)
19. Kauai: Presence of pathogen in the island of Kauai (1=present, 0=absent, blank=unknown)
20. Kahoolawe: Presence of pathogen in the island of Kahoolawe (1=present, 0=absent, blank=unknown)
21. Niihau: Presence of pathogen in the island of Niihau (1=present, 0=absent, blank=unknown)
22. city (112): Origin city of reported pathogen
23. complete_ref (8027): Source of report

Tags: agriculture, bacteria, distribution, fungi, nematodes, phytopathology, virus
Organization: State of Hawaii