Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring > Western Pacific Fisheries Information Network (... > CNMI Boat-based Creel Survey >

c_bbs_exp_vfp

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

Item Identification

Title: c_bbs_exp_vfp
Status: Completed
Abstract:

Contains shore-based expanded species composition data.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: cnmi_dfw_wh
Description:

Contains shore-based expanded species composition data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key EXPANSION_PK int System-generated artificial primary key.
100
 YEAR_QUARTER int Start year and quarter and end year and quarter of expansion data. Format is yyyyqYYYYQ: 'yyyy' is the start year, 'q' is the start quarter, 'YYYY' is the end year, and 'Q' is the end quarter. Quarters are 1 = 4 calendar year.
100
 TYPE_OF_DAY int Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
100
 PORT int Port code for this expansion.
100
 CHARTER_F char If true (T), indicates chartered trip.
100
 METHOD int Fishing method.
100
 SM_TR decimal The number of trips represented by interviews collected for the current stratum.
100
 AVG_EST_TRIP decimal Average trip per day from boat log.
100
 DAYS_Q int Days in the quarter for current stratum.
100
 EXP_TRIP decimal Expanded trips for the current stratum.
100
 EXP_HOUR decimal Expanded hours for the current stratum.
100
 EXP_FISHER decimal Expanded fishers for the current stratum.
100
 EXP_FISHER_HOUR decimal Expanded fisher-hours for the current stratum.
100
 EXP_GEAR_HOUR decimal Expanded gear-hours for the current stratum.
100
 CPUE_TRIP decimal The average catch-per-trip.
100
 EXP_CATCH decimal Expanded total catch for the current stratum.
100
 VAR_EST_TRIP decimal The variance of the estimated number of trips across sampling days for the current stratum.
100
 VAR_EXP_TRIP decimal The variance of the expanded number of trips for the current stratum.
100
 VAR_CPUE_TRIP decimal The variance of the catch-per-trip from interviews for the current stratum.
100
 VAR_EXP_CATCH decimal The variance of the estimated number of expanded catch across sampling days for the current stratum.
100
 STD_EXP_TRIP decimal The coefficient of variation of the expanded number of trips for the current stratum.
100
 STD_CPUE_TRIP decimal The coefficient of variation of the catch-per-trip from interviews for the current stratum.
100
 STD_EXP_CATCH decimal The coefficient of variation of the average number of trips per sampling day for the current stratum.
100
 NUM_SAMPLE_DAY int Number of sampled days.
100
 P1 decimal Place holder, not used.
100
 P2 decimal Place holder, not used.
100
 AD_FISH decimal Place holder, not used.
100
 AD_SM_TR decimal Place holder, not used.
100
 AD_SM_TR2 decimal Place holder, not used.
100
 SM_KG decimal The number of kgs represented by interviews collected for the current stratum.
100
 SM_KG2 decimal The number of kgs represented by interviews collected for the current stratum squared.
100
 NUM_INT0 int The number of interviews counted for this stratum.
100
 NUM_INT int The number of interviews counted for this stratum.
100
 SM_HOUR decimal The number of hours represented by interviews collected for the current stratum.
100
 SM_HOUR2 decimal The number of hours represented by interviews collected for the current stratum squared.
100
 SM_PRSN int The number of persons represented by interviews collected for the current stratum.
100
 SM_PR2 int The number of persons represented by interviews collected for the current stratum for the nao-sampled ports.
100
 SM_PR_HR decimal The number of person-hours represented by interviews collected for the current stratum.
100
 SM_PR_HR2 decimal The number of person-hours represented by interviews collected for the current stratum squared.
100
 SM_GEAR_HOUR decimal The number of gear hours represented by interviews collected for the current stratum.
100
 SM_GEAR_HOUR2 decimal The number of gear hours represented by interviews collected for the current stratum squared.
100
 EX_FACTOR decimal A ratio of (expanded trips)/(trips from interviews data). This factor is used to create the expanded effort data (e.g. Exp_Gears, Exp_fisher, Exp_fisher_hours, etc…)
100
 POOL_FLAG varchar Type of pooling was excecuted.
100
 WCT_TR int Total trips from WCT data.
100
 WCT_TR2 int Total trips from WCT data, squared.
100
 VAR_WCT_TR decimal The variance of the number of trips for the current stratum from WCT data.
100
 CHT_TR91 int Total trolling charted trips.
100
 CHT_TR91_2 int Total trolling charted trips, squared.
100
 V_CHT_TR91 decimal temporary place holder to calculate the the variance of CHT_TR92.
100
 CHT_TR92 int Total bottomfishing charted trips.
100
 CHT_TR92_2 int Total bottomfishing charted trips, squared.
100
 V_CHT_TR92 decimal temporary place holder to calculate the the variance of CHT_TR91.
100
 LATE_TR_AD decimal Trips that were collected in the PM shift.
100
 PC_METH decimal The proportion of all trips that are for the current method, calculated from boat log data.
100
 ALL_DAY int Total all-day trip from interviews
100
 ALL_LATE int Late trips from interviews.
100
 TR_DAY int Total trips observed duringpm shift.
100
 TR_LATE int Total trips observed during am shift.
100
 CHT_CNT int Chartered trip counts
100
 CHT_CNT_AD int Chartered trips added. Aditional chartered trips that was made after returned from the morning trips.
100
 ADD_FROM varchar Place holder, not used.
100
 SYS_CREATE_TIME datetime Date the record was created
100
 SYS_MODIFY_TIME datetime Date the record was last modified
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

EXPANSION_PK

CC ID: 1007567
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: 1007568
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. Format is yyyyqYYYYQ: 'yyyy' is the start year, 'q' is the start quarter, 'YYYY' is the end year, and 'Q' is the end quarter. Quarters are 1 = 4 calendar year.
Default Value: 0

TYPE_OF_DAY

CC ID: 1007569
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).
Default Value: 0

