Environmental Data Summary Data Dictionary
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:65210 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Data dictionary for meta-analysis.
DescriptionMeta-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
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
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
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
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted |
LATITUDE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Analysed sea surface temperature, degree_C |
Chla
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Chlorophyll Concentration, OC3 Algorithm, mg m^-3. |
Kd490
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
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 |