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

Item Identification

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 Information

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

Data Attributes

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

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.

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 Details

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