PORT

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

Port code for this expansion.
Default Value: 0

CHARTER_F

CC ID: 1007571
Seq. Order: 5
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true (T), indicates chartered trip.

METHOD

CC ID: 1007572
Seq. Order: 6
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Fishing method.
Default Value: 0

SM_TR

CC ID: 1007573
Seq. Order: 7
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 6
Status: Active
Description:

The number of trips represented by interviews collected for the current stratum.
Default Value: 0.000000

AVG_EST_TRIP

CC ID: 1007574
Seq. Order: 8
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 3
Status: Active
Description:

Average trip per day from boat log.
Default Value: 0.000

DAYS_Q

CC ID: 1007575
Seq. Order: 9
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Days in the quarter for current stratum.
Default Value: 0

EXP_TRIP

CC ID: 1007576
Seq. Order: 10
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 13
Scale: 4
Status: Active
Description:

Expanded trips for the current stratum.
Default Value: 0.0000

EXP_HOUR

CC ID: 1007577
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.
Default Value: 0.00

EXP_FISHER

CC ID: 1007578
Seq. Order: 12
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Expanded fishers for the current stratum.
Default Value: 0.00

EXP_FISHER_HOUR

CC ID: 1007579
Seq. Order: 13
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

Expanded fisher-hours for the current stratum.
Default Value: 0.00

EXP_GEAR_HOUR

CC ID: 1007580
Seq. Order: 14
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

Expanded gear-hours for the current stratum.
Default Value: 0.00

CPUE_TRIP

CC ID: 1007581
Seq. Order: 15
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

The average catch-per-trip.
Default Value: 0.00

EXP_CATCH

CC ID: 1007582
Seq. Order: 16
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 2
Status: Active
Description:

Expanded total catch for the current stratum.
Default Value: 0.00

VAR_EST_TRIP

