Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data dictionary for urchins surveys.

Description

Column definitions for urchin survey data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REGION
VARCHAR2
The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
REGIONCODE
VARCHAR2
Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
YEAR
NUMERIC
4-digit year the survey was conducted.
CRUISE_ID
VARCHAR2
Mission Identifier
LOCATION
VARCHAR2
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
LOCATIONCODE
VARCHAR2
3-Letter unique code for LOCATION.
OCC_SITEID
VARCHAR2
An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number.
OCC_SITENAME
VARCHAR2
Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed.
LATITUDE
NUMERIC
Latitude in decimal degrees, WGS84, for the given OCC_SITEID.
LONGITUDE
NUMERIC
Longitude in decimal degrees, WGS84, for the given OCC_SITEID.
DEPTH_M
NUMERIC
Depth of survey site, in meters.
LOCALDATE
DATE
Local date the survey was conducted in MM/DD/YYYY.
CB_METHOD
VARCHAR2
Methodology used for collection of urchin data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 6 x 1m x 10m belt transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 1m x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 1m x 8-10m virtual transects.
CB_TRANSECTID
VARCHAR2
An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords: A, B, C, D, E, F; SfM: A, B, C, D, E, F.
TRANSECT_LENGTH_M
NUMERIC
Total planar length of transect surveyed (CB_TRANSECTID), in meters.
URCH_OBS_TF
VARCHAR2
Urchins were (TRUE) or were not (FALSE) observed on the transect.
TAXON_NAME
VARCHAR2
Genus or species of urchins observed on the transect (CB_TRANSECTID). Left blank if no urchins were observed.
TAXON_CODE
VARCHAR2
Unique code for TAXON_NAME.
TEST_SIZE_BIN_0_20_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 0 and 20 millimeters.
TEST_SIZE_BIN_21_40_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 21 and 40 millimeters.
TEST_SIZE_BIN_41_60_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 41 and 60 millimeters.
TEST_SIZE_BIN_61_80_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 61 and 80 millimeters.
TEST_SIZE_BIN_81_100_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 81 and 100 millimeters.
TEST_SIZE_BIN_101_120_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 101 and 120 millimeters.
TEST_SIZE_BIN_121_140_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 121 and 140 millimeters.
TEST_SIZE_BIN_141_160_MM
NUMERIC
Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 141 and 160 millimeters.

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: ESD_CarbBudget_Urchin_DataDictionary_2023
Short Name: CarbBudget Urchin DataDictionary
Status: Completed
Abstract:

Data dictionary for urchins surveys.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Column definitions for urchin survey data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REGION VARCHAR2 The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
REGIONCODE VARCHAR2 Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
100
YEAR NUMERIC 4-digit year the survey was conducted.
100
CRUISE_ID VARCHAR2 Mission Identifier
100
LOCATION VARCHAR2 Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
100
LOCATIONCODE VARCHAR2 3-Letter unique code for LOCATION.
100
OCC_SITEID VARCHAR2 An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number.
100
OCC_SITENAME VARCHAR2 Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed.
100
LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given OCC_SITEID.
100
LONGITUDE NUMERIC Longitude in decimal degrees, WGS84, for the given OCC_SITEID.
100
DEPTH_M NUMERIC Depth of survey site, in meters.
100
LOCALDATE DATE Local date the survey was conducted in MM/DD/YYYY.
100
CB_METHOD VARCHAR2 Methodology used for collection of urchin data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 6 x 1m x 10m belt transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 1m x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 1m x 8-10m virtual transects.
100
CB_TRANSECTID VARCHAR2 An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords: A, B, C, D, E, F; SfM: A, B, C, D, E, F.
100
TRANSECT_LENGTH_M NUMERIC Total planar length of transect surveyed (CB_TRANSECTID), in meters.
100
URCH_OBS_TF VARCHAR2 Urchins were (TRUE) or were not (FALSE) observed on the transect.
100
TAXON_NAME VARCHAR2 Genus or species of urchins observed on the transect (CB_TRANSECTID). Left blank if no urchins were observed.
100
TAXON_CODE VARCHAR2 Unique code for TAXON_NAME.
100
TEST_SIZE_BIN_0_20_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 0 and 20 millimeters.
100
TEST_SIZE_BIN_21_40_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 21 and 40 millimeters.
100
TEST_SIZE_BIN_41_60_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 41 and 60 millimeters.
100
TEST_SIZE_BIN_61_80_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 61 and 80 millimeters.
100
TEST_SIZE_BIN_81_100_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 81 and 100 millimeters.
100
TEST_SIZE_BIN_101_120_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 101 and 120 millimeters.
100
TEST_SIZE_BIN_121_140_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 121 and 140 millimeters.
100
TEST_SIZE_BIN_141_160_MM NUMERIC Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 141 and 160 millimeters.

