Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBBTU

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33287 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Sea Turtle Biological Samples from standard observer trips

Description

Observer Sea Turtle Biological Samples from standard observer trips

Entity Type
Data View

Data Attribute / Type	Description
LINK1 VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
PSID VARCHAR2	Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.
LINK6 VARCHAR2	Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID.
PROGRAM VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
NESPP4 VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
SCANNED VARCHAR2	Indicator of whether all four flippers, head and shoulder areas were scanned for presence of PIT tags. 0 = no 1 = yes. Not part of protocol before 2002 (set to 0 = no)
PITTAG VARCHAR2	Complete alphnumeric number for PIT tag.
NOTTIPLEN NUMBER	Curvilinear length of the carapace from the nuchal notch to posterior marginal tip, to nearest 10th of centimeter.
NOTNOTLEN NUMBER	Curvilinear length of the carapace from the nuchal notch to posterior marginal notch, to nearest 10th of centimeter. Not recorded prior to 2001(set to null = unknown)
WIDCAR NUMBER	Curvilinear width of the carapace across widest part of shell, in centimeters.
VSCUTE NUMBER	Number of vertical scutes (plates that run down middle of carapace). Not collected prior to 1994(set to null = unknown)
LSCUTE NUMBER	Number of lateral scutes. Not collected prior to 1994 (set to null = unknown)
ISCUTE NUMBER	Number of inframarginal scutes. Not collected prior to 1994 (set to null = unknown)
PAIRPF VARCHAR2	Indicator of whether the turtle has one pair of prefrontal scales.0=no, 1=yes, 9 = unknown. Not collected prior to 1994; set to 9 = unknown
OLAP VARCHAR2	Indicator of whether turtle has overlapping scutes on carapace. 0 = no, 1 = yes , 9 = unknown.
TURCOLOR VARCHAR2	Code for dorsal coloration of sea turtle. 00 = unknown 01 = black 02 = gray / green 03 = orange, red/brown 04 = brown 99 = other. Not recorded prior to 2001; set to 00 unknown.
WHOLE VARCHAR2	Indicator of whether animal is retained by observer to be brought to shore. 0 = no, 1 = yes. Not recorded prior to 1994 (set to 0 = false)
SKIN NUMBER	Number of skin biopsies taken. Not collected prior to 2001.
OTHSAMP NUMBER	Number of other samples collected of types not accounted for in other categories.
BTUCOMMENTS VARCHAR2	Comments on turtle bio sampling. Prior to 2001 only true (1), false (0)

Data Attribute / Type

Description

LINK1
VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

PSID
VARCHAR2

Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.

LINK6
VARCHAR2

Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID.

PROGRAM
VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

YEAR
VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

MONTH
VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

TRIPID
VARCHAR2

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.

NESPP4
VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

SCANNED
VARCHAR2

Indicator of whether all four flippers, head and shoulder areas were scanned for presence of PIT tags. 0 = no 1 = yes. Not part of protocol before 2002 (set to 0 = no)

PITTAG
VARCHAR2

Complete alphnumeric number for PIT tag.

NOTTIPLEN
NUMBER

Curvilinear length of the carapace from the nuchal notch to posterior marginal tip, to nearest 10th of centimeter.

NOTNOTLEN
NUMBER

Curvilinear length of the carapace from the nuchal notch to posterior marginal notch, to nearest 10th of centimeter. Not recorded prior to 2001(set to null = unknown)

WIDCAR
NUMBER

Curvilinear width of the carapace across widest part of shell, in centimeters.

VSCUTE
NUMBER

Number of vertical scutes (plates that run down middle of carapace). Not collected prior to 1994(set to null = unknown)

LSCUTE
NUMBER

Number of lateral scutes. Not collected prior to 1994 (set to null = unknown)

ISCUTE
NUMBER

Number of inframarginal scutes. Not collected prior to 1994 (set to null = unknown)

PAIRPF
VARCHAR2

Indicator of whether the turtle has one pair of prefrontal scales.0=no, 1=yes, 9 = unknown. Not collected prior to 1994; set to 9 = unknown

OLAP
VARCHAR2

Indicator of whether turtle has overlapping scutes on carapace. 0 = no, 1 = yes , 9 = unknown.

TURCOLOR
VARCHAR2

Code for dorsal coloration of sea turtle. 00 = unknown 01 = black 02 = gray / green 03 = orange, red/brown 04 = brown 99 = other. Not recorded prior to 2001; set to 00 unknown.

WHOLE
VARCHAR2

Indicator of whether animal is retained by observer to be brought to shore. 0 = no, 1 = yes. Not recorded prior to 1994 (set to 0 = false)

SKIN
NUMBER

Number of skin biopsies taken. Not collected prior to 2001.

OTHSAMP
NUMBER

Number of other samples collected of types not accounted for in other categories.

