VegBIEN¶

• Accessing VegBIEN
  • Instructions for new users
    • Adding a database user
      • Welcome e-mail
• Analyses
  • Plot change over time analysis
• Analytical database
  • Analytical DB workflow
• Conditions of use
• Connecting to vegbiendev
• Database performance tuning
• Derived columns
  • Geovalidation
  • Growth forms
  • Specimen descriptions
  • TaxonMorphospecies creation
  • TNRS
    • Higher plant group node names in Tropicos APGIII
    • TNRS derived columns
    • TNRS unsafe chars
• Download tracking
• Import process
  • Backup benchmarks
  • Denormalizing a datasource
  • Import steps
    • General import steps
      • Adding a single-table flat-file datasource
      • Connecting to vegbiendev to run import
      • Datasource import steps
      • Datasource left-joining steps
      • Datasource mapping steps
      • Setting up a VegBIEN VM from scratch
    • Specific import steps
      • Adding ACAD--a Darwin Core datasource
      • Adding Cyrille traits--a traits datasource
      • Adding Madidi--a flat-file plots datasource
      • Mapping a new table in VegBank--a SQL plots datasource
      • Refreshing ACAD--a Darwin Core datasource
      • Refreshing CVS--an MS Access plots datasource
      • Refreshing VegBank--a SQL plots datasource
  • Individual datasource refresh
  • New-style import
    • Db process comments
    • Importing to a denormalized VegCore schema
    • Refactor-in-place
    • Stage II vs stage IV validations
    • Staging table column renaming
      • Adding new-style import to a datasource
  • Normalization techniques
    • Auto-folding
    • Auto-forwarding
    • Breadcrumb alternatives
    • Dup-select
      • Column-based import
      • Dup-return
    • Pull-forward
    • Trigger-based import
  • Result filtering
  • Row-based import benchmarks
  • TNRS workflow
• Maintenance FAQ
• Validation
  • Aggregating validations status
    • Aggregating validations on sparse datasources
    • Aggregating validations pipeline
    • Aggregating validations refactoring
    • NY aggregating validations
    • SALVIAS aggregating validations
  • Data provider feedback
    • CVS issues
    • Import issues
    • MO issues
    • NYBG issues
    • REMIB issues
    • SALVIAS issues
    • SpeciesLink issues
    • UArizona issues
    • UNCC issues
  • Full-database summary statistics
  • Spot-checking validation status
    • Spot-checking validation details
      • BIEN2 traits validation
      • CVS validation
        • CVS embargoes
      • FIA validation
      • GBIF validation
      • SALVIAS validation
      • Spot-checking workflow issues
      • TEX validation
      • VegBank validation
    • Spot-checking validation order
  • Usability testing
    • Core columns
      • DwC terms not mapped to VegBIEN
    • General materialized views
• VegBIEN contents
  • Traits data
• VegBIEN data dictionary
• VegBIEN FAQ
• VegBIEN schema
  • Plot Methodology
  • VegBIEN schema refactoring
  • VegBIEN taxonomic schema
• Web interface
• Web interface options