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

Rubric Score Primary Key? 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
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2020-06-03 20:05+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-07-20 03:59+0000
Metadata Record Published: 2020-07-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-07-21