tblSIMRAD_Env_Transects
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34061 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | tblSIMRAD_Env_Transects |
|---|---|
| Short Name: | tblSIMRAD_Env_Transects |
| Abstract: |
Water quality data from hydroacoustic surveys |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Water quality data from hydroacoustic surveys |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
Date | Date/Time | Date of sampling event | |
|
100
|
Time | Date/Time | Time (Eastern Time) of start of survey | |
|
100
|
Latitude | Double | Latitude position of observation in UTM (NAD 1983) | |
|
100
|
Longitude | Double | Latitude position of observation in UTM (NAD 1983) | |
|
100
|
SpCond_uS/cm | Double | Sensor recorded water specific conductance recorded in microsiemens per centimter (uS/cm) | |
|
100
|
Temp_C | Double | Sensor recorded water temperature recorded in degrees Celcius | |
|
100
|
pH | Double | Sensor recorded water pH recorded in standard units | |
|
100
|
Salinity_ppt | Double | Sensor recorded water salinity recorded in parts per thousand (ppt) | |
|
100
|
Turbidity_NTU | Double | Sensor recorded water turbidity recorded in (NTU) | |
|
100
|
YSI_Model | Double | model number of sonde used to record parameters | |
|
100
|
pH mV | Double | Sensor recorded pH millivolts | |
|
100
|
ODOsat % | Double | Sensor recorded water oxygen saturation in percent saturation (%) | |
|
100
|
ODO mg/L | Double | Sensor recorded water oxygen saturation in milligrams per liter (mg/L) | |
|
100
|
Battery volts | Double | Sonde recorded battery voltage | |
|
100
|
Date_Time | Date/Time | No description available | |
|
100
|
TSS_mgL | Double | Sensor recorded water total suspended solids in milligrams per liter (mg/L) | |
|
100
|
TDS_mgL | Double | Sensor recorded water total disssolved solids in milligrams per liter (mg/L) | |
|
100
|
DateTime | Date/Time | Concatinated date-time field rounded to nearest minute used to link to other observations during acoustic surveys | |
|
100
|
EnvID | Long Integer | Unique autonumber of trip used for maintaining referetial integrity |
Attribute Details
Date
CC ID: 342475
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | Date/Time |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date of sampling event |
| General Data Type: | Date/Time |
Time
CC ID: 342476
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | Date/Time |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time (Eastern Time) of start of survey |
| General Data Type: | Date/Time |
Latitude
CC ID: 342478
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude position of observation in UTM (NAD 1983) |
| General Data Type: | Number |
Longitude
CC ID: 342479
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude position of observation in UTM (NAD 1983) |
| General Data Type: | Number |
SpCond_uS/cm
CC ID: 342481
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water specific conductance recorded in microsiemens per centimter (uS/cm) |
| General Data Type: | Number |
Temp_C
CC ID: 342482
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water temperature recorded in degrees Celcius |
| General Data Type: | Number |
pH
CC ID: 342480
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water pH recorded in standard units |
| General Data Type: | Number |
Salinity_ppt
CC ID: 342483
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water salinity recorded in parts per thousand (ppt) |
| General Data Type: | Number |
Turbidity_NTU
CC ID: 342485
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | Double |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water turbidity recorded in (NTU) |
| General Data Type: | Text |
YSI_Model
CC ID: 342484
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
model number of sonde used to record parameters |
| General Data Type: | Number |
pH mV
CC ID: 342486
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded pH millivolts |
| General Data Type: | Number |
ODOsat %
CC ID: 342487
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water oxygen saturation in percent saturation (%) |
| General Data Type: | Number |
ODO mg/L
CC ID: 342488
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water oxygen saturation in milligrams per liter (mg/L) |
| General Data Type: | Number |
Battery volts
CC ID: 825990
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sonde recorded battery voltage |
Date_Time
CC ID: 825991
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | Date/Time |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
No description available |
TSS_mgL
CC ID: 825992
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water total suspended solids in milligrams per liter (mg/L) |
TDS_mgL
CC ID: 825993
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | Double |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sensor recorded water total disssolved solids in milligrams per liter (mg/L) |
DateTime
CC ID: 825994
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | Date/Time |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Concatinated date-time field rounded to nearest minute used to link to other observations during acoustic surveys |
EnvID
CC ID: 825995
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | Long Integer |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique autonumber of trip used for maintaining referetial integrity |
Catalog Details
| Catalog Item ID: | 34061 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:34061 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-08-03 14:01+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-08-08 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-08-08 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-08-08 |