Portland Harbor Phase 3 Subyearling Chinook 2018 Samples Feature Catalog
Entity (ENT) | Office of Response and Restoration (ORR)GUID: gov.noaa.nmfs.inport:58366 | Updated: February 15, 2023 | Published / External
Item Identification
Title: | Portland Harbor Phase 3 Subyearling Chinook 2018 Samples Feature Catalog |
---|
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Feature Catalog |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
Date | String | Data collection date, as year, month, and day. | |
100
|
Case/Activity | String | The name of the case incident or the activity used to collect data. | |
100
|
QM Site ID | String | Identifier for a site in the Query Manager database. | |
100
|
Collection Study Name | String | The name of the study under which the field data were collected. | |
100
|
QM Study ID | String | Code assigned to each study in Query Manager; this is unique across the QM national dataset. | |
100
|
Area Description | String | Name of area assigned to Photologger Photo | |
100
|
Station/Site | String | Station or site identifier. This is often defined by the workplan and/or recorded by the field team, but may be standardized to database requirements. | |
100
|
Station Description | String | Description of station, or grouping (by reach, by section of river, by embayment) | |
100
|
Station Group List | String | Predefined sets of grouped stations/locations | |
100
|
QM Sample ID | String | Identifier for a sample in the Query Manager database. | |
100
|
Sample ID | String | Unique ID assigned to each sample by the field sampler. | |
100
|
Collection Matrix | String | The type of sample or record collected (e.g., Sediment, Water, Photograph, Wipe). | |
100
|
Species Group | String | Samples - Great Lakes Cube - Species Group.Species Group Hierarchy - Species Group Level | |
100
|
Common Name: Species | String | Common name for the species' biological Species. | |
100
|
Latin Name: Genus | String | Latin name for the species' biological Genus. | |
100
|
Latin Name: Species | String | Latin name for the species' biological Species. | |
100
|
Collection Form | String | The type of the data submission form used by the field team to submit raw field data. | |
100
|
Workspace Name | String | Name of the Portal Workspace where data were entered. | |
100
|
Data Classification | String | The purpose for which data was collected within the case incident or activity. | |
100
|
Data Source | String | The originating owner of the dataset. | |
100
|
Source Type | String | General owner/source of the data (e.g., NRDA, Response, Responsible Party). | |
100
|
Sharing Status | String | Identifies extent of data distribution (e.g., Publicly Available). | |
100
|
Workgroup | String | The Technical Working Group under which the field data were collected. | |
100
|
Collection Workplan | String | The workplan under which the field data were collected. | |
100
|
Habitat Type | String | Standardized habitat type based on habitat reported on the field team's collection form. | |
100
|
Organism ID | String | Identification assigned to organism (e.g. dolphin, turtle) by field team | |
100
|
Results Status | String | Samples - Great Lakes Cube - Results Status.Results Status Hierarchy - Results Status Level | |
100
|
DIVER Dataset | String | DIVER’s internal database table name | |
100
|
File Collection ID | String | Record identifier for the corresponding DIVER file collection. | |
100
|
Analysis Category | String | General category of analysis performed (e.g., Plankton_Nekton, Visual Observation, Contaminant Chemistry). For additional detail, see Analysis Type and/or Analysis. | |
100
|
Analysis Type | String | Subcategory (i.e., type) of analysis performed, such as Biomass, Hematology, Genetics, etc. For additional detail, see Analysis. | |
100
|
Analysis | String | Specific chemical or physical property measured. For groupings of analyses, see Analysis Type and/or Analysis Category. | |
100
|
ChemCode | String | Abbreviation used to represent Analysis. See Chemical Dictionary for key. | |
100
|
Lab Replicate | String | Replicate number if the laboratory analyzed the same sample multiple times by the same method (lab duplicates, typically indicated by 1,2,3) or by different methods for the same analyte (less preferred method will generally have an X). | |
100
|
Analysis Result | String | Measured result of the Analysis. May be text or number. | |
100
|
Analysis Result Unit | String | Unit of the Analysis Result. | |
100
|
Measurement Basis | String | Samples - Great Lakes Cube - Measurement Basis.Measurement Basis Hierarchy - Measurement Basis Level | |
100
|
QM Matrix | String | Identifier for location of results in the Query Manager structure - sediment, water, oil, tissue. | |
100
|
Lab/Result Matrix | String | The main substance of a sample as recorded by the laboratory for analysis. This may differ from the sample's Collection Matrix, which is determined by the field sampler. | |
100
|
Lab/Result Matrix Detailed | String | Additional information on matrix as reported by laboratory. Includes tissue type, if applicable. | |
100
|
Analysis Method | String | Laboratory method applied to perform analysis, if specified (e.g., 8081B or 8270C). | |
100
|
Qualifier Code | String | Analytical qualifier code. See Data Dictionary for code definitions. | |
100
|
Detection Extent | String | Text interpretation of qualifier codes related to the detection limit for the analyte result. | |
100
|
Review Status | String | Extent of data quality review performed. | |
100
|
Detection Limit | String | Lab-calculated concentration limit for an analyte. Method- and analyte-specific. | |
100
|
Reporting Limit | String | Level at which target analytes are reported (practical quantitation limit). | |
100
|
Validation Level | String | Specific level of validation performed for contaminant chemistry samples. See Data Dictionary for code definitions. | |
100
|
Collection Method | String | Sampling method employed by field sampler to collect a physical sample. | |
100
|
Depth Category | String | This applies to sediment samples, and classifies them as surface sediment (upper depth of 0 cm and lower depth less than 30 cm) or subsurface sediment. | |
100
|
Sample Upper Depth | String | The upper depth of a sediment, soil, water, oil, or tar sample. | |
100
|
Sample Lower Depth | String | The lower depth of a sediment, soil, water, oil, or tar sample. | |
100
|
Sample Depth Unit | String | The unit of the depth measurement. | |
100
|
Lab ID | String | Identifier assigned for internal tracking of a sample by a laboratory. | |
100
|
Sample Type | String | Defines sample as Sample, Field Duplicate, Field Blank, or Reference, generally based on field sample form designation. Currently only defined for samples from QM. | |
100
|
Result Type | String | Distinguishes an Analysis Result as a "Calculation" or a raw "Result." A "Calculation" combines data from multiple individual "Results." If no result is available, this field will show "Status Information Only." | |
100
|
Lab Name | String | Lab which performed analysis. | |
100
|
Sample Delivery Group | String | Analytical batch as identified by the laboratory. | |
100
|
Percent Lipid | String | Percent lipids for a tissue sample, usually measured as total extractable organics. | |
100
|
Number in Composite | String | Number of individual samples combined to form a composite. | |
100
|
Length (cm) | String | Length of organism in centimeters, averaged for composites. | |
100
|
Weight (g) | String | Weight of organism in grams; total weight of organisms in a composite. | |
100
|
Age (years) | String | TBD | |
100
|
Tissue Type | String | For tissue samples, additional detail on whether the whole body or a component part of tissue was sampled and analyzed, such as the eggs, muscle, etc. | |
100
|
Sex | String | Gender of sampled organism. | |
100
|
Data Category | String | General category of data collection (e.g., Instruments, Photographs, Samples, or Visual Observations). | |
100
|
Location_Geom | String | Samples Cube - LocationGeom.LocationGeom Hierarchy - Location_Geom Level | |
100
|
legend_text | String | legend_text | |
100
|
map_index | String | map_index | |
100
|
Start Latitude | String | Sample Latitude in decimal degrees, or start Latitude for samples collected by trawl, transect or in a line. | |
100
|
Start Longitude | String | Sample Longitude in decimal degrees, or start longitude for samples collected by trawl, transect or in a line. | |
100
|
End Latitude | String | End Latitude in decimal degrees for trawls, transects or samples collected in a line. | |
100
|
End Longitude | String | End Longitude in decimal degrees for trawls, transects or samples collected in a line. |
Attribute Details
Date
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Data collection date, as year, month, and day. |
Case/Activity
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the case incident or the activity used to collect data. |
QM Site ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifier for a site in the Query Manager database. |
Collection Study Name
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the study under which the field data were collected. |
QM Study ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code assigned to each study in Query Manager; this is unique across the QM national dataset. |
Area Description
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of area assigned to Photologger Photo |
Station/Site
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station or site identifier. This is often defined by the workplan and/or recorded by the field team, but may be standardized to database requirements. |
Station Description
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Description of station, or grouping (by reach, by section of river, by embayment) |
Station Group List
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Predefined sets of grouped stations/locations |
QM Sample ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifier for a sample in the Query Manager database. |
Sample ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID assigned to each sample by the field sampler. |
Collection Matrix
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The type of sample or record collected (e.g., Sediment, Water, Photograph, Wipe). |
Species Group
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Samples - Great Lakes Cube - Species Group.Species Group Hierarchy - Species Group Level |
Common Name: Species
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name for the species' biological Species. |
Latin Name: Genus
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latin name for the species' biological Genus. |
Latin Name: Species
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latin name for the species' biological Species. |
Collection Form
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The type of the data submission form used by the field team to submit raw field data. |
Workspace Name
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the Portal Workspace where data were entered. |
Data Classification
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The purpose for which data was collected within the case incident or activity. |
Data Source
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The originating owner of the dataset. |
Source Type
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
General owner/source of the data (e.g., NRDA, Response, Responsible Party). |
Sharing Status
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifies extent of data distribution (e.g., Publicly Available). |
Workgroup
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Technical Working Group under which the field data were collected. |
Collection Workplan
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The workplan under which the field data were collected. |
Habitat Type
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Standardized habitat type based on habitat reported on the field team's collection form. |
Organism ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identification assigned to organism (e.g. dolphin, turtle) by field team |
Results Status
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Samples - Great Lakes Cube - Results Status.Results Status Hierarchy - Results Status Level |
DIVER Dataset
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
DIVER’s internal database table name |
File Collection ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Record identifier for the corresponding DIVER file collection. |
Analysis Category
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
General category of analysis performed (e.g., Plankton_Nekton, Visual Observation, Contaminant Chemistry). For additional detail, see Analysis Type and/or Analysis. |
Analysis Type
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Subcategory (i.e., type) of analysis performed, such as Biomass, Hematology, Genetics, etc. For additional detail, see Analysis. |
Analysis
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Specific chemical or physical property measured. For groupings of analyses, see Analysis Type and/or Analysis Category. |
ChemCode
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Abbreviation used to represent Analysis. See Chemical Dictionary for key. |
Lab Replicate
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Replicate number if the laboratory analyzed the same sample multiple times by the same method (lab duplicates, typically indicated by 1,2,3) or by different methods for the same analyte (less preferred method will generally have an X). |
Analysis Result
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured result of the Analysis. May be text or number. |
Analysis Result Unit
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unit of the Analysis Result. |
Measurement Basis
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Samples - Great Lakes Cube - Measurement Basis.Measurement Basis Hierarchy - Measurement Basis Level |
QM Matrix
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifier for location of results in the Query Manager structure - sediment, water, oil, tissue. |
Lab/Result Matrix
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The main substance of a sample as recorded by the laboratory for analysis. This may differ from the sample's Collection Matrix, which is determined by the field sampler. |
Lab/Result Matrix Detailed
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information on matrix as reported by laboratory. Includes tissue type, if applicable. |
Analysis Method
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Laboratory method applied to perform analysis, if specified (e.g., 8081B or 8270C). |
Qualifier Code
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Analytical qualifier code. See Data Dictionary for code definitions. |
Detection Extent
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Text interpretation of qualifier codes related to the detection limit for the analyte result. |
Review Status
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extent of data quality review performed. |
Detection Limit
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lab-calculated concentration limit for an analyte. Method- and analyte-specific. |
Reporting Limit
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Level at which target analytes are reported (practical quantitation limit). |
Validation Level
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Specific level of validation performed for contaminant chemistry samples. See Data Dictionary for code definitions. |
Collection Method
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sampling method employed by field sampler to collect a physical sample. |
Depth Category
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This applies to sediment samples, and classifies them as surface sediment (upper depth of 0 cm and lower depth less than 30 cm) or subsurface sediment. |
Sample Upper Depth
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The upper depth of a sediment, soil, water, oil, or tar sample. |
Sample Lower Depth
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The lower depth of a sediment, soil, water, oil, or tar sample. |
Sample Depth Unit
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The unit of the depth measurement. |
Lab ID
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifier assigned for internal tracking of a sample by a laboratory. |
Sample Type
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Defines sample as Sample, Field Duplicate, Field Blank, or Reference, generally based on field sample form designation. Currently only defined for samples from QM. |
Result Type
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Distinguishes an Analysis Result as a "Calculation" or a raw "Result." A "Calculation" combines data from multiple individual "Results." If no result is available, this field will show "Status Information Only." |
Lab Name
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lab which performed analysis. |
Sample Delivery Group
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Analytical batch as identified by the laboratory. |
Percent Lipid
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Percent lipids for a tissue sample, usually measured as total extractable organics. |
Number in Composite
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of individual samples combined to form a composite. |
Length (cm)
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length of organism in centimeters, averaged for composites. |
Weight (g)
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight of organism in grams; total weight of organisms in a composite. |
Age (years)
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
TBD |
Tissue Type
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
For tissue samples, additional detail on whether the whole body or a component part of tissue was sampled and analyzed, such as the eggs, muscle, etc. |
Sex
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Gender of sampled organism. |
Data Category
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
General category of data collection (e.g., Instruments, Photographs, Samples, or Visual Observations). |
Location_Geom
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Samples Cube - LocationGeom.LocationGeom Hierarchy - Location_Geom Level |
legend_text
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
legend_text |
map_index
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
map_index |
Start Latitude
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sample Latitude in decimal degrees, or start Latitude for samples collected by trawl, transect or in a line. |
Start Longitude
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sample Longitude in decimal degrees, or start longitude for samples collected by trawl, transect or in a line. |
End Latitude
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End Latitude in decimal degrees for trawls, transects or samples collected in a line. |
End Longitude
Data Storage Type: | String |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End Longitude in decimal degrees for trawls, transects or samples collected in a line. |
Catalog Details
Catalog Item ID: | 58366 |
---|---|
GUID: | gov.noaa.nmfs.inport:58366 |
Metadata Record Created By: | Terrance Wang |
Metadata Record Created: | 2019-12-23 13:14+0000 |
Metadata Record Last Modified By: | Adam Rotert |
Metadata Record Last Modified: | 2023-02-15 20:12+0000 |
Metadata Record Published: | 2023-02-15 |
Owner Org: | ORR |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-05-01 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-05-01 |