Hawaii Bleaching 2019: Benthic Cover Data Dictionary
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:59196 | Updated: October 1, 2022 | Published / External
Item Identification
| Title: | Hawaii Bleaching 2019: Benthic Cover Data Dictionary |
|---|---|
| Status: | Completed |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Data dictionary for the benthic image analysis results for StR and fixed sites surveyed during the 2019 bleaching surveys across the Hawaiian Archipelago. A new bleaching label set was generated for annotations run through CoralNet to allow for hard coral to be identified as bleached or non-bleached. |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
ROUNDID | NUMERIC | Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.) | |
|
100
|
MISSIONID | TEXT | Mission Identifier typically assigned by PIFSC | |
|
100
|
REGION | TEXT | Region acronym | |
|
100
|
REGION_NAME | TEXT | One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas. | |
|
100
|
ISLANDCODE | TEXT | Code of island or atoll surveyed | |
|
100
|
ISLAND | TEXT | Island or Atoll surveyed | |
|
100
|
SITE | TEXT | The 5- to 6- character code for the site surveyed. Combines a 3-letter island code with a site number | |
|
100
|
OCC_SITEID | TEXT | Ocean Climate Change site identifier | |
|
100
|
PERM_SITE | NUMERIC | Permanent site flag, yes = -1 | |
|
100
|
CLIMATE_STATION_YN | NUMERIC | Climate station flag, yes = -1 | |
|
100
|
SITEVISITID | TEXT | Unique numeric identifier for the instance of the site survey | |
|
100
|
DATE_ | DATE | Date the survey was conducted | |
|
100
|
OBS_YEAR | NUMERIC | Year the survey was conducted | |
|
100
|
OBS_MONTH | NUMERIC | Month the survey was conducted | |
|
100
|
OBS_DAY | NUMERIC | Day the survey was conducted | |
|
100
|
LATITUDE | NUMERIC | Site latitude in decimal degrees | |
|
100
|
LONGITUDE | NUMERIC | Site longitude in decimal degrees | |
|
100
|
MIN_DEPTH | NUMERIC | Minimum depth (measured in feet) | |
|
100
|
MAX_DEPTH | NUMERIC | Maximum depth (measured in feet) | |
|
100
|
ORIGINAL_FILE_NAME | TEXT | Original file name of the image analyzed | |
|
100
|
REPLICATE | NUMERIC | Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3 (REP column in previous years) | |
|
100
|
IMAGE_NUMBER | NUMERIC | Image number along transect | |
|
100
|
DATE_ANNOTATED | DATE | Date the image was annotated | |
|
100
|
ANNOTATOR | TEXT | Name of the annotator | |
|
100
|
ROW_ | NUMERIC | X position of the analyzed point | |
|
100
|
COL | NUMERIC | Y position of the analyzed point | |
|
100
|
NAME | TEXT | Classification name of the point on the analyzed image | |
|
100
|
SHORT_CODE | TEXT | Classification code of the point on the analyzed image | |
|
100
|
FUNCTIONAL_GROUP | TEXT | Functional group of the point on the analyzed image |
Attribute Details
ROUNDID
CC ID: 901979
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 28 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Unique Identifier auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.) |
MISSIONID
CC ID: 901972
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mission Identifier typically assigned by PIFSC |
REGION
CC ID: 901976
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Region acronym |
REGION_NAME
CC ID: 901977
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 30 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
One of the five Pacific Island regions ESD surveys: Main Hawaiian islands, Northwestern Hawaiian islands, American Samoa, Marianas, and the Pacific Remote Island Areas. |
ISLANDCODE
CC ID: 901964
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 60 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code of island or atoll surveyed |
ISLAND
CC ID: 901967
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island or Atoll surveyed |
SITE
CC ID: 901980
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The 5- to 6- character code for the site surveyed. Combines a 3-letter island code with a site number |
OCC_SITEID
CC ID: 1179564
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | TEXT |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Ocean Climate Change site identifier |
PERM_SITE
CC ID: 901974
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 5 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Permanent site flag, yes = -1 |
CLIMATE_STATION_YN
CC ID: 901962
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Climate station flag, yes = -1 |
SITEVISITID
CC ID: 901983
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique numeric identifier for the instance of the site survey |
DATE_
CC ID: 901963
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the survey was conducted |
OBS_YEAR
CC ID: 901973
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 16 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year the survey was conducted |
OBS_MONTH
CC ID: 901961
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Month the survey was conducted |
OBS_DAY
CC ID: 901984
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Day the survey was conducted |
LATITUDE
CC ID: 901968
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 8 |
| Status: | Active |
| Description: |
Site latitude in decimal degrees |
LONGITUDE
CC ID: 901969
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 28 |
| Scale: | 8 |
| Status: | Active |
| Description: |
Site longitude in decimal degrees |
MIN_DEPTH
CC ID: 901971
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Scale: | 8 |
| Status: | Active |
| Description: |
Minimum depth (measured in feet) |
MAX_DEPTH
CC ID: 901970
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 28 |
| Scale: | 8 |
| Status: | Active |
| Description: |
Maximum depth (measured in feet) |
ORIGINAL_FILE_NAME
CC ID: 901966
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Original file name of the image analyzed |
REPLICATE
CC ID: 901978
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Letter associated to replicate (A, B, C, or D) or to photo number if no replicate. Photo 1-9 = 0 Photo 10-19 = 1 Photo 20-29 = 2 Photo 30-39 = 3 (REP column in previous years) |
IMAGE_NUMBER
CC ID: 901975
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 4000 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Image number along transect |
DATE_ANNOTATED
CC ID: 901981
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the image was annotated |
ANNOTATOR
CC ID: 901960
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name of the annotator |
ROW_
CC ID: 901986
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
X position of the analyzed point |
COL
CC ID: 901987
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMERIC |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Y position of the analyzed point |
NAME
CC ID: 901985
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | TEXT |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Classification name of the point on the analyzed image |
SHORT_CODE
CC ID: 901982
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | TEXT |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Classification code of the point on the analyzed image |
FUNCTIONAL_GROUP
CC ID: 1179565
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | TEXT |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Functional group of the point on the analyzed image |
Catalog Details
| Catalog Item ID: | 59196 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:59196 |
| Metadata Record Created By: | Annette M DesRochers |
| Metadata Record Created: | 2020-03-31 16:44+0000 |
| Metadata Record Last Modified By: | Lori H Luers |
| Metadata Record Last Modified: | 2022-10-01 02:06+0000 |
| Metadata Record Published: | 2022-10-01 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2022-08-10 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2023-08-10 |