Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Pacific Reef Assessment and Monitoring Program:... >

View: V0_FISH_REA BLT

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36869 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Object Comments:. Fish REA foundational view

Description

Object Comments:. Fish REA foundational view

Entity Type
Data View

Data Attribute / Type	Description
OBJECTID NUMBER	Unique identifier for fish REA observations
ROUNDID NUMBER	Unique Identifier for ROUND record
MISSIONID VARCHAR2	Mission Identifier
REGION_NAME VARCHAR2	One of the five Pacific Island regions CRED surveys
ISLAND NVARCHAR2	Island or Atoll surveyed
SITE NVARCHAR2	The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
LATITUDE NUMBER	Site latitude as recorded by divers on the Dive & Nav Info datasheets
LONGITUDE NUMBER	Site longitude as recorded by divers on the Dive & Nav Info datasheets
REEF_ZONE NVARCHAR2	The reef zone for the given site (Forereef, Backreef or Lagoon)
DEPTH_BIN NVARCHAR2	Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
SITEVISITID NUMBER	Unique Identifier for SITE_VISIT record
DATE_ DATE	Date the survey was conducted
OBS_YEAR NUMBER	Year the survey was conducted
DIVER NVARCHAR2	Initials of diver conducting survey
REPLICATEID NUMBER	Unique identifier for the replicate sample within a Fish REA survey
REP NVARCHAR2	Letter associated to replicate (A, B, C, or D)
METHOD NVARCHAR2	Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)
DEPTH NUMBER	Depth of survey area in meters
SURVEY_LENGTH_M NUMBER	Length of survey area in meters
SURVEY_WIDTH_M NUMBER	Width of survey area in meters
SPECIES NVARCHAR2	4-letter species code
TAXONNAME NVARCHAR2	Scientific name
COMMONNAME NVARCHAR2	Common name (from FishBase)
COMMONFAMILYALL NVARCHAR2	Common name of all families
FAMILY NVARCHAR2	Taxonomic family classification
SCIENTIFIC_NAME VARCHAR2	Holds the true scientific name
RANK VARCHAR2	Lowest defined rank in taxonomic hierarchy
TROPHIC NVARCHAR2	Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)
TROPHIC_MONREP NVARCHAR2	Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)
LW_A NUMBER	Parameter "a" used in length-weight calculations
LW_B NUMBER	Parameter "b" used in length-weight calculations
LMAX NUMBER	Maximum length of the fish published in literature
LENGTH_CONVERSION_FACTOR NUMBER	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
COUNT NUMBER	Number of fish observed during survey
SIZE_ NUMBER	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.

Data Attribute / Type

Description

OBJECTID
NUMBER

Unique identifier for fish REA observations

ROUNDID
NUMBER

Unique Identifier for ROUND record

MISSIONID
VARCHAR2

Mission Identifier

REGION_NAME
VARCHAR2

One of the five Pacific Island regions CRED surveys

ISLAND
NVARCHAR2

Island or Atoll surveyed

SITE
NVARCHAR2

The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number

LATITUDE
NUMBER

Site latitude as recorded by divers on the Dive & Nav Info datasheets

LONGITUDE
NUMBER

Site longitude as recorded by divers on the Dive & Nav Info datasheets

REEF_ZONE
NVARCHAR2

The reef zone for the given site (Forereef, Backreef or Lagoon)

DEPTH_BIN
NVARCHAR2

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site

SITEVISITID
NUMBER

Unique Identifier for SITE_VISIT record

DATE_
DATE

Date the survey was conducted

OBS_YEAR
NUMBER

Year the survey was conducted

DIVER
NVARCHAR2

Initials of diver conducting survey

REPLICATEID
NUMBER

Unique identifier for the replicate sample within a Fish REA survey

REP
NVARCHAR2

Letter associated to replicate (A, B, C, or D)

METHOD
NVARCHAR2

Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)

DEPTH
NUMBER

Depth of survey area in meters

SURVEY_LENGTH_M
NUMBER

Length of survey area in meters

SURVEY_WIDTH_M
NUMBER

Width of survey area in meters

SPECIES
NVARCHAR2

4-letter species code

TAXONNAME
NVARCHAR2

Scientific name

COMMONNAME
NVARCHAR2

Common name (from FishBase)

COMMONFAMILYALL
NVARCHAR2

Common name of all families

FAMILY
NVARCHAR2

Taxonomic family classification

SCIENTIFIC_NAME
VARCHAR2

Holds the true scientific name

RANK
VARCHAR2

Lowest defined rank in taxonomic hierarchy

TROPHIC
NVARCHAR2

Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)

TROPHIC_MONREP
NVARCHAR2

Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)

LW_A
NUMBER

Parameter "a" used in length-weight calculations

LW_B
NUMBER

Parameter "b" used in length-weight calculations

LMAX
NUMBER

Maximum length of the fish published in literature

