Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Benthic Missions > Benthic Surveys in Faga'alu, American Samoa: be... >

View: V0_BENT_LPI

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

Item Identification

Title:	View: V0_BENT_LPI
Status:	Completed
Abstract:	LPI foundational view

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	LPI foundational view

Data Attributes

Attribute Summary

	Name	Type	Description
100	OBJECTID	NUMBER	Unique identifier for benthic LPI 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	SITEVISITID	NUMBER	Unique Identifier
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	Latitude in decimal degrees, WGS84, for the given site
100	LONGITUDE	NUMBER	Longitude in decimal degrees, WGS84 for the given site
100	REEF_ZONE	NVARCHAR2	The reef zone for the given site (Forereef, Backreef or Lagoon)
100	DATE_	DATE	Date the survey was conducted
100	OBS_YEAR	NUMBER	Year the survey was conducted
100	LPITRANSECTRUN	NUMBER	Unique sample identifier to link observation data to transects
100	DIVER	NVARCHAR2	Line Point Intersect (LPI) Diver
100	MINDEPTH	NUMBER	Line Point Intersect (LPI) transect minimum depth
100	MAXDEPTH	NUMBER	Line Point Intersect (LPI) transect maximum depth
100	METHODCODE	NVARCHAR2	Line Point Intersect (LPI) Method Code
100	CALIBRATION	NUMBER	Added Sept. 2010
100	TRANNUM	NUMBER	Transect Number for the Line Point Intersect (LPI) survey
100	LPI_SEG	NVARCHAR2	Distance along the transect between 0 and 25M where the intersect lies
100	BENTHICCODE	NVARCHAR2	Line Point Intersect (LPI) species benthic code
100	FAMILY	VARCHAR2	FAMILY value returned by the WoRMS web service
100	GENUS	VARCHAR2	GENUS value returned by the WoRMS web service
100	CATEGORY_GENUS	NVARCHAR2	Line Point Intersect (LPI) species category genus
100	BENTHICNAME	NVARCHAR2	Line Point Intersect (LPI) species benthic name
100	BENTHICCATEGORY	NVARCHAR2	Line Point Intersect (LPI) species benthic category
100	COMMON_NAME	NVARCHAR2	Common name of given benthic element
100	COUNT	NUMBER	Line Point Intersect (LPI) observation count
100	KINGDOM	TEXT	KINGDOM taxonomic rank
100	PHYLUM	TEXT	PHYLUM taxonomic rank
100	CLASS	TEXT	CLASS taxonomic rank
100	S_ORDER	TEXT	ORDER taxonomic rank

Name

Type

Description

100

OBJECTID

NUMBER

Unique identifier for benthic LPI 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

SITEVISITID

NUMBER

Unique Identifier

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

Latitude in decimal degrees, WGS84, for the given site

100

LONGITUDE

NUMBER

Longitude in decimal degrees, WGS84 for the given site

100

REEF_ZONE

NVARCHAR2

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

100

DATE_

DATE

Date the survey was conducted

100

OBS_YEAR

NUMBER

Year the survey was conducted

100

LPITRANSECTRUN

NUMBER

Unique sample identifier to link observation data to transects

100

DIVER

NVARCHAR2

Line Point Intersect (LPI) Diver

100

MINDEPTH

NUMBER

Line Point Intersect (LPI) transect minimum depth

100

MAXDEPTH

NUMBER

Line Point Intersect (LPI) transect maximum depth

100

METHODCODE

NVARCHAR2

Line Point Intersect (LPI) Method Code

100

CALIBRATION

NUMBER

Added Sept. 2010

100

TRANNUM

NUMBER

Transect Number for the Line Point Intersect (LPI) survey

100

LPI_SEG

NVARCHAR2

Distance along the transect between 0 and 25M where the intersect lies

100

BENTHICCODE

NVARCHAR2

Line Point Intersect (LPI) species benthic code

100

FAMILY

VARCHAR2

FAMILY value returned by the WoRMS web service

100

