Item Identification

Title: Database for PIR Marine Turtle Nesting and Basking
Short Name: Nesting and Basking Database
Status: On Going
Abstract:

This Nesting database is used to track nesting and basking observations of Pacific Island Region marine turtles

Purpose:

The Turtle Data Processing System (TDPS) was designed to support marine turtle research at the National Marine Fisheries Service's (NMFS) Marine Turtle Biology and Assessment Program (MTBAP). It provides for the systematic storage, retreival, and summarization of data collected in three source categories, one being data on nesting and basking activity collected by NMFS, U.S. Fish and Wildlife Service (FWS) or other collaborating biologists from turtle nesting beaches. In all categories, most turtles involved are uniquely identified through the application of flipper tags. Thus a key feature of the database is the ability to trace the history of encounters with individual turtles and cross-reference information among data sets. A central turtle ID facilitates this.

Supplemental Information:

Division: Protected Species

Division Director: Charles Littnan

Program: Marine Turtle Biology and Assessment Program

Program Lead: T. Todd Jones

Authorities: Endangered Species Act

Ownership: PIFSC

Temporal Resolution: Date

Frequency of Collection: Daily

Time of Collection: Summer field season in the NWHI or fall in the south Pacific region

Types of Data Collected: Nesting and basking turtles

Collection Method: Collection form

Recording Media: Paper

Validation and QC Procedures: Available

QC Standards: Available

Storage Media: Paper Forms, Hard Disk Drive (HDD), External HDD/Access database

Storage Format: Access

Backups: Available

Update Schedule: Whenever new data are entered

Data Distribution Method: Email

Keywords

Theme Keywords

Thesaurus Keyword
None MTBAP
None nest
None Pacific sea turtles
None PIFSC
None PSD

Temporal Keywords

Thesaurus Keyword
None Date

Spatial Keywords

Thesaurus Keyword
None American Samoa
None Hawaiian Islands
None Northwestern Hawaiian Islands
None Pacific Ocean

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA
Location Description:

1845 Wasp Boulevard

Building 176

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

