Introduction

Native trees are the building blocks of many terrestrial ecosystems where they protect biodiversity and are important carbon sequesters that mitigate climate change1,2,3. They also provide a wide range of socio-economic benefits to billions of people4 that include being important sources of nutrient-rich foods that support healthy diets5,6,7. Agroforestry systems – integration of trees in farming systems8—are recognised as an important and relatively low-cost restoration mechanism which can help meet massive current forest landscape restoration targets (https://www.bonnchallenge.org) and benefit hundreds of millions of people9,10.

However, large-scale tree planting initiatives are prone to fail if not planned and executed wisely8,11,12. Tree species to be planted should be selected carefully, for example to avoid the biosafety risks associated with promoting invasive species13,14. At the same time, trees planted should contribute to local livelihoods and biodiversity—not just carbon sequestration, as has often been the dominant consideration of the past15.

A fundamental principle to selecting and delivering tree portfolios essential for successful forest landscape restoration is to consider more specifically the uses of tree species. Significant win–win opportunities exist for driving forest landscape restoration adoption and improving local communities’ livelihoods if proper consideration is given to the uses of the trees to be planted. Careful reference to tree uses that meet specific local needs is an important incentive for community involvement in restoration activities5,16,17. What is needed especially is a knowledge of the uses of native tree species, whose planting and management in restoration activities supports the twin goals of biodiversity conservation and livelihood improvement, and avoids some of the detrimental impacts of focusing on better-known exotic trees.

Concerns related to the failure of current tree-planting initiatives to deliver diverse benefits to local communities while maximizing rates of biodiversity recovery have recently led to the formulation of the ’10 golden rules for reforestation’18. These principles guide the formulation of a Global Biodiversity Standard (https://www.biodiversitystandard.org/), which aims to (a) assess impacts of tree planting programmes on biodiversity, and (b) provide mentoring and support to tree-planting practitioners for better livelihood and biodiversity outcomes. Among these principles, listed as Rule #6, is to ‘Select species to maximize biodiversity’ specifying that monocultures should be avoided wherever possible. Furthermore, the same principle states that the planting mixtures should (a) maximize the number of native tree species, and (b) exclude invasive species.

Here, we describe the development of the GlobalUsefulNativeTrees (GlobUNT) database to provide diverse mixtures of useful native trees in support of their use in forest landscape restoration This new database is based primarily on combining information from two sources, the GlobalTreeSearch database19 and the World Checklist of Useful Plant Species (WCUPS)20. GlobalTreeSearch documents the native country or territory of distribution of all known tree species globally, whereas WCUPS lists over 40,000 plants with their different documented human uses. The resulting GlobUNT database, which includes data for over 14,000 tree species, constitutes the largest available dataset on trees, their uses and their distributions.

Our new database allows users to select diverse assemblages of tree species native to chosen countries and territories that are useful for the provision of ranges of specific products and services. GlobUNT also has a range of extra functionalities, including the ability to generates summary tables of differences in tree species, genus and family richness at subcontinental and continental levels. This information is important for communicating the potential livelihood benefits provided by native tree species to policymakers and practitioners involved in the regional planning that is essential for effective forest landscape restoration. To further explore the potential of GlobUNT for contributing to biodiversity conservation along with livelihood provision, we analysed the subcontinental distributions of endemic and threatened useful tree species, based on data on threat status taken from the Global Tree Assessment21,22 (GTA; https://www.globaltreeassessment.org/).

Results

Characteristics of the GlobalUsefulNativeTrees database

The GlobalUsefulNativeTrees (GlobUNT) can be accessed via https://worldagroforestry.org/output/globalusefulnativetrees. GlobUNT is managed and has been designed to be updated regularly (see discussion) among a wider set of tools available from the CIFOR-ICRAF Global Tree Knowledge Platform (https://www.worldagroforestry.org/tree-knowledge). This wider set of tools includes the Agroforestry Species Switchboard23, an online database that was designed to assist users in finding information for a particular plant species across 50+ information sources and to which each species in GlobUNT has been hyperlinked. GlobUNT is managed also as part of a stepwise methodology named “Climate Appropriate Portfolios of Tree Diversity” that is deployed and field-tested by CIFOR-ICRAF24. GlobUNT is hyperlinked with the GlobalTree Portal22, thereby enabling users to check on the conservation status and actions for filtered species.

At the global level, the richness of useful native tree species (Su) was 14,014, representing roughly one third (33.7%) of all plant species with documented uses in the World Checklist of Useful Plant Species (WCUPS) and one quarter (24.2%) of all tree species documented by GlobalTreeSearch (Table 1). Only one use category had a global Su lower than 1000 (Invertebrate Food with 712); this was also the category in the WCUPS with lowest richness overall. Among the 14,014 species in the database, 64 species (0.5%) were listed for all ten use categories. These species were from 56 genera and with five genera that included more than one species (Cordia, Prosopis, Tarchonanthus, Vachellia and Ziziphus). GlobUNT lists 118 species (0.8%) for nine use categories and 209 (1.5%) for eight. The database contains 6776 species (48.3%) that had only one use category and 2871 species (20.5%) that had two.

Table 1 Species richness in GlobalUsefulNativeTrees (GlobUNT) for the ten countries with highest richness overall.

At a plant family level, the total number in GlobUNT was 234 (GlobalTreeSearch includes 261 families). The total number of plant genera was 2599. The twenty genera with the highest Su were Ficus (287), Syzygium (189), Diospyros (184), Eucalyptus (155), Quercus (117), Terminalia (99), Acacia (98), Elaeocarpus (96), Garcinia (96), Croton (94), Prunus (93), Coffea (90), Pinus (87), Salix (82), Macaranga (75), Dombeya (74), Shorea (74), Commiphora (73), Magnolia (69) and Ilex (67).

The global native distribution of useful tree species by major use categories

At a continental level, tropical Asia had the highest Su overall with 5177 species (Supplementary Table 1), followed by Africa (3413), Southern America (3158) and temperate Asia (2118). Two continents had Su below 1000, the Pacific (530) and Europe (299).

At a sub-continental level, Su varied from 3349 to 4 (Supplementary Table 1). The value was highest overall in Malesia (comprised of Brunei Darussalam, Christmas Island, Cocos Islands, Indonesia, Malaysia, Philippines, Singapore and Timor-Leste) and lowest in Subarctic America (Greenland). Su was also largest in Malesia for Materials (MA, 2723), Medicines (ME, 1533), Human Food (HF, 958), Fuel (FU, 734), Environmental Uses (EU, 632), Social Uses (SU, 614), Animal Food (AF, 443), Poisons (PO, 322) and Invertebrate Food (IF, 266) (Fig. 1). Indo-China (Cambodia, Lao People’s Democratic Republic, Thailand and Viet Nam) ranked second highest for MA (1488). West-Central Tropical Africa (Burundi, Cameroon, Central African Republic, Congo, The Democratic Republic of the Congo [DRC], Equatorial Guinea, Gabon, Rwanda and Sao Tomé and Principe) ranked highest for Su in Gene Sources (GS, 476; this category of reported uses includes wild relatives of major crops which may be valuable for breeding programs) and second highest for HF (819) and PO (314). South Tropical Africa (Angola, Malawi, Mozambique, Zambia and Zimbabwe) ranked second highest in Su for EU (631), GS (438) and AF (405). Papuasia (Papua New Guinea and the Solomon Islands) had the second highest Su for FU (640), SU (547) and IF (245). The Indian Subcontinent (Bangladesh, Bhutan, India, Maldives, Nepal, Pakistan and Sri Lanka) ranked second for ME (1470). Western South America (the Plurinational State of Bolivia, Colombia, Ecuador and Peru) that ranked third overall in Su (1883) never ranked second or third for separate use categories.

Figure 1
figure 1

Subcontinental species richness for GlobalUsefulNativeTrees across different use categories. AF, Animal Food. EU, Environmental Uses. FU, Fuel. GS, Gene Sources. HF, Human Food. IF, Invertebrate Food. MA, Materials. ME, Medicines. PO, Poisons. SU, Social Uses (See 20 for definitions of reported uses). Supplementary Table 1 includes data for 242 countries and territories, 42 subcontinents and 8 continents for the 10 use categories. Supplementary Figure 1 provides country boundaries. Map created in R with Equal Earth projection.

At a country/territory level, the species richness of native trees documented to be useful in GlobUNT (Su) ranged between 2724 and 1 (Supplementary Table 1). The Malesian countries of Indonesia and Malaysia ranked first and second in overall Su with 2724 and 2115 species respectively. Indonesia also ranked first for MA (2291), HF (833), FU (701), SU (571), EU (553), AF (425), PO (280) and IF (257). Brazil, the most species-rich country in the GlobalTreeSearch database with 8791 species (Supplementary Table 1) ranked third overall in Su (1772) and only had the same ranking for ME (1143) and otherwise ranked significantly lower for individual use categories with a highest sixth ranking for MA (1059). Colombia that ranked second in GlobalTreeSearch (5943 species) only ranked eighth for GlobUNT (1342). India ranked first overall in Su for ME (1290). The DRC ranked first overall in Su for GS (367) and second highest for HF (632). China ranked second overall in Su for EU (551, only two species lower than the best-ranked Indonesia) and GS (215).

The global native distribution of endemism and threat status of useful tree species

To further explore the potential of GlobUNT for contributing to biodiversity conservation along with livelihood provision, we analysed the distributions of endemic and threatened useful trees.

When classifying endemism as being native to a single country or territory only, the richness of endemic species (Se1) was largest in the subcontinents of Australia (557, Fig. 2, Supplementary Table 2) and the Western Indian Ocean (British Indian Ocean Territory, Comoros, Madagascar, Mauritius, Mayotte, Réunion and Seychelles, 515), followed by Malesia (513), Brazil (383) and the Indian Subcontinent (316). The two countries with highest Se1 were Australia (557) and Madagascar (432), followed by Brazil (383) and Papua New Guinea (287). There were 64 countries where Su included none of the single-country endemics (the country with the highest number of endemics in GlobalTreeSearch among these was Haiti with 163 species).

Figure 2
figure 2

Subcontinental patterns of endemism for GlobalUsefulNativeTrees. ALL, All species in GlobUNT. E1, Species in GlobUNT native to one country only. NE1, Species in GlobUNT native to two countries or more. E2, Species in GlobUNT native to one continent only. NE2, Species in GlobUNT native to two continent or more. ALL %-NE %, Richness of left-hand panel expressed as percentages from the total number of species in GlobalTreeSearch in the same category. Supplementary Table 2 includes data on endemism for 242 countries and territories, 42 subcontinents and 8 continents. Supplementary Figure 2 provides country boundaries. Map created in R with Equal Earth projection.

When defining endemic species by those useful tree species that were native to one continent only, the species richness of endemic species was largest in Malesia (2502), West-Central Tropical Africa (1547) and Brazil (1541).

The most widely distributed useful tree species across subcontinents were Dodonaea viscosa (28 subcontinents, 7 continents), Ximenia americana (24, 7), Sophora tomentosa (23, 7), Hibiscus tiliaceus (22, 7), Pisonia aculeata (22, 7), Tephrosia purpurea (20, 5), Thespesia populnea (20, 7), Suriana maritima (19, 7), Avicennia marina (18, 5), Trema orientale (18, 5) and Vitex trifolia (18, 6).

Defining useful threatened tree species as those with the IUCN Red List categories of Critically Endangered (CR), Endangered (EN) or Vulnerable (VU) resulted in the subcontinent of Malesia hosting the highest number of threatened species (STHR = 382; Fig. 3) with the Western Indian Ocean ranked second (245). These subcontinents showed the same ranking for CR (60 and 55 species, respectively) and EN (111 and 108, respectively). For VU, Malesia ranked first once again (211 species), but the Indian subcontinent ranked second (111).

Figure 3
figure 3

Subcontinental patterns of threatened useful tree species for GlobalUsefulNativeTrees. CR, Critically Endangered species. EN, Endangered species. VU, Vulnerable species. NT, Near Threatened species. LC, Species of Least Concern. CR %-LC %, Richness of left-hand panel expressed as percentages from the total number of species in GlobalTreeSearch in the same category. Supplementary Table 3 includes data on threats for 242 countries and territories, 42 subcontinents and 8 continents. Supplementary Figure 3 provides country boundaries. Map created in R with Equal Earth projection.

The Malesian countries of Indonesia and Malaysia contained the highest numbers of threatened species (240 and 219 species, respectively; Supplementary Table 3). Madagascar had the highest number for EN (96). Sri Lanka ranked fourth overall in numbers of threatened species and also had more than twice the number of CR species than the fifth ranked India. Globally, percentages of threatened species were below 17% for the different categories for threatened species, whereas the percentage for LC was 40.4%.

Discussion

Many current tree-planting initiatives for forest landscape restoration fail because they do not sufficiently consider the needs of the local communities who plant and tend them. In these situations, the planted trees are neglected and consequently do not survive to maturity. The range of species selected for use in restoration is furthermore limited, with an emphasis on easy-to-propagate exotic species that do not support biodiversity. To help address these concerns, the ’10 golden rules for reforestation’ were recently developed18. Among these ‘golden rules’ there is an emphasis on maximising native tree biodiversity and addressing local community needs to support success.

Our compilation of data primarily from GlobalTreeSearch and WCUPS (see methods on selected species and sources of information on tree uses) indicates that almost a quarter of all known trees have been assigned specific uses and that nearly a third of all useful plants are trees. These statistics highlight both the potential and limitations of focusing on useful tree species within global tree conservation schemes. While underscoring the need for in situ conservation of tree species without known uses, the GlobUNT illustrates the scope for conservation-through-use of tree species with demonstrable value to humans.

Even if we focus solely on country endemics (12.6% of species represented in GlobUNT) or threatened species (12.9% listed by GlobUNT), the biodiversity conservation potential is not insignificant with over 4000 and 1700 species respectively representing win:win opportunities for human use and biodiversity conservation. It is possible to select planting mixtures from GlobUNT that satisfy the criteria of the ‘golden rules’ of favouring native species and also including endemic and threatened species (GlobUNT further includes hyperlinks to the GlobalTree Portal from where information is available on published IUCN Red List data and those of regional or national assessments as documented in the ThreatSearch database). At the same time, the selected assemblages will provide useful products and services to local communities. Furthermore, the database can allow for prioritizing based on desired services. However, a trade-off does exist between the number of species grown in landscape mosaics and their viable population sizes, and therefore tree densities should not drop below thresholds that prevent their long term survival or enable connectivity25.

GlobUNT is not the only database that allows selections of useful trees (overviews are provided elsewhere26,27 and country-specific manuals and tools also exist (see for example the RELMA-ICRAF Useful Trees series available via http://apps.worldagroforestry.org/usefultrees/index.php). However, when comparing the database with a selection of 27 databases with species-specific details for tree species that are available from the Agroforestry Species Switchboard23, GlobUNT was the database that included the highest number of useful tree species (Supplementary Table 4). When considering all species listed in GlobalTreeSearch, only the obvious WCUPS, the Useful Tropical Plants Database28 (57.8%) and wood density data available from the BIOMASS package29 (51.0%) included more than half of the species found in GlobUNT. In addition to these databases, only the World Economic Plants in GRIN30 (27.1%) and the Plant Resources of South East Asia31 (24.6%) had close to or more than a quarter of species listed.

GlobUNT lists over 1000 species for potential use in 18 countries and over 300 species in 78 countries. For countries that have made pledges to bring degraded and deforested landscapes into restoration in response to the Bonn Challenge (https://www.bonnchallenge.org/pledges), GlobUNT provides 100 species or more for every country from Africa, tropical Asia, Northern America and Southern America except for Chile (Supplementary Table 5; combined, these 52 countries have pledged over 200 million ha).

Where GlobUNT lists 100 species or more, during the planning of tree planting projects it will be necessary to select subsets of species suitable for the planting sites and for the desired uses (conceptually such selection could be thought of as a local ecological filter selecting species from a regional species pool32,33). Filtering species for uses can be done directly within GlobUNT by selecting the desired use categories. As described similarly in the ‘golden rules’ guidelines, country-specific checklists of native species can be used by local specialists to select a subset of species that is most suitable for a particular project site, for example by considering results from previous planting experiments34. Since GlobUNT was developed in parallel with the previously mentioned Switchboard, specialists can readily access data from a large number of databases since this database provides verified hyperlinks to taxon-specific information across 45 information sources.

Malesia, Indonesia and Malaysia frequently obtained top rankings in the richness of useful species results. Brazil, the subcontinent and country of highest species richness in GlobalTreeSearch and the country of second-highest area coverage in Table 1, only got the third highest ranking overall and otherwise ranked lower except for the number of medicinal species and country-endemic species. The country did not feature among the countries with highest rankings for useful and threatened tree species. We can only speculate why this is the case, but possibly the inclusion of more regional sources from the continents of Africa and tropical Asia within WCUPS could have biased species composition in WCUPS and subsequently in GlobUNT away from Brazil and Southern America. As we aim to update GlobUNT regularly by incorporating future updates of the GlobalTreeSearch, WCUPS, Switchboard and taxonomic backbone databases, it is possible that some biases could be reduced via a newer version of WCUPS.

In large countries that include several ecoregions (e.g., according to the Ecoregions 201735), it will be important as well to select species that match species assemblages of the natural vegetation. Knowledge of native floras (many available online as for example via the World Flora Online website36 or information from vegetation atlases (e.g., http://www.vegetationmap4africa.org) can be of help here. Similarly, where seed zonation maps have been developed (e.g.,37), or habitat distribution maps are available for individual tree species (e.g.,38,39,40,41) these would be directly relevant in selecting species that match the environmental conditions of planting sites and future climatic conditions. Recognizing the benefit of subnational levels for larger countries, in a first revision of GlobUNT (version 2023.01) we expanded the database with 188 subnational levels for 33 countries including the United States (52 levels), the Russian Federation (22), Canada (13), China (9), Australia (7), Mexico (7), India (6) and Brazil (5). In one of the next updates of GlobUNT, we plan to include environmental filters that employ known environmental ranges of tree species documented in the TreeGOER database42. As the environmental variables of TreeGOER include bioclimatic variables, users would be able to match species to future climatic conditions of the planting sites (see also38,43).

We want to underscore that our vision about usage of GlobUNT is not that the database is primarily used from a remote office as the principal method of deciding which species should be planted. On the contrary, tree planting projects wanting to avoid failure should, in addition to the ‘golden rules’18, also consider people-centred factors16,44. Previous recommendations for participatory selection remain highly valid, as recently repeated by45,46,47. However, for any country where a project aims to implement tree planting schemes that aspire to maximise native tree biodiversity while addressing local community needs, GlobUNT will be a user-friendly source for practical information.

Methods

Species selection and distribution

The GlobalUsefulNativeTrees (GlobUNT, version 2023.01) database includes 14,014 species (the complete species list is archived at https://zenodo.org/record/7994433). The identities of 13,947 species (99.5%) were obtained by matching species listed by GlobalTreeSearch19,48 (accessed on 8th May 2022 for individual countries) with those listed in the World Checklist of Useful Plant Species20 (WCUPS) by protocols documented below. Also included in GlobUNT were 62 species that were included in the WCUPS but not in the GlobalTreeSearch, but that otherwise had been included among 830 tree species prioritized for planting in the tropics and subtropics49 (Top-830), that were listed in the Agroforestree database50 (AFD) or listed within a selection of tree, bamboo and rattan species that are most widely planted in the tropics and subtropics51. Details about these species are provided in Supplementary Table 6.

Four more species were added (Acacia cincinnata, A. pachycarpa, Shorea javanica and Toona ciliata) from GlobalTreeSearch and the Top-830 or AFD, which were species that were not listed in the WCUPS. Further added was the one species (Cratylia argentea) remaining from the Top-830, a species not listed either in the WCUPS or GlobalTreeSearch. Uses for these five species were inferred from the AFD or the World Economic Plants from the USDA GRIN database30 (https://npgsweb.ars-grin.gov/gringlobal/taxon/taxonomysearchwep accessed June 2022) and then matched with the use categories of the WCUPS.

Our reason for adding these 67 species was to offer a wider suite of useful woody species to users of GlobUNT, such as widely planted bamboo and rattan species. Users that wish to exclude the additional species and restrict to those included in GlobalTreeSearch can do so in GlobUNT via specific query options. The additional species were also given a different format in the species lists shown in the database. All the additional species have a taxonomic status of ‘ACCEPTED’ in World Flora Online36 (WFO), except for the unchecked Citrus bergamia uniquely identified as wfo-0000748570 in WFO.

For the additional species not listed in GlobalTreeSearch, the native distribution was obtained from Plants of the World Online (https://powo.science.kew.org; accessed in May and June 2022). For all other 13,951 species, country distributions were obtained by combining the individual country lists from GlobalTreeSearch.

Species matching

Species matching between species listed in GlobalTreeSearch and the WCUPS was done after preparing standardized lists of species names for the 2022 version of the Agroforestry Species Switchboard23. Standardization of nomenclatures for the Switchboard was achieved via the WorldFlora R package52 (version 1.10) by matching names to World Flora Online36 (version 2021.12 downloaded from http://www.worldfloraonline.org/downloadData) and, for species that were not matched to WFO, to the World Checklist of Vascular Plants53 (WCVP; version 8 downloaded from http://sftp.kew.org/pub/data-repositories/WCVP/).

Matching was thus done separately between GlobalTreeSearch and the Switchboard and between the WCUPS and the Switchboard, therefore using the master list of standardized names from the Switchboard as taxonomic backbone data. This allowed for a straightforward process of including hyperlinks for every species of GlobUNT to the Switchboard.

GlobUNT provides information on the type of taxonomic matches for each species, allowing users to verify the credibility of the matches, for example by visually inspecting the similarity in spellings and naming authorities. As hyperlinks are also provided to the matched species names in WFO or WCVP, users can further check for possible changes in taxonomy with the current online versions of WFO and WCVP.

GlobUNT differentiates between six types of taxonomic matches, including (a) direct matches; (b) manual matches; (c) direct matches via WCVP; (d) manual matches via WCVP; (e) direct matches via POWO; and (f) manual matches via POWO.

A 'direct match’ indicates that the exact name was matched between two species lists. For the 14,014 species listed in GlobUNT, 13,875 were directly matched with the Switchboard. A 'manual match’ indicates that a fuzzy match (a match with Levenshtein Distance > 0; see52 for details) was accepted after visual inspection. There were 129 of such GlobUNT-Switchboard matches. Matches of 'direct via WCVP' or 'manual via WCVP' indicate that the species was first matched with a synonym in the WCVP, where the accepted name for the species identified by WCVP was also listed in WFO. There were ten GlobUNT-Switchboard matches of these types, including three manual ones.

For the 14,009 species in GlobUNT where information was obtained from WCUPS, there were 13,856 direct matches, 138 manual matches and one ‘manual via WCVP’ match.

Matches of ‘direct via POWO’ or ‘manual via POWO’ indicate that matching was done via a synonym listed in the Plants of the World Online; 14 of these matches were done, including only one ‘manual via POWO’ match. All ‘matches via POWO’ were done for the WCUPS and for 13 of these, these matches were for the additional species that were not listed in GlobalTreeSearch (additional Table 6; the one exception was Cupressus lusitanica matched with Hesperocyparis lusitanica in WCUPS).

Threat status

Information on threat status of individual tree species have been collated through the ongoing Global Tree Assessment21 (GTA; https://www.globaltreeassessment.org/) and were obtained from the GlobalTree Portal22 (https://www.bgci.org/resources/bgci-databases/globaltree-portal/ accessed on 28th May 2022) by downloading lists for each country .The GTA assigned tree species to the IUCN Red List categories of Extinct, Critically Endangered, Endangered, Vulnerable, Near Threatened, Least Concern, Data Deficient and Not Evaluated. We verified that a unique Red List category had been assigned to species that occur in more than one country.

Mapping

Countries and territories were allocated to continents and 'subcontinents' based on their hierarchical structure within the second edition of the World Geographical Scheme for Recording Plant Distributions54 (WGSRPD). This scheme was modified for GlobUNT by:

  1. (a)

    Cape Verde and Saint Helena, Ascension and Tristan da Cunha were assigned to a newly created subcontinental level for Africa of 'Atlantic Ocean';

  2. (b)

    Turkey was assigned to Western Asia only ('Turkey-in-Europe' was thus ignored); and

  3. (c)

    The Russian Federation was included as a subcontinental level both for Europe and temperate Asia.

Furthermore, the United States Minor Outlying Islands were assigned to different levels within the Pacific based on assignments of individual islands of Johnston I., Midway I., Palmyra I. and Wake I.

Maps were created via the ggplot255 (version 3.3.6) and sf56 (version 1.0-8) R packages using R57 (version 4.2.1). Country boundaries were obtained from a Natural Earth ‘admin_0’ vector layer at 1:110 million scale downloaded as a shapefile on 25th September 2022 from https://www.naturalearthdata.com/downloads/110m-cultural-vectors/. The shapefile was processed in QGIS58 (version 3.22.11) to split the multipolygon for France into separate polygons for France and French Guyana, and to split the multipolygon for Norway into separate polygons for Norway and Svalbard and Jan Mayen. Further processing was also done to include Kosovo into Serbia, to merge Somalia with Somaliland and to merge polygons for Cyprus. These splits and merges were required to match the country and territory distribution employed by GlobalTreeSearch.

Calculations of species richness at different levels of geographical aggregation

Species richness at global, continental, subcontinental and country levels were calculated via the dplyr R package59 (version 1.0.10). Internally in the database, the same package is used to create summary tables of the distribution of species, genus and family richness at different geographical levels.