Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

LPI foundational view

Description

LPI foundational view

Entity Information

Entity Type
Data View

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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

Rubric Score Primary Key? 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