Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Hawaii Disease Project > Environmental Monitoring of Coral Bleaching and... >

View: V0_BENT_LPI

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:47680 | Updated: August 9, 2022 | Published / External

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

	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.

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
GUID:	gov.noaa.nmfs.inport:47680
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2017-10-27 21:41+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-12-14
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-12-14
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-12-14