60741
BIA_CNET_ANALYSIS_DataDictionary
Entity
Published / External
36155
National Coral Reef Monitoring Program: Benthic Cover Derived from Analysis of Benthic Images Collected during Stratified Random Surveys (StRS) across the Hawaiian Archipelago from 2013 to 2019
Data Set
Completed
Data Table
Yes
Benthic image analysis results for stratified random sites
1
ROUNDID
NUMBER
22
Yes
No
28
0
Active
Unique Identifier for MISSIONID auto-assigned by database for ROUND record (corresponds to mission, cruise, cruise leg, etc.).
2
MISSIONID
VARCHAR2
30
Yes
No
Active
Mission Identifier.
3
REGION_NAME
VARCHAR2
30
No
No
Active
The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
4
ISLAND
NVARCHAR2
150
No
No
Active
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
5
SITE
NVARCHAR2
150
No
No
Active
The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-5 digit site number, separated by a hyphen.
5
SITEVISITID
NUMERIC
No
No
Active
IC Unique identifier created each time a SITE is surveyed on a DATE_.
6
LATITUDE
NUMBER
22
No
No
38
8
Active
Latitude in decimal degrees, WGS84, for the given SITE.
7
LONGITUDE
NUMBER
22
No
No
28
8
Active
Longitude in decimal degrees, WGS84 for the given SITE.
8
REEF_ZONE
NVARCHAR2
150
No
No
Active
The reef zone for the given SITE (Forereef, Backreef, Lagoon, Protected Slope).
9
DEPTH_BIN
NVARCHAR2
60
No
No
Active
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.
10
PERM_SITE
NUMBER
22
No
No
5
0
Active
Flag for PERMANENT SITE (-1), many of which were established in the early years of the Pacific Reef Assessment and Monitoring Program. Applicable only to climate sites surveyed by the oceanography team, not applicable to stratified random sites and therefore all records in this dataset are NULL. Only a subset of activities conducted at CLIMATE STATIONS are conducted at PERMANENT SITES. Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and in some cases may be flagged as both or none.
11
CLIMATE_STATION_YN
NUMBER
22
No
No
Active
Flag for NOAA National Coral Reef Monitoring Program CLIMATE STATION (-1). Applicable only to climate sites surveyed by the oceanography team, and therefor all records in this dataset are zero or NULL. CLIMATE STATIONS are PERMANENT SITES (regardless of PERM_SITE flag). Climate sites are usually flagged as PERM_SITE or CLIMATE_STATION, and may be flagged as both or none. Typically, 3-4 CLIMATE STATIONS were selected to be roughly equally spaced around the island/atoll, along the 15-m contour, on hard bottom, and at least 1-km away from a river mouth or embayment (if relevant to the island/atoll). Multiple features of the coral reef environment are assessed at CLIMATE STATIONS, including in-situ water temperature using subsurface temperature recorders (STRs), seawater carbonate chemistry from water samples, net carbonate accretion using calcification accretion units (CAUs), bioerosion using bioerosion monitoring units (BMUs), and cryptobiota diversity using autonomous reef monitoring structures (ARMS).
12
MIN_DEPTH
NUMBER
22
No
No
38
8
Active
Minimum depth (measured in feet). Only recorded for coral demographic surveys.
13
MAX_DEPTH
NUMBER
22
No
No
28
8
Active
Maximum depth (measured in feet). Only recorded for coral demographic surveys.
14
DATE_
DATE
7
Yes
No
Active
Date the survey was conducted (d-mmm-yy).
15
IMAGE_NAME
VARCHAR2
4000
No
No
Active
Image name (SITE_YEAR_REP_PHOTOID).
16
OBS_YEAR
VARCHAR2
16
No
No
Active
4-digit year the survey was conducted (DATE_).
17
REPLICATE
VARCHAR2
4
No
No
Active
Letter associated to replicate / transect for the survey. In 2013 and 2016, Rep A is for reef fish surveys and Rep A or B is for coral demographic surveys. In 2019, all fish and coral surveys are rep A.
18
PHOTOID
VARCHAR2
4000
No
No
Active
Sequential image number along transect, usually 1-30, though some sites may have less than or exceed 30 images.
19
ANALYST
VARCHAR2
20
No
No
Active
Username of the person that annotated the images. The analyst for automated annotations (as opposed to annotations generated by humans) is ALLEVIATE (aka the CoralNet Robot).
20
TIER_1
VARCHAR2
5
No
No
Active
Code for CATEGORY NAME.
21
CATEGORY_NAME
VARCHAR2
20
No
No
Active
Category classification for the point on the analyzed image (X POS, Y POS). Taxa/functional group includes: coral, coralline alga, macroalga, mobile fauna, sediment, sessile invertebrate, soft coral, tape and wand, turf alga, and unclassified.
22
TIER_2
VARCHAR2
5
No
No
Active
Code for SUBCATEGORY NAME.
23
SUBCATEGORY_NAME
VARCHAR2
50
No
No
Active
Subcategory classification name for the point on the analyzed image (X POS, Y POS). Includes morphology for hard corals and functional groups (giant clam, zoanthid, etc.)
24
TIER_3
VARCHAR2
5
No
No
Active
Code for GENERA NAME.
25
GENERA_NAME
VARCHAR2
50
No
No
Active
Genus taxonomic name for the point on the analyzed image (X POS, Y POS) or the subcategory classification/description.
26
X_POS
NUMBER
22
No
No
38
Active
X position of the analyzed point on the image.
27
Y_POS
NUMBER
22
No
No
Active
Y position of the analyzed point on the image.
gov.noaa.nmfs.inport:60741
Morgan Winston
2020-07-21T15:21:53
Lori Luers
2022-11-26T00:18:34
2020-08-17
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
http://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2020-08-17
1 Year
2021-08-17