Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Support Roles
Distribution Info
Catalog Details

Summary

Abstract

Data Description at time of turtle tagging

Description

Data Description at time of turtle tagging

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TURTLE_SPECIES_CODE
VARCHAR2
Species of turtle. LK- Kemp's ridley turtle, CM- green turtle, CC- loggerhead turtle, EI- hawksbill turtle
SPECIES_NAME
VARCHAR2
Decoded Species Of Turtle. Added As a convenience to the data user
RECAP
VARCHAR2
Tag number(s) of recaptured turtles. The second tag may have part of its number truncated if there are consecutive QQJ 457-(458) is two consecutive tags QQJ457 anz and QQJ458
TAG1
VARCHAR2
Flipper tag placed on the training edge of a front flipper. Tags used were Inconel no, 681 cattle ear tags. Turtles were double tagged (one on each front flipper) from July 1997 to Oct 2001, and single tagged thereafter.
TAG2
VARCHAR2
Flipper tag placed on the training edge of a front flipper. Tags used were Inconel no, 681 cattle ear tags. Turtles were double tagged (one on each front flipper) from July 1997 to Oct 2001, and single tagged thereafter.
PIT_TAG
VARCHAR2
Passive Integrated Transponder (PIT) tag was placed in the left front flipper of Kemp's ridley turtles.
LOCALITY
VARCHAR2
Location name (eg. Key, Pass, Bay or Cove)
LATITUDE
NUMBER
Latitude in decimal degrees
LONGITUDE
NUMBER
Longitude in decimal degrees
TIDAL_STATE
VARCHAR2
Tidal state (eg. high, low, incoming, falling, slack)
WATER_TEMPERATURE
NUMBER
Water Temperature in Degrees Celsius
WATER_SALINITY
NUMBER
Water Salinity amount
DISSOvED_OXYGEN_AMT
NUMBER
Dissolve Oxygen
WEATHER
VARCHAR2
General weather conditions (eg. cloud cover and wind speed/direction)
GEAR
VARCHAR2
Strike net technique, 20.5cm stretched-mesh nylon strike net from a 6m commercial use boat
TOT_STR_LINE_CARAPACE_LENGTH
NUMBER
Total straight line carapace length (anterior most edge of carapace to posterior margin of supracaudal scute), measured to the nearest 0.1 cm with Vernier calipers
ST_STR_LINE_CARAPACE_LENGTH
NUMBER
Standard straight line carapace length (midline of nuchal scute to posterior margin of supracaudal), measured to the nearest 0.1 cm with Vernier calipers
MIN_STR_LINE_CARAPCE_LENGTH
NUMBER
Minimum straight line carapace length (midline of nuchal scute to the posterior notch of supracaudal), measured to the nearest 0.1 cm with Vernier calipers
MINIMUM_CURVED_CARAPACE_LENGTH
NUMBER
Minimum curved carapace length (midline of nuchal scute to the posterior notch of supracaudal), measured to the nearest 0.1 cm with a felxible fiberglass tape measure
STARIGHT_LINE_CARAPACE_WIDTH
NUMBER
Straight line carapace width at the widest point, measured to the nearest 0.1 cm with Vernier calipers
STRAIGHT_LINE_PLASTRON_LENGTH
NUMBER
Straight line plastron length (midline of plastron), measured to the nearest 0.1 cm with Vernier calipers
STRAIGHT_LINE_HEAD_WIDTH
NUMBER
Straight line head width (the widest point), measured to the nearest 0.1 cm with Vernier calipers
BODY_DEPTH_DORSAL_SPINE
NUMBER
Body depth, measurement taken at the dorsal spine or at the maximum carapace height, measured to the nearest 0.1 cm with Vernier calipers
BODY_DEPTH_POST_DORSAL_SPINE
NUMBER
Body depth, taken posterior to the dorsal spine, measured to the nearest 0.1 cm with Vernier calipers
PLAS_CLOAC
NUMBER
Length measurement from the posterior-most tip of the plastron to the middle of the cloaca, measured to the nearest 0.1 cm with (?) Vernier calipers or tape
PLAS_TIP
NUMBER
Length measurement from the posterior-most tip of the plastron to the tip of the tail, measured to the nearest 0.1 cm with felxible fiberglass tape measure
WGHT_LBS
NUMBER
Measured to the nearest 0.25 pounds with a spring scale
WGHT_KG
NUMBER
Weight in kilograms converted from weight in pounds
REMARKS
VARCHAR2
Indication of Yes or No if notes on the condition of the turtle were recorded if the animal was injured or deformed (tag scars, carapace and flipper wounds, fibropapillomas, ect.) Specific remarks not indicated.
TAGGER1_INITIALS
VARCHAR2
The first of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS. This column originally contained all of the personnel in one field and then the values were parsed into four total columns
TAG_DATE
DATE
Capture or recapture date of turtle.
TAGGER2_INITIALS
VARCHAR2
The second of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS
TAGGER3_INITIALS
VARCHAR2
The thrid of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS
TAGGER4_INITIALS
VARCHAR2
The fourth of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS

