36179
View: V0_CORAL_OBS_E_PRESENCE
V0_CORAL_OBS_E_PRESENCE
Entity
Published / External
36164
National Coral Reef Monitoring Program: Stratified Random Surveys (StRS) of Coral Demography (Adult and Juvenile Corals) across the Hawaiian Archipelago since 2013
Data Set
Completed
Coral belt observations (presence)
Updated Feb 2019 to reflect addition of monument-led surveys 2014 and 2015. Presence surveys do not apply to PMNM-led missions in 2014 or 2015.
Updated TRANSECT description on June 19 2019 in anticipation of diver calibration data to be collected on transect 2 during HARAMP surveys (legs 2 and 3).
Data View
Yes
GISDAT
Coral belt observations (presence)
1
ROUNDID
NUMBER
22
Yes
No
28
0
Active
Unique Identifier for ROUND record.
2
MISSIONID
VARCHAR2
30
Yes
No
Active
Mission Identifier.
3
REGION
VARCHAR2
20
Yes
No
Active
Code for REGION_NAME.
4
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.
5
ISLANDCODE
NVARCHAR2
15
No
No
Active
3-letter code for ISLAND.
6
ISLAND
NVARCHAR2
150
No
No
Active
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
7
SITE
NVARCHAR2
150
Yes
No
Active
The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
8
LATITUDE
NUMBER
22
No
No
38
Active
Latitude in decimal degrees, WGS84, for the given SITE.
9
LONGITUDE
NUMBER
22
No
No
Active
Longitude in decimal degrees, WGS84 for the given SITE.
10
REEF_ZONE_CODE
VARCHAR2
3
Yes
No
Active
3-letter code for REEF_ZONE.
11
REEF_ZONE
NVARCHAR2
150
No
No
Active
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
12
HABITAT_CODE
VARCHAR2
50
No
No
Active
3-letter code for HABITAT_TYPE.
12
HABITAT_TYPE
VARCHAR2
30
No
No
Active
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
12
SITE_MIN_DEPTH
NUMBER
22
No
No
5
0
Active
Minimum SITE depth (ft).
13
SITE_MAX_DEPTH
NUMBER
22
No
No
5
0
Active
Maximum SITE depth (ft).
14
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
14
SITEVISITID
NUMBER
22
Yes
No
Active
Unique identifier created each time a SITE is surveyed on a DATE_.
14
DEPTH_CODE
VARCHAR2
1
No
No
Active
Single-letter code for DEPTH_BIN (S, M, D).
15
DATE_
DATE
7
Yes
No
Active
Local date the survey was conducted.
16
OBS_DAY
NUMBER
22
No
No
Active
Numeric day the survey was conducted (DATE_).
17
OBS_MONTH
NUMBER
22
No
No
38
Active
Numeric month the survey was conducted (DATE_).
18
OBS_YEAR
NUMBER
22
No
No
Active
4-digit year the survey was conducted (DATE_).
23
NO_SURVEY_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate transect was not surveyed (Added Sept. 2014).
23
PHOTOS_TAKEN
NUMBER
No
No
Active
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).
24
DIVER
NVARCHAR2
150
Yes
No
Active
Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.
25
METHODNAME
NVARCHAR2
150
Yes
No
Active
References the coral belt survey method.
26
TRANSECT
NUMBER
22
Yes
No
38
0
Active
Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset
26
TRANSECTID
NUMBER
No
No
Active
Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
26
BELTTRANSECTRUN
NUMBER
22
Yes
No
38
0
Active
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
26
TRANSECTNUM
NUMBER
No
No
Active
Unique identifier for each transect surveyed within a SITE.
26
SEGMENTID
NUMBER
No
No
Active
Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
27
SEGMENT
NVARCHAR2
150
No
No
Active
Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.
28
SEGLENGTH
NUMBER
22
No
No
28
8
Active
Segment length (m).
29
CORL_YN
NUMBER
No
No
Active
Flag (-1) to indicate presence of corallimorph on transect.
29
NO_COLONY_OBSERVED
NUMBER
No
No
Active
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
29
SEGWIDTH
NUMBER
22
No
No
38
8
Active
Segment width (m).
30
CORALLIMORPH_YN
NUMERIC
No
No
Active
Flag (-1) to indicate presence of corallimorph on transect (Added Feb. 2015).
31
CLADIELLA_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate presence of cladiella on transect (Added Sept. 2014)
32
DENDRONEPHTHYA_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate presence of dendronephthya on transect (Added Sept. 2014).
33
DISTICHOPORA_YN
NUMERIC
No
No
Active
Flag (-1) to indicate presence of distichopora on transect (Added Feb. 2015).
34
LOBOPHYTUM_YN
NUMBER
22
No
No
38
Active
Flag (-1) to indicate presence of lobophytum on transect (Added Sept. 2014).
35
OCTO_YN
NUMERIC
No
No
Active
Flag (-1) to indicate presence of octocoral on transect (added 2015).
36
PACHYCLAVULARIA_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate presence of pachyclavularia on transect (Added Sept. 2014).
37
PALYTHOA_YN
NUMBER
22
No
No
38
Active
Flag (-1) to indicate presence of palythoa on transect (Added Sept. 2014).
38
PROTOPALYTHOA_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate presence of protopalythoa on transect (Added Sept. 2014).
39
SARCOPHYTON_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
40
SARCOTHELIA_YN
NUMERIC
No
No
Active
Flag (-1) to indicate presence of sarcothelia on transect (added 2017).
41
SINULARIA_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate presence of sinularia on transect (Added Sept. 2014).
42
SOFT_YN
NUMERIC
No
No
Active
Flag (-1) to indicate presence of soft coral on transect (added 2015).
43
STEREONEPHTHYA_YN
NUMBER
22
No
No
38
Active
Flag (-1) to indicate presence of stereonephthya on transect (Added Sept. 2014).
44
STYLASTER_YN
NUMERIC
No
No
Active
Flag (-1) to indicate presence of stylaster on transect (Added Feb. 2015).
45
WIRECORAL_YN
NUMBER
22
No
No
Active
Flag (-1) to indicate presence of wire coral on transect (Added Sept. 2014).
46
ZOANTHUS_YN
NUMBER
22
No
No
38
Active
Flag (-1) to indicate presence of zoanthus on transect (Added Sept. 2014).
gov.noaa.nmfs.inport:36179
Troy Kanemura
2016-12-31T00:51:29
Lori Luers
2022-10-20T01:21:11
2022-10-20
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-11-24
1 Year
2021-11-24