Parent Colony Data Table
Entity (ENT) | Pacific Islands Regional Office (PIRO)GUID: gov.noaa.nmfs.inport:64675 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | Parent Colony Data Table |
---|---|
Short Name: | Parent Colony Data |
Status: | On Going |
Publication Date: | 2021-05-21 |
Notes: |
This data reflects the species and site information of the parent colonies where fragmentation took place. These fragments were then transferred to the coral nursery. The coral nursery data is associated to the parent colony data through the "Wild_Donor_Code" column. |
Entity Information
Entity Type: | Data File |
---|---|
Active Version?: | Yes |
Description: |
Parent colony fragmentation and site information. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
N/A
|
Donor_Colony_ID | Number | Donor Colony ID | |
N/A
|
Wild_Donor_Code | VARCHAR2 | Species code with number of that species. The identifier to associate parent data with nursery growth data. | |
N/A
|
Genus_Species | TEXT | Genus and species of the parent colony | |
N/A
|
Date_Collected | DATE | mm-dd-yyyy of collection data in Chamorro Standard Time (CHST) | |
N/A
|
Island | TEXT | Island where collection took place | |
N/A
|
Reef_Name | VARCHAR2 | Reef name where the parent colony resides | |
N/A
|
Reef_Zone | TEXT | Forereef or Lagoon | |
N/A
|
Latitude | NUMBER | Latitude of collection site | |
N/A
|
Longitude | NUMBER | Longitude of collection site | |
N/A
|
Depth_m | NUMBER | Depth of collection site | |
N/A
|
Tag_Number | NUMBER | Tag number of the parent colony. If tag number is null then no tag was added. |
Attribute Details
Donor_Colony_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | Number |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Donor Colony ID |
Wild_Donor_Code
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species code with number of that species. The identifier to associate parent data with nursery growth data. |
Genus_Species
Data Storage Type: | TEXT |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Genus and species of the parent colony |
Date_Collected
Data Storage Type: | DATE |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
mm-dd-yyyy of collection data in Chamorro Standard Time (CHST) |
Island
Data Storage Type: | TEXT |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island where collection took place |
Reef_Name
Data Storage Type: | VARCHAR2 |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Reef name where the parent colony resides |
Reef_Zone
Data Storage Type: | TEXT |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Forereef or Lagoon |
Latitude
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude of collection site |
Longitude
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude of collection site |
Depth_m
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Depth of collection site |
Tag_Number
Data Storage Type: | NUMBER |
---|---|
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tag number of the parent colony. If tag number is null then no tag was added. |
Catalog Details
Catalog Item ID: | 64675 |
---|---|
GUID: | gov.noaa.nmfs.inport:64675 |
Metadata Record Created By: | Brooke Olenski |
Metadata Record Created: | 2021-05-21 16:27+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-09-22 |
Owner Org: | PIRO |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-09-22 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-09-22 |