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
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2018-01-09 18:55+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-01-13 15:18+0000
Metadata Record Published: 2020-01-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-01-13