space for example download files....
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
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
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 | |
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. |
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 | |
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. |
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
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 | |
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 |
2 Comments
Anonymous
Comment from S. Spaulding:
Tracey,
A few comments on the handbook…
StudyReach
Length of stream selected for sampling purposes. Unique in BioData by Project and Site.
Is it correct to say that the length is unique? Specify units here? Meters or feet or?
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.
It looks like field staff/lab staff would enter these fields in the order 1) PreservativeVol_ml (done by field staff), 2) ShippedVol_ml (done by field staff after adding preservative), 3) SubsampleVol_ml (done by lab staff), 4) DecantVol_ml (done by lab staff). If I have the order correctly, it might make sense to present the fields in the order that they would be completed.
Unknown User (maharris@usgs.gov)
StudyReach - is the Study Reach name, not the length
Subsample volume is actually the volume (measured in field) without the preservative.
ShippedVol_ml = SubsampleVol_ml + PreservativeVol_ml (UNLESS decanted, when ShippedVol_ml = DecantVol_ml
Then by the logic that fields should reflect data entry, Decant and Preservative should be reversed (we expect decanting after perserving, although I have recently seen a case where decanting was done in the field).