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 > Pacific Reef Monitoring and Assessment Program:... >

View: V0_BENT_LPI

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:37616  |  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)
DEPTH_BIN
NVARCHAR2 		Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
MIN_Z_M
NUMBER 		Minimum depth (in meters) of survey
MAX_Z_M
NUMBER 		Maximum depth (in meters) of survey
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

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
Short Name: 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
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
 MIN_Z_M NUMBER Minimum depth (in meters) of survey
100
 MAX_Z_M NUMBER Maximum depth (in meters) of survey
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

Attribute Details

OBJECTID

CC ID: 392175
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
General Data Type: NUMBER

ROUNDID

CC ID: 392176
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
General Data Type: NUMBER

MISSIONID

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

Mission Identifier
General Data Type: VARCHAR2

REGION_NAME

CC ID: 392179
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
General Data Type: VARCHAR2

ISLAND

CC ID: 392180
Seq. Order: 6
Data Storage Type: NVARCHAR2
Max Length: 765
Required: No
Primary Key: No
Status: Active
Description:

Island or Atoll surveyed
General Data Type: NVARCHAR2

SITEVISITID

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

Unique Identifier
General Data Type: NUMBER

SITE

CC ID: 392182
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.
General Data Type: NVARCHAR2

LATITUDE

CC ID: 392183
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
General Data Type: NUMBER

LONGITUDE

CC ID: 392184
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
General Data Type: NUMBER

REEF_ZONE

CC ID: 392185
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)
General Data Type: NVARCHAR2

DEPTH_BIN

CC ID: 392186
Seq. Order: 12
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
General Data Type: NVARCHAR2

MIN_Z_M

CC ID: 392187
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Minimum depth (in meters) of survey
General Data Type: NUMBER

MAX_Z_M

CC ID: 392188
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Maximum depth (in meters) of survey
General Data Type: NUMBER

DATE_

CC ID: 392189
Seq. Order: 15
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted
General Data Type: DATE

OBS_YEAR

CC ID: 392190
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Year the survey was conducted
General Data Type: NUMBER

LPITRANSECTRUN

CC ID: 392191
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
General Data Type: NUMBER

DIVER

CC ID: 392192
Seq. Order: 18
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Line Point Intersect (LPI) Diver
General Data Type: NVARCHAR2

MINDEPTH

CC ID: 392193
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
General Data Type: NUMBER

MAXDEPTH

CC ID: 392194
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
General Data Type: NUMBER

METHODCODE

CC ID: 392195
Seq. Order: 21
Data Storage Type: NVARCHAR2
Max Length: 18
Required: Yes
Primary Key: No
Status: Active
Description:

Line Point Intersect (LPI) Method Code
General Data Type: NVARCHAR2

CALIBRATION

CC ID: 392196
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
General Data Type: NUMBER

TRANNUM

CC ID: 392197
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
General Data Type: NUMBER

LPI_SEG

CC ID: 392198
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
General Data Type: NVARCHAR2

BENTHICCODE

CC ID: 392199
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
General Data Type: NVARCHAR2

FAMILY

CC ID: 392204
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
General Data Type: VARCHAR2

GENUS

CC ID: 392205
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
General Data Type: VARCHAR2

CATEGORY_GENUS

CC ID: 392206
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
General Data Type: NVARCHAR2

BENTHICNAME

CC ID: 392207
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
General Data Type: NVARCHAR2

BENTHICCATEGORY

CC ID: 392208
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
General Data Type: NVARCHAR2

COMMON_NAME

CC ID: 392209
Seq. Order: 31
Data Storage Type: NVARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
Description:

Common name of given benthic element
General Data Type: NVARCHAR2

COUNT

CC ID: 392210
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
General Data Type: NUMBER

Catalog Details

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