CC ID: 1007583
Seq. Order: 17
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 4
Status: Active
Description:

The variance of the estimated number of trips across sampling days for the current stratum.
Default Value: 0.0000

VAR_EXP_TRIP

CC ID: 1007584
Seq. Order: 18
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

The variance of the expanded number of trips for the current stratum.
Default Value: 0.00

VAR_CPUE_TRIP

CC ID: 1007585
Seq. Order: 19
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 2
Status: Active
Description:

The variance of the catch-per-trip from interviews for the current stratum.
Default Value: 0.00

VAR_EXP_CATCH

CC ID: 1007586
Seq. Order: 20
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 18
Scale: 2
Status: Active
Description:

The variance of the estimated number of expanded catch across sampling days for the current stratum.
Default Value: 0.00

STD_EXP_TRIP

CC ID: 1007587
Seq. Order: 21
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The coefficient of variation of the expanded number of trips for the current stratum.
Default Value: 0.0

STD_CPUE_TRIP

CC ID: 1007588
Seq. Order: 22
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The coefficient of variation of the catch-per-trip from interviews for the current stratum.
Default Value: 0.0

STD_EXP_CATCH

CC ID: 1007589
Seq. Order: 23
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The coefficient of variation of the average number of trips per sampling day for the current stratum.
Default Value: 0.0

NUM_SAMPLE_DAY

CC ID: 1007590
Seq. Order: 24
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of sampled days.
Default Value: 0

P1

CC ID: 1007591
Seq. Order: 25
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 3
Status: Active
Description:

Place holder, not used.
Default Value: 0.000

P2

CC ID: 1007592
Seq. Order: 26
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 4
Status: Active
Description:

Place holder, not used.
Default Value: 0.0000

AD_FISH

CC ID: 1007593
Seq. Order: 27
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 4
Status: Active
Description:

Place holder, not used.
Default Value: 0.0000

AD_SM_TR

CC ID: 1007594
Seq. Order: 28
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 9
Scale: 2
Status: Active
Description:

Place holder, not used.
Default Value: 0.00

AD_SM_TR2

CC ID: 1007595
Seq. Order: 29
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 11
Scale: 2
Status: Active
Description:

Place holder, not used.
Default Value: 0.00

SM_KG

CC ID: 1007596
Seq. Order: 30
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 1
Status: Active
Description:

The number of kgs represented by interviews collected for the current stratum.
Default Value: 0.0

SM_KG2

CC ID: 1007597
Seq. Order: 31
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 1
Status: Active
Description:

The number of kgs represented by interviews collected for the current stratum squared.
Default Value: 0.0

NUM_INT0

CC ID: 1007598
Seq. Order: 32
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The number of interviews counted for this stratum.
Default Value: 0

NUM_INT

CC ID: 1007599
Seq. Order: 33
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The number of interviews counted for this stratum.
Default Value: 0

SM_HOUR

CC ID: 1007600
Seq. Order: 34
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 1
Status: Active
Description:

The number of hours represented by interviews collected for the current stratum.
Default Value: 0.0

SM_HOUR2

CC ID: 1007601
Seq. Order: 35
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

The number of hours represented by interviews collected for the current stratum squared.
Default Value: 0.00

SM_PRSN

CC ID: 1007602
Seq. Order: 36
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The number of persons represented by interviews collected for the current stratum.
Default Value: 0

SM_PR2

CC ID: 1007603
Seq. Order: 37
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

The number of persons represented by interviews collected for the current stratum for the nao-sampled ports.
Default Value: 0

SM_PR_HR

CC ID: 1007604
Seq. Order: 38
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 17
Scale: 1
Status: Active
Description:

The number of person-hours represented by interviews collected for the current stratum.
Default Value: 0.0

SM_PR_HR2

CC ID: 1007605
Seq. Order: 39
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

The number of person-hours represented by interviews collected for the current stratum squared.
Default Value: 0.00

