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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

LPI foundational view

Description

LPI foundational view

Entity Type
Data View

Data Attribute / Type	Description
OBJECTID NUMBER	Unique identifier for benthic LPI observations.
ROUNDID NUMBER	Unique identifier for MISSIONID.
MISSIONID VARCHAR2	Mission identifier.
REGION_NAME VARCHAR2	The name of the Pacific Islands Region where the surveys were conducted.
ISLAND NVARCHAR2	The name of the island or atoll in the REGION_NAME where the surveys were conducted.
SITEVISITID NUMBER	Unique identifier created each time a SITE is surveyed on a DATE_
SITE NVARCHAR2	The name of the location where the survey was conducted. Combines a 3-letter ISLAND code with a site number.
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.
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.
LOCATION TEXT	Descriptive location for survey SITE.
DATE_ DATE	Date the survey was conducted.
OBS_YEAR NUMBER	Year the survey was conducted.
LPITRANSECTRUN NUMBER	Unique sample identifier.
DIVER NVARCHAR2	Initials of diver that conducted the survey.
MINDEPTH NUMBER	Minimum survey transect depth in feet.
MAXDEPTH NUMBER	Maximum survey transect depth in feet.
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.
TRANNUM NUMBER	The transect number (1 or 2).
LPI_SEG NVARCHAR2	Distance along the transect between 0 and 25 m where the intercept/point lies.
BENTHICCODE NVARCHAR2	The LPI-specific code for the BENTHICNAME identified during LPI surveys.
FAMILY VARCHAR2	Family taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service.
GENUS VARCHAR2	GENUS taxonomic rank for the BENTHICNAME identified, from the World Register of Marine Species (WoRMS) service.
CATEGORY_GENUS NVARCHAR2	The LPI-specific category genus for BENTHICNAME.
BENTHICNAME NVARCHAR2	The LPI-specific benthic name to the lowest taxonomic level possible for the benthic element identified during LPI surveys.
BENTHICCATEGORY NVARCHAR2	The LPI-specific benthic category code for the benthic element identified during LPI surveys.
COMMON_NAME NVARCHAR2	The LPI-specific BENTHICCATEGORY name for the benthic element identified during LPI surveys.
COUNT NUMBER	The observation count for the benthic element identified.

Data Attribute / Type

Description

OBJECTID
NUMBER

Unique identifier for benthic LPI observations.

ROUNDID
NUMBER

Unique identifier for MISSIONID.

MISSIONID
VARCHAR2

Mission identifier.

REGION_NAME
VARCHAR2

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

ISLAND
NVARCHAR2

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

SITEVISITID
NUMBER

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

SITE
NVARCHAR2

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

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.

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.

LOCATION
TEXT

Descriptive location for survey SITE.

DATE_
DATE

Date the survey was conducted.

OBS_YEAR
NUMBER

Year the survey was conducted.

LPITRANSECTRUN
NUMBER

Unique sample identifier.

DIVER
NVARCHAR2

Initials of diver that conducted the survey.

MINDEPTH
NUMBER

Minimum survey transect depth in feet.

MAXDEPTH
NUMBER

Maximum survey transect depth in feet.

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.

TRANNUM
NUMBER

The transect number (1 or 2).

LPI_SEG
NVARCHAR2

Distance along the transect between 0 and 25 m where the intercept/point lies.

BENTHICCODE
NVARCHAR2

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

FAMILY
VARCHAR2

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

GENUS
VARCHAR2

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

CATEGORY_GENUS
NVARCHAR2

The LPI-specific category genus for BENTHICNAME.

BENTHICNAME
NVARCHAR2

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

BENTHICCATEGORY
NVARCHAR2

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

COMMON_NAME
NVARCHAR2

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

COUNT
NUMBER

The observation count for the benthic element identified.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	View: V0_BENT_LPI
Short Name:	V0_BENT_LPI
Status:	Completed
Abstract:	LPI foundational view

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	LPI foundational view

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

100

LONGITUDE

NUMBER

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

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 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

View: V0_BENT_LPI

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

OBJECTID

ROUNDID

MISSIONID

REGION_NAME

ISLAND

SITEVISITID

SITE

LATITUDE

LONGITUDE

LOCATION

DATE_

OBS_YEAR

LPITRANSECTRUN

DIVER

MINDEPTH

MAXDEPTH

METHODCODE

TRANNUM

LPI_SEG

BENTHICCODE

FAMILY

GENUS

CATEGORY_GENUS

BENTHICNAME

BENTHICCATEGORY

COMMON_NAME

COUNT

Catalog Details