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
  • Invertebrate Lab Orders

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Top
Top

Section
Column
width4035
Panel
borderColorgreen
bgColorwhite
borderWidth3

Quick Links to Specific File Types

Lab Order File

Container File

Site File

Panel
borderColorgreen
bgColorwhite
borderWidth3

Example Lab Order Files

Example Lab Orders from single site for single project. There are two lab orders and each lab order has two containers.

  • Zip files contains three lab order files:USGS_BioData_Lab_Orders_20120123_1110.zip
    • USGS_BioData_Lab_Orders_20120123_1110.txt - Two lab orders
    • USGS_BioData_Lab_Orders_Containers_20120123_1110.txt - Four containers. One Main body and one field large/rare for each of two lab orders
    • USGS_BioData_Lab_Orders_Site_20120123_1110.txt - One site. 01472157 French Creek near Phoenixville, PA
Column
width6065
Panel
borderColorgreen
borderWidth3

What's A Lab Order?

A lab order is the mechanism for providing labs with information about samples sent to them for analysis. A lab order specifies:

  • The analysis procedure the lab will use
  • The container(s) that are sent to the lab to provide the material needed for the analysis.
Panel
borderColorgreen
borderWidth3

The Lab Order Download Files

Lab representatives are notified via email when a biologist Places a lab order. A Lab Representative then logs onto BioData, selects the lab orders of interest, and retrieves them. Typically, a lab will want to retrieve more than one lab order at a time.

The selected lab orders are packaged together in a zip file that contains three tab-delimited files.

Files delivered in downloaded zip file

The "yyymmdd_tttt" component of the file name is set to reflect the date and time when the lab orders were retrieved.

  • A list of the lab orders: file name: "USGS_BioData_Lab_Orders_yyyymmdd_tttt"
  • A list of containers for the lab orders: file name: "USGS_BioData_Containers_yyyymmdd_tttt"
  • A list of the sites where the samples were collected: file name: "USGS_BioData_Site_yyyymmdd_tttt"

The files can be related (linked) as follows:

  • The Lab Order file is related to the Containers file using LabOrderID (both files have LabOrderID in them).
  • The Lab Order file is related to the Site file using SiteNumber

...