Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
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