LENGTH_CONVERSION_FACTOR
NUMBER

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

COUNT
NUMBER

Number of fish observed during survey

SIZE_
NUMBER

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	View: V0_FISH_REA BLT
Short Name:	V0_FISH_REA BLT
Status:	Completed
Abstract:	Object Comments:. Fish REA foundational view
Notes:	Loaded by batch 9575, 12-14-2016 17:48

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Object Comments:. Fish REA foundational view

Attribute Summary

	Name	Type	Description
100	OBJECTID	NUMBER	Unique identifier for fish REA observations
100	ROUNDID	NUMBER	Unique Identifier for ROUND record
100	MISSIONID	VARCHAR2	Mission Identifier
100	REGION_NAME	VARCHAR2	One of the five Pacific Island regions CRED surveys
100	ISLAND	NVARCHAR2	Island or Atoll surveyed
100	SITE	NVARCHAR2	The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100	LATITUDE	NUMBER	Site latitude as recorded by divers on the Dive & Nav Info datasheets
100	LONGITUDE	NUMBER	Site longitude as recorded by divers on the Dive & Nav Info datasheets
100	REEF_ZONE	NVARCHAR2	The reef zone for the given site (Forereef, Backreef or Lagoon)
100	DEPTH_BIN	NVARCHAR2	Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100	SITEVISITID	NUMBER	Unique Identifier for SITE_VISIT record
100	DATE_	DATE	Date the survey was conducted
100	OBS_YEAR	NUMBER	Year the survey was conducted
100	DIVER	NVARCHAR2	Initials of diver conducting survey
100	REPLICATEID	NUMBER	Unique identifier for the replicate sample within a Fish REA survey
100	REP	NVARCHAR2	Letter associated to replicate (A, B, C, or D)
100	METHOD	NVARCHAR2	Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)
100	DEPTH	NUMBER	Depth of survey area in meters
100	SURVEY_LENGTH_M	NUMBER	Length of survey area in meters
100	SURVEY_WIDTH_M	NUMBER	Width of survey area in meters
100	SPECIES	NVARCHAR2	4-letter species code
100	TAXONNAME	NVARCHAR2	Scientific name
100	COMMONNAME	NVARCHAR2	Common name (from FishBase)
100	COMMONFAMILYALL	NVARCHAR2	Common name of all families
100	FAMILY	NVARCHAR2	Taxonomic family classification
100	SCIENTIFIC_NAME	VARCHAR2	Holds the true scientific name
100	RANK	VARCHAR2	Lowest defined rank in taxonomic hierarchy
100	TROPHIC	NVARCHAR2	Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)
100	TROPHIC_MONREP	NVARCHAR2	Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)
100	LW_A	NUMBER	Parameter "a" used in length-weight calculations
100	LW_B	NUMBER	Parameter "b" used in length-weight calculations
100	LMAX	NUMBER	Maximum length of the fish published in literature
100	LENGTH_CONVERSION_FACTOR	NUMBER	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
100	COUNT	NUMBER	Number of fish observed during survey
100	SIZE_	NUMBER	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.

Name

Type

Description

100

OBJECTID

NUMBER

Unique identifier for fish REA observations

100

ROUNDID

NUMBER

Unique Identifier for ROUND record

100

MISSIONID

VARCHAR2

Mission Identifier

100

REGION_NAME

VARCHAR2

One of the five Pacific Island regions CRED surveys

100

ISLAND

NVARCHAR2

Island or Atoll surveyed

100

SITE

NVARCHAR2

The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number

100

LATITUDE

NUMBER

Site latitude as recorded by divers on the Dive & Nav Info datasheets

100

LONGITUDE

NUMBER

Site longitude as recorded by divers on the Dive & Nav Info datasheets

100

REEF_ZONE

NVARCHAR2

The reef zone for the given site (Forereef, Backreef or Lagoon)

100

DEPTH_BIN

NVARCHAR2

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site

100

SITEVISITID

NUMBER

Unique Identifier for SITE_VISIT record

100

DATE_

DATE

Date the survey was conducted

100

OBS_YEAR

NUMBER

Year the survey was conducted

100

DIVER

NVARCHAR2

Initials of diver conducting survey

100

REPLICATEID

NUMBER

Unique identifier for the replicate sample within a Fish REA survey

100

REP

NVARCHAR2

Letter associated to replicate (A, B, C, or D)

100

METHOD

NVARCHAR2

Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)

100

DEPTH

NUMBER

Depth of survey area in meters

100

SURVEY_LENGTH_M

NUMBER

Length of survey area in meters

100

SURVEY_WIDTH_M

NUMBER

Width of survey area in meters

100

SPECIES

NVARCHAR2

4-letter species code

100

TAXONNAME

NVARCHAR2

Scientific name

100

COMMONNAME

NVARCHAR2

Common name (from FishBase)

100

