Metadata Rubric

100%

6 / 6

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

g_sbs_exp_vfp

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

Item Identification

Title:	g_sbs_exp_vfp
Status:	Completed
Abstract:	Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	guam_dawr_wh
Description:	Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Data Attributes

Attribute Summary

	Name	Type	Description
100	EXP_PK	varchar	Key link each species record back to it parent record (g_sbs_exp_vfp)
100	YEAR	int	Year of the survey date
100	SHIFT	int	Time of survey shift (1 = 6:00 to 17:59, 2 = 18:00 to 5:59 on next day.
100	TYPE_OF_DAY	varchar	Type of day on which interview/survey was conducted. (1 = weekday, 2 = weekend/holiday). Calculated field.
100	METHOD_FK	int	Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.
100	REGION	int	Route code of the survey.
100	NUM_PAR	int	Record counts in the stratum from GINyyPAR.DBF.
100	NUM_INTERVIEW	int	Number of interviews in this stratum.
100	NUM_SAMPLE_DAYS	int	The number of participation log entries for the current stratum
100	NUM_CALENDAR_DAYS	int	number of calender days used in the expansion.
100	SUM_GEAR_PAR	int	The total number of gears recorded during participation runs for the current stratum.
100	SUM_GEAR2_PAR	int	The total number of gears recorded during participation runs for the current stratum squared.
100	SUM_FISHER_PAR	int	The total number of fishers recorded during participation runs for the current stratum.
100	SUM_GEAR_HOUR	decimal	The number of gear hours represented by interviews collected for the current stratum.
100	SUM_GEAR_HOUR2	decimal	The number of gear hours represented by interviews collected for the current stratum squared.
100	SUM_TOT_KGS	decimal	Total species weight per this stratum
100	SUM_TOT_KGS2	decimal	Total species weight per this stratum squared
100	SUM_KGS_GEAR_HOUR	decimal	The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.
100	SUM_HOUR_INT	decimal	The number of fishing hours represented by interviews collected for the current stratum.
100	SUM_GEAR_INT	decimal	The total number of gears represented by interviews collected for the current stratum
100	SUM_FISHER_INT	int	The number of fishers represented by interviews collected for the current stratum
100	SUM_FISHER_HOUR_INT	decimal	The number of fisher-hours represented by interviews collected for the current stratum.
100	CPUE_GEAR_HOUR	decimal	Gear-Hour CPUE (Kgs/Gear-Hour) = SM_KG / SM_GR_HR.
100	AVG_GEAR_PAR	decimal	Average number of gears
100	AVG_FISHER_PAR	decimal	Average number of fishers
100	EXP_HOUR	int	Expanded hours fished per stratum = 12 * DAYS (for Shift = 1); 8 * DAYS (for Shift = 2).
100	EXP_GEAR_HOUR	decimal	Expanded Gear_Hour per stratum = AV_GR * EX_HR.
100	EXP_FISHER_HOUR	decimal	Expanded Fisherman_Hour per stratum = EX_FACTOR * SM_PR_HR.
100	EXP_KGS	decimal	Expanded kgs of this gear and stratum
100	EXP_KGS_POOLED	decimal	Not used. Temporary place holder value during the expansion.
100	VAR_EXP_KGS	decimal	Varian of expanded fish weight
100	VAR_AVG_GEAR	decimal	Varian of average gears
100	VAR_GEAR_HOUR	decimal	Varian of gear-hours CPUE
100	VAR_CPUE_GEAR_HOUR	decimal	Varian of gear-hours CPUE
100	STD_GEAR_HOUR	decimal	Standard deviation of gear-hours
100	STD_CPUE_GEAR_HOUR	decimal	Standard deviation of gear-hours CPUE
100	STD_EXP_KGS	decimal	Standard deviation of expanded weight
100	P2	decimal	A spatial adjustment factor for region = 4 or Region = 0 Expansion): from G_P2.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

EXP_PK

varchar

Key link each species record back to it parent record (g_sbs_exp_vfp)

100

YEAR

int

Year of the survey date

100

SHIFT

int

