Confluence Retirement

In an effort to consolidate USGS hosted Wikis, myUSGS’ Confluence service is scheduled for retirement on January 27th, 2023. The official USGS Wiki and collaboration space is now SharePoint. Please migrate existing spaces and content to the SharePoint platform and remove it from Confluence at your earliest convenience. If you need any additional information or have any concerns about this change, please contact myusgs@usgs.gov. Thank you for your prompt attention to this matter.


Quick Links

Child pages
  • Algal Lab Orders

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Anchor
Top
Top

Section
Column
width30
Panel
borderColorsteelblue
bgColorwhite
borderWidth1

Quick Links to Specific File Types

Lab Order File

Container File

Site File

Column
width70
Panel
borderColorsteelblue
bgColorwhite
borderWidth1

space for example download files....

Anchor
LabOrder
LabOrder
The Lab Orders File (Return to Top)

File Name: - USGS_BioData_Lab_Orders_yyyymmdd_tttt

The Lab Order file contains a list of all of the lab orders selected for downloading.

Note
titleNote

The LabOrderID must be included in the result data file that is uploaded to BioData when data are released. LabOrderID links the lab order (and field sample) to the result data uploaded by the lab.

Warning
titleWarning

If you import the Lab Order file into Excel the SiteNumber must be imported as text to preserve leading zero's

Attribute

Description For Lab

File: USGS_BioData_Lab_Orders_yyyymmdd_tttt

Anchor
algae-lab-order
algae-lab-order

LabOrderID

BioData System-generated Integer assigned as an identifier for a Lab Order. A Lab Order is comprised of the one or more containers that are processed according to requested procedures.

SIDNO

Sample ID Number (SIDNO) is a unique and immutable sample identifier that is automatically created by the system. A prefix of BDB designates BioData as the source of the identifier.

ProjectID

System-generated, unique, immutable, non-editable code that uniquely identifies a project within the BioData system

ProjectLabel

ProjectLabel is a short, unique name associated with and identifying a specific BioData Project.The BioData Project is the atomic unit to handle data permissions, allow access to samples, assist in enforcement of business rules, and for documentation, management and monitoring of data collection activities. All Field Samples, Study Reaches, and Lab Orders in BioData belong to a Project.

ProjectName

Long name associated with and identifying a specific BioData Project.The BioData Project is the atomic unit to handle data permissions, allow access to samples, assist in enforcement of business rules, and for documentation, management and monitoring of data collection activities. All Field Samples, Study Reaches, and Lab Orders in BioData belong to a Project

Program

National, regional, or local program for which these data are collected. This field may be blank if no program applies

SiteNumber

USGS National Water Information System (NWIS) 8 to 15-digit  identifier for the place for where sample was collected.

SiteName

USGS National Water Information System (NWIS) name for the place where sample was collected

StudyReach

Length of stream selected for sampling purposes. Unique in BioData by Project and Site.

CollectionStartDate

Date and time at which the sample was collected; format is mm/dd/yyyy hh:mm:ss; hh uses 24-hour clock.

ProjectAssignedSampleLabel

A unique label or code assigned to the Sample by the Project (unique within a Project); maximum length is 20 characters.

PlacedDate

Date and time at which the lab order was placed in the BioData system; format is mm/dd/yyyy hh:mm:ss; hh uses 24-hour clock.

LastModifiedDate

Date and time (mm/dd/yyyy hh:mm:ss ) at which a field in the lab order was last modified in the BioData system format is mm/dd/yyyy hh:mm:ss; hh uses 24-hour clock.

LabAnalysisProcedure

Name of the processing methods requested for the lab order.

SampleType

BioData short name for the Field Sample collection and field processing methods. The BioData Sample Type also references the biological community sampled and the published protocols.

ScienceCenter

USGS entity that has principal responsibility for managing and executing the project to which this lab order belongs.

ContactName

USGS contact person name

ContactPhone

USGS contact person phone

ContactEmail

USGS contact person email

NumberOfContainers

The number of discrete portions of a field sample (physical containers) that are part of this lab order.

Anchor
Container
Container
The Containers File (Return to Top)

File Name: USGS_BioData_Containers_yyyymmdd_tttt

The container file is a list of all of the containers needed to satisfy the analyses requested in the lab order file.

Attribute

Description For Lab

File: USGS_BioData_Containers_yyyymmdd_tttt

Anchor
algae-container
algae-container

LabOrderID

BioData System-generated integer assigned as an identifier for a Lab Order. A Lab Order is comprised of the one or more containers that are processed according to requested procedures.

ContainerID

BioData System-generated integer assigned as an identifier for a sample Container.

Component

Growth form represented: Microalgae; Macroalgae.

Bottle

Character (A, B, C, etc...) that uniquely identify the container (includes bottles, filters, etc) within a Field Sample.

Preservative

Solution (such as ethanol, formalin) added to preserve the sample material.

Comments

Notes about the container and the material within.

SubsampleVol_ml

Volume of sample removed from the composite for a particular lab analysis procedure. Subsample volume is measured before any preservative is added.

DecantVol_ml

Volume remaining after excess liquid was removed (decanted) from a preserved subsample to concentrate solids (algae).

PreservativeVol_ml

Volume of preservative added to the subsample before submitting for taxonomic analysis.

ShippedVol_ml

Volume of sample when shipped and used to confirm volume received. Shipped Volume is equal to SubsampleVol plus PreservativeVol unless Subsample has been decanted.

Anchor
Site
Site
The Site File (Return to Top)

File Name: USGS_BioData_Site_yyyymmdd_tttt

The site file is a list of USGS sites where the samples referenced by the lab order file were collected.

Warning
titleWarning

If you import the Site file into Excel SiteNumber, Latitude_ddmmss, and Longitude_dddmmss must be imported as text to preserve leading zero's

Attribute

Description For Lab

File: USGS_BioData_Site_yyyymmdd_tttt

Anchor
algae-site
algae-site

SiteNumber

USGS National Water Information System (NWIS) 8 to 15-digit  identifier for the place for where sample was collected

SiteName

USGS National Water Information System (NWIS) name for the place where sample was collected

CountryCode_FIPS

Country Code (Federal Information Processing Standard (FIPS))

StateName

State name (Federal Information Processing Standard (FIPS))

State_USPS

US Postal Service State/Possession abbreviation

State_FIPS

Numeric FIPS code for the State

CountyName

County name (Federal Information Processing Standard (FIPS))

County_FIPS

Numeric FIPS code for the County

Latitude_dd

Site Latitude in decimal degrees

Longitude_dd

Site Longitude in decimal degrees

CoordinateDatum

Datum used for Latitude and Longitude

Latitude_ddmmss

Latitude of the site in degrees, minutes, and seconds. Seconds may be entered to 100ths of a second. Leading zeros may be present.

Longitude_dddmmss

Longitude of the site in degrees, minutes, and seconds. Seconds may be entered to 100ths of a second. Leading zeros may be present.

Elevation_ft

Elevation above NGVD 1929, in feet