COMMONFAMILYALL

NVARCHAR2

Common name of all families

100

FAMILY

NVARCHAR2

Taxonomic family classification

100

SCIENTIFIC_NAME

VARCHAR2

Holds the true scientific name

100

RANK

VARCHAR2

Lowest defined rank in taxonomic hierarchy

100

TROPHIC

NVARCHAR2

Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)

100

TROPHIC_MONREP

NVARCHAR2

Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)

100

LW_A

NUMBER

Parameter "a" used in length-weight calculations

100

LW_B

NUMBER

Parameter "b" used in length-weight calculations

100

LMAX

NUMBER

Maximum length of the fish published in literature

100

LENGTH_CONVERSION_FACTOR

NUMBER

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

100

COUNT

NUMBER

Number of fish observed during survey

100

SIZE_

NUMBER

Attribute Details

OBJECTID

CC ID: 382613

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Unique identifier for fish REA observations

ROUNDID

CC ID: 382625

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Unique Identifier for ROUND record

MISSIONID

CC ID: 382612

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Mission Identifier

REGION_NAME

CC ID: 382622

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	One of the five Pacific Island regions CRED surveys

ISLAND

CC ID: 382600

Seq. Order:	5
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Island or Atoll surveyed

SITE

CC ID: 382628

Seq. Order:	6
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number

LATITUDE

CC ID: 382601

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Site latitude as recorded by divers on the Dive & Nav Info datasheets

LONGITUDE

CC ID: 382604

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Site longitude as recorded by divers on the Dive & Nav Info datasheets

REEF_ZONE

CC ID: 382621

Seq. Order:	9
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	The reef zone for the given site (Forereef, Backreef or Lagoon)

DEPTH_BIN

CC ID: 382594

Seq. Order:	10
Data Storage Type:	NVARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site

SITEVISITID

CC ID: 382629

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Unique Identifier for SITE_VISIT record

DATE_

CC ID: 382592

Seq. Order:	12
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date the survey was conducted

OBS_YEAR

CC ID: 382616

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Year the survey was conducted

DIVER

CC ID: 382595

Seq. Order:	14
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Initials of diver conducting survey

REPLICATEID

CC ID: 382624

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Unique identifier for the replicate sample within a Fish REA survey

REP

CC ID: 382623

Seq. Order:	16
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Letter associated to replicate (A, B, C, or D)

METHOD

CC ID: 382610

Seq. Order:	17
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)

DEPTH

CC ID: 382593

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Depth of survey area in meters

SURVEY_LENGTH_M

CC ID: 382639

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Length of survey area in meters

SURVEY_WIDTH_M

CC ID: 382599

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Width of survey area in meters

SPECIES

CC ID: 382632

Seq. Order:	21
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	4-letter species code

TAXONNAME

CC ID: 382641

Seq. Order:	22
Data Storage Type:	NVARCHAR2
Max Length:	765
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Scientific name

COMMONNAME

CC ID: 382587

Seq. Order:	23
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Common name (from FishBase)

COMMONFAMILYALL

CC ID: 382586

Seq. Order:	24
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Common name of all families

FAMILY

CC ID: 382596

Seq. Order:	25
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic family classification

SCIENTIFIC_NAME

CC ID: 382627

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Holds the true scientific name

RANK

CC ID: 382620

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Lowest defined rank in taxonomic hierarchy

TROPHIC

CC ID: 382643

Seq. Order:	28
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)

TROPHIC_MONREP

CC ID: 382644

Seq. Order:	29
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore)

LW_A

CC ID: 382605

Seq. Order:	30
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Parameter "a" used in length-weight calculations

LW_B

CC ID: 382606

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Parameter "b" used in length-weight calculations

LMAX

CC ID: 382603

Seq. Order:	32
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Maximum length of the fish published in literature

LENGTH_CONVERSION_FACTOR

CC ID: 382602

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	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

COUNT

CC ID: 382589

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Number of fish observed during survey

SIZE_

CC ID: 382630

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	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.

Catalog Item ID:	36869
GUID:	gov.noaa.nmfs.inport:36869
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2017-02-22 15:49+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-04-28
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-04-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-04-28

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

OBJECTID

ROUNDID

MISSIONID

REGION_NAME

ISLAND

SITE

LATITUDE

LONGITUDE

REEF_ZONE

DEPTH_BIN

SITEVISITID

DATE_

OBS_YEAR

DIVER

REPLICATEID

REP

METHOD

DEPTH

SURVEY_LENGTH_M

SURVEY_WIDTH_M

SPECIES

TAXONNAME

COMMONNAME

COMMONFAMILYALL

FAMILY

SCIENTIFIC_NAME

RANK

TROPHIC

TROPHIC_MONREP

LW_A

LW_B

LMAX

LENGTH_CONVERSION_FACTOR

COUNT

SIZE_

Catalog Details