36181
View: V0_CORAL_OBS_E_PRESENCE 2013-2016
V0_CORAL_OBS_E_PRESENCE 2013-2016
Entity
Published / External
36166
National Coral Reef Monitoring Program: Stratified Random Surveys (StRS) of Coral Demography (Adult and Juvenile Corals) across the Pacific Remote Island Areas from 2014 to 2018
Data Set
Completed
Coral belt observations (presence)
Loaded by batch 9632, 12-31-2016 00:51
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
Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
4
REGION_NAME
VARCHAR2
30
No
No
Active
One of the five Pacific Island regions CRED surveys
5
ISLAND
NVARCHAR2
150
No
No
Active
Island or Atoll surveyed
6
ISLANDCODE
NVARCHAR2
15
No
No
Active
3-letter island code
7
SITE
NVARCHAR2
150
Yes
No
Active
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a 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 reef zone code
11
REEF_ZONE
NVARCHAR2
150
No
No
Active
The reef zone for the given site (Forereef, Backreef or Lagoon)
12
DEPTH_BIN
NVARCHAR2
60
No
No
Active
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
13
DEPTH_CODE
VARCHAR2
1
No
No
Active
Depth zone code
14
SITEVISITID
NUMBER
22
Yes
No
Active
Unique Identifier for SITE_VISIT record
15
DATE_
DATE
7
Yes
No
Active
Date the survey was conducted
16
OBS_DAY
NUMBER
22
No
No
Active
Observation Day
17
OBS_MONTH
NUMBER
22
No
No
38
Active
Observation Month
18
OBS_YEAR
NUMBER
22
No
No
Active
Observation Year
19
SITE_MIN_DEPTH
NUMBER
22
No
No
5
0
Active
Minimum site depth (ft)
20
SITE_MAX_DEPTH
NUMBER
22
No
No
5
0
Active
Maximum site depth (ft)
21
HABITAT_CODE
VARCHAR2
50
No
No
Active
Habitat code
22
HABITAT_TYPE
VARCHAR2
30
No
No
Active
Habitat type
23
DIVER
NVARCHAR2
150
Yes
No
Active
Initials of diver conducting survey
24
BELTTRANSECTRUN
NUMBER
22
Yes
No
38
0
Active
Primary key for CORAL_BELT_TRANSECTRUN
25
METHODNAME
NVARCHAR2
150
Yes
No
Active
References the coral belt survey method
26
TRANSECT
NUMBER
22
Yes
No
38
0
Active
Transect Number
27
SEGMENT
NVARCHAR2
150
No
No
Active
Segment Number
28
SEGWIDTH
NUMBER
22
No
No
38
8
Active
Segment Length (m)
29
SEGLENGTH
NUMBER
22
No
No
28
8
Active
Segment Width (m)
30
CLADIELLA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of cladiella on transect (Added Sept. 2014)
31
DENDRONEPHTHYA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
32
LOBOPHYTUM_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
33
PACHYCLAVULARIA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
34
SARCOPHYTON_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
35
SINULARIA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of sinularia on transect (Added Sept. 2014)
36
STEREONEPHTHYA_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
37
WIRECORAL_YN
NUMBER
22
No
No
Active
Flag to indicate presence of wire coral on transect (Added Sept. 2014)
38
PALYTHOA_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of palythoa on transect (Added Sept. 2014)
39
PROTOPALYTHOA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
40
ZOANTHUS_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
41
NO_SURVEY_YN
NUMBER
22
No
No
Active
Flag to indicate transect was not surveyed (Added Sept. 2014)
gov.noaa.nmfs.inport:36181
Troy Kanemura
2016-12-31T00:52:41
SysAdmin InPortAdmin
2022-08-09T17:11:17
2017-06-21
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
2017-06-21
1 Year
2018-06-21