Time of survey shift (1 = 6:00 to 17:59, 2 = 18:00 to 5:59 on next day.

100

TYPE_OF_DAY

varchar

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

100

METHOD_FK

int

Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.

100

REGION

int

Route code of the survey.

100

NUM_PAR

int

Record counts in the stratum from GINyyPAR.DBF.

100

NUM_INTERVIEW

int

Number of interviews in this stratum.

100

NUM_SAMPLE_DAYS

int

The number of participation log entries for the current stratum

100

NUM_CALENDAR_DAYS

int

number of calender days used in the expansion.

100

SUM_GEAR_PAR

int

The total number of gears recorded during participation runs for the current stratum.

100

SUM_GEAR2_PAR

int

The total number of gears recorded during participation runs for the current stratum squared.

100

SUM_FISHER_PAR

int

The total number of fishers recorded during participation runs for the current stratum.

100

SUM_GEAR_HOUR

decimal

The number of gear hours represented by interviews collected for the current stratum.

100

SUM_GEAR_HOUR2

decimal

The number of gear hours represented by interviews collected for the current stratum squared.

100

SUM_TOT_KGS

decimal

Total species weight per this stratum

100

SUM_TOT_KGS2

decimal

Total species weight per this stratum squared

100

SUM_KGS_GEAR_HOUR

decimal

The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.

100

SUM_HOUR_INT

decimal

The number of fishing hours represented by interviews collected for the current stratum.

100

SUM_GEAR_INT

decimal

The total number of gears represented by interviews collected for the current stratum

100

SUM_FISHER_INT

int

The number of fishers represented by interviews collected for the current stratum

100

SUM_FISHER_HOUR_INT

decimal

The number of fisher-hours represented by interviews collected for the current stratum.

100

CPUE_GEAR_HOUR

decimal

Gear-Hour CPUE (Kgs/Gear-Hour) = SM_KG / SM_GR_HR.

100

AVG_GEAR_PAR

decimal

Average number of gears

100

AVG_FISHER_PAR

decimal

Average number of fishers

100

EXP_HOUR

int

Expanded hours fished per stratum = 12 * DAYS (for Shift = 1); 8 * DAYS (for Shift = 2).

100

EXP_GEAR_HOUR

decimal

Expanded Gear_Hour per stratum = AV_GR * EX_HR.

100

EXP_FISHER_HOUR

decimal

Expanded Fisherman_Hour per stratum = EX_FACTOR * SM_PR_HR.

100

EXP_KGS

decimal

Expanded kgs of this gear and stratum

100

EXP_KGS_POOLED

decimal

Not used. Temporary place holder value during the expansion.

100

VAR_EXP_KGS

decimal

Varian of expanded fish weight

100

VAR_AVG_GEAR

decimal

Varian of average gears

100

VAR_GEAR_HOUR

decimal

Varian of gear-hours CPUE

100

VAR_CPUE_GEAR_HOUR

decimal

Varian of gear-hours CPUE

100

STD_GEAR_HOUR

decimal

Standard deviation of gear-hours

100

STD_CPUE_GEAR_HOUR

decimal

Standard deviation of gear-hours CPUE

100

STD_EXP_KGS

decimal

Standard deviation of expanded weight

100

decimal

A spatial adjustment factor for region = 4 or Region = 0 Expansion): from G_P2.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

EXP_PK

CC ID: 1008189

Seq. Order:	1
Data Storage Type:	varchar
Max Length:	10
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Key link each species record back to it parent record (g_sbs_exp_vfp)

YEAR

CC ID: 1008190

Seq. Order:	2
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Year of the survey date

SHIFT

CC ID: 1008191

