VegBIEN contents¶

VegBIEN currently has:

records¶

• 84 million observations¹
• 68 million specimens²
• 2.9 million plots³ (includes both top-level plots and subplots)
• 250,000 unique accepted species⁴ (binomials) resolved by TNRS

datasources¶

41 datasources⁸:
ACAD, ARIZ, BRIT, CTFS, CVS, FIA, GBIF, HIBG, HVAA, IRMNG, IUCN, JBM, MO, MT, Madidi, NCBI, NCU, NVS, NY, QFA, REMIB, SALVIAS, SpeciesLink, TEAM, TEX, TNRS, TRT, TRTE, U, UBC, UNCC, VASCAN, VegBank, WIN, XAL, bien2_traits, bien_web, geoscrub, herbaria, newWorld, test_taxonomic_names

• 30 datasources with observations⁵:
  GBIF, FIA, MO, SpeciesLink, NY, VegBank, REMIB, SALVIAS, CVS, ARIZ, Madidi, TEAM, UBC, NCU, bien2_traits, TRT, U, QFA, ACAD, UNCC, TEX, JBM, MT, WIN, CTFS, TRTE, HIBG, BRIT, HVAA, NVS
  • 8 with plots⁶: FIA, VegBank, SALVIAS, CVS, Madidi, TEAM, CTFS, NVS
  • 22 with specimens⁷: GBIF, MO, SpeciesLink, NY, REMIB, ARIZ, UBC, NCU, bien2_traits, TRT, U, QFA, ACAD, UNCC, TEX, JBM, MT, WIN, TRTE, HIBG, BRIT, HVAA
• 11 other datasources:
  • taxa-only: 1: VASCAN
  • demo: 3: XAL, bien_web, test_taxonomic_names
  • metadata: 7: IRMNG, IUCN, NCBI, TNRS, geoscrub, herbaria, newWorld (41⁸ - 30 with observations⁵ - 4 taxa-only/demo)

¹ /*r9897.*/analytical_stem:
Rows (estimated) 83742600

² /*r9897.*/specimenreplicate:
Rows (estimated) 67632300

³ 2947989
select count(*) from /*r9897.*/location where source_id IN (select source_id from /*r9897.*/source where observationtype = 'plot')
Total query runtime: 26234 ms.

⁴ 256825
select count(*) from (select distinct "Accepted_name_species" from "TNRS".tnrs) s
Total query runtime: 64034 ms.

⁵ 30
select count(*), string_agg(dataprovider, ', ') from /*r9897.*/provider_count where dataset = '(total)' and observationtype IS NOT NULL

⁶ 8
select count(*), string_agg(dataprovider, ', ') from /*r9897.*/provider_count where dataset = '(total)' and observationtype = 'plot'

⁷ 22
select count(*), string_agg(dataprovider, ', ') from /*r9897.*/provider_count where dataset = '(total)' and observationtype = 'specimen'

⁸ from the VegBIEN DB datasource schemas