Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Ecosystem Modeling > Evaluating management strategies to optimize co... >

Puako Ecosystem Model Input Data

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:50699 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Input data tables for the Ecopath with Ecosim Puako model

Description

EwE input data. Three tables. One table shows the biomass, vital rates and ecotrophic eficiency; table 2 shows the diet matrix; and table 3 shows the predator/prey vulnerabilities used in ecosim.

Entity Type
Spreadsheet

Data Attribute / Type	Description
FunctGrp VARCHAR2	Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance
No. NUMBER	Functional group number
Group name VARCHAR2	Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance
TL NUMBER	Trophic Level of the functional group
B NUMBER	Initial biomass of the functional group in metric tons per squared kilometer
P:B NUMBER	Production per biomass ratio with unit per year
Q:B NUMBER	Comsumption per biomass ratio with unit per year
EE NUMBER	Ecotrophic efficiency, unitless and should be below 1
P/Q NUMBER	Production to Consumption ratio which in general is between 0.1 and 0.3
DietMatrix NUMBER	All rows are preys and all columns are predators. The numbers in the column headings correspond to the number in the row headings. So this table shows per column (predator) the diet composition (in of the prey (rows) items.
VulnerabilityMatrix NUMBER	Just as in the DietMatrix data table, the rows represent the preys and functional group number and the columns represent the predators by functional group number. The values represent the vulnerability of that prey functional group to the predator. A high value represents a top-down control and a low value represents a bottom-up control.

Data Attribute / Type

Description

FunctGrp
VARCHAR2

Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance

No.
NUMBER

Functional group number

Group name
VARCHAR2

Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance

TL
NUMBER

Trophic Level of the functional group

B
NUMBER

Initial biomass of the functional group in metric tons per squared kilometer

P:B
NUMBER

Production per biomass ratio with unit per year

Q:B
NUMBER

Comsumption per biomass ratio with unit per year

EE
NUMBER

Ecotrophic efficiency, unitless and should be below 1

P/Q
NUMBER

Production to Consumption ratio which in general is between 0.1 and 0.3

DietMatrix
NUMBER

All rows are preys and all columns are predators. The numbers in the column headings correspond to the number in the row headings. So this table shows per column (predator) the diet composition (in of the prey (rows) items.

VulnerabilityMatrix
NUMBER

Just as in the DietMatrix data table, the rows represent the preys and functional group number and the columns represent the predators by functional group number. The values represent the vulnerability of that prey functional group to the predator. A high value represents a top-down control and a low value represents a bottom-up control.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	Puako Ecosystem Model Input Data
Short Name:	Input Data
Status:	Completed
Abstract:	Input data tables for the Ecopath with Ecosim Puako model

Entity Type:	Spreadsheet
Active Version?:	Yes
Description:	EwE input data. Three tables. One table shows the biomass, vital rates and ecotrophic eficiency; table 2 shows the diet matrix; and table 3 shows the predator/prey vulnerabilities used in ecosim.

Attribute Summary

	Name	Type	Description
100	FunctGrp	VARCHAR2	Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance
100	No.	NUMBER	Functional group number
100	Group name	VARCHAR2	Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance
100	TL	NUMBER	Trophic Level of the functional group
100	B	NUMBER	Initial biomass of the functional group in metric tons per squared kilometer
100	P:B	NUMBER	Production per biomass ratio with unit per year
100	Q:B	NUMBER	Comsumption per biomass ratio with unit per year
100	EE	NUMBER	Ecotrophic efficiency, unitless and should be below 1
100	P/Q	NUMBER	Production to Consumption ratio which in general is between 0.1 and 0.3
100	DietMatrix	NUMBER	All rows are preys and all columns are predators. The numbers in the column headings correspond to the number in the row headings. So this table shows per column (predator) the diet composition (in of the prey (rows) items.
100	VulnerabilityMatrix	NUMBER	Just as in the DietMatrix data table, the rows represent the preys and functional group number and the columns represent the predators by functional group number. The values represent the vulnerability of that prey functional group to the predator. A high value represents a top-down control and a low value represents a bottom-up control.

Name

Type

Description

100

FunctGrp

VARCHAR2

Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance

100

No.

NUMBER

Functional group number

100

Group name

VARCHAR2

Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance

100

NUMBER

Trophic Level of the functional group

100

NUMBER

Initial biomass of the functional group in metric tons per squared kilometer

100

P:B

NUMBER

Production per biomass ratio with unit per year

100

Q:B

NUMBER

Comsumption per biomass ratio with unit per year

100

NUMBER

Ecotrophic efficiency, unitless and should be below 1

100

P/Q

NUMBER

Production to Consumption ratio which in general is between 0.1 and 0.3

100

DietMatrix

NUMBER

100

VulnerabilityMatrix

NUMBER

Attribute Details

FunctGrp

CC ID: 703655

Seq. Order:	1
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance

No.

CC ID: 703660

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Functional group number

Group name

CC ID: 703661

Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Functional group; these are the groups of species aggregated based on diet, life history, ecological role or economic importance

TL

CC ID: 703662

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Trophic Level of the functional group

B

CC ID: 703663

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Initial biomass of the functional group in metric tons per squared kilometer

P:B

CC ID: 703664

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Production per biomass ratio with unit per year

Q:B

CC ID: 703665

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Comsumption per biomass ratio with unit per year

EE

CC ID: 703666

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Ecotrophic efficiency, unitless and should be below 1

P/Q

CC ID: 703667

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Production to Consumption ratio which in general is between 0.1 and 0.3

DietMatrix

CC ID: 703676

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	All rows are preys and all columns are predators. The numbers in the column headings correspond to the number in the row headings. So this table shows per column (predator) the diet composition (in of the prey (rows) items.

VulnerabilityMatrix

CC ID: 703677

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Just as in the DietMatrix data table, the rows represent the preys and functional group number and the columns represent the predators by functional group number. The values represent the vulnerability of that prey functional group to the predator. A high value represents a top-down control and a low value represents a bottom-up control.

Catalog Item ID:	50699
GUID:	gov.noaa.nmfs.inport:50699
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2017-12-07 20:00+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2018-01-17
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2018-01-17
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2019-01-17

Puako Ecosystem Model Input Data

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

FunctGrp

No.

Group name

TL

B

P:B

Q:B

EE

P/Q

DietMatrix

VulnerabilityMatrix

Catalog Details