Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Description

Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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.

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