Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Database of Grazing Metrics of Herbivorous Fishes: Data Dictionary
Short Name: Database Grazing Metrics: Data Dictionary
Status: Completed
Creation Date: 2022-07

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Entities and attributes for database.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID_study TEXT Unique identifier assigned to each source study.
100
ID_citation TEXT Full citation of each source study.
100
METHD_gen TEXT General methods used to measure response metric.
100
LOCN_gen TEXT General region of study.
100
LOCN_reg_isl TEXT Within-region area or island of study.
100
LOCN_site TEXT Information about specific study site.
100
LOCN_hab TEXT Information about habitat of study area.
100
LOCN_lat NUMERIC Latitude of LOCN_reg_isl or LOCN_site (finest scale reported).
100
LOCN_long NUMERIC Longitude of LOCN_reg_isl or LOCN_site (finest scale reported).
100
LOCN_mult_coord TEXT List of coordinates (latitude, longitude) when observations took place at multiple locations.
100
SST_mean NUMERIC Mean monthly sea-surface temperature (SST) calculated from satellite data (applies only to observations of bite rate).
100
SST_sd NUMERIC Standard deviation of monthly sea-surface temperature (SST) calculated from satellite data (applies only to observations of bite rate).
100
DEPTH_m NUMERIC Reported depth (meters) of observation(s) (applies only to observations of bite rate).
100
TIME_day_num NUMERIC Reported time of day (military time as an integer) of observation(s) (applies only to observations of bite rate).
100
FISH_family TEXT Taxonomic family of observed fish.
100
FISH_genus TEXT Taxonomic genus of observed fish.
100
FISH_species TEXT Taxonomic species of observed fish.
100
FISH_sciname TEXT Scientific name of observed fish.
100
SIZE_type_final TEXT Metric of fish size: length of individual fish (indiv), mean length of observed fish (mean), or midpoint of range in lengths of observed fish (midpt).
100
SIZE_range_deltacm NUMERIC Total range in fish size (cm) that "midpt" in SIZE_type_final represents.
100
SIZE_cm_TL NUMERIC Fish size (cm total length [TL]).
100
SIZE_Lmax_cmTL NUMERIC Maximum size (cm total length [TL]) of FISH_sciname.
100
DATA_source TEXT Location of accessed public data.
100
DATA_thief TEXT Indicator of whether DataThief software was used to extract data from figures/plots in DATA_source.
100
DATA_type TEXT Format of response values: aggregated data summary (e.g., mean and error; agg) or individual response (raw).
100
DATA_N NUMERIC Reported sample size when DATA_type_orig is "agg".
100
RESP_gen TEXT Response metric.
100
RESP_calc TEXT Notable details about how RESP_gen was calculated if varied from standard methods.
100
RESP_unit TEXT Units of RESP_gen.
100
RESP_value NUMERIC Response value.
100
RESP_err NUMERIC Error when DATA_type_orig is "agg".
100
RESP_err_unit TEXT Type of error metric reported in RESP_err.

Attribute Details

ID_study

CC ID: 1076124
Seq. Order: 1
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier assigned to each source study.

ID_citation

CC ID: 1178673
Seq. Order: 2
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Full citation of each source study.

METHD_gen

CC ID: 1178675
Seq. Order: 4
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

General methods used to measure response metric.

LOCN_gen

CC ID: 1178676
Seq. Order: 5
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

General region of study.

LOCN_reg_isl

CC ID: 1178677
Seq. Order: 6
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Within-region area or island of study.

LOCN_site

CC ID: 1178678
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Information about specific study site.

LOCN_hab

CC ID: 1178680
Seq. Order: 9
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Information about habitat of study area.

LOCN_lat

CC ID: 1178681
Seq. Order: 10
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Latitude of LOCN_reg_isl or LOCN_site (finest scale reported).

LOCN_long

CC ID: 1178682
Seq. Order: 11
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude of LOCN_reg_isl or LOCN_site (finest scale reported).

LOCN_mult_coord

CC ID: 1178683
Seq. Order: 12
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

List of coordinates (latitude, longitude) when observations took place at multiple locations.

SST_mean

CC ID: 1178687
Seq. Order: 16
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Mean monthly sea-surface temperature (SST) calculated from satellite data (applies only to observations of bite rate).

SST_sd

CC ID: 1178688
Seq. Order: 17
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Standard deviation of monthly sea-surface temperature (SST) calculated from satellite data (applies only to observations of bite rate).

DEPTH_m

CC ID: 1178689
Seq. Order: 18
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Reported depth (meters) of observation(s) (applies only to observations of bite rate).

TIME_day_num

CC ID: 1178690
Seq. Order: 19
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Reported time of day (military time as an integer) of observation(s) (applies only to observations of bite rate).

FISH_family

CC ID: 1178691
Seq. Order: 20
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic family of observed fish.

FISH_genus

CC ID: 1178692
Seq. Order: 21
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic genus of observed fish.

FISH_species

CC ID: 1178693
Seq. Order: 22
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic species of observed fish.

FISH_sciname

CC ID: 1178694
Seq. Order: 23
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Scientific name of observed fish.

SIZE_type_final

CC ID: 1178695
Seq. Order: 24
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Metric of fish size: length of individual fish (indiv), mean length of observed fish (mean), or midpoint of range in lengths of observed fish (midpt).

SIZE_range_deltacm

CC ID: 1178696
Seq. Order: 25
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Total range in fish size (cm) that "midpt" in SIZE_type_final represents.

SIZE_cm_TL

CC ID: 1178697
Seq. Order: 26
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Fish size (cm total length [TL]).

SIZE_Lmax_cmTL

CC ID: 1178698
Seq. Order: 27
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Maximum size (cm total length [TL]) of FISH_sciname.

DATA_source

CC ID: 1178726
Seq. Order: 28
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Location of accessed public data.

DATA_thief

CC ID: 1178727
Seq. Order: 29
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Indicator of whether DataThief software was used to extract data from figures/plots in DATA_source.

DATA_type

CC ID: 1178728
Seq. Order: 30
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Format of response values: aggregated data summary (e.g., mean and error; agg) or individual response (raw).

DATA_N

CC ID: 1178729
Seq. Order: 31
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Reported sample size when DATA_type_orig is "agg".

RESP_gen

CC ID: 1178731
Seq. Order: 33
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Response metric.

RESP_calc

CC ID: 1178733
Seq. Order: 35
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Notable details about how RESP_gen was calculated if varied from standard methods.

RESP_unit

CC ID: 1178734
Seq. Order: 36
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Units of RESP_gen.

RESP_value

CC ID: 1178737
Seq. Order: 39
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Response value.

RESP_err

CC ID: 1178738
Seq. Order: 40
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Error when DATA_type_orig is "agg".

RESP_err_unit

CC ID: 1178739
Seq. Order: 41
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Type of error metric reported in RESP_err.

Catalog Details

Catalog Item ID: 65073
GUID: gov.noaa.nmfs.inport:65073
Metadata Record Created By: Brooke Olenski
Metadata Record Created: 2021-07-26 22:24+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2023-08-23 18:21+0000
Metadata Record Published: 2023-08-21
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-08-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-08-24