NCRMP_FGB2022_Fish_Data02B_Raw_Substrate.csv
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:71018 | Updated: October 17, 2023 | Published / External
Item Identification
| Title: | NCRMP_FGB2022_Fish_Data02B_Raw_Substrate.csv |
|---|---|
| Status: | Completed |
| Abstract: |
Specific benthic information from the diver cylinder, including biotic and abiotic cover, rugosity, relief and slope. |
| Purpose: |
To provide Specific benthic information from the diver cylinder, including biotic and abiotic cover, rugosity, relief and slope. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Specific benthic information from the diver cylinder, including biotic and abiotic cover, rugosity, relief and slope. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
MASTER_SAMPLE_CD | Character | Link to primary key in fish sample table | |
|
100
|
SUBSTRATE_MAX_DEPTH | Numeric | Maximum depth of cylinder feet | |
|
100
|
SUBSTRATE_MIN_DEPTH | Numeric | Minimum depth of cylinder feet | |
|
100
|
HARD_VERTICAL_RELIEF | Numeric | Highest hard vertical relief in cylinder meters | |
|
100
|
SOFT_VERTICAL_RELIEF | Numeric | Highest short vertical relief in cylinder meters | |
|
100
|
h_relcat_0 | Numeric | Percentage surface relief coverage on hardbottom category < 0.2m | |
|
100
|
h_relcat_1 | Numeric | Percentage surface relief coverage on hardbottom category 0.2 - 0.5m | |
|
100
|
h_relcat_2 | Numeric | Percentage surface relief coverage on hardbottom category 0.5 - 1.0m | |
|
100
|
h_relcat_3 | Numeric | Percentage surface relief coverage on hardbottom category 1.0 - 1.5m | |
|
100
|
h_relcat_4 | Numeric | Percentage surface relief coverage on hardbottom category > 1.5m | |
|
100
|
s_relcat_0 | Numeric | Percentage surface relief coverage on softbottom category < 0.2m | |
|
100
|
s_relcat_1 | Numeric | Percentage surface relief coverage on softbottom category 0.2 - 0.5m | |
|
100
|
s_relcat_2 | Numeric | Percentage surface relief coverage on softbottom category 0.5 - 1.0m | |
|
100
|
s_relcat_3 | Numeric | Percentage surface relief coverage on softbottom category 1.0 - 1.5m | |
|
100
|
s_relcat_4 | Numeric | Percentage surface relief coverage on softbottom category > 1.5m | |
|
100
|
SAND_PERCENTAGE | Numeric | Abiotic percentge sand in cylinder | |
|
100
|
HARDB_PRECENTAGE | Numeric | Abiotic percentge hardbottom in cylinder | |
|
100
|
RUBBLE_PERCENTAGE | Numeric | Abiotic percentge rubble in cylinder | |
|
100
|
SAND_BARE | Numeric | Biotic cover percentage in sand bare | |
|
100
|
SAND_MACRO_ALGAE | Numeric | Biotic cover percentage in sand macro algae | |
|
100
|
SAND_SEAGRASS | Numeric | Biotic cover percentage in sand seagrass | |
|
100
|
SAND_SPONGE | Numeric | Biotic cover percentage in sand sponges | |
|
100
|
s_pcov_oth1_lab | Numeric | Biotic cover label in sand other 1 | |
|
100
|
s_pcov_oth2_lab | Numeric | Biotic cover label in sand other 2 | |
|
100
|
s_pcov_oth1 | Numeric | Biotic cover percentage in sand other 1 | |
|
100
|
s_pcov_oth2 | Numeric | Biotic cover percentage in sand other 1 | |
|
100
|
HARDBOTTOM_ALGAL_TURF | Numeric | Biotic cover percentage on hardbottom turf algae | |
|
100
|
HARBOTTOM_MACRO_ALGAE | Numeric | Biotic cover percentage on hardbottom macro algae | |
|
100
|
HARDBOTTOM_LIVE_CORAL | Numeric | Biotic cover percentage on hardbottom turf live coral | |
|
100
|
HARDBOTTOM_OCTOCORAL | Numeric | Biotic cover percentage on hardbottom turf octocoral | |
|
100
|
HARDBOTTOM_SPONGE | Numeric | Biotic cover percentage on hardbottom turf sponge | |
|
100
|
h_pcov_oth1_lab | Numeric | Biotic cover label on hardbottom other 1 | |
|
100
|
h_pcov_oth2_lab | Numeric | Biotic cover label on hardbottom other 2 | |
|
100
|
h_pcov_oth1 | Numeric | Biotic cover percentage on hardbottom other 1 | |
|
100
|
h_pcov_oth2 | Numeric | Biotic cover percentage on hardbottom other 2 |
Attribute Details
MASTER_SAMPLE_CD
CC ID: 1275445
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | Character |
| Max Length: | 17 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Link to primary key in fish sample table |
SUBSTRATE_MAX_DEPTH
CC ID: 1275453
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Maximum depth of cylinder feet |
| Unit of Measure: | Feet |
SUBSTRATE_MIN_DEPTH
CC ID: 1275454
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minimum depth of cylinder feet |
| Unit of Measure: | Feet |
HARD_VERTICAL_RELIEF
CC ID: 1275444
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Highest hard vertical relief in cylinder meters |
| Unit of Measure: | meters |
SOFT_VERTICAL_RELIEF
CC ID: 1275452
| Seq. Order: | 50 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Highest short vertical relief in cylinder meters |
| Unit of Measure: | meters |
h_relcat_0
CC ID: 1275457
| Seq. Order: | 60 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on hardbottom category < 0.2m |
h_relcat_1
CC ID: 1275458
| Seq. Order: | 70 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on hardbottom category 0.2 - 0.5m |
h_relcat_2
CC ID: 1275459
| Seq. Order: | 80 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Percentage surface relief coverage on hardbottom category 0.5 - 1.0m |
h_relcat_3
CC ID: 1275460
| Seq. Order: | 90 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on hardbottom category 1.0 - 1.5m |
h_relcat_4
CC ID: 1275461
| Seq. Order: | 100 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on hardbottom category > 1.5m |
s_relcat_0
CC ID: 1275466
| Seq. Order: | 110 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on softbottom category < 0.2m |
s_relcat_1
CC ID: 1275467
| Seq. Order: | 120 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Percentage surface relief coverage on softbottom category 0.2 - 0.5m |
s_relcat_2
CC ID: 1275468
| Seq. Order: | 130 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Percentage surface relief coverage on softbottom category 0.5 - 1.0m |
s_relcat_3
CC ID: 1275469
| Seq. Order: | 140 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on softbottom category 1.0 - 1.5m |
s_relcat_4
CC ID: 1275470
| Seq. Order: | 150 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Percentage surface relief coverage on softbottom category > 1.5m |
SAND_PERCENTAGE
CC ID: 1275449
| Seq. Order: | 160 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Abiotic percentge sand in cylinder |
HARDB_PRECENTAGE
CC ID: 1275443
| Seq. Order: | 170 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Abiotic percentge hardbottom in cylinder |
RUBBLE_PERCENTAGE
CC ID: 1275446
| Seq. Order: | 175 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Abiotic percentge rubble in cylinder |
SAND_BARE
CC ID: 1275447
| Seq. Order: | 180 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage in sand bare |
SAND_MACRO_ALGAE
CC ID: 1275448
| Seq. Order: | 190 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage in sand macro algae |
SAND_SEAGRASS
CC ID: 1275450
| Seq. Order: | 200 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage in sand seagrass |
SAND_SPONGE
CC ID: 1275451
| Seq. Order: | 210 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage in sand sponges |
s_pcov_oth1_lab
CC ID: 1275463
| Seq. Order: | 220 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover label in sand other 1 |
s_pcov_oth2_lab
CC ID: 1275465
| Seq. Order: | 240 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover label in sand other 2 |
s_pcov_oth1
CC ID: 1275462
| Seq. Order: | 250 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage in sand other 1 |
s_pcov_oth2
CC ID: 1275464
| Seq. Order: | 260 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage in sand other 1 |
HARDBOTTOM_ALGAL_TURF
CC ID: 1275441
| Seq. Order: | 270 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom turf algae |
HARBOTTOM_MACRO_ALGAE
CC ID: 1275436
| Seq. Order: | 280 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom macro algae |
HARDBOTTOM_LIVE_CORAL
CC ID: 1275437
| Seq. Order: | 290 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom turf live coral |
HARDBOTTOM_OCTOCORAL
CC ID: 1275438
| Seq. Order: | 300 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom turf octocoral |
HARDBOTTOM_SPONGE
CC ID: 1275442
| Seq. Order: | 310 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom turf sponge |
h_pcov_oth1_lab
CC ID: 1275456
| Seq. Order: | 320 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover label on hardbottom other 1 |
h_pcov_oth2_lab
CC ID: 1275440
| Seq. Order: | 330 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover label on hardbottom other 2 |
h_pcov_oth1
CC ID: 1275455
| Seq. Order: | 340 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom other 1 |
h_pcov_oth2
CC ID: 1275439
| Seq. Order: | 350 |
|---|---|
| Data Storage Type: | Numeric |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 3 |
| Status: | Active |
| Description: |
Biotic cover percentage on hardbottom other 2 |
Support Roles
Distributor
CC ID: 1275471
| Date Effective From: | 2023 |
|---|---|
| Date Effective To: | |
| Contact (Organization): | National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD) |
| Address: |
NOAA/NESDIS E/OC SSMC3, 4th Floor, 1351 East-West Highway Silver Spring, MD 20910-3282 |
| Phone: | (301) 713-3277 |
Distribution Information
Distribution 1
CC ID: 1275472
| Start Date: | 2023 |
|---|---|
| End Date: | Present |
| Download URL: | https://www.ncei.noaa.gov/archive/accession/0277994/1.1/data/0-data/Data_Sets/NCRMP_FGB2022_Fish_Data02B_Raw_Substrate.csv |
| Distributor: | National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD) (2023 - Present) |
| File Name: | NCRMP_FGB2022_Fish_Data02B_Raw_Substrate.csv |
| File Date/Time: | 2023-04-26 15:10:00 |
| File Type (Deprecated): | tabular digital data (Microsoft Excel, CSV, or other tabular format) |
| Distribution Format: | CSV - Comma Separated Values (Text) |
| File Size: | 11K |
| Compression: | Uncompressed |
| Review Status: | Chked Viruses Inapp Content |
Catalog Details
| Catalog Item ID: | 71018 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:71018 |
| Metadata Record Created By: | Lee M Weinberger |
| Metadata Record Created: | 2023-10-05 11:05+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2023-10-17 16:12+0000 |
| Metadata Record Published: | 2023-10-05 |
| Owner Org: | SEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2022-02-28 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2023-02-28 |