Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Benthic Missions > Determining Watershed Management Efficacy in We... >

View: V0_BENT_LPI

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:27437  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Object Comments: .Benthic Line-Point Intercept foundational view; Used in Data Download Tool . .Join Comments: . . .Where Comments: . . .Group By Comments: . . .Having Comments: . . .Order By Comments: .

Description

Object Comments: .Benthic Line-Point Intercept foundational view; Used in Data Download Tool . .Join Comments: . . .Where Comments: . . .Group By Comments: . . .Having Comments: . . .Order By Comments: .

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LPITRANSECTRUN
NUMBER 		Unique sample identifier to link observation data to transects
REGION
VARCHAR2 		Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
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
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 		Flag to identify calibration dave (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
KINGDOM
VARCHAR2 		KINGDOM value returned by the WoRMS web service
PHYLUM
VARCHAR2 		PHYLUM value returned by the WoRMS web service
CLASS
VARCHAR2 		CLASS value returned by the WoRMS web service
S_ORDER
VARCHAR2 		ORDER value returned by the WoRMS web service
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
CORIS_ID
NUMBER 		Benthic LPI CoRIS ID

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.

Item Identification

Title: View: V0_BENT_LPI
Short Name: V0_BENT_LPI
Status: Completed
Abstract:

Object Comments: .Benthic Line-Point Intercept foundational view; Used in Data Download Tool . .Join Comments: . . .Where Comments: . . .Group By Comments: . . .Having Comments: . . .Order By Comments: .
Notes:

Loaded by batch 7115, 09-23-2015 23:01

Entity Information

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

Object Comments: .Benthic Line-Point Intercept foundational view; Used in Data Download Tool . .Join Comments: . . .Where Comments: . . .Group By Comments: . . .Having Comments: . . .Order By Comments: .

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LPITRANSECTRUN NUMBER Unique sample identifier to link observation data to transects
100
 REGION VARCHAR2 Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
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
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
 MIN_Z_M NUMBER Minimum depth (in meters) of survey
100
 MAX_Z_M NUMBER Maximum depth (in meters) of survey
100
 DATE_ DATE Date the survey was conducted
100
 OBS_YEAR NUMBER Year the survey was conducted
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 Flag to identify calibration dave (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
 KINGDOM VARCHAR2 KINGDOM value returned by the WoRMS web service
100
 PHYLUM VARCHAR2 PHYLUM value returned by the WoRMS web service
100
 CLASS VARCHAR2 CLASS value returned by the WoRMS web service
100
 S_ORDER VARCHAR2 ORDER value returned by the WoRMS web service
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
 CORIS_ID NUMBER Benthic LPI CoRIS ID

Attribute Details

LPITRANSECTRUN

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

Unique sample identifier to link observation data to transects
General Data Type: NUMBER

REGION

CC ID: 224597
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
General Data Type: VARCHAR2

REGION_NAME

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

One of the five Pacific Island regions CRED surveys
General Data Type: VARCHAR2

ISLAND

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

Island or Atoll surveyed
General Data Type: NVARCHAR2

SITEVISITID

CC ID: 224615
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique Identifier
General Data Type: NUMBER

SITE

CC ID: 224616
Seq. Order: 6
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.
General Data Type: NVARCHAR2

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given site
General Data Type: NUMBER

LONGITUDE

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

Longitude in decimal degrees, WGS84 for the given site
General Data Type: NUMBER

REEF_ZONE

CC ID: 224619
Seq. Order: 9
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)
General Data Type: NVARCHAR2

DEPTH_BIN

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

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
General Data Type: NVARCHAR2

MIN_Z_M

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

Minimum depth (in meters) of survey
General Data Type: NUMBER

MAX_Z_M

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

Maximum depth (in meters) of survey
General Data Type: NUMBER

DATE_

CC ID: 224590
Seq. Order: 13
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted
General Data Type: DATE

OBS_YEAR

CC ID: 224591
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Year the survey was conducted
General Data Type: NUMBER

DIVER

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

Line Point Intersect (LPI) Diver
General Data Type: NVARCHAR2

MINDEPTH

CC ID: 224593
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Line Point Intersect (LPI) transect minimum depth
General Data Type: NUMBER

MAXDEPTH

CC ID: 224594
Seq. Order: 17
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
General Data Type: NUMBER

METHODCODE

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

Line Point Intersect (LPI) Method Code
General Data Type: NVARCHAR2

CALIBRATION

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

Flag to identify calibration dave (Added Sept. 2010)
General Data Type: NUMBER

TRANNUM

CC ID: 224598
Seq. Order: 20
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
General Data Type: NUMBER

LPI_SEG

CC ID: 224599
Seq. Order: 21
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
General Data Type: NVARCHAR2

BENTHICCODE

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

Line Point Intersect (LPI) species benthic code
General Data Type: NVARCHAR2

KINGDOM

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

KINGDOM value returned by the WoRMS web service
General Data Type: VARCHAR2

PHYLUM

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

PHYLUM value returned by the WoRMS web service
General Data Type: VARCHAR2

CLASS

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

CLASS value returned by the WoRMS web service
General Data Type: VARCHAR2

S_ORDER

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

ORDER value returned by the WoRMS web service
General Data Type: VARCHAR2

FAMILY

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

FAMILY value returned by the WoRMS web service
General Data Type: VARCHAR2

GENUS

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

GENUS value returned by the WoRMS web service
General Data Type: VARCHAR2

CATEGORY_GENUS

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

Line Point Intersect (LPI) species category genus
General Data Type: NVARCHAR2

BENTHICNAME

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

Line Point Intersect (LPI) species benthic name
General Data Type: NVARCHAR2

BENTHICCATEGORY

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

Line Point Intersect (LPI) species benthic category
General Data Type: NVARCHAR2

COMMON_NAME

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

Common name of given benthic element
General Data Type: NVARCHAR2

COUNT

CC ID: 224612
Seq. Order: 33
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
General Data Type: NUMBER

CORIS_ID

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

Benthic LPI CoRIS ID
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 27437
GUID: gov.noaa.nmfs.inport:27437
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2015-09-23 23:01+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2020-04-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-04-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-04-03