BTUCOMMENTS
VARCHAR2

Comments on turtle bio sampling. Prior to 2001 only true (1), false (0)

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OBBTU
Short Name:	OBBTU
Status:	Completed
Abstract:	Observer Sea Turtle Biological Samples from standard observer trips
Notes:	Loaded by batch 8949, 07-06-2016 08:23

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Sea Turtle Biological Samples from standard observer trips

Attribute Summary

	Name	Type	Description
100	LINK1	VARCHAR2	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100	PSID	VARCHAR2	Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.
100	LINK6	VARCHAR2	Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID.
100	PROGRAM	VARCHAR2	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100	YEAR	VARCHAR2	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100	MONTH	VARCHAR2	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100	TRIPID	VARCHAR2	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100	NESPP4	VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100	SCANNED	VARCHAR2	Indicator of whether all four flippers, head and shoulder areas were scanned for presence of PIT tags. 0 = no 1 = yes. Not part of protocol before 2002 (set to 0 = no)
100	PITTAG	VARCHAR2	Complete alphnumeric number for PIT tag.
100	NOTTIPLEN	NUMBER	Curvilinear length of the carapace from the nuchal notch to posterior marginal tip, to nearest 10th of centimeter.
100	NOTNOTLEN	NUMBER	Curvilinear length of the carapace from the nuchal notch to posterior marginal notch, to nearest 10th of centimeter. Not recorded prior to 2001(set to null = unknown)
100	WIDCAR	NUMBER	Curvilinear width of the carapace across widest part of shell, in centimeters.
100	VSCUTE	NUMBER	Number of vertical scutes (plates that run down middle of carapace). Not collected prior to 1994(set to null = unknown)
100	LSCUTE	NUMBER	Number of lateral scutes. Not collected prior to 1994 (set to null = unknown)
100	ISCUTE	NUMBER	Number of inframarginal scutes. Not collected prior to 1994 (set to null = unknown)
100	PAIRPF	VARCHAR2	Indicator of whether the turtle has one pair of prefrontal scales.0=no, 1=yes, 9 = unknown. Not collected prior to 1994; set to 9 = unknown
100	OLAP	VARCHAR2	Indicator of whether turtle has overlapping scutes on carapace. 0 = no, 1 = yes , 9 = unknown.
100	TURCOLOR	VARCHAR2	Code for dorsal coloration of sea turtle. 00 = unknown 01 = black 02 = gray / green 03 = orange, red/brown 04 = brown 99 = other. Not recorded prior to 2001; set to 00 unknown.
100	WHOLE	VARCHAR2	Indicator of whether animal is retained by observer to be brought to shore. 0 = no, 1 = yes. Not recorded prior to 1994 (set to 0 = false)
100	SKIN	NUMBER	Number of skin biopsies taken. Not collected prior to 2001.
100	OTHSAMP	NUMBER	Number of other samples collected of types not accounted for in other categories.
100	BTUCOMMENTS	VARCHAR2	Comments on turtle bio sampling. Prior to 2001 only true (1), false (0)

Name

Type

Description

100

LINK1

VARCHAR2

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.

100

PSID

VARCHAR2

Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.

100

LINK6

VARCHAR2

Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID.

100

PROGRAM

VARCHAR2

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.

100

YEAR

VARCHAR2

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.

100

MONTH

VARCHAR2

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.

100

TRIPID

VARCHAR2

100

NESPP4

VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

100

SCANNED

VARCHAR2

Indicator of whether all four flippers, head and shoulder areas were scanned for presence of PIT tags. 0 = no 1 = yes. Not part of protocol before 2002 (set to 0 = no)

100

PITTAG

VARCHAR2

Complete alphnumeric number for PIT tag.

100

NOTTIPLEN

NUMBER

Curvilinear length of the carapace from the nuchal notch to posterior marginal tip, to nearest 10th of centimeter.

100

NOTNOTLEN

NUMBER

Curvilinear length of the carapace from the nuchal notch to posterior marginal notch, to nearest 10th of centimeter. Not recorded prior to 2001(set to null = unknown)

100

WIDCAR

NUMBER

Curvilinear width of the carapace across widest part of shell, in centimeters.

100

VSCUTE

NUMBER

Number of vertical scutes (plates that run down middle of carapace). Not collected prior to 1994(set to null = unknown)

100

LSCUTE

NUMBER

Number of lateral scutes. Not collected prior to 1994 (set to null = unknown)

100

ISCUTE

NUMBER

Number of inframarginal scutes. Not collected prior to 1994 (set to null = unknown)

100

PAIRPF

VARCHAR2

Indicator of whether the turtle has one pair of prefrontal scales.0=no, 1=yes, 9 = unknown. Not collected prior to 1994; set to 9 = unknown

100

OLAP

VARCHAR2

Indicator of whether turtle has overlapping scutes on carapace. 0 = no, 1 = yes , 9 = unknown.