Attribute Details

REGION

CC ID: 1192489
Seq. Order: 1
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

REGIONCODE

CC ID: 1257926
Seq. Order: 2
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).

YEAR

CC ID: 1257927
Seq. Order: 3
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

4-digit year the survey was conducted.

CRUISE_ID

CC ID: 1257928
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Mission Identifier

LOCATION

CC ID: 1257929
Seq. Order: 5
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).

LOCATIONCODE

CC ID: 1257930
Seq. Order: 6
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

3-Letter unique code for LOCATION.

OCC_SITEID

CC ID: 1257931
Seq. Order: 7
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number.

OCC_SITENAME

CC ID: 1257932
Seq. Order: 8
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed.

LATITUDE

CC ID: 1257933
Seq. Order: 9
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given OCC_SITEID.

LONGITUDE

CC ID: 1257934
Seq. Order: 10
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given OCC_SITEID.

DEPTH_M

CC ID: 1257935
Seq. Order: 11
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Depth of survey site, in meters.

LOCALDATE

CC ID: 1257936
Seq. Order: 12
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Local date the survey was conducted in MM/DD/YYYY.

CB_METHOD

CC ID: 1257937
Seq. Order: 13
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Methodology used for collection of urchin data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 6 x 1m x 10m belt transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 1m x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 1m x 8-10m virtual transects.

CB_TRANSECTID

CC ID: 1257938
Seq. Order: 14
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords: A, B, C, D, E, F; SfM: A, B, C, D, E, F.

TRANSECT_LENGTH_M

CC ID: 1257939
Seq. Order: 15
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Total planar length of transect surveyed (CB_TRANSECTID), in meters.

URCH_OBS_TF

CC ID: 1257940
Seq. Order: 16
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Urchins were (TRUE) or were not (FALSE) observed on the transect.

TAXON_NAME

CC ID: 1257941
Seq. Order: 17
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Genus or species of urchins observed on the transect (CB_TRANSECTID). Left blank if no urchins were observed.

TAXON_CODE

CC ID: 1257942
Seq. Order: 18
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Unique code for TAXON_NAME.

TEST_SIZE_BIN_0_20_MM

CC ID: 1257943
Seq. Order: 19
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 0 and 20 millimeters.

TEST_SIZE_BIN_21_40_MM

CC ID: 1257944
Seq. Order: 20
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 21 and 40 millimeters.

TEST_SIZE_BIN_41_60_MM

CC ID: 1257945
Seq. Order: 21
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 41 and 60 millimeters.

TEST_SIZE_BIN_61_80_MM

CC ID: 1257946
Seq. Order: 22
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 61 and 80 millimeters.

TEST_SIZE_BIN_81_100_MM

CC ID: 1257947
Seq. Order: 23
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 81 and 100 millimeters.

TEST_SIZE_BIN_101_120_MM

CC ID: 1257948
Seq. Order: 24
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 101 and 120 millimeters.

TEST_SIZE_BIN_121_140_MM

CC ID: 1257949
Seq. Order: 25
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 121 and 140 millimeters.

TEST_SIZE_BIN_141_160_MM

CC ID: 1257950
Seq. Order: 26
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Number of urchins of the specified taxa (TAXON_NAME) observed on the transect (CB_TRANSECTID) with a test size between 141 and 160 millimeters.

Catalog Details

Catalog Item ID: 68417
GUID: gov.noaa.nmfs.inport:68417
Metadata Record Created By: Lori H Luers
Metadata Record Created: 2022-11-15 02:56+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2023-10-04 21:26+0000
Metadata Record Published: 2023-10-04
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year