27438
View: V0_CORAL_OBS_E
V0_CORAL_OBS_E
Entity
Published / External
25326
Determining Watershed Management Efficacy in West Maui: Belt transect surveys of coral demography (adult and juvenile corals) from 2014 to 2015
Data Set
Completed
Coral belt observations (adult)
Loaded by batch 7116, 09-23-2015 23:05
Data View
Yes
GISDAT
Coral belt observations (adult)
1
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
VARCHAR2
2
REGION_NAME
VARCHAR2
30
No
No
Active
One of the five Pacific Island regions CRED surveys
VARCHAR2
3
ISLAND
NVARCHAR2
150
No
No
Active
Island or Atoll surveyed
NVARCHAR2
4
ISLANDCODE
NVARCHAR2
15
No
No
Active
3-letter island code
NVARCHAR2
5
SECTOR
VARCHAR2
20
No
No
Active
This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
VARCHAR2
6
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
NVARCHAR2
7
LATITUDE
NUMBER
22
No
No
38
Active
Latitude in decimal degrees, WGS84, for the given site
NUMBER
8
LONGITUDE
NUMBER
22
No
No
Active
Longitude in decimal degrees, WGS84 for the given site
NUMBER
9
REEF_ZONE_CODE
VARCHAR2
3
Yes
No
Active
3-letter reef zone code
VARCHAR2
10
REEF_ZONE
NVARCHAR2
150
No
No
Active
The reef zone for the given site (Forereef, Backreef or Lagoon)
NVARCHAR2
11
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
NVARCHAR2
12
DEPTH_CODE
VARCHAR2
1
No
No
Active
Depth zone code
VARCHAR2
13
EXCLUDE_FLAG
NUMBER
22
No
No
38
Active
Flag to indicate whether site should be excluded from analysis
NUMBER
14
SITEVISITID
NUMBER
22
Yes
No
Active
Unique Identifier for SITE_VISIT record
NUMBER
15
DATE_
DATE
7
Yes
No
Active
Date the survey was conducted
DATE
16
OBS_DAY
NUMBER
22
No
No
Active
Observation Day
NUMBER
17
OBS_MONTH
NUMBER
22
No
No
38
Active
Observation Month
NUMBER
18
OBS_YEAR
NUMBER
22
No
No
Active
Observation Year
NUMBER
19
HABITAT_CODE
VARCHAR2
50
No
No
Active
Habitat code
VARCHAR2
20
HABITAT_TYPE
VARCHAR2
30
No
No
Active
Habitat type
VARCHAR2
21
COMMENTS
NVARCHAR2
750
No
No
Active
General observation comments
NVARCHAR2
22
DIVER
NVARCHAR2
150
Yes
No
Active
Initials of diver conducting survey
NVARCHAR2
23
BELTTRANSECTRUN
NUMBER
22
Yes
No
38
0
Active
Primary key for CORAL_BELT_TRANSECTRUN
NUMBER
24
METHODNAME
NVARCHAR2
150
Yes
No
Active
References the coral belt survey method
NVARCHAR2
25
TRANSECT
NUMBER
22
Yes
No
38
0
Active
Transect Number
NUMBER
26
SEGMENT
NVARCHAR2
150
No
No
Active
Segment Number
NVARCHAR2
27
TRANWIDTH
NUMBER
22
No
No
38
8
Active
Transect Length (m)
NUMBER
28
TRANLENGTH
NUMBER
22
No
No
28
8
Active
Transect Width (m)
NUMBER
29
MINDEPTH
NUMBER
22
No
No
28
0
Active
Minimum Depth of the transect (in meters)
NUMBER
30
MAXDEPTH
NUMBER
22
No
No
28
0
Active
Maximum Depth of the transect (in meters)
NUMBER
31
CLADIELLA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of cladiella on transect (Added Sept. 2014)
NUMBER
32
DENDRONEPHTHYA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of dendronephthya on transect (Added Sept. 2014)
NUMBER
33
LOBOPHYTUM_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of lobophytum on transect (Added Sept. 2014)
NUMBER
34
PACHYCLAVULARIA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of pachyclavularia on transect (Added Sept. 2014)
NUMBER
35
SARCOPHYTON_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
NUMBER
36
SINULARIA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of sinularia on transect (Added Sept. 2014)
NUMBER
37
STEREONEPHTHYA_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of stereonephthya on transect (Added Sept. 2014)
NUMBER
38
WIRECORAL_YN
NUMBER
22
No
No
Active
Flag to indicate presence of wire coral on transect (Added Sept. 2014)
NUMBER
39
PALYTHOA_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of palythoa on transect (Added Sept. 2014)
NUMBER
40
PROTOPALYTHOA_YN
NUMBER
22
No
No
Active
Flag to indicate presence of protopalythoa on transect (Added Sept. 2014)
NUMBER
41
ZOANTHUS_YN
NUMBER
22
No
No
38
Active
Flag to indicate presence of zoanthus on transect (Added Sept. 2014)
NUMBER
42
NO_SURVEY_YN
NUMBER
22
No
No
Active
Flag to indicate transect was not surveyed (Added Sept. 2014)
NUMBER
43
COLONYID
NUMBER
22
No
No
38
0
Active
Colony Identifier
NUMBER
44
SPECIES
NVARCHAR2
150
No
No
Active
Species observed
NVARCHAR2
45
MORPH_CODE
VARCHAR2
5
No
No
Active
4-letter morphology code
VARCHAR2
46
MORPHOLOGY
VARCHAR2
50
No
No
Active
Definition of morphology code
VARCHAR2
47
COLONYLENGTH
NUMBER
22
No
No
38
8
Active
Colony Length (cm)
NUMBER
48
OLDDEAD
NUMBER
22
No
No
5
0
Active
Percentage of old dead coral
NUMBER
49
RECENTDEAD
NUMBER
22
No
No
5
0
Active
Percentage of recently dead coral
NUMBER
50
RECENT_GENERAL_CAUSE_CODE
VARCHAR2
4
No
No
Active
General cause code of recently dead coral captured in RECENTDEAD field
VARCHAR2
51
RECENT_SPECIFIC_CAUSE_CODE
VARCHAR2
4
No
No
Active
Specific cause code of recently dead coral captured in RECENTDEAD field
VARCHAR2
52
RECENTDEAD_2
NUMBER
22
No
No
5
0
Active
Percentage of recently dead coral
NUMBER
53
RECENT_GENERAL_CAUSE_CODE_2
VARCHAR2
4
No
No
Active
General cause code of recently dead coral captured in RECENTDEAD_2 field
VARCHAR2
54
RECENT_SPECIFIC_CAUSE_CODE_2
VARCHAR2
4
No
No
Active
Specific cause code of recently dead coral captured in RECENTDEAD_2 field
VARCHAR2
55
DZCODE
NVARCHAR2
15
No
No
Active
Coral disease code of the observed coral colony
NVARCHAR2
56
DZCLASS
NVARCHAR2
150
No
No
Active
Coral Disease
NVARCHAR2
57
MAP_CODE
NVARCHAR2
150
No
No
Active
The map code for the coral disease
NVARCHAR2
58
EXTENT
NUMBER
22
No
No
38
0
Active
Disease Extent (1-100)
NUMBER
59
SEVERITY
NUMBER
22
No
No
5
0
Active
Disease Severity (1-5)
NUMBER
60
TAXONNAME
NVARCHAR2
765
No
No
Active
Taxonomic Name
NVARCHAR2
61
PHYLUM
VARCHAR2
255
No
No
Active
Phylum Taxonomic Rank
VARCHAR2
62
CLASS
NVARCHAR2
60
No
No
Active
Class Taxonomic Rank
NVARCHAR2
63
S_ORDER
VARCHAR2
255
No
No
Active
Order Taxonomic Rank
VARCHAR2
64
FAMILY
VARCHAR2
255
No
No
Active
Family Taxonomic Rank
VARCHAR2
65
GENUS_CODE
NVARCHAR2
12
No
No
Active
4-letter genus code
NVARCHAR2
66
GENUS
NVARCHAR2
300
No
No
Active
Genus Taxonomic Rank
NVARCHAR2
67
SCIENTIFIC_NAME
VARCHAR2
255
No
No
Active
Scientific Name Taxonomic Rank
VARCHAR2
68
RANK
VARCHAR2
20
No
No
Active
Rank from WoRMS
VARCHAR2
69
APHIAID
VARCHAR2
20
No
No
Active
Aphia ID from WoRMS
VARCHAR2
70
CORAL_CORISID
NUMBER
22
No
No
Active
CoRIS ID for coral metadata record (Added June 2011)
NUMBER
gov.noaa.nmfs.inport:27438
Annette DesRochers
2015-09-23T23:05:10
SysAdmin InPortAdmin
2022-08-09T17:11:04
2020-04-03
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-04-03
1 Year
2021-04-03