100

TURCOLOR

VARCHAR2

Code for dorsal coloration of sea turtle. 00 = unknown 01 = black 02 = gray / green 03 = orange, red/brown 04 = brown 99 = other. Not recorded prior to 2001; set to 00 unknown.

100

WHOLE

VARCHAR2

Indicator of whether animal is retained by observer to be brought to shore. 0 = no, 1 = yes. Not recorded prior to 1994 (set to 0 = false)

100

SKIN

NUMBER

Number of skin biopsies taken. Not collected prior to 2001.

100

OTHSAMP

NUMBER

Number of other samples collected of types not accounted for in other categories.

100

BTUCOMMENTS

VARCHAR2

Comments on turtle bio sampling. Prior to 2001 only true (1), false (0)

Attribute Details

LINK1

CC ID: 329492

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

PSID

CC ID: 329503

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Consecutive identification number assigned each animal incidentally taken on board. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK6

CC ID: 329508

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	Key field linking marine mammal and turtle biological sample tables (OBBMM, OBBTU) to the incidental take (OBINC) Collected for ASM where applicable.; link6 is made up of: link1 + PSID.
General Data Type:	VARCHAR2

PROGRAM

CC ID: 329509

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

YEAR

CC ID: 329510

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type:	VARCHAR2

MONTH

CC ID: 329511

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TRIPID

CC ID: 329512

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type:	VARCHAR2

NESPP4

CC ID: 329513

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

SCANNED

CC ID: 329514

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether all four flippers, head and shoulder areas were scanned for presence of PIT tags. 0 = no 1 = yes. Not part of protocol before 2002 (set to 0 = no)
General Data Type:	VARCHAR2

PITTAG

CC ID: 329493

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Complete alphnumeric number for PIT tag.
General Data Type:	VARCHAR2

NOTTIPLEN

CC ID: 329494

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Curvilinear length of the carapace from the nuchal notch to posterior marginal tip, to nearest 10th of centimeter.
General Data Type:	NUMBER

NOTNOTLEN

CC ID: 329495

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Curvilinear length of the carapace from the nuchal notch to posterior marginal notch, to nearest 10th of centimeter. Not recorded prior to 2001(set to null = unknown)
General Data Type:	NUMBER

WIDCAR

CC ID: 329496

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	1
Status:	Active
Description:	Curvilinear width of the carapace across widest part of shell, in centimeters.
General Data Type:	NUMBER

VSCUTE

CC ID: 329497

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of vertical scutes (plates that run down middle of carapace). Not collected prior to 1994(set to null = unknown)
General Data Type:	NUMBER

LSCUTE

CC ID: 329498

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of lateral scutes. Not collected prior to 1994 (set to null = unknown)
General Data Type:	NUMBER

ISCUTE

CC ID: 329499

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of inframarginal scutes. Not collected prior to 1994 (set to null = unknown)
General Data Type:	NUMBER

PAIRPF

CC ID: 329500

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether the turtle has one pair of prefrontal scales.0=no, 1=yes, 9 = unknown. Not collected prior to 1994; set to 9 = unknown
General Data Type:	VARCHAR2

OLAP

CC ID: 329501

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether turtle has overlapping scutes on carapace. 0 = no, 1 = yes , 9 = unknown.
General Data Type:	VARCHAR2

TURCOLOR

CC ID: 329502

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for dorsal coloration of sea turtle. 00 = unknown 01 = black 02 = gray / green 03 = orange, red/brown 04 = brown 99 = other. Not recorded prior to 2001; set to 00 unknown.
General Data Type:	VARCHAR2

WHOLE

CC ID: 329504

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether animal is retained by observer to be brought to shore. 0 = no, 1 = yes. Not recorded prior to 1994 (set to 0 = false)
General Data Type:	VARCHAR2

SKIN

CC ID: 329505

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Number of skin biopsies taken. Not collected prior to 2001.
General Data Type:	NUMBER

OTHSAMP

CC ID: 329506

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Number of other samples collected of types not accounted for in other categories.
General Data Type:	NUMBER

BTUCOMMENTS

CC ID: 329507

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	1000
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments on turtle bio sampling. Prior to 2001 only true (1), false (0)
General Data Type:	VARCHAR2

Catalog Item ID:	33287
GUID:	gov.noaa.nmfs.inport:33287
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 08:23+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-28
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-28

View: OBBTU

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK1

PSID

LINK6

PROGRAM

YEAR

MONTH

TRIPID

NESPP4

SCANNED

PITTAG

NOTTIPLEN

NOTNOTLEN

WIDCAR

VSCUTE

LSCUTE

ISCUTE

PAIRPF

OLAP

TURCOLOR

WHOLE

SKIN

OTHSAMP

BTUCOMMENTS

Catalog Details