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 |