This Nesting database is used to track nesting and basking observations of Pacific Island Region marine turtles

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
EVENTS_Event_ID Number Unique numeric identifier for this table generated by computer
100
EVENT_TYPE Text The id for a type of turtle or human activity during which data about a turtle are recorded. Different event types are used to describe different types of activities.
100
TURTLEID Text A unique alphanumeric identifier assigned by MTBAP staff to a specific turtle. The TURTLEID remains the same for a turtle throughout its recorded history. The TURTLEID can range in length from 3 characters to (currently) 10 characters. The TURTLEID was previously (but is not always) the first tag number applied to the turtle.
100
MOTOTOOL Text Etched number, letter, and/or symbol engraved into the carapace
100
TAG_NUM Text The unique alpha/numeric characters associated with each tag.
100
EVENT_DATE Date Date the event occurred
100
EVENT_TIME Number The exact time of the event, if known
100
ISLAND Text The id of the island where turtle was encountered
100
Area Text The id of a specific (named) site where historical fieldwork has occurred.
100
Site Text The id of the location within the island where the turtle was encountered (Note: This is NOT a named study site)
100
EVENTS_GPS_WAYPT Number A number assigned by a Global Positioning System unit for a specific location (coordinates) of the event
100
EVENTS_GPS_unit Number The last four digits of the property sticker number of the Global Positioning System unit
100
EVENTS_DATALOGGER Number Serial number of the electronic device that records the temperature of wherever it is placed.
100
EVENTS_LAT_DD Number Global Positioning System latitude coordinate of the event location
100
EVENTS_LONG_DD Number Global Positioning System longitude coordinate of the event location
100
SPECIES_CODE Text Two letter abbreviation of the scientific name of one of seven sea turtle species encountered in the Pacific Island Region
100
SEX Text The abbreviation for the gender of the turtle (M = male, F = female , U = Unknown).
100
SCL_CM Number Straight carapace length measured in centimeters (cm) to the nearest 0.1, taken from the midpoint of the precentral/nuchal notch to longest point on shell (post central), not to the notch, using the metal caliper.
100
SCW_CM Number Straight carapace width measured in centimeters (cm) to the nearest 0.1, taken from the widest part on the shell, usually at the 6th marginals for greens and hawksbills, using the metal caliper.
100
CCL_CM Number Curved carapace length measured in centimeters (cm, or a conversion of 2.54cm x number of inches if not taken in cm) to the nearest 0.5, taken from the midpoint of the precentral/nuchal scute to the longest point (post centrals) not to the notch, following the curvature of the shell using the measuring tape.
100
CCW_CM Number Curved carapace width measured in centimeters (cm, or a conversion of 2.54cm x number of inches if not taken in cm) to the nearest 0.5, taken from the widest part on the shell, usually at the 6th marginals for greens and hawksbills, following the curvature of the shell using the measuring tape.
100
PLASTRON_LEN_CM Number Plastron length measured in centimeters (cm) to the nearest 0.1, taken from the hardest points at the anterior and the posterior of the plastron (hard bottom shell) using the metal caliper.
100
TAIL_LEN_CM Number Tail length measured in centimeters (cm) to the nearest 0.5, taken from posterior rigid tip of the plastron to the distal tip of the tail with the tail extended as straight as possible using the measuring tape.
100
VENT_LEN_CM Number Cloaca length measured in centimeters (cm) to the nearest 0.5, taken from the posterior tip of the plastron to the middle of the cloaca opening using the measuring tape.
100
Mass Number Weight measured in kilograms (kg) to the nearest 0.1 using a digital scale.
100
TUMORS_YNU Text Whether or not tumors are present.
100
TUMRNK Number Number assigned for the subjective overall tumor score based on the severity and location of the tumors (range 0-4, with 0 being no tumors and 4 indicating very severe tumor coverage)
100
EMACIATION_CODE Number Number assigned for the degree to which the turtle's underside (plastron) is concave (range 0-3, with 0 being no emaciation and 3 being extreme emaciation)
100
DESCRIP Text Additional information that can't be entered into an existing field
100
PHOTOS_Taken Yes/No Whether or not photos were taken of this turtle.
100
SAMPLES_Taken Yes/No Whether or not samples were taken from this turtle.
100
RELEASE_DATE Date The data when the turtle was released once captured
100
RELEASE_LOC Text The id of the location/study site where turtle was released after the event
100
NECROPSY Yes/No Whether or not a necropsy was performed on this turtle
100
HOOK Yes/No Whether or not a fish hook is embedded in the turtle. Unknown means that it is not verified whether or not a fishing hook is present.
100
LINE Yes/No Whether or not fishing line is entangling the turtle. Unknown means that it is not verified whether or not fishing line is present.
100
Fishing_Line_Severity Number Number assigned to describe the seriousness of the affect the fishing line has to the turtle (e.g., number of appendages entangled but no amputations = 2, ingestion/amputation = 3)
100
NET Yes/No Whether or not a net is entrapping the turtle. Unknown means that it is not verified whether or not a net or trap (such as a crab or lobster) is present.
100
BOAT_IMPACT Yes/No Whether or not the turtle has been hit by a boat or propeller. Unknown means that it is not verified whether or not an impact by a boat or propeller occurred.
100
SHARK_ATTACK Yes/No Whether or not the turtle has been bitten or attacked by a shark. Unknown means it is not verified that the turtle was attacked by a shark.
100
HUMAN_TAKE Yes/No Whether or not a person or persons intentionally took the turtle for their benefit. (Unknown means that it is not known whether or not the information was collected or that the turtle was not examined to determine whether or not human take was involved.)
100
Capture_Platform Text The process as to where the biologists are capturing/observing the turtle
100
Capture_Method Text The process as to how the biologists are capturing/observing the turtle

Attribute Details

EVENTS_Event_ID

CC ID: 839706
Seq. Order: 1
Data Storage Type: Number
Required: Yes
Primary Key: No
Status: Active
Description:

Unique numeric identifier for this table generated by computer

EVENT_TYPE

CC ID: 839707
Seq. Order: 2
Data Storage Type: Text
Required: Yes
Primary Key: No
Status: Active
Description:

The id for a type of turtle or human activity during which data about a turtle are recorded. Different event types are used to describe different types of activities.

TURTLEID

CC ID: 839708
Seq. Order: 3
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

A unique alphanumeric identifier assigned by MTBAP staff to a specific turtle. The TURTLEID remains the same for a turtle throughout its recorded history. The TURTLEID can range in length from 3 characters to (currently) 10 characters. The TURTLEID was previously (but is not always) the first tag number applied to the turtle.

MOTOTOOL

CC ID: 839709
Seq. Order: 4
Data Storage Type: Text
Required: Yes
Primary Key: No
Status: Active
Description:

Etched number, letter, and/or symbol engraved into the carapace

TAG_NUM

CC ID: 839710
Seq. Order: 5
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The unique alpha/numeric characters associated with each tag.

EVENT_DATE

CC ID: 839711
Seq. Order: 6
Data Storage Type: Date
Required: Yes
Primary Key: No
Status: Active
Description:

Date the event occurred

EVENT_TIME

CC ID: 839712
Seq. Order: 7
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

The exact time of the event, if known

ISLAND

