Database of Grazing Metrics of Herbivorous Fishes: Data Dictionary

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 65073 | Published / External
Created: 2021-07-26   |   Last Modified: 2023-08-23

Parent: Database of Grazing Metrics for Herbivorous Fishes of the Indo-Pacific
Data Set (DS) | ID: 65072

ID: 65073
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

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
Revision Date  
• Publication Date  
* » Abstract
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Spreadsheet
Active Version? Y
Alias  
Schema Name  
» Description

Entities and attributes for database.
Change Summary

Data Attributes

Attribute Summary

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

Attribute Details

Attribute Name ID_study
Seq. Order 1
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Unique identifier assigned to each source study.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ID_citation
Seq. Order 2
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Full citation of each source study.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name METHD_gen
Seq. Order 4
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

General methods used to measure response metric.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_gen
Seq. Order 5
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

General region of study.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_reg_isl
Seq. Order 6
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Within-region area or island of study.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_site
Seq. Order 7
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Information about specific study site.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_hab
Seq. Order 9
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Information about habitat of study area.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_lat
Seq. Order 10
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Latitude of LOCN_reg_isl or LOCN_site (finest scale reported).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_long
Seq. Order 11
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Longitude of LOCN_reg_isl or LOCN_site (finest scale reported).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LOCN_mult_coord
Seq. Order 12
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

List of coordinates (latitude, longitude) when observations took place at multiple locations.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SST_mean
Seq. Order 16
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Mean monthly sea-surface temperature (SST) calculated from satellite data (applies only to observations of bite rate).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SST_sd
Seq. Order 17
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Standard deviation of monthly sea-surface temperature (SST) calculated from satellite data (applies only to observations of bite rate).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPTH_m
Seq. Order 18
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Reported depth (meters) of observation(s) (applies only to observations of bite rate).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIME_day_num
Seq. Order 19
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Reported time of day (military time as an integer) of observation(s) (applies only to observations of bite rate).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISH_family
Seq. Order 20
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Taxonomic family of observed fish.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISH_genus
Seq. Order 21
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Taxonomic genus of observed fish.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISH_species
Seq. Order 22
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Taxonomic species of observed fish.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISH_sciname
Seq. Order 23
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Scientific name of observed fish.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_type_final
Seq. Order 24
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
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).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_range_deltacm
Seq. Order 25
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Total range in fish size (cm) that "midpt" in SIZE_type_final represents.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_cm_TL
Seq. Order 26
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Fish size (cm total length [TL]).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_Lmax_cmTL
Seq. Order 27
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Maximum size (cm total length [TL]) of FISH_sciname.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATA_source
Seq. Order 28
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Location of accessed public data.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATA_thief
Seq. Order 29
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Indicator of whether DataThief software was used to extract data from figures/plots in DATA_source.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATA_type
Seq. Order 30
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Format of response values: aggregated data summary (e.g., mean and error; agg) or individual response (raw).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DATA_N
Seq. Order 31
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Reported sample size when DATA_type_orig is "agg".
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESP_gen
Seq. Order 33
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Response metric.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESP_calc
Seq. Order 35
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Notable details about how RESP_gen was calculated if varied from standard methods.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESP_unit
Seq. Order 36
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Units of RESP_gen.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESP_value
Seq. Order 39
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Response value.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESP_err
Seq. Order 40
Data Storage Type NUMERIC
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Error when DATA_type_orig is "agg".
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name RESP_err_unit
Seq. Order 41
Data Storage Type TEXT
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Type of error metric reported in RESP_err.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 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 Workflow State Published / External
Metadata Last Review Date 2022-08-24
Metadata Review Frequency 1 Year
Metadata Next Review Date 2023-08-24
Tags