b235-archive

Spectral and biological sample archive

File: 

b235-borges-archive-20230925_0.csv (143.21 KB)

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

Variables
dataset_code
  • Label: Dataset code
  • Definition: Internal dataset code.
  • Type: Nominal
  • Missing values: None specified
unique_id
  • Label: Unique ID
  • Definition: Unique identifier associated with each measurement.
  • Type: Nominal
  • Missing values: None specified
date_collected
  • Label: Date collected
  • Definition: Date of the measurement in NZDT (GMT+13).
  • Type: Date/time
  • Date format: MM/DD/YYYY
  • Missing values: None specified
time_collected
  • Label: Time collected
  • Definition: Time of the measurement in NZDT (GMT+13) if known.
  • Type: Date/time
  • Date format: HH:MM:SS
  • Missing values: None specified
stream_name
  • Label: Stream name
  • Definition: The name of the stream where the measurement was taken.
  • Type: Nominal
  • Missing values: None specified
site_id
  • Label: Site ID
  • Definition: Site identifier corresponding with the location where the measurement was taken. BOW = Bowles Creek, CAN = Canada Stream, CRE = Crescent Stream, COM = Commonwealth Stream, HUE = Huey Creek, LSS = Lost Seal Stream, MCK = McKnight Creek, PLA = relict channel, VON = Von Guerard Stream
  • Type: Nominal
  • Missing values: None specified
plot_id
  • Label: Plot ID
  • Definition: Plot identifier within the stream where the measurement was conducted. See methods for further details.
  • Type: Nominal
  • Missing values: None specified
subplot_id
  • Label: Subplot ID
  • Definition: Identifier for 1 x 1 m subplots that were randomly generated in the Esri geographic information system software, ArcGIS, within the 20 x 20 m plots and surveyed for mat and moss cover.
  • Type: Nominal
  • Missing values: None specified
mat_type
  • Label: Mat type
  • Definition: Microbial mat type, moss, or soil.
  • Type: Nominal
  • Missing values: None specified
mat_id
  • Label: Mat ID
  • Definition: Identifier corresponding with microbial mat type, moss, or soil. A = moss/black mat (mostly moss with black mat on top), B = black mat, C = black/orange mat, D = black/red mat, E = black/red/orange mat, F = black mat/moss (mostly black mat with moss on top), G = tan (sandy orange/tan) mat, H = red/orange mat (red mat with orange on top), M = moss, N = green mat, O = orange mat, R = red mat, S = bare soil/rock, Y = black/moss/orange (black mat/moss with orange mat on top)
  • Type: Nominal
  • Missing values: None specified
moisture_content
  • Label: Moisture content
  • Definition: Saturated, dry or inundated microbial mat. If the mat was moist or wet, it was considered saturated.
  • Type: Nominal
  • Missing values: None specified
data_type
  • Label: Data type
  • Definition: Indicates if this microbial mat or moss was measured for spectral data only (spec), spectral data that was specifically a mixture between mat/moss and soil collected within the 30 cm diameter circle (ring), both spectral and biological data (joint), or biological data only (bio). Some microbial mats and moss in this database were only analyzed for spectral, biological, both spectral and biological, or spectral data of geological and biological materials. spec = spectral data collected ~3 cm above measured surface, ring = spectral data collected ~140 cm above measured surface and is a mixture of geological and biological materials, joint = spectral and biological data (spectral data collected ~3 cm above measured surface, e.g. no mixtures), bio = biological data collected of chlorophyll, ash-free dry mass, percent organic matter, and various pigments
  • Type: Nominal
  • Missing values: None specified
latitude
  • Label: Latitude
  • Definition: The latitude of the coordinates where the measurement was taken (in decimal degrees).
  • Type: Nominal
  • Missing values: None specified
longitude
  • Label: Longitude
  • Definition: The longitude of the coordinates where the measurement was taken (in decimal degrees).
  • Type: Nominal
  • Missing values: None specified
sample_name
  • Label: Sample name
  • Definition: Names associated with biological samples. Format: site_id + date + plot + subplot + mat_id + number_of_cores.
  • Type: Nominal
  • Missing values: None specified
sample_id
  • Label: Sample ID
  • Definition: Identifiers associated with biological samples. All biological samples were numbered upon collection, starting at 1.
  • Type: Nominal
  • Missing values: None specified
sample_type
  • Label: Sample type
  • Definition: Was the sample a unique "sample" or a "duplicate"?
  • Type: Nominal
  • Missing values: None specified
number_of_cores
  • Label: Number of cores
  • Definition: The number of cores collected for the associated sample.
  • Type: Nominal
  • Missing values: None specified
spectral_id
  • Label: Spectral ID
  • Definition: Identifiers associated with spectral measurements. Format is generally = site_id + plot (if applicable) + date + mat_id + moisture_content + the number of the field spectrometer measurement. Other label information sometimes appears between the stream name or plot number and date, which indicates the type of measurement collected (opp = opportunistic or all measurements of 100% of the mat or moss type being measured, ring = ring measurement).
  • Type: Nominal
  • Missing values: None specified
photo_id
  • Label: Photo ID
  • Definition: Filename(s) of the name of the photo(s) taken at the time and place of the associated measurement.
  • Type: Nominal
  • Missing values: None specified
sample_description
  • Label: Description
  • Definition: Raw notes/observations collected in the field. Notes in this column describe the plots and subplots, microbial mats/moss being measured, stream characteristics in this area, and which data types were collected. Notes in this section did not always determine the mat type assigned to a measurement. Refer to the photoIDs column for images of the samples if there is not enough information from this column.
  • Type: Nominal
  • Missing values: None specified
filtering_remarks
  • Label: Filtering remarks.
  • Definition: Any relevant notes taken when biological samples were filtered.
  • Type: Nominal
  • Missing values: None specified
freezer_remarks
  • Label: Freezer remarks.
  • Definition: Any relevant notes taken when biological samples were frozen.
  • Type: Nominal
  • Missing values: None specified
Data Source Details

Header lines: 

1

Orientation: 

Column

Quote character: 

"

Field delimiter: 

,