Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > Guam Boat-based Creel Survey >

g_bbs_spc_vfp

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Contains species composition data from the boat-based survey for each species, fishing method and expansion period.

Description

Contains species composition data from the boat-based survey for each species, fishing method and expansion period.

Entity Type
Data Table

Data Attribute / Type	Description
SPECCOMP_PK int	System-generated artificial primary key.
YEAR_QUARTER int	Start year and quarter and end year and quarter of expansion data.
TYPE_OF_DAY int	Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
PORT int	Port code.
CHARTER_F char	True = charter boat, False = not a charter boat.
METHOD int	Fishing method code.
SPECIES int	Species sampled. Links to G_SPEC.DBF.
SPECIES_NAME varchar	Common English name for the species.
PC_SPCOMP decimal	Percentage of this species composition = 100 * CAT_KGS / Sum of CAT_KGS for all species.
EXP_KGS decimal	Expanded weight in kilograms in the stratum = PC_SPCOMP * EX_CAT from GOF_EX.DBF.
EXP_HOUR decimal	Expanded hours for the current stratum.
CAT_KGS decimal	Catch weight of species in kilograms. Sum of CAT_KGS in stratum from GOFyyCAT.DBF.
NUM_INT int	The number of interviews counted for this stratum.
NUM_INT0 int	The number of interviews counted for this stratum.
NUM_CAT int	Number of pieces of species caught: Sum of NUM_CAT in stratum from GOFyyCAT.DBF.
POOL_FLAG varchar	Shows the quality of expanded data in the stratum from GOF_EX.DBF.
LOAD_TABLE varchar	Name of the FoxPro table that was loaded into MySQL.
LOAD_DATETIME datetime	The date and time the data was loaded in to the table
LOAD_USER varchar	User who loaded the data to the MySQL table.

Data Attribute / Type

Description

SPECCOMP_PK
int

System-generated artificial primary key.

YEAR_QUARTER
int

Start year and quarter and end year and quarter of expansion data.

TYPE_OF_DAY
int

Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).

PORT
int

Port code.

CHARTER_F
char

True = charter boat, False = not a charter boat.

METHOD
int

Fishing method code.

SPECIES
int

Species sampled. Links to G_SPEC.DBF.

SPECIES_NAME
varchar

Common English name for the species.

PC_SPCOMP
decimal

Percentage of this species composition = 100 * CAT_KGS / Sum of CAT_KGS for all species.

EXP_KGS
decimal

Expanded weight in kilograms in the stratum = PC_SPCOMP * EX_CAT from GOF_EX.DBF.

EXP_HOUR
decimal

Expanded hours for the current stratum.

CAT_KGS
decimal

Catch weight of species in kilograms. Sum of CAT_KGS in stratum from GOFyyCAT.DBF.

NUM_INT
int

The number of interviews counted for this stratum.

NUM_INT0
int

The number of interviews counted for this stratum.

NUM_CAT
int

Number of pieces of species caught: Sum of NUM_CAT in stratum from GOFyyCAT.DBF.

POOL_FLAG
varchar

Shows the quality of expanded data in the stratum from GOF_EX.DBF.

LOAD_TABLE
varchar

Name of the FoxPro table that was loaded into MySQL.

LOAD_DATETIME
datetime

The date and time the data was loaded in to the table

LOAD_USER
varchar

User who loaded the data to the MySQL table.

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:	g_bbs_spc_vfp
Status:	Completed
Abstract:	Contains species composition data from the boat-based survey for each species, fishing method and expansion period.

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	guam_dawr_wh
Description:	Contains species composition data from the boat-based survey for each species, fishing method and expansion period.

Attribute Summary

	Name	Type	Description
100	SPECCOMP_PK	int	System-generated artificial primary key.
100	YEAR_QUARTER	int	Start year and quarter and end year and quarter of expansion data.
100	TYPE_OF_DAY	int	Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
100	PORT	int	Port code.
100	CHARTER_F	char	True = charter boat, False = not a charter boat.
100	METHOD	int	Fishing method code.
100	SPECIES	int	Species sampled. Links to G_SPEC.DBF.
100	SPECIES_NAME	varchar	Common English name for the species.
100	PC_SPCOMP	decimal	Percentage of this species composition = 100 * CAT_KGS / Sum of CAT_KGS for all species.
100	EXP_KGS	decimal	Expanded weight in kilograms in the stratum = PC_SPCOMP * EX_CAT from GOF_EX.DBF.
100	EXP_HOUR	decimal	Expanded hours for the current stratum.
100	CAT_KGS	decimal	Catch weight of species in kilograms. Sum of CAT_KGS in stratum from GOFyyCAT.DBF.
100	NUM_INT	int	The number of interviews counted for this stratum.
100	NUM_INT0	int	The number of interviews counted for this stratum.
100	NUM_CAT	int	Number of pieces of species caught: Sum of NUM_CAT in stratum from GOFyyCAT.DBF.
100	POOL_FLAG	varchar	Shows the quality of expanded data in the stratum from GOF_EX.DBF.
100	LOAD_TABLE	varchar	Name of the FoxPro table that was loaded into MySQL.
100	LOAD_DATETIME	datetime	The date and time the data was loaded in to the table
100	LOAD_USER	varchar	User who loaded the data to the MySQL table.