CC ID: 839713
Seq. Order: 8
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The id of the island where turtle was encountered

Area

CC ID: 839714
Seq. Order: 9
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The id of a specific (named) site where historical fieldwork has occurred.

Site

CC ID: 846159
Seq. Order: 10
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The id of the location within the island where the turtle was encountered (Note: This is NOT a named study site)

EVENTS_GPS_WAYPT

CC ID: 846160
Seq. Order: 11
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

A number assigned by a Global Positioning System unit for a specific location (coordinates) of the event

EVENTS_GPS_unit

CC ID: 846184
Seq. Order: 12
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

The last four digits of the property sticker number of the Global Positioning System unit

EVENTS_DATALOGGER

CC ID: 846185
Seq. Order: 13
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Serial number of the electronic device that records the temperature of wherever it is placed.

EVENTS_LAT_DD

CC ID: 846186
Seq. Order: 14
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Global Positioning System latitude coordinate of the event location

EVENTS_LONG_DD

CC ID: 846187
Seq. Order: 15
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Global Positioning System longitude coordinate of the event location

SPECIES_CODE

CC ID: 846188
Seq. Order: 16
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Two letter abbreviation of the scientific name of one of seven sea turtle species encountered in the Pacific Island Region

SEX

CC ID: 846189
Seq. Order: 17
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The abbreviation for the gender of the turtle (M = male, F = female , U = Unknown).

SCL_CM

CC ID: 846190
Seq. Order: 18
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Straight carapace length measured in centimeters (cm) to the nearest 0.1, taken from the midpoint of the precentral/nuchal notch to longest point on shell (post central), not to the notch, using the metal caliper.

SCW_CM

CC ID: 846191
Seq. Order: 19
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Straight carapace width measured in centimeters (cm) to the nearest 0.1, taken from the widest part on the shell, usually at the 6th marginals for greens and hawksbills, using the metal caliper.

CCL_CM

CC ID: 846192
Seq. Order: 20
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Curved carapace length measured in centimeters (cm, or a conversion of 2.54cm x number of inches if not taken in cm) to the nearest 0.5, taken from the midpoint of the precentral/nuchal scute to the longest point (post centrals) not to the notch, following the curvature of the shell using the measuring tape.

CCW_CM

CC ID: 846193
Seq. Order: 21
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Curved carapace width measured in centimeters (cm, or a conversion of 2.54cm x number of inches if not taken in cm) to the nearest 0.5, taken from the widest part on the shell, usually at the 6th marginals for greens and hawksbills, following the curvature of the shell using the measuring tape.

PLASTRON_LEN_CM

CC ID: 846194
Seq. Order: 22
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Plastron length measured in centimeters (cm) to the nearest 0.1, taken from the hardest points at the anterior and the posterior of the plastron (hard bottom shell) using the metal caliper.

TAIL_LEN_CM

CC ID: 846195
Seq. Order: 23
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Tail length measured in centimeters (cm) to the nearest 0.5, taken from posterior rigid tip of the plastron to the distal tip of the tail with the tail extended as straight as possible using the measuring tape.

VENT_LEN_CM

CC ID: 846196
Seq. Order: 24
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Cloaca length measured in centimeters (cm) to the nearest 0.5, taken from the posterior tip of the plastron to the middle of the cloaca opening using the measuring tape.

Mass

CC ID: 846197
Seq. Order: 25
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Weight measured in kilograms (kg) to the nearest 0.1 using a digital scale.

TUMORS_YNU

CC ID: 846198
Seq. Order: 26
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Whether or not tumors are present.

TUMRNK

CC ID: 846199
Seq. Order: 27
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Number assigned for the subjective overall tumor score based on the severity and location of the tumors (range 0-4, with 0 being no tumors and 4 indicating very severe tumor coverage)

EMACIATION_CODE

CC ID: 846200
Seq. Order: 28
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Number assigned for the degree to which the turtle's underside (plastron) is concave (range 0-3, with 0 being no emaciation and 3 being extreme emaciation)

DESCRIP

CC ID: 846201
Seq. Order: 29
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

Additional information that can't be entered into an existing field

PHOTOS_Taken

CC ID: 846202
Seq. Order: 30
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not photos were taken of this turtle.

SAMPLES_Taken

CC ID: 846203
Seq. Order: 31
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not samples were taken from this turtle.

RELEASE_DATE

CC ID: 846204
Seq. Order: 32
Data Storage Type: Date
Required: No
Primary Key: No
Status: Active
Description:

The data when the turtle was released once captured

RELEASE_LOC

CC ID: 846205
Seq. Order: 33
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The id of the location/study site where turtle was released after the event

NECROPSY

CC ID: 846222
Seq. Order: 34
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not a necropsy was performed on this turtle