Distribution Information

Child Items

No Child Items for this record.

Contact Information

Distributor
National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD)
(301) 713-3277

Item Identification

Title: Table: GULLIVAN_HEADER
Short Name: GULLIVAN_HEADER.csv
Status: Completed
Abstract:

Data Description at time of turtle tagging

Notes:

Data was collected and was provided in .xls format.

It was transformed and documented in Oracle.

The data is now served to the public in .csv format.

Entity Information

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

Data Description at time of turtle tagging

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
TURTLE_SPECIES_CODE VARCHAR2 Species of turtle. LK- Kemp's ridley turtle, CM- green turtle, CC- loggerhead turtle, EI- hawksbill turtle
100
SPECIES_NAME VARCHAR2 Decoded Species Of Turtle. Added As a convenience to the data user
100
RECAP VARCHAR2 Tag number(s) of recaptured turtles. The second tag may have part of its number truncated if there are consecutive QQJ 457-(458) is two consecutive tags QQJ457 anz and QQJ458
100
TAG1 VARCHAR2 Flipper tag placed on the training edge of a front flipper. Tags used were Inconel no, 681 cattle ear tags. Turtles were double tagged (one on each front flipper) from July 1997 to Oct 2001, and single tagged thereafter.
100
TAG2 VARCHAR2 Flipper tag placed on the training edge of a front flipper. Tags used were Inconel no, 681 cattle ear tags. Turtles were double tagged (one on each front flipper) from July 1997 to Oct 2001, and single tagged thereafter.
100
PIT_TAG VARCHAR2 Passive Integrated Transponder (PIT) tag was placed in the left front flipper of Kemp's ridley turtles.
100
LOCALITY VARCHAR2 Location name (eg. Key, Pass, Bay or Cove)
100
LATITUDE NUMBER Latitude in decimal degrees
100
LONGITUDE NUMBER Longitude in decimal degrees
100
TIDAL_STATE VARCHAR2 Tidal state (eg. high, low, incoming, falling, slack)
100
WATER_TEMPERATURE NUMBER Water Temperature in Degrees Celsius
100
WATER_SALINITY NUMBER Water Salinity amount
100
DISSOvED_OXYGEN_AMT NUMBER Dissolve Oxygen
100
WEATHER VARCHAR2 General weather conditions (eg. cloud cover and wind speed/direction)
100
GEAR VARCHAR2 Strike net technique, 20.5cm stretched-mesh nylon strike net from a 6m commercial use boat
100
TOT_STR_LINE_CARAPACE_LENGTH NUMBER Total straight line carapace length (anterior most edge of carapace to posterior margin of supracaudal scute), measured to the nearest 0.1 cm with Vernier calipers
100
ST_STR_LINE_CARAPACE_LENGTH NUMBER Standard straight line carapace length (midline of nuchal scute to posterior margin of supracaudal), measured to the nearest 0.1 cm with Vernier calipers
100
MIN_STR_LINE_CARAPCE_LENGTH NUMBER Minimum straight line carapace length (midline of nuchal scute to the posterior notch of supracaudal), measured to the nearest 0.1 cm with Vernier calipers
100
MINIMUM_CURVED_CARAPACE_LENGTH NUMBER Minimum curved carapace length (midline of nuchal scute to the posterior notch of supracaudal), measured to the nearest 0.1 cm with a felxible fiberglass tape measure
100
STARIGHT_LINE_CARAPACE_WIDTH NUMBER Straight line carapace width at the widest point, measured to the nearest 0.1 cm with Vernier calipers
100
STRAIGHT_LINE_PLASTRON_LENGTH NUMBER Straight line plastron length (midline of plastron), measured to the nearest 0.1 cm with Vernier calipers
100
STRAIGHT_LINE_HEAD_WIDTH NUMBER Straight line head width (the widest point), measured to the nearest 0.1 cm with Vernier calipers
100
BODY_DEPTH_DORSAL_SPINE NUMBER Body depth, measurement taken at the dorsal spine or at the maximum carapace height, measured to the nearest 0.1 cm with Vernier calipers
100
BODY_DEPTH_POST_DORSAL_SPINE NUMBER Body depth, taken posterior to the dorsal spine, measured to the nearest 0.1 cm with Vernier calipers
100
PLAS_CLOAC NUMBER Length measurement from the posterior-most tip of the plastron to the middle of the cloaca, measured to the nearest 0.1 cm with (?) Vernier calipers or tape
100
PLAS_TIP NUMBER Length measurement from the posterior-most tip of the plastron to the tip of the tail, measured to the nearest 0.1 cm with felxible fiberglass tape measure
100
WGHT_LBS NUMBER Measured to the nearest 0.25 pounds with a spring scale
100
WGHT_KG NUMBER Weight in kilograms converted from weight in pounds
100
REMARKS VARCHAR2 Indication of Yes or No if notes on the condition of the turtle were recorded if the animal was injured or deformed (tag scars, carapace and flipper wounds, fibropapillomas, ect.) Specific remarks not indicated.
100
TAGGER1_INITIALS VARCHAR2 The first of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS. This column originally contained all of the personnel in one field and then the values were parsed into four total columns
100
TAG_DATE DATE Capture or recapture date of turtle.
100
TAGGER2_INITIALS VARCHAR2 The second of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS
100
TAGGER3_INITIALS VARCHAR2 The thrid of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS
100
TAGGER4_INITIALS VARCHAR2 The fourth of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS

