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
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2015-09-23 23:01+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-04-03 22:39+0000
Metadata Record Published: 2020-04-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-04-04