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

Summary

Abstract

Data dictionary for meta-analysis.

Description

Meta-analysis data dictionary

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
SITE
NVARCHAR2
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number.
ISLAND
VARCHAR2
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
REGION
VARCHAR2
The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
DATE
DATE
Date the survey was conducted
LATITUDE
NUMBER
Site latitude in decimal degrees, WGS84, for the given site.
LONGITUDE
NUMBER
Site longitude in decimal degrees, WGS84 for the given site.
03mo
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 3 months from any given survey date (see Column DATE).
01yr
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 1 year from any given survey date (Column DATE).
03yr
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 3 years from any given survey date (Column DATE).
05yr
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 5 years from any given survey date (Column DATE).
10yr
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 10 years from any given survey date (Column DATE).
10yr_01yr
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed from ten years before but excluding the most recent year from any given survey date (Column DATE).
all_before
NUMBER
A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over full length of the time series available from any given survey date (Column DATE).
DHW
NUMBER
Decadal frequency of periods of abnormally hot seawater, defined quantitatively as the number of non-zero degree heating week events during a specific period of time, converted into a number per ten years. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
major_DHW
NUMBER
Decadal frequency of periods of abnormally hot seawater, defined quantitatively as the number of degree heating week events whose maxima reached at least 4 DHW during a specific period of time, converted into a number per ten years. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
mean_maximum_DHW
NUMBER
The mean of the maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
mean_maximum_major_DHW
NUMBER
The mean of the maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
maximum_DHW
NUMBER
maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
maximum_major_DHW
NUMBER
maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
mean_durnal_DHW
NUMBER
The mean duration of each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
mean_durnal_major_DHW
NUMBER
The mean duration of each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
maximum_maximum_DHW
NUMBER
The maximum of the maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
maximum_maximum_major_DHW
NUMBER
The maximum of the maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
KdPAR
NUMBER
Diffuse attenuation coefficient of the photosynthetically available radiation Kd(PAR), m^-1.
SST
NUMBER
Analysed sea surface temperature, degree_C
Chla
NUMBER
Chlorophyll Concentration, OC3 Algorithm, mg m^-3.
Kd490
NUMBER
Diffuse attenuation coefficient at 490 nm, kd2 algorithm, m^-1.
PAR
NUMBER
Photosynthetically Available Radiation, R. Frouin, einstein m-2 day-1.

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: Environmental Data Summary Data Dictionary
Status: Completed
Abstract:

Data dictionary for meta-analysis.

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Meta-analysis data dictionary

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number.
100
ISLAND VARCHAR2 Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
REGION VARCHAR2 The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
DATE DATE Date the survey was conducted
100
LATITUDE NUMBER Site latitude in decimal degrees, WGS84, for the given site.
100
LONGITUDE NUMBER Site longitude in decimal degrees, WGS84 for the given site.
100
03mo NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 3 months from any given survey date (see Column DATE).
100
01yr NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 1 year from any given survey date (Column DATE).
100
03yr NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 3 years from any given survey date (Column DATE).
100
05yr NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 5 years from any given survey date (Column DATE).
100
10yr NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 10 years from any given survey date (Column DATE).
100
10yr_01yr NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed from ten years before but excluding the most recent year from any given survey date (Column DATE).
100
all_before NUMBER A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over full length of the time series available from any given survey date (Column DATE).
100
DHW NUMBER Decadal frequency of periods of abnormally hot seawater, defined quantitatively as the number of non-zero degree heating week events during a specific period of time, converted into a number per ten years. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
major_DHW NUMBER Decadal frequency of periods of abnormally hot seawater, defined quantitatively as the number of degree heating week events whose maxima reached at least 4 DHW during a specific period of time, converted into a number per ten years. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
mean_maximum_DHW NUMBER The mean of the maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
mean_maximum_major_DHW NUMBER The mean of the maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
maximum_DHW NUMBER maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
maximum_major_DHW NUMBER maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
mean_durnal_DHW NUMBER The mean duration of each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
mean_durnal_major_DHW NUMBER The mean duration of each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
maximum_maximum_DHW NUMBER The maximum of the maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
maximum_maximum_major_DHW NUMBER The maximum of the maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.
100
KdPAR NUMBER Diffuse attenuation coefficient of the photosynthetically available radiation Kd(PAR), m^-1.
100
SST NUMBER Analysed sea surface temperature, degree_C
100
Chla NUMBER Chlorophyll Concentration, OC3 Algorithm, mg m^-3.
100
Kd490 NUMBER Diffuse attenuation coefficient at 490 nm, kd2 algorithm, m^-1.
100
PAR NUMBER Photosynthetically Available Radiation, R. Frouin, einstein m-2 day-1.

Attribute Details

SITE

CC ID: 1111872
Seq. Order: 2
Data Storage Type: NVARCHAR2
Required: Yes
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.

ISLAND

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

Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).

REGION

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

The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

DATE

CC ID: 1079766
Seq. Order: 3
Data Storage Type: DATE
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

LATITUDE

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

Site latitude in decimal degrees, WGS84, for the given site.

LONGITUDE

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

Site longitude in decimal degrees, WGS84 for the given site.

03mo

CC ID: 1131336
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 3 months from any given survey date (see Column DATE).

01yr

CC ID: 1131337
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 1 year from any given survey date (Column DATE).

03yr

CC ID: 1131338
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 3 years from any given survey date (Column DATE).

05yr

CC ID: 1131339
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 5 years from any given survey date (Column DATE).

10yr

CC ID: 1131340
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over past 10 years from any given survey date (Column DATE).

10yr_01yr

CC ID: 1131341
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Precision: 3
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed from ten years before but excluding the most recent year from any given survey date (Column DATE).

all_before

CC ID: 1131342
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

A statistically summarized environmental value (mean, max, min, ci95, sd, 5th and 95th quantiles) computed over full length of the time series available from any given survey date (Column DATE).

DHW

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

Decadal frequency of periods of abnormally hot seawater, defined quantitatively as the number of non-zero degree heating week events during a specific period of time, converted into a number per ten years. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

major_DHW

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

Decadal frequency of periods of abnormally hot seawater, defined quantitatively as the number of degree heating week events whose maxima reached at least 4 DHW during a specific period of time, converted into a number per ten years. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

mean_maximum_DHW

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

The mean of the maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

mean_maximum_major_DHW

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

The mean of the maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

maximum_DHW

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

maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

maximum_major_DHW

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

maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

mean_durnal_DHW

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

The mean duration of each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

mean_durnal_major_DHW

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

The mean duration of each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

maximum_maximum_DHW

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

The maximum of the maximum degree heating week value from each degree heating week event during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

maximum_maximum_major_DHW

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

The maximum of the maximum degree heating week value from each degree heating week event that reached at least 4 DHW during a specific period of time. We ran periods of 3 months, 1 year, 3 years, 5 years, 10 years, and the full length of the DHW time series before the time of sampling, as well as ten years before but excluding the most recent year.

KdPAR

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

Diffuse attenuation coefficient of the photosynthetically available radiation Kd(PAR), m^-1.

SST

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

Analysed sea surface temperature, degree_C

Chla

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

Chlorophyll Concentration, OC3 Algorithm, mg m^-3.

Kd490

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

Diffuse attenuation coefficient at 490 nm, kd2 algorithm, m^-1.

PAR

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

Photosynthetically Available Radiation, R. Frouin, einstein m-2 day-1.

Catalog Details

Catalog Item ID: 65210
GUID: gov.noaa.nmfs.inport:65210
Metadata Record Created By: Brooke Olenski
Metadata Record Created: 2021-08-25 21:50+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-07-27
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-07-27
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-07-27