HOOK

CC ID: 846223
Seq. Order: 35
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not a fish hook is embedded in the turtle. Unknown means that it is not verified whether or not a fishing hook is present.

LINE

CC ID: 846224
Seq. Order: 36
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not fishing line is entangling the turtle. Unknown means that it is not verified whether or not fishing line is present.

Fishing_Line_Severity

CC ID: 846225
Seq. Order: 37
Data Storage Type: Number
Required: No
Primary Key: No
Status: Active
Description:

Number assigned to describe the seriousness of the affect the fishing line has to the turtle (e.g., number of appendages entangled but no amputations = 2, ingestion/amputation = 3)

NET

CC ID: 846226
Seq. Order: 38
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not a net is entrapping the turtle. Unknown means that it is not verified whether or not a net or trap (such as a crab or lobster) is present.

BOAT_IMPACT

CC ID: 846227
Seq. Order: 39
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not the turtle has been hit by a boat or propeller. Unknown means that it is not verified whether or not an impact by a boat or propeller occurred.

SHARK_ATTACK

CC ID: 846228
Seq. Order: 40
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not the turtle has been bitten or attacked by a shark. Unknown means it is not verified that the turtle was attacked by a shark.

HUMAN_TAKE

CC ID: 846229
Seq. Order: 41
Data Storage Type: Yes/No
Required: No
Primary Key: No
Status: Active
Description:

Whether or not a person or persons intentionally took the turtle for their benefit. (Unknown means that it is not known whether or not the information was collected or that the turtle was not examined to determine whether or not human take was involved.)

Capture_Platform

CC ID: 846231
Seq. Order: 42
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The process as to where the biologists are capturing/observing the turtle

Capture_Method

CC ID: 846232
Seq. Order: 43
Data Storage Type: Text
Required: No
Primary Key: No
Status: Active
Description:

The process as to how the biologists are capturing/observing the turtle

Support Roles

Data Steward

CC ID: 839715
Date Effective From: 2006-11-28
Date Effective To:
Contact (Person): Murakawa, Shawn KK
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: shawn.murakawa@noaa.gov
Phone: (808)725-5731
Business Hours: 6:30 a.m. - 3:00 p.m. M - F

Data Steward

CC ID: 839716
Date Effective From: 2006-11-28
Date Effective To: 2014
Contact (Person): Balazs, George H
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: george.balazs@noaa.gov
Phone: (808)725-5733

Distributor

CC ID: 839717
Date Effective From: 2015
Date Effective To:
Contact (Organization): Pacific Islands Fisheries Science Center (PIFSC)
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Phone: 808-725-5300
URL: http://www.pifsc.noaa.gov
Business Hours: 8:00 a.m. - 4:30 p.m.

Metadata Contact

CC ID: 839718
Date Effective From: 2015
Date Effective To:
Contact (Person): Murakawa, Shawn KK
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: shawn.murakawa@noaa.gov
Phone: (808)725-5731
Business Hours: 6:30 a.m. - 3:00 p.m. M - F
Contact Instructions:

Via email Shawn.Murakawa@noaa.gov

Point of Contact

CC ID: 839719
Date Effective From: 2006-11-28
Date Effective To:
Contact (Person): Murakawa, Shawn KK
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
Email Address: shawn.murakawa@noaa.gov
Phone: (808)725-5731
Business Hours: 6:30 a.m. - 3:00 p.m. M - F
Contact Instructions:

Via email

Extents

Extent Group 1

Extent Group 1 / Geographic Area 1

CC ID: 846234
W° Bound: -177.395907
E° Bound: -154.789191
N° Bound: 28.217525
S° Bound: -14.560291
Description

Shorelines of the Hawaiian Archipelago and American Samoa

Extent Group 1 / Time Frame 1

CC ID: 846235
Time Frame Type: Continuing
Start: 1965-08-06

Access Information

Security Class: Unclassified
Data Access Procedure:

Email request to Shawn Murakawa (shawn.murakawa@noaa.gov)

Distribution Information

Distribution 1

CC ID: 846133
Start Date: 2006
End Date: Present
Download URL: https://oceanwatch.pifsc.noaa.gov/xfer/PIFSC_PIRO_bulk_data_download_InPort_5452.tgz
Distributor: Pacific Islands Fisheries Science Center (PIFSC) (2015 - Present)
File Name: PIFSC_PIRO_bulk_data_download_InPort_5452.tgz

Catalog Details

Catalog Item ID: 56272
Metadata Record Created By: Shawn KK Murakawa
Metadata Record Created: 2019-05-10 19:39+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2021-03-18 17:49+0000
Metadata Record Published: 2019-05-31
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-31