Seq. Order:	3
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Time of survey shift (1 = 6:00 to 17:59, 2 = 18:00 to 5:59 on next day.

TYPE_OF_DAY

CC ID: 1008192

Seq. Order:	4
Data Storage Type:	varchar
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of day on which interview/survey was conducted. (1 = weekday, 2 = weekend/holiday). Calculated field.

METHOD_FK

CC ID: 1008193

Seq. Order:	5
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.

REGION

CC ID: 1008194

Seq. Order:	6
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Route code of the survey.

NUM_PAR

CC ID: 1008195

Seq. Order:	7
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Record counts in the stratum from GINyyPAR.DBF.

NUM_INTERVIEW

CC ID: 1008196

Seq. Order:	8
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of interviews in this stratum.

NUM_SAMPLE_DAYS

CC ID: 1008197

Seq. Order:	9
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of participation log entries for the current stratum

NUM_CALENDAR_DAYS

CC ID: 1008198

Seq. Order:	10
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	number of calender days used in the expansion.

SUM_GEAR_PAR

CC ID: 1008199

Seq. Order:	11
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The total number of gears recorded during participation runs for the current stratum.

SUM_GEAR2_PAR

CC ID: 1008200

Seq. Order:	12
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The total number of gears recorded during participation runs for the current stratum squared.

SUM_FISHER_PAR

CC ID: 1008201

Seq. Order:	13
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The total number of fishers recorded during participation runs for the current stratum.

SUM_GEAR_HOUR

CC ID: 1008202

Seq. Order:	14
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	5
Status:	Active
Description:	The number of gear hours represented by interviews collected for the current stratum.

SUM_GEAR_HOUR2

CC ID: 1008203

Seq. Order:	15
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	5
Status:	Active
Description:	The number of gear hours represented by interviews collected for the current stratum squared.

SUM_TOT_KGS

CC ID: 1008204

Seq. Order:	16
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	4
Status:	Active
Description:	Total species weight per this stratum

SUM_TOT_KGS2

CC ID: 1008205

Seq. Order:	17
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	4
Status:	Active
Description:	Total species weight per this stratum squared

SUM_KGS_GEAR_HOUR

CC ID: 1008206

Seq. Order:	18
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	5
Status:	Active
Description:	The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.

SUM_HOUR_INT

CC ID: 1008207

Seq. Order:	19
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	The number of fishing hours represented by interviews collected for the current stratum.

SUM_GEAR_INT

CC ID: 1008208

Seq. Order:	20
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	The total number of gears represented by interviews collected for the current stratum

SUM_FISHER_INT

CC ID: 1008209

Seq. Order:	21
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of fishers represented by interviews collected for the current stratum

SUM_FISHER_HOUR_INT

CC ID: 1008210

Seq. Order:	22
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	2
Status:	Active
Description:	The number of fisher-hours represented by interviews collected for the current stratum.

CPUE_GEAR_HOUR

CC ID: 1008211

Seq. Order:	23
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	4
Status:	Active
Description:	Gear-Hour CPUE (Kgs/Gear-Hour) = SM_KG / SM_GR_HR.

AVG_GEAR_PAR

CC ID: 1008212

Seq. Order:	24
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	6
Status:	Active
Description:	Average number of gears

AVG_FISHER_PAR

CC ID: 1008213

Seq. Order:	25
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	6
Status:	Active
Description:	Average number of fishers

EXP_HOUR

CC ID: 1008214

Seq. Order:	26
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Expanded hours fished per stratum = 12 * DAYS (for Shift = 1); 8 * DAYS (for Shift = 2).

EXP_GEAR_HOUR

CC ID: 1008215

Seq. Order:	27
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Expanded Gear_Hour per stratum = AV_GR * EX_HR.

EXP_FISHER_HOUR

CC ID: 1008216

Seq. Order:	28
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Expanded Fisherman_Hour per stratum = EX_FACTOR * SM_PR_HR.

EXP_KGS

CC ID: 1008217

Seq. Order:	29
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	2
Status:	Active
Description:	Expanded kgs of this gear and stratum

EXP_KGS_POOLED

CC ID: 1008218

Seq. Order:	30
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	2
Status:	Active
Description:	Not used. Temporary place holder value during the expansion.

VAR_EXP_KGS

CC ID: 1008219

Seq. Order:	31
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	19
Scale:	4
Status:	Active
Description:	Varian of expanded fish weight

VAR_AVG_GEAR

CC ID: 1008220

Seq. Order:	32
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	7
Status:	Active
Description:	Varian of average gears

VAR_GEAR_HOUR

CC ID: 1008221

Seq. Order:	33
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	15
Scale:	5
Status:	Active
Description:	Varian of gear-hours CPUE

VAR_CPUE_GEAR_HOUR

CC ID: 1008222

Seq. Order:	34
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	10
Status:	Active
Description:	Varian of gear-hours CPUE

STD_GEAR_HOUR

CC ID: 1008223

Seq. Order:	35
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Standard deviation of gear-hours

STD_CPUE_GEAR_HOUR

CC ID: 1008224

Seq. Order:	36
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Standard deviation of gear-hours CPUE

STD_EXP_KGS

CC ID: 1008225

Seq. Order:	37
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Standard deviation of expanded weight

P2

CC ID: 1008226

Seq. Order:	38
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	4
Status:	Active
Description:	A spatial adjustment factor for region = 4 or Region = 0 Expansion): from G_P2.DBF.

LOAD_TABLE

CC ID: 1008227

Seq. Order:	39
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: 1008228

Seq. Order:	40
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: 1008229

Seq. Order:	41
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 Details

Catalog Item ID:	63471
GUID:	gov.noaa.nmfs.inport:63471
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2021-01-21 01:09+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