Attribute Details

TURTLE_SPECIES_CODE

CC ID: 45566
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Species of turtle.

LK- Kemp's ridley turtle,

CM- green turtle,

CC- loggerhead turtle,

EI- hawksbill turtle

General Data Type: VARCHAR2

SPECIES_NAME

CC ID: 350980
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Decoded Species Of Turtle.

Added As a convenience to the data user

RECAP

CC ID: 45567
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Tag number(s) of recaptured turtles.

The second tag may have part of its number truncated if there are consecutive

QQJ 457-(458) is two consecutive tags QQJ457 anz and QQJ458

General Data Type: VARCHAR2
Null Value Meaning:

No recapture

TAG1

CC ID: 45568
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Flipper tag placed on the training edge of a front flipper. Tags used were Inconel no, 681 cattle ear tags. Turtles were double tagged (one on each front flipper) from July 1997 to Oct 2001, and single tagged thereafter.

General Data Type: VARCHAR2

TAG2

CC ID: 45569
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Flipper tag placed on the training edge of a front flipper. Tags used were Inconel no, 681 cattle ear tags. Turtles were double tagged (one on each front flipper) from July 1997 to Oct 2001, and single tagged thereafter.

General Data Type: VARCHAR2

PIT_TAG

CC ID: 45570
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Passive Integrated Transponder (PIT) tag was placed in the left front flipper of Kemp's ridley turtles.

General Data Type: VARCHAR2

LOCALITY

CC ID: 45571
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Location name (eg. Key, Pass, Bay or Cove)

General Data Type: VARCHAR2

LATITUDE

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

Latitude in decimal degrees

General Data Type: NUMBER

LONGITUDE

CC ID: 45573
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 4
Status: Active
Description:

Longitude in decimal degrees

General Data Type: NUMBER

TIDAL_STATE

CC ID: 45574
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Tidal state (eg. high, low, incoming, falling, slack)

General Data Type: VARCHAR2

WATER_TEMPERATURE

CC ID: 45575
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Water Temperature in Degrees Celsius

General Data Type: NUMBER
Unit of Measure: Degrees Celsius

WATER_SALINITY

CC ID: 45576
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Water Salinity amount

General Data Type: NUMBER
Unit of Measure: mg/ml

DISSOvED_OXYGEN_AMT

CC ID: 45577
Seq. Order: 13
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Dissolve Oxygen

General Data Type: NUMBER
Unit of Measure: mg/lit

WEATHER

CC ID: 45578
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 38
Required: No
Primary Key: No
Status: Active
Description:

General weather conditions (eg. cloud cover and wind speed/direction)

General Data Type: VARCHAR2

GEAR

CC ID: 45579
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Strike net technique, 20.5cm stretched-mesh nylon strike net from a 6m commercial use boat

General Data Type: VARCHAR2

TOT_STR_LINE_CARAPACE_LENGTH

CC ID: 45580
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Total straight line carapace length (anterior most edge of carapace to posterior margin of supracaudal scute), measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

ST_STR_LINE_CARAPACE_LENGTH

CC ID: 45581
Seq. Order: 17
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 6
Scale: 1
Status: Active
Description:

Standard straight line carapace length (midline of nuchal scute to posterior margin of supracaudal), measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: cm

