Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Hawaiian Archipelago > National Coral Reef Monitoring Program: Methodo... >

Downscaling_Dataset_Entities

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:59929 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	Downscaling_Dataset_Entities

Entity Information

Entity Type:	Spreadsheet
Active Version?:	Yes
Description:	Entities for the "Main Hawaiian Islands 2005-2015, Methodological Case Study for 'Downscaling Ecological Trends from the Spatially Randomized Datasets of the National Coral Reef Monitoring Program" dataset.

Data Attributes

Attribute Summary

	Name	Type	Description
100	ISLAND	TEXT	Name of island or atoll surveyed in the Pacific Islands region, including: Hawaii, Kauai, Lanai, Maui, Molokai, Niihau, and Oahu.
100	SITE	TEXT	Site format dependent on METHOD. Site number for stratified random (CNET and CPCE) and fixed sites (LPI), and Segment number for towed diver survey sites (TDS). CPCE, CNET, and LPI: 3-letter Island Code + 5-digit number; TDS: Date (YYYYMMDD) + Tow Number(#) + Segment Number(##).
100	DEPTH_BIN	TEXT	Survey depth binned into 3 categories: shallow (0 - 6 m), mid-depth (>6 - 18 m) and deep (>18 - 30 m). Due to bottom time limitations, 25 m is generally the deepest depth.
100	LONGITUDE	NUMBER	Longitude in decimal degrees, WGS84 for the given SITE.
100	LATITUDE	NUMBER	Latitude in decimal degrees, WGS84, for the given SITE.
100	OBS_YEAR	NUMBER	Year in which observation was recorded.
100	DATE_R	DATE	Date of observation (m/dd/yyyy).
100	METHOD	TEXT	Method of Benthic Percent Cover observation, including: "CNET" (Photoquadrat analysis using CoralNet), "CPCE" (Photoquadrat analysis using Coral Point Count with Excel extensions),"LPI" (Line-point inercept), "TDS" (Towed diver survey).
100	xCORAL	NUMBER	Proportional cover of live hard coral, including Scleractinians and shallow hydrozoans (e.g., Millepora spp.).
100	xSC	NUMBER	Proportional cover of live soft coral.
100	xCCA	NUMBER	Proportional cover of crustose coralline algae.
100	xSED	NUMBER	Proportional cover of soft sediment, including sand.
100	xMALG_TALG	NUMBER	Proportional cover of macroalgae and turf algae.
100	xOTHER	NUMBER	Proportional cover that does not fall into one of the five other cover categories.
100	ClustID_Selected	TEXT	This site-visit's grouping into a downscaled cluster at level of clustering selected in associated tech memo's analysis.
100	ClustID_k01	TEXT	This site-visit's grouping into a downscaled cluster with 1 cut of the minimum spanning tree (i.e., 2 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k02	TEXT	This site-visit's grouping into a downscaled cluster with 2 cuts of the minimum spanning tree (i.e., 3 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k03	TEXT	This site-visit's grouping into a downscaled cluster with 3 cuts of the minimum spanning tree (i.e., 4 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k04	TEXT	This site-visit's grouping into a downscaled cluster with 4 cuts of the minimum spanning tree (i.e., 5 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k05	TEXT	This site-visit's grouping into a downscaled cluster with 5 cuts of the minimum spanning tree (i.e., 6 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k06	TEXT	This site-visit's grouping into a downscaled cluster with 6 cuts of the minimum spanning tree (i.e., 7 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k07	TEXT	This site-visit's grouping into a downscaled cluster with 7 cuts of the minimum spanning tree (i.e., 8 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k08	TEXT	This site-visit's grouping into a downscaled cluster with 8 cuts of the minimum spanning tree (i.e., 9 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k09	TEXT	This site-visit's grouping into a downscaled cluster with 9 cuts of the minimum spanning tree (i.e., 10 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k10	TEXT	This site-visit's grouping into a downscaled cluster with 10 cuts of the minimum spanning tree (i.e., 11 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k12	TEXT	This site-visit's grouping into a downscaled cluster with 12 cuts of the minimum spanning tree (i.e., 13 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k14	TEXT	This site-visit's grouping into a downscaled cluster with 14 cuts of the minimum spanning tree (i.e., 15 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k16	TEXT	This site-visit's grouping into a downscaled cluster with 16 cuts of the minimum spanning tree (i.e., 17 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k18	TEXT	This site-visit's grouping into a downscaled cluster with 18 cuts of the minimum spanning tree (i.e., 19 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k20	TEXT	This site-visit's grouping into a downscaled cluster with 20 cuts of the minimum spanning tree (i.e., 21 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.
100	ClustID_k25	TEXT	This site-visit's grouping into a downscaled cluster with 25 cuts of the minimum spanning tree (i.e., 26 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

Name

Type

Description

100

ISLAND

TEXT

Name of island or atoll surveyed in the Pacific Islands region, including: Hawaii, Kauai, Lanai, Maui, Molokai, Niihau, and Oahu.

100

SITE

TEXT

Site format dependent on METHOD. Site number for stratified random (CNET and CPCE) and fixed sites (LPI), and Segment number for towed diver survey sites (TDS). CPCE, CNET, and LPI: 3-letter Island Code + 5-digit number; TDS: Date (YYYYMMDD) + Tow Number(#) + Segment Number(##).

100

DEPTH_BIN

TEXT

Survey depth binned into 3 categories: shallow (0 - 6 m), mid-depth (>6 - 18 m) and deep (>18 - 30 m). Due to bottom time limitations, 25 m is generally the deepest depth.

100

LONGITUDE

NUMBER

Longitude in decimal degrees, WGS84 for the given SITE.

100

LATITUDE

NUMBER

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

100

OBS_YEAR

NUMBER

Year in which observation was recorded.

100

DATE_R

DATE

Date of observation (m/dd/yyyy).

100

METHOD

TEXT

Method of Benthic Percent Cover observation, including: "CNET" (Photoquadrat analysis using CoralNet), "CPCE" (Photoquadrat analysis using Coral Point Count with Excel extensions),"LPI" (Line-point inercept), "TDS" (Towed diver survey).

100

xCORAL

NUMBER

Proportional cover of live hard coral, including Scleractinians and shallow hydrozoans (e.g., Millepora spp.).

100

xSC

NUMBER

Proportional cover of live soft coral.

100

xCCA

NUMBER

Proportional cover of crustose coralline algae.

100

xSED

NUMBER

Proportional cover of soft sediment, including sand.

100

xMALG_TALG

NUMBER

Proportional cover of macroalgae and turf algae.

100

xOTHER

NUMBER

Proportional cover that does not fall into one of the five other cover categories.

100

ClustID_Selected

TEXT

This site-visit's grouping into a downscaled cluster at level of clustering selected in associated tech memo's analysis.

100

ClustID_k01

TEXT

This site-visit's grouping into a downscaled cluster with 1 cut of the minimum spanning tree (i.e., 2 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k02

TEXT

This site-visit's grouping into a downscaled cluster with 2 cuts of the minimum spanning tree (i.e., 3 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k03

TEXT

This site-visit's grouping into a downscaled cluster with 3 cuts of the minimum spanning tree (i.e., 4 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k04

TEXT

This site-visit's grouping into a downscaled cluster with 4 cuts of the minimum spanning tree (i.e., 5 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k05

TEXT

This site-visit's grouping into a downscaled cluster with 5 cuts of the minimum spanning tree (i.e., 6 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k06

TEXT

This site-visit's grouping into a downscaled cluster with 6 cuts of the minimum spanning tree (i.e., 7 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k07

TEXT

This site-visit's grouping into a downscaled cluster with 7 cuts of the minimum spanning tree (i.e., 8 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k08

TEXT

This site-visit's grouping into a downscaled cluster with 8 cuts of the minimum spanning tree (i.e., 9 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k09

TEXT

This site-visit's grouping into a downscaled cluster with 9 cuts of the minimum spanning tree (i.e., 10 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k10

TEXT

This site-visit's grouping into a downscaled cluster with 10 cuts of the minimum spanning tree (i.e., 11 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k12

TEXT

This site-visit's grouping into a downscaled cluster with 12 cuts of the minimum spanning tree (i.e., 13 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k14

TEXT

This site-visit's grouping into a downscaled cluster with 14 cuts of the minimum spanning tree (i.e., 15 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k16

TEXT

This site-visit's grouping into a downscaled cluster with 16 cuts of the minimum spanning tree (i.e., 17 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k18

TEXT

This site-visit's grouping into a downscaled cluster with 18 cuts of the minimum spanning tree (i.e., 19 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k20

TEXT

This site-visit's grouping into a downscaled cluster with 20 cuts of the minimum spanning tree (i.e., 21 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

100

ClustID_k25

TEXT

This site-visit's grouping into a downscaled cluster with 25 cuts of the minimum spanning tree (i.e., 26 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

Attribute Details

ISLAND

CC ID: 909837

Seq. Order:	1
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of island or atoll surveyed in the Pacific Islands region, including: Hawaii, Kauai, Lanai, Maui, Molokai, Niihau, and Oahu.

SITE

CC ID: 910586

Seq. Order:	2
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Site format dependent on METHOD. Site number for stratified random (CNET and CPCE) and fixed sites (LPI), and Segment number for towed diver survey sites (TDS). CPCE, CNET, and LPI: 3-letter Island Code + 5-digit number; TDS: Date (YYYYMMDD) + Tow Number(#) + Segment Number(##).

DEPTH_BIN

CC ID: 910590

Seq. Order:	3
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Survey depth binned into 3 categories: shallow (0 - 6 m), mid-depth (>6 - 18 m) and deep (>18 - 30 m). Due to bottom time limitations, 25 m is generally the deepest depth.

LONGITUDE

CC ID: 910587

Seq. Order:	4
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude in decimal degrees, WGS84 for the given SITE.

LATITUDE

CC ID: 910588

Seq. Order:	5
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the given SITE.

OBS_YEAR

CC ID: 910591

Seq. Order:	6
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Year in which observation was recorded.

DATE_R

CC ID: 910602

Seq. Order:	7
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of observation (m/dd/yyyy).

METHOD

CC ID: 910603

Seq. Order:	8
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	Method of Benthic Percent Cover observation, including: "CNET" (Photoquadrat analysis using CoralNet), "CPCE" (Photoquadrat analysis using Coral Point Count with Excel extensions),"LPI" (Line-point inercept), "TDS" (Towed diver survey).

xCORAL

CC ID: 910604

Seq. Order:	9
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Proportional cover of live hard coral, including Scleractinians and shallow hydrozoans (e.g., Millepora spp.).

xSC

CC ID: 910605

Seq. Order:	10
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Proportional cover of live soft coral.

xCCA

CC ID: 910606

Seq. Order:	11
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Proportional cover of crustose coralline algae.

xSED

CC ID: 910607

Seq. Order:	12
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Proportional cover of soft sediment, including sand.

xMALG_TALG

CC ID: 910608

Seq. Order:	13
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Proportional cover of macroalgae and turf algae.

xOTHER

CC ID: 910609

Seq. Order:	14
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Proportional cover that does not fall into one of the five other cover categories.

ClustID_Selected

CC ID: 913295

Seq. Order:	15
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster at level of clustering selected in associated tech memo's analysis.

ClustID_k01

CC ID: 910611

Seq. Order:	16
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 1 cut of the minimum spanning tree (i.e., 2 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k02

CC ID: 910612

Seq. Order:	17
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 2 cuts of the minimum spanning tree (i.e., 3 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k03

CC ID: 910613

Seq. Order:	18
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 3 cuts of the minimum spanning tree (i.e., 4 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k04

CC ID: 910614

Seq. Order:	19
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 4 cuts of the minimum spanning tree (i.e., 5 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k05

CC ID: 910615

Seq. Order:	20
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 5 cuts of the minimum spanning tree (i.e., 6 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k06

CC ID: 910616

Seq. Order:	21
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 6 cuts of the minimum spanning tree (i.e., 7 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k07

CC ID: 910617

Seq. Order:	22
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 7 cuts of the minimum spanning tree (i.e., 8 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k08

CC ID: 910618

Seq. Order:	23
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 8 cuts of the minimum spanning tree (i.e., 9 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k09

CC ID: 910619

Seq. Order:	24
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 9 cuts of the minimum spanning tree (i.e., 10 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k10

CC ID: 910620

Seq. Order:	25
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 10 cuts of the minimum spanning tree (i.e., 11 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k12

CC ID: 910621

Seq. Order:	26
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 12 cuts of the minimum spanning tree (i.e., 13 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k14

CC ID: 910622

Seq. Order:	27
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 14 cuts of the minimum spanning tree (i.e., 15 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k16

CC ID: 910623

Seq. Order:	28
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 16 cuts of the minimum spanning tree (i.e., 17 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k18

CC ID: 910624

Seq. Order:	29
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 18 cuts of the minimum spanning tree (i.e., 19 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k20

CC ID: 910625

Seq. Order:	30
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 20 cuts of the minimum spanning tree (i.e., 21 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

ClustID_k25

CC ID: 910626

Seq. Order:	31
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	This site-visit's grouping into a downscaled cluster with 25 cuts of the minimum spanning tree (i.e., 26 groups). "NA_2016" implies that the site-visit occurred in 2016, which was not included in the initial clustering.

Catalog Details

Catalog Item ID:	59929
GUID:	gov.noaa.nmfs.inport:59929
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2020-06-03 20:05+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2020-07-20
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-07-20
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-07-20