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 MISSIONID.
100
MISSIONID VARCHAR2 Mission identifier.
100
REGION_NAME VARCHAR2 The name of the Pacific Islands Region where the surveys were conducted.
100
ISLAND NVARCHAR2 The name of the island or atoll in the REGION_NAME where the surveys were conducted.
100
SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_
100
SITE NVARCHAR2 The name of the location where the survey was conducted. Combines a 3-letter ISLAND code with a site number.
100
LATITUDE NUMBER Latitude in decimal degrees, WGS84, for SITE surveyed. There are 8 sites where the latitude and longitude were not captured: MAI-906, MAI-908, MAI-910, MAI-913, MAI-920, MAI-921, OAH-904, and OAH-905.
100
LONGITUDE NUMBER Longitude in decimal degrees, WGS84 for the SITE surveyed. There are 8 sites where the latitude and longitude were not captured: MAI-906, MAI-908, MAI-910, MAI-913, MAI-920, MAI-921, OAH-904, and OAH-905.
100
LOCATION TEXT Descriptive location for survey SITE.
100
DATE_ DATE Date the survey was conducted.
100
OBS_YEAR NUMBER Year the survey was conducted.
100
LPITRANSECTRUN NUMBER Unique sample identifier.
100
DIVER NVARCHAR2 Initials of diver that conducted the survey.
100
MINDEPTH NUMBER Minimum survey transect depth in feet.
100
MAXDEPTH NUMBER Maximum survey transect depth in feet.
100
METHODCODE NVARCHAR2 The numeric code for the survey method used to conduct the survey. 30 = Line Point Intercept method version c, LPI survey conducted at 50-cm intervals. 32 = Line Point Intercept method version d, LPI survey conducted at 25-cm intervals.
100
TRANNUM NUMBER The transect number (1 or 2).
100
LPI_SEG NVARCHAR2 Distance along the transect between 0 and 25 m where the intercept/point lies.
100
BENTHICCODE NVARCHAR2 The LPI-specific code for the BENTHICNAME identified during LPI surveys.
100
FAMILY VARCHAR2 Family taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service.
100
GENUS VARCHAR2 GENUS taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service.
100
CATEGORY_GENUS NVARCHAR2 The LPI-specific category genus for BENTHICNAME.
100
BENTHICNAME NVARCHAR2 The LPI-specific benthic name to the lowest taxonomic level possible for the benthic element identified during LPI surveys.
100
BENTHICCATEGORY NVARCHAR2 The LPI-specific benthic category code for the benthic element identified during LPI surveys.
100
COMMON_NAME NVARCHAR2 The LPI-specific BENTHICCATEGORY name for the benthic element identified during LPI surveys.
100
COUNT NUMBER The observation count for the benthic element identified.

Attribute Details

OBJECTID

CC ID: 595833
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: 595837
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 MISSIONID.

MISSIONID

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

Mission identifier.

REGION_NAME

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

The name of the Pacific Islands Region where the surveys were conducted.

ISLAND

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

The name of the island or atoll in the REGION_NAME where the surveys were conducted.

SITEVISITID

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

Unique identifier created each time a SITE is surveyed on a DATE_

SITE

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

The name of the location where the survey was conducted. Combines a 3-letter ISLAND code with a site number.

LATITUDE

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

Latitude in decimal degrees, WGS84, for SITE surveyed. There are 8 sites where the latitude and longitude were not captured: MAI-906, MAI-908, MAI-910, MAI-913, MAI-920, MAI-921, OAH-904, and OAH-905.

LONGITUDE

CC ID: 595824
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 SITE surveyed. There are 8 sites where the latitude and longitude were not captured: MAI-906, MAI-908, MAI-910, MAI-913, MAI-920, MAI-921, OAH-904, and OAH-905.

LOCATION

CC ID: 869633
Seq. Order: 11
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Descriptive location for survey SITE.

DATE_

CC ID: 595817
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: 595834
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: 595825
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.

DIVER

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

Initials of diver that conducted the survey.

MINDEPTH

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

Minimum survey transect depth in feet.

MAXDEPTH

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

Maximum survey transect depth in feet.

METHODCODE

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

The numeric code for the survey method used to conduct the survey.

30 = Line Point Intercept method version c, LPI survey conducted at 50-cm intervals.

32 = Line Point Intercept method version d, LPI survey conducted at 25-cm intervals.

TRANNUM

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

The transect number (1 or 2).

LPI_SEG

CC ID: 595826
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 25 m where the intercept/point lies.

BENTHICCODE

CC ID: 595811
Seq. Order: 25
Data Storage Type: NVARCHAR2
Max Length: 15
Required: Yes
Primary Key: No
Status: Active
Description:

The LPI-specific code for the BENTHICNAME identified during LPI surveys.

FAMILY

CC ID: 595820
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Family taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service.

GENUS

CC ID: 595821
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

GENUS taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service.

CATEGORY_GENUS

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

The LPI-specific category genus for BENTHICNAME.

BENTHICNAME

CC ID: 595812
Seq. Order: 29
Data Storage Type: NVARCHAR2
Max Length: 165
Required: Yes
Primary Key: No
Status: Active
Description:

The LPI-specific benthic name to the lowest taxonomic level possible for the benthic element identified during LPI surveys.

BENTHICCATEGORY

CC ID: 595810
Seq. Order: 30
Data Storage Type: NVARCHAR2
Max Length: 12
Required: Yes
Primary Key: No
Status: Active
Description:

The LPI-specific benthic category code for the benthic element identified during LPI surveys.

COMMON_NAME

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

The LPI-specific BENTHICCATEGORY name for the benthic element identified during LPI surveys.

COUNT

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

The observation count for the benthic element identified.

Catalog Details

Catalog Item ID: 47680
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-10-27 21:41+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2019-08-22 19:45+0000
Metadata Record Published: 2017-12-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-12-15