Search Help Show/Hide Menu
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.