SM_GEAR_HOUR

CC ID: 1007606
Seq. Order: 40
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 17
Scale: 1
Status: Active
Description:

The number of gear hours represented by interviews collected for the current stratum.
Default Value: 0.0

SM_GEAR_HOUR2

CC ID: 1007607
Seq. Order: 41
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

The number of gear hours represented by interviews collected for the current stratum squared.
Default Value: 0.00

EX_FACTOR

CC ID: 1007608
Seq. Order: 42
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 11
Scale: 4
Status: Active
Description:

A ratio of (expanded trips)/(trips from interviews data). This factor is used to create the expanded effort data (e.g. Exp_Gears, Exp_fisher, Exp_fisher_hours, etc…)
Default Value: 0.0000

POOL_FLAG

CC ID: 1007609
Seq. Order: 43
Data Storage Type: varchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Type of pooling was excecuted.

WCT_TR

CC ID: 1007610
Seq. Order: 44
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total trips from WCT data.
Default Value: 0

WCT_TR2

CC ID: 1007611
Seq. Order: 45
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total trips from WCT data, squared.
Default Value: 0

VAR_WCT_TR

CC ID: 1007612
Seq. Order: 46
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

The variance of the number of trips for the current stratum from WCT data.
Default Value: 0.00

CHT_TR91

CC ID: 1007613
Seq. Order: 47
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total trolling charted trips.
Default Value: 0

CHT_TR91_2

CC ID: 1007614
Seq. Order: 48
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total trolling charted trips, squared.
Default Value: 0

V_CHT_TR91

CC ID: 1007615
Seq. Order: 49
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

temporary place holder to calculate the the variance of CHT_TR92.
Default Value: 0.00

CHT_TR92

CC ID: 1007616
Seq. Order: 50
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total bottomfishing charted trips.
Default Value: 0

CHT_TR92_2

CC ID: 1007617
Seq. Order: 51
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total bottomfishing charted trips, squared.
Default Value: 0

V_CHT_TR92

CC ID: 1007618
Seq. Order: 52
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

temporary place holder to calculate the the variance of CHT_TR91.
Default Value: 0.00

LATE_TR_AD

CC ID: 1007619
Seq. Order: 53
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 9
Scale: 5
Status: Active
Description:

Trips that were collected in the PM shift.
Default Value: 0.00000

PC_METH

CC ID: 1007620
Seq. Order: 54
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 9
Scale: 5
Status: Active
Description:

The proportion of all trips that are for the current method, calculated from boat log data.
Default Value: 0.00000

ALL_DAY

CC ID: 1007621
Seq. Order: 55
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total all-day trip from interviews
Default Value: 0

ALL_LATE

CC ID: 1007622
Seq. Order: 56
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Late trips from interviews.
Default Value: 0

TR_DAY

CC ID: 1007623
Seq. Order: 57
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total trips observed duringpm shift.
Default Value: 0

TR_LATE

CC ID: 1007624
Seq. Order: 58
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total trips observed during am shift.
Default Value: 0

CHT_CNT

CC ID: 1007625
Seq. Order: 59
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Chartered trip counts
Default Value: 0

CHT_CNT_AD

CC ID: 1007626
Seq. Order: 60
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Chartered trips added. Aditional chartered trips that was made after returned from the morning trips.
Default Value: 0

ADD_FROM

CC ID: 1007627
Seq. Order: 61
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Place holder, not used.

SYS_CREATE_TIME

CC ID: 1007628
Seq. Order: 62
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date the record was created

SYS_MODIFY_TIME

CC ID: 1007629
Seq. Order: 63
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date the record was last modified

LOAD_TABLE

CC ID: 1007630
Seq. Order: 64
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: 1007631
Seq. Order: 65
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: 1007632
Seq. Order: 66
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: 63460
GUID: gov.noaa.nmfs.inport:63460
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 00:25+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