GENUS

VARCHAR2

GENUS value returned by the WoRMS web service

100

CATEGORY_GENUS

NVARCHAR2

Line Point Intersect (LPI) species category genus

100

BENTHICNAME

NVARCHAR2

Line Point Intersect (LPI) species benthic name

100

BENTHICCATEGORY

NVARCHAR2

Line Point Intersect (LPI) species benthic category

100

COMMON_NAME

NVARCHAR2

Common name of given benthic element

100

COUNT

NUMBER

Line Point Intersect (LPI) observation count

100

KINGDOM

TEXT

KINGDOM taxonomic rank

100

PHYLUM

TEXT

PHYLUM taxonomic rank

100

CLASS

TEXT

CLASS taxonomic rank

100

S_ORDER

TEXT

ORDER taxonomic rank

Attribute Details

OBJECTID

CC ID: 710741

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

ROUNDID

CC ID: 710745

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: 710740

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

REGION_NAME

CC ID: 710744

Seq. Order:	5
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: 710730

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

SITEVISITID

CC ID: 710747

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unique Identifier

SITE

CC ID: 710746

Seq. Order:	8
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
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: 710731

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the given site

LONGITUDE

CC ID: 710732

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude in decimal degrees, WGS84 for the given site

REEF_ZONE

CC ID: 710743

Seq. Order:	11
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)

DATE_

CC ID: 710725

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

OBS_YEAR

CC ID: 710742

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

LPITRANSECTRUN

CC ID: 710733

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Unique sample identifier to link observation data to transects

DIVER

CC ID: 710727

Seq. Order:	18
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Line Point Intersect (LPI) Diver

MINDEPTH

CC ID: 710738

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Line Point Intersect (LPI) transect minimum depth

MAXDEPTH

CC ID: 710735

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Line Point Intersect (LPI) transect maximum depth

METHODCODE

CC ID: 710737

Seq. Order:	21
Data Storage Type:	NVARCHAR2
Max Length:	18
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Line Point Intersect (LPI) Method Code

CALIBRATION

CC ID: 710721

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Added Sept. 2010

TRANNUM

CC ID: 710748

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Transect Number for the Line Point Intersect (LPI) survey

LPI_SEG

CC ID: 710734

Seq. Order:	24
Data Storage Type:	NVARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Distance along the transect between 0 and 25M where the intersect lies

BENTHICCODE

CC ID: 710719

Seq. Order:	25
Data Storage Type:	NVARCHAR2
Max Length:	15
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Line Point Intersect (LPI) species benthic code

FAMILY

CC ID: 710728

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	FAMILY value returned by the WoRMS web service

GENUS

CC ID: 710729

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	GENUS value returned by the WoRMS web service

CATEGORY_GENUS

CC ID: 710722

Seq. Order:	28
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Line Point Intersect (LPI) species category genus

BENTHICNAME

CC ID: 710720

Seq. Order:	29
Data Storage Type:	NVARCHAR2
Max Length:	165
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Line Point Intersect (LPI) species benthic name

BENTHICCATEGORY

CC ID: 710718

Seq. Order:	30
Data Storage Type:	NVARCHAR2
Max Length:	12
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Line Point Intersect (LPI) species benthic category

COMMON_NAME

CC ID: 710723

Seq. Order:	31
Data Storage Type:	NVARCHAR2
Max Length:	60
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Common name of given benthic element

COUNT

CC ID: 710724

Seq. Order:	32
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Line Point Intersect (LPI) observation count

KINGDOM

CC ID: 710780

Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	KINGDOM taxonomic rank

PHYLUM

CC ID: 710781

Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	PHYLUM taxonomic rank

CLASS

CC ID: 710782

Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	CLASS taxonomic rank

S_ORDER

CC ID: 710783

Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	ORDER taxonomic rank

Catalog Details

Catalog Item ID:	51132
GUID:	gov.noaa.nmfs.inport:51132
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2018-01-09 18:55+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-01-13
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-01-13
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-01-13