View: V0_BENT_LPI
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:37616 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
LPI foundational view
DescriptionLPI 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.
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 ROUND record | |
100
|
MISSIONID | VARCHAR2 | Mission Identifier | |
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
|
LPITRANSECTRUN | NUMBER | Unique sample identifier to link observation data to transects | |
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 | 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
|
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 |
Attribute Details
OBJECTID
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 |
General Data Type: | NUMBER |
ROUNDID
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 ROUND record |
General Data Type: | NUMBER |
MISSIONID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier |
General Data Type: | VARCHAR2 |
REGION_NAME
Seq. Order: | 5 |
---|---|
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
Seq. Order: | 6 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 765 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed |
General Data Type: | NVARCHAR2 |
SITEVISITID
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique Identifier |
General Data Type: | NUMBER |
SITE
Seq. Order: | 8 |
---|---|
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given site |
General Data Type: | NUMBER |
LONGITUDE
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 given site |
General Data Type: | NUMBER |
REEF_ZONE
Seq. Order: | 11 |
---|---|
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
Seq. Order: | 12 |
---|---|
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
Seq. Order: | 13 |
---|---|
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
Seq. Order: | 14 |
---|---|
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_
Seq. Order: | 15 |
---|---|
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
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year the survey was conducted |
General Data Type: | NUMBER |
LPITRANSECTRUN
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 to link observation data to transects |
General Data Type: | NUMBER |
DIVER
Seq. Order: | 18 |
---|---|
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
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Line Point Intersect (LPI) transect minimum depth |
General Data Type: | NUMBER |
MAXDEPTH
Seq. Order: | 20 |
---|---|
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
Seq. Order: | 21 |
---|---|
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
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Added Sept. 2010 |
General Data Type: | NUMBER |
TRANNUM
Seq. Order: | 23 |
---|---|
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
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 25M where the intersect lies |
General Data Type: | NVARCHAR2 |
BENTHICCODE
Seq. Order: | 25 |
---|---|
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 |
FAMILY
Seq. Order: | 26 |
---|---|
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
Seq. Order: | 27 |
---|---|
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
Seq. Order: | 28 |
---|---|
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
Seq. Order: | 29 |
---|---|
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
Seq. Order: | 30 |
---|---|
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
Seq. Order: | 31 |
---|---|
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
Seq. Order: | 32 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 37616 |
---|---|
GUID: | gov.noaa.nmfs.inport:37616 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2017-04-04 16:13+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-08-01 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-08-01 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-08-01 |