35991
View: V0_FISH_REA
V0_FISH_REA
Entity
Published / External
35774
Rebreather Fish Surveys in American Samoa from 2016-04-15 to 2016-05-05
Data Set
Completed
Object Comments:. Fish REA foundational view
Data View
Yes
GISDAT
Object Comments:. Fish REA foundational view
1
OBJECTID
NUMBER
22
Yes
No
38
0
Active
Unique identifier for fish REA observations
2
ROUNDID
NUMBER
22
Yes
No
28
0
Active
Unique Identifier for ROUND record
3
MISSIONID
VARCHAR2
30
Yes
No
Active
Mission Identifier
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
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
7
LATITUDE
NUMBER
22
No
No
38
Active
Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
8
LONGITUDE
NUMBER
22
No
No
Active
Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
9
REEF_ZONE
NVARCHAR2
150
No
No
Active
The reef zone for the given site (Forereef, Backreef or Lagoon)
10
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. Shallow=0-6 m, Mid=6-18 m, Deep=18-30 m
11
SITEVISITID
NUMBER
22
Yes
No
38
Active
Unique Identifier for SITE_VISIT record
12
DATE_
DATE
7
Yes
No
Active
Date the survey was conducted
13
OBS_YEAR
NUMBER
22
No
No
38
Active
Year the survey was conducted
14
DIVER
NVARCHAR2
150
Yes
No
Active
Initials of diver conducting survey
15
REPLICATEID
NUMBER
22
Yes
No
38
0
Active
Unique identifier for the replicate sample within a Fish REA survey
16
REP
NVARCHAR2
150
No
No
Active
Letter associated to replicate (A, B, C, or D)
17
METHOD
NVARCHAR2
150
Yes
No
Active
Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)
18
PHOTOGRAPHER
NUMBER
22
No
No
5
0
Active
Flag to indicate photographer of benthic photos. Two divers simultaneously conduct a survey at a site (indicated by the initials of the observer in the DIVER field), only one of which captures the benthic photos. Value = -1 indicates the photographer.
19
TRAINING_YN
NUMBER
22
No
No
Active
Flag to signify whether replicate was for training purposes. Value = -1 indicates the replicate was for training.
20
DEPTH
NUMBER
22
No
No
38
Active
Depth of survey area in meters
21
SURVEY_RADIUS_M
NUMBER
22
No
No
Active
Radius of survey area in meters
22
HARD_CORAL
NUMBER
22
No
No
Active
Hard Coral %
23
SOFT_CORAL
NUMBER
22
No
No
38
Active
Soft Coral %
24
MA
NUMBER
22
No
No
Active
Macroalgae %
25
CCA
NUMBER
22
No
No
38
Active
Crustose Coralline Algae %
26
TA
NUMBER
22
No
No
38
Active
Turf Algae %
27
SAND
NUMBER
22
No
No
38
Active
Sand %
28
TUNICATE
NUMBER
22
No
No
38
Active
Tunicate %
29
ZOANTHID
NUMBER
22
No
No
38
Active
Zoanthid %
30
CORALLIMORPH
NUMBER
22
No
No
38
Active
Corallimorph %
31
CLAM
NUMBER
22
No
No
38
Active
Clam %
32
CYANO
NUMBER
22
No
No
38
Active
Cyanobacteria %
33
SPONGE
NUMBER
22
No
No
38
Active
Sponge %
34
OTHER
NUMBER
22
No
No
Active
Other benthic composition value %
35
OTHER_TYPE
VARCHAR2
20
No
No
Active
Other benthic composition type
36
HABITAT_CODE
VARCHAR2
50
No
No
Active
Habitat Type (see HABITAT_TYPE) for description of code.
37
HABITAT_TYPE
VARCHAR2
50
No
No
Active
Habitat description
38
CURRENT_STRENGTH
VARCHAR2
20
No
No
Active
Current Strength (None, Slight, Moderate, High)
39
VISIBILITY
NUMBER
22
No
No
38
8
Active
Visibility measured in meters
40
MIN_DEPTH
NUMBER
22
No
No
Active
Minimum slope depth in meters
41
MAX_DEPTH
NUMBER
22
No
No
38
Active
Maximum slope depth in meters
42
SUBSTRATE_HEIGHT_0
NUMBER
22
No
No
38
8
Active
Substrate complexity between 0cm and 20cm elevation
43
SUBSTRATE_HEIGHT_20
NUMBER
22
No
No
38
8
Active
Substrate complexity between 20cm and 50cm elevation
44
SUBSTRATE_HEIGHT_50
NUMBER
22
No
No
38
8
Active
Substrate complexity between 50cm and 100cm elevation
45
SUBSTRATE_HEIGHT_100
NUMBER
22
No
No
38
8
Active
Substrate complexity between 100cm and 150cm elevation
46
SUBSTRATE_HEIGHT_150
NUMBER
22
No
No
38
8
Active
Substrate complexity over 150cm elevation
47
MAX_HEIGHT
NUMBER
22
No
No
Active
Highest elevation point in SPC cylinder measured in centimeters
48
URCHIN_DACOR
VARCHAR2
1
No
No
Active
Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare)
49
BORING_URCHIN_DACOR
VARCHAR2
1
No
No
Active
Boring Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare)
50
SPECIES
NVARCHAR2
150
Yes
No
Active
4-letter species code
51
TAXONNAME
NVARCHAR2
765
Yes
No
Active
Scientific name
52
COMMONNAME
NVARCHAR2
150
No
No
Active
Common name (from FishBase)
53
COMMONFAMILYALL
NVARCHAR2
150
No
No
Active
Common name of all families
54
FAMILY
NVARCHAR2
150
No
No
Active
Taxonomic family classification
55
SCIENTIFIC_NAME
VARCHAR2
255
No
No
Active
Holds the true scientific name
56
RANK
VARCHAR2
20
No
No
Active
Lowest defined rank in taxonomic hierarchy
57
TROPHIC
NVARCHAR2
150
No
No
Active
Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)
58
TROPHIC_MONREP
NVARCHAR2
150
No
No
Active
Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)
59
LW_A
NUMBER
22
No
No
38
8
Active
Parameter "a" used in length-weight calculations
60
LW_B
NUMBER
22
No
No
28
8
Active
Parameter "b" used in length-weight calculations
61
LMAX
NUMBER
22
No
No
28
8
Active
Maximum length of the fish published in literature
62
LENGTH_CONVERSION_FACTOR
NUMBER
22
No
No
28
8
Active
Factor to convert length as total length by to get it to right form (SL or FL or TL) for available length weight A and B parameters for this species
63
COUNT
NUMBER
22
No
No
5
0
Active
Number of fish observed during survey
64
SIZE_
NUMBER
22
No
No
38
8
Active
Total length of fish, measured from the tip of the snout to the tip of the longer lobe of the caudal fin, reported in centimeters. Total length for rays (Myliobatidae) is measured from pectoral fin tip to pectoral fin tip.
65
OBS_TYPE
VARCHAR2
1
No
No
Active
A single letter representation of the observation type (I: Instantaneous, N: Non-Instantaneous, F: After 5 minutes, T: After 10 minutes, P: Presence, U: Unknown)
66
OBS_DESC
VARCHAR2
20
Yes
No
Active
The definition of the observation type
gov.noaa.nmfs.inport:35991
Troy Kanemura
2016-12-14T17:51:48
SysAdmin InPortAdmin
2022-08-09T17:11:17
2017-11-22
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-11-22
1 Year
2018-11-22