Item Identification

Title: Puako Ecosystem Model Input Data
Short Name: Input Data
Status: Completed
Abstract:

Input data tables for the Ecopath with Ecosim Puako model

Entity Information

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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.

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 Details

Catalog Item ID: 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: 2019-06-04 13:14+0000
Metadata Record Published: 2018-01-17
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-01-18