Slide Menu
Search Help Show/Hide Menu

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