Skip to main content
. 2020 Oct 20;7:355. doi: 10.1038/s41597-020-00698-6

Table 3.

List of tables/files (and their structure) included in the repository.

Table/File Data field Descriptor
seaviewsurvey_surveys.csv surveyid A five unique digit survey ID representing data collection at one location (a transect location) at one point in time. This ID is unique in this table and used in the folder naming code. There may be multiple survey IDs associated with a transect ID if multi-temporal surveys were conducted at this reef location
transectid The five unique digit transect ID. A transect ID will appear more than once in this field if the transect has been surveyed temporally (more than one occasion)
surveydate The date (YYYYMMDD) on which the survey was completed
ocean The three letter code representing the ocean within which the survey occurred: ATL = Atlantic Ocean, IND = Indian Ocean, PAC = Pacific Ocean
country The three letter country code of the Exclusive Economic Zone within which the survey occurs (e.g., AUS = Australia)
folder_name The full name of the zipped folder associated with the survey (e.g., “ PAC_AUS_47035_201710”) where quadrats are stored within the “photo_quadrats” folder
lat_start The latitude of the start of the survey (decimal degrees)
lng_start The longitude of the start of the survey (decimal degrees)
lat_end The latitude of the end of the survey (decimal degrees)
lng_end The longitude of the end of the survey (decimal degrees)
pr_hard_coral The proportional cover of hard coral
pr_algae The proportional cover of algae
pr_soft_coral The proportional cover of soft coral
pr_oth_invert The proportional cover of other invertebrates apart from hard corals and soft corals
pr_other The proportional cover of other categories apart from hard corals, algae, soft corals and other invertebrates
seaviewsurvey_quadrats.csv surveyid The five-digit survey ID number from the “seaviewsurvey_surveys.csv” table. There is a one:many relationship between the surveys table and the quadrats table.
imageid The nine-digit image ID. This correspond to the five-digit survey ID and four more digits between 0001 and 9999 (number of the picture automatically assigned by the camera). Identical image ID’s will appear multiple times in this field as one image has associated multiple quadrats
quadratid The 11 unique digit quadrat ID. This correspond to the nine-digit image ID and two more digits usually between 01 and 09, which refer to the quadrat number within an image (automatically assigned during the cropping process). “.jpg” must be added to the quadrat ID to derive the filename of the quadrat (with the extension) within the imagery.
seaviewsurvey_reefcover_[region].csv surveyid The five-digit survey ID number from the seaviewsurvey_surveys.csv table. There is a one:many relationship between the surveys table and the reefcover table.
imageid The nine-digit image ID from the seaviewsurvey_quadrats.csv. Identical image ID’s appear multiple times in this field as one image has associated multiple quadrats
quadratid The 11-digit quadrat ID from the seaviewsurvey_quadrats.csv table. There is a one:many relationship between the cover table and the annotations table because each quadrat can have many annotations
lat The latitude the survey (decimal degrees)
lng The longitude of the survey (decimal degrees)
[label] The proportional cover of the label within the quadrat. A description of each label is presented in the “seaviewsurvey_labelsets.csv” table
seaviewsurvey_annotations.csv quadratid The 11-digit quadrat ID from the seaviewsurvey_quadrats.csv table. There is a one:many relationship between the quadrat table and the annotations table because each quadrat can have many annotations
y Y coordinate (row) of the pixel (graphics format image, origin of first pixel in the upper left corner) that has been automatically annotated.
x X coordinate (column) of the pixel (graphics format image, origin of first pixel in the upper left corner) that has been automatically annotated.
label The short code representing the category identified. A description of each label is presented in the “seaviewsurvey_labelsets.csv” table
annotations_[ocean]_[country].csv quadratid The 11 digit quadrat ID from the seaviewsurvey_quadrats.csv table. There is a one:many relationship between the quadrat table and the annotations table because each quadrat can have many annotations
y Y coordinate (row) of the pixel (graphics format image, origin of first pixel in the upper left corner) that has been manually annotated
x X coordinate (column) of the pixel (graphics format image, origin of first pixel in the upper left corner) that has been manually annotated
label_name The full name of the label identified. A description of each label is presented in the seaviewsurvey_labelsets.csv table
label The short code representing the category identified. A description of each label is presented in the “seaviewsurvey_labelsets.csv” table
func_group Main benthic group of the label identified: hard coral, soft coral, other invertebrates, algae, other
method Type of annotation: random = point selected randomly during the annotation; target = point aimed during the annotation
data_set Application of the manual annotations: train = to train a net; test = to validate a net
seaviewsurvey_labelsets.csv region Name of one of the five regions surveyed: Atlantic, Indian Ocean, Pacific Australia, Southeast Asia, Pacific Hawaii
label The short code for one of the labels within the region considered
func_group Main benthic group of the label: hard coral, soft coral, other invertebrates, algae, other
label_name The full name of the label within the region considered
merged_label Alternative short code in order reduce the complexity of the label-set. Some related labels were merged for the technical validation
merged_name The full name of the merged label
description_examples A brief description of what the labels represent, with examples