MIN_STR_LINE_CARAPCE_LENGTH

CC ID: 45582
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Minimum straight line carapace length (midline of nuchal scute to the posterior notch of supracaudal), measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

MINIMUM_CURVED_CARAPACE_LENGTH

CC ID: 45583
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Minimum curved carapace length (midline of nuchal scute to the posterior notch of supracaudal), measured to the nearest 0.1 cm with a felxible fiberglass tape measure

General Data Type: NUMBER
Unit of Measure: CM

STARIGHT_LINE_CARAPACE_WIDTH

CC ID: 45584
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Straight line carapace width at the widest point, measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

STRAIGHT_LINE_PLASTRON_LENGTH

CC ID: 45585
Seq. Order: 21
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Straight line plastron length (midline of plastron), measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

STRAIGHT_LINE_HEAD_WIDTH

CC ID: 45586
Seq. Order: 22
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Straight line head width (the widest point), measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

BODY_DEPTH_DORSAL_SPINE

CC ID: 45587
Seq. Order: 23
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Body depth, measurement taken at the dorsal spine or at the maximum carapace height, measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

BODY_DEPTH_POST_DORSAL_SPINE

CC ID: 45588
Seq. Order: 24
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Body depth, taken posterior to the dorsal spine, measured to the nearest 0.1 cm with Vernier calipers

General Data Type: NUMBER
Unit of Measure: CM

PLAS_CLOAC

CC ID: 45589
Seq. Order: 25
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Length measurement from the posterior-most tip of the plastron to the middle of the cloaca, measured to the nearest 0.1 cm with (?) Vernier calipers or tape

General Data Type: NUMBER
Unit of Measure: CM

PLAS_TIP

CC ID: 45590
Seq. Order: 26
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Length measurement from the posterior-most tip of the plastron to the tip of the tail, measured to the nearest 0.1 cm with felxible fiberglass tape measure

General Data Type: NUMBER
Unit of Measure: CM

WGHT_LBS

CC ID: 45591
Seq. Order: 27
Data Storage Type: NUMBER
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Measured to the nearest 0.25 pounds with a spring scale

General Data Type: NUMBER
Unit of Measure: Lbs

WGHT_KG

CC ID: 45592
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Weight in kilograms converted from weight in pounds

General Data Type: NUMBER
Unit of Measure: KG
Derivation:

Weight in kilograms converted from weight in pounds. This field is calculated

REMARKS

CC ID: 45593
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indication of Yes or No if notes on the condition of the turtle were recorded if the animal was injured or deformed (tag scars, carapace and flipper wounds, fibropapillomas, ect.) Specific remarks not indicated.

General Data Type: VARCHAR2
Allowed Values: Y = Yes N - No There were a few records where the value was null

TAGGER1_INITIALS

CC ID: 45594
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The first of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS.

This column originally contained all of the personnel in one field and then the values were parsed into four total columns

General Data Type: VARCHAR2
Validation Rules:

The distinct values in this field should be found in gullivan _field_workers

TAG_DATE

CC ID: 45595
Seq. Order: 31
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Capture or recapture date of turtle.

General Data Type: DATE

TAGGER2_INITIALS

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

The second of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS

TAGGER3_INITIALS

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

The thrid of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS

TAGGER4_INITIALS

CC ID: 350979
Seq. Order: 34
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The fourth of the personnel who did the tagging. The lookup of the code may be found in the table GULLIVAN_FIELD_WORKERS

Support Roles

Distributor

CC ID: 1125048
Date Effective From: 2016
Date Effective To:
Contact (Organization): National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD)
Address: NOAA/NESDIS E/OC SSMC3, 4th Floor, 1351 East-West Highway
Silver Spring, MD 20910-3282
Phone: (301) 713-3277

Distribution Information

Distribution 1

CC ID: 1125049
Start Date: 2016
End Date: Present
Download URL: https://www.ncei.noaa.gov/archive/accession/0156706/1.1/data/0-data/Inport_ID_22439/Inport_ID_22439/gullivan_header.csv
Distributor: National Centers for Environmental Information - Silver Spring, Maryland (NCEI-MD) (2016 - Present)
File Name: gullivan_header.csv
File Date/Time: 2016-09-29 14:48:00
File Type (Deprecated): tabular digital data (Microsoft Excel, CSV, or other tabular format)
Distribution Format: CSV - Comma Separated Values (Text)
File Size: 54K

Catalog Details

Catalog Item ID: 11766
GUID: gov.noaa.nmfs.inport:11766
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2012-02-14 13:20+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2023-10-17 16:12+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29