65773 Data Dictionary Entity Published / External 65764 Coral Bleaching & Recovery Observations using Structure-from-Motion (SfM) Models from Main Hawaiian Islands Fixed Sites Surveyed from 2019 to 2021 Data Set Spreadsheet Yes Observation data entities compiled for 2023 SfM colony level annotations conducted by NOAA Ecosystem Sciences Division. This data dictionary was updated to include new columns in the 2023 generated dataset for 2019 - 2021 SfM bleaching fixed site annotations ; originally it held metrics that were collected during the initial phase of data collection for only the 2019 SfM models. 1 PatchID NUMBER No No Active Unique ID number per site for coral patch outlined 2 Site TEXT No No Active Fixed site at which SfM imagery was collected 3 Quadrat NUMBER No No Active ID number of randomly placed 0.7 x 0.7m quadrat. Blank values values signify a colony was opportunistically surveyed outside of a quadrat. Quadrat 0 implies that the observations were conducted irregardless of quadrats (described further in Notes) 4 Date DATE No No Active Date of SfM survey in MM/DD/YYYY format. 5 Spec_Code TEXT No No Active 4-letter code assigned to adult coral species identified in annotations, defined in list of coral species codes provided 6 Morph_Code TEXT No No Active 2-letter code for coral morphology type ('BR' = branching, 'EM' = encrusting (mounding), 'MD' = mounding, 'KN' = knobby, 'PL' = plating) 7 BLE_EXT NUMBER No No Active Extent of bleaching as expressed by percent of patch exhibiting paling from 0-100%. Blank values denote no bleaching observations were conducted (survey years 2020 and 2021). 8 BLE_SEV NUMBER No No Active The severity of bleaching from 1 (being slightly pale) to 3 (stark white). Blank values signify no bleaching observations were conducted (survey years 2020 and 2021). Values of 0 mean that the bleaching extent was 0%. 9 LinkTP_Back VARCHAR2 No No Active List of unique Patch IDs that this patch transitioned from in previous timepoint. Blank values mean that no prior timepoint of data exists for this patch. 10 LinkTP_For VARCHAR2 No No Active List of unique Patch IDs that this patch transitioned to in the next available timepoint. -99.2 and -99.3 mean that the patch underwent mortality in the subsequent timepoint. Blank values mean that no future timepoint of data exists for this patch. 11 TimePt NUMBER No No Active Timepoint ID for this survey year 12 Perimeter_m NUMBER No No Active The perimeter (meters) of the patch. 13 PlanarArea_m_sq NUMBER No No Active The planar area (squared meters) of the patch. 14 Year DATE No No Active The year this survey was conducted 15 Max_Diameter_m NUMBER No No Active The maximum diameter (meters) of the patch. 16 Genet_ID NUMBER No No Active The unique identification number of the overall 'genet' that this coral patch is a part of. See Lineage Statement for definition and more information regarding 'genet'. 17 Notes TEXT No No Active Any notes from annotations; explains blank values for specific columns. Blanks indicate no notes were recorded. gov.noaa.nmfs.inport:65773 Brooke Olenski 2021-11-06T00:43:41 Lori Luers 2023-10-04T21:29:10 2023-10-04 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2021-12-14 1 Year 2022-12-14