Name

Type

Description

100

SPECCOMP_PK

int

System-generated artificial primary key.

100

YEAR_QUARTER

int

Start year and quarter and end year and quarter of expansion data.

100

TYPE_OF_DAY

int

Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).

100

PORT

int

Port code.

100

CHARTER_F

char

True = charter boat, False = not a charter boat.

100

METHOD

int

Fishing method code.

100

SPECIES

int

Species sampled. Links to G_SPEC.DBF.

100

SPECIES_NAME

varchar

Common English name for the species.

100

PC_SPCOMP

decimal

Percentage of this species composition = 100 * CAT_KGS / Sum of CAT_KGS for all species.

100

EXP_KGS

decimal

Expanded weight in kilograms in the stratum = PC_SPCOMP * EX_CAT from GOF_EX.DBF.

100

EXP_HOUR

decimal

Expanded hours for the current stratum.

100

CAT_KGS

decimal

Catch weight of species in kilograms. Sum of CAT_KGS in stratum from GOFyyCAT.DBF.

100

NUM_INT

int

The number of interviews counted for this stratum.

100

NUM_INT0

int

The number of interviews counted for this stratum.

100

NUM_CAT

int

Number of pieces of species caught: Sum of NUM_CAT in stratum from GOFyyCAT.DBF.

100

POOL_FLAG

varchar

Shows the quality of expanded data in the stratum from GOF_EX.DBF.

100

LOAD_TABLE

varchar

Name of the FoxPro table that was loaded into MySQL.

100

LOAD_DATETIME

datetime

The date and time the data was loaded in to the table

100

LOAD_USER

varchar

User who loaded the data to the MySQL table.

Attribute Details

SPECCOMP_PK

CC ID: 1008125

Seq. Order:	1
Data Storage Type:	int
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	System-generated artificial primary key.

YEAR_QUARTER

CC ID: 1008126

Seq. Order:	2
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Start year and quarter and end year and quarter of expansion data.

TYPE_OF_DAY

CC ID: 1008127

Seq. Order:	3
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).

PORT

CC ID: 1008128

Seq. Order:	4
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Port code.

CHARTER_F

CC ID: 1008129

Seq. Order:	5
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	True = charter boat, False = not a charter boat.

METHOD

CC ID: 1008130

Seq. Order:	6
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Fishing method code.

SPECIES

CC ID: 1008131

Seq. Order:	7
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Species sampled. Links to G_SPEC.DBF.

SPECIES_NAME

CC ID: 1008132

Seq. Order:	8
Data Storage Type:	varchar
Max Length:	28
Required:	No
Primary Key:	No
Status:	Active
Description:	Common English name for the species.

PC_SPCOMP

CC ID: 1008133

Seq. Order:	9
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Percentage of this species composition = 100 * CAT_KGS / Sum of CAT_KGS for all species.

EXP_KGS

CC ID: 1008134

Seq. Order:	10
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	2
Status:	Active
Description:	Expanded weight in kilograms in the stratum = PC_SPCOMP * EX_CAT from GOF_EX.DBF.

EXP_HOUR

CC ID: 1008135

Seq. Order:	11
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	2
Status:	Active
Description:	Expanded hours for the current stratum.

CAT_KGS

CC ID: 1008136

Seq. Order:	12
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Catch weight of species in kilograms. Sum of CAT_KGS in stratum from GOFyyCAT.DBF.

NUM_INT

CC ID: 1008137

Seq. Order:	13
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of interviews counted for this stratum.

NUM_INT0

CC ID: 1008138

Seq. Order:	14
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of interviews counted for this stratum.

NUM_CAT

CC ID: 1008139

Seq. Order:	15
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of pieces of species caught: Sum of NUM_CAT in stratum from GOFyyCAT.DBF.

POOL_FLAG

CC ID: 1008140

Seq. Order:	16
Data Storage Type:	varchar
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Shows the quality of expanded data in the stratum from GOF_EX.DBF.

LOAD_TABLE

CC ID: 1008141

Seq. Order:	17
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the FoxPro table that was loaded into MySQL.

LOAD_DATETIME

CC ID: 1008142

Seq. Order:	18
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	The date and time the data was loaded in to the table

LOAD_USER

CC ID: 1008143

Seq. Order:	19
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User who loaded the data to the MySQL table.

Catalog Item ID:	63469
GUID:	gov.noaa.nmfs.inport:63469
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2021-01-21 01:06+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2021-01-21
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-01-21
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-01-21

g_bbs_spc_vfp

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SPECCOMP_PK

YEAR_QUARTER

TYPE_OF_DAY

PORT

CHARTER_F

METHOD

SPECIES

SPECIES_NAME

PC_SPCOMP

EXP_KGS

EXP_HOUR

CAT_KGS

NUM_INT

NUM_INT0

NUM_CAT

POOL_FLAG

LOAD_TABLE

LOAD_DATETIME

LOAD_USER

Catalog Details