SOILS_BEE

Comma delimited file containing the BEE data described here

File: 

...or query the dataset by variables and dates of interest:

Variables
DATASET_CODE
  • Label: Data Set Code
  • Definition: Unique identifier for the table in the MCM LTER database
  • Type: Nominal
  • Missing values: None specified
BASIN
  • Label: Basin
  • Definition: The lake basin where the soil sample was collected from (Bonney, Fryxell and Hoare).
  • Type: Nominal
  • Missing values: None specified
DATE_TIME
  • Label: Date Time
  • Definition: The date the soil sample was collected from the field
  • Type: Date/time
  • Date format: MM/DD/YYYY
  • Missing values: None specified
SAMPLE_ID
  • Label: Sample Id
  • Definition: The block and treatment combination of the sample.
  • Type: Nominal
  • Missing values: None specified
BLOCK_ID
  • Label: Block Id
  • Definition: The block number that the soil sample was collected from.
  • Type: Nominal
  • Missing values: None specified
TREATMENT
  • Label: Treatment
  • Definition: The manipulation for a given plot from where the soil was collected. See 'Additional Info' for treatment codes
  • Type: Nominal
  • Missing values: None specified
SOIL_WATER_CONTENT
  • Label: Soil water content
  • Definition: The gravimetric soil water content
  • Type: Physical quantity
  • Unit: percent g/g
  • Maximum: 100
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SML
  • Label: Scottnema Male Live
  • Definition: The total number of living male Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SMD
  • Label: Scottnema Male Dead
  • Definition: The total number of dead male Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SFL
  • Label: Scottnema Female Live
  • Definition: The total number of living female Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SFD
  • Label: Scottnema Female Dead
  • Definition: The total number of dead female Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SJL
  • Label: Scottnema Juvenile Live
  • Definition: The total number of living juvenile Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SJD
  • Label: Scottnema Juvenile Dead
  • Definition: The total number of dead juvenile Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SA
  • Label: Scottnema Adult
  • Definition: The total number of living and dead Scottnema lindsayae adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
SJ
  • Label: Scottnema Juvenile
  • Definition: The total number of living and dead Scottnema lindsayae juvenile nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
STL
  • Label: Scottnema Total Live
  • Definition: total number of living Scottnema lindsayae (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
STD
  • Label: Scottnema Total Dead
  • Definition: The total number of dead Scottnema lindsayae (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
STLD
  • Label: Total Scottnema Live and Dead
  • Definition: The total number of live + dead Scottnema lindsayae (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EML
  • Label: Eudorylaimus Male Live
  • Definition: The total number of living male Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EMD
  • Label: Eudorylaimus Male Dead
  • Definition: The total number of dead male Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EFL
  • Label: Eudorylaimus Female Live
  • Definition: The total number of living female Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EFD
  • Label: Eudorylaimus Female Dead
  • Definition: The total number of dead female Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EJL
  • Label: Eudorylaimus Juvenile Live
  • Definition: The total number of living juvenile Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EJD
  • Label: Eudorylaimus Juvenile Dead
  • Definition: The total number of dead juvenile Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EA
  • Label: Eudorylaimus Adults
  • Definition: The total number of living and dead Eudorylaimus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
EJ
  • Label: Eudorylaimus Juvenile
  • Definition: The total number of living and dead Eudorylaimus spp. juvenile nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
ETL
  • Label: Total Eudorylaimus Live
  • Definition: total number of living Eudorylaimus spp. (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
ETD
  • Label: Total Eudorylaimus Dead
  • Definition: The total number of dead Eudorylaimus spp. (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
ETLD
  • Label: Total Eudorylaimus Live and Dead
  • Definition: The total number of live + dead Eudorylaimus spp. (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PFL
  • Label: Plectus Female Live
  • Definition: The total number of living female Plectus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PFD
  • Label: Plectus Female Dead
  • Definition: The total number of dead female Plectus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PJL
  • Label: Plectus Juvenile Live
  • Definition: The total number of living juvenile Plectus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PJD
  • Label: Plectus Juvenile Dead
  • Definition: The total number of dead juvenile Plectus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PA
  • Label: Plectus Adult
  • Definition: The total number of living and dead Plectus spp. adult nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PJ
  • Label: Plectus Juvenile
  • Definition: The total number of living and dead Plectus spp. juvenile nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PTL
  • Label: Total Plectus Live
  • Definition: total number of living Plectus spp. (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PTD
  • Label: Total Plectus Dead
  • Definition: The total number of dead Plectus spp. (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
PTLD
  • Label: Total Plectus Live and Dead
  • Definition: The total number of live + dead Plectus spp. (juvenile and adults) nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
TOTAL_ROTIFERS
  • Label: total rotifers
  • Definition: total number of rotifers per kg soil oven dry weight equivalent present in a sample
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
TOTAL_TARDIGRADES
  • Label: total tardigrades
  • Definition: total number of tardigrades per kg soil oven dry weight equivalent present in a sample
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
UNCLASS_SCOTTNEMA
  • Label: unclassified Scottnema
  • Definition: The total number of nematodes from the respective genera Scottnema for which sex and life stage was not determined.
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
UNCLASS_EUDORALAIMUS
  • Label: unclassified Eudorylaimus
  • Definition: The total number of nematodes from the respective genera Eudorylaimus for which sex and life stage was not determined.
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
UNCLASS_PLECTUS
  • Label: unclassified Plectus
  • Definition: The total number of nematodes from the respective genera (Scottnema, Eudorylaimus, Plectus and unknown) for which sex and life stage was not determined.
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
UNKNOWN
  • Label:
  • Definition: Unkown nematode species
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
TOTAL_LIVE
  • Label: Total Live
  • Definition: The total number of living nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
TOTAL_DEAD
  • Label: Total Dead
  • Definition: The total number of dead nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
TOTAL_UNCLASS
  • Label: total unclassified
  • Definition: The total number of nematodes extracted from the soil sample for which sex and life stage and/or species was not determined in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
TOTAL
  • Label: Total
  • Definition: The total number of living and dead nematodes extracted from the soil sample in number of organisms per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: # kg/soil
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
CONDUCTIVITY
  • Label: Conductivity
  • Definition: The electrical conductivity in microSiemens/cm of a 1:5 soil:deionized water solution.
  • Type: Physical quantity
  • Unit: microSiemens/cm
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • Null = None given
Chlorophyll a (ug/g)
  • Label: Chlorophyll a (ug/g)
  • Definition: The chlorophyll a content of the sample expressed per kg soil oven dry weight equivalent
  • Type: Physical quantity
  • Unit: ug/g
  • Maximum: Not specified
  • Minimum: Not specified
  • Precision: Not specified
  • Missing values:
    • Null = None given
COMMENTS
  • Label: Comments
  • Definition: Generic comments about the sample
  • Type: Nominal
  • Missing values: None specified
PH
  • Label: pH
  • Definition: The opposite log of the hydrogen ion concentration of a 1:2 soil-water paste
  • Type: Physical quantity
  • Unit: pH
  • Maximum: Not specified
  • Minimum: 0
  • Precision: Not specified
  • Missing values:
    • Null = None given
Data Source Details

Header lines: 

1

Orientation: 

Column

Quote character: 

"

Field delimiter: 

,

Record delimiter: 

\n