Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: CRITTERCAM_DATA
Short Name: CRITTERCAMMASTER
Status: Completed
Supplemental Information:

SPREADSHEET: Crittercam data For JUST SEGMENTS with TALUS revised-20230728.xlsx

Entity Information

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

Crittercam data for JUST SEGMENTS with TALUS. This contains the records from the crittercam database that showed loose rock on the seafloor.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ID NUMBER ID of the seal.
100
INTERVAL CHARACTER Interval in minutes of sampling.
100
SECONDS NUMBER Seconds of video recording.
100
CLOCK NUMBER Clock time of recording.
100
DEPTHM NUMBER Depth in meters.
100
RUNTIMEHR CHARACTER Shows the span of hours of the day when sampling occurred.
100
RECORDNO NUMBER ID for the individual sampling record within each deployment on a seal.
100
SWITCH CHARACTER Switch code.
100
DAYNIGHT CHARACTER Daynight code d=day, n=night.
100
LOCATION CHARACTER Location code a=atoll, b=bank.
100
HABITAT CHARACTER Habitat code.
100
ACTIVITY CHARACTER Activity code t or T=transit (travelling), S= stationary.
100
SEARCHNO NUMBER Number of bottom searches the seal made during the seconds recorded.
100
SECINTRANS NUMBER The number of seconds the seal was traveling over the bottom (could include searching behavior).
100
AUDIO CHARACTER Any vocalizations.
100
VISIONPREY NUMBER Sighting of a prey item consumed.
100
COMPETITORS TOTAL NUM NUMBER Competitors total number.
100
CATCH CHARACTER What the fish was that was caught.
100
IGNOBILIS NUMBER Number of Caranx ignobilis.
100
SERIOLA NUMBER Number of Seriola sp. (dumerili).
100
MELANPYGUS NUMBER Number of Caranx melanpygus.
100
TRIAENODON NUMBER Number of Triaenodo obesus.
100
GREYREEF NUMBER Number of Charcharhinus sp.
100
GALAPAGOS NUMBER Number of Charcharhinus galapagensis.
100
APRION NUMBER Number of Aprion virescens.
100
FACE CHARACTER Competitor was moving close into seals face to obtain prey.
100
ESCORT CHARACTER Competitor was following the seal from place to place as it travelled.
100
FEEDING CHARACTER Competitor seen to feed on prey flushed by the seal.
100
KLEPTO CHARACTER Competitor seen to steal or try to steal a prey item the seal has captured.
100
COMMENTS CHARACTER Any observations added, nothing required.
100
TALUS PRESENT CHARACTER Loose rock is present in the segment.
100
NUMBER SEARCHES NUMBER Number of times the seal searches the bottom in the segment.
100
SECS ON BOTTOM NUMBER Number of secs in the video segment spent on the bottom.
100
TOTAL MINS IN TRANSIT NUMBER Total time that the seal was traveling and searching the bottom in the segment.

Attribute Details

ID

CC ID: 1263257
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

ID of the seal.

General Data Type: NUMBER

INTERVAL

CC ID: 1263258
Seq. Order: 2
Data Storage Type: CHARACTER
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Interval in minutes of sampling.

General Data Type: CHARACTER
Unit of Measure: minutes

SECONDS

CC ID: 1263259
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Seconds of video recording.

General Data Type: NUMBER
Unit of Measure: seconds

CLOCK

CC ID: 1263260
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Clock time of recording.

General Data Type: NUMBER

DEPTHM

CC ID: 1263261
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Precision: 3
Scale: 1
Status: Active
Description:

Depth in meters.

General Data Type: NUMBER
Unit of Measure: meters

RUNTIMEHR

CC ID: 1263262
Seq. Order: 6
Data Storage Type: CHARACTER
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Shows the span of hours of the day when sampling occurred.

General Data Type: CHARACTER

RECORDNO

CC ID: 1263263
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

ID for the individual sampling record within each deployment on a seal.

General Data Type: NUMBER

SWITCH

CC ID: 1263264
Seq. Order: 8
Data Storage Type: CHARACTER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Switch code.

General Data Type: CHARACTER
Default Value: d = DAY SWITCH; n = NIGHT SWITCH; w = WET SWITCH

DAYNIGHT

CC ID: 1263265
Seq. Order: 9
Data Storage Type: CHARACTER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Daynight code d=day, n=night.

General Data Type: CHARACTER
Allowed Values: d = D = DAY; n = NIGHT

LOCATION

CC ID: 1263266
Seq. Order: 10
Data Storage Type: CHARACTER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Location code a=atoll, b=bank.

General Data Type: CHARACTER
Allowed Values: a = A = ATOLL; b =BANK

HABITAT

CC ID: 1263267
Seq. Order: 11
Data Storage Type: CHARACTER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Habitat code.

General Data Type: CHARACTER
Allowed Values: er = EVEN WITH LOOSE ROCK; hc = HARD CONFIGURED BOTTOM; he = HARD EVEN BOTTOM; hr = HARDPAN BOTTOM WITH LOOSE ROCK; sr = SAND WITH LOOSE ROCK

ACTIVITY

CC ID: 1263268
Seq. Order: 12
Data Storage Type: CHARACTER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Activity code t or T=transit (travelling), S= stationary.

General Data Type: CHARACTER
Allowed Values: s = STATIONARY; t = T = TRANSIT (TRAVELLING)

SEARCHNO

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

Number of bottom searches the seal made during the seconds recorded.

General Data Type: NUMBER

SECINTRANS

CC ID: 1263270
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

The number of seconds the seal was traveling over the bottom (could include searching behavior).

General Data Type: NUMBER
Unit of Measure: seconds

AUDIO

CC ID: 1263271
Seq. Order: 15
Data Storage Type: CHARACTER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Any vocalizations.

General Data Type: CHARACTER

VISIONPREY

CC ID: 1263272
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sighting of a prey item consumed.

General Data Type: NUMBER

COMPETITORS TOTAL NUM

CC ID: 1263273
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Competitors total number.

General Data Type: NUMBER

CATCH

CC ID: 1263274
Seq. Order: 18
Data Storage Type: CHARACTER
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

What the fish was that was caught.

General Data Type: CHARACTER

IGNOBILIS

CC ID: 1263275
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of Caranx ignobilis.

General Data Type: NUMBER

SERIOLA

CC ID: 1263276
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of Seriola sp. (dumerili).

General Data Type: NUMBER

MELANPYGUS

CC ID: 1263277
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of Caranx melanpygus.

General Data Type: NUMBER

TRIAENODON

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

Number of Triaenodo obesus.

General Data Type: NUMBER

GREYREEF

CC ID: 1263279
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of Charcharhinus sp.

General Data Type: NUMBER

GALAPAGOS

CC ID: 1263280
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of Charcharhinus galapagensis.

General Data Type: NUMBER

APRION

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

Number of Aprion virescens.

General Data Type: NUMBER

FACE

CC ID: 1263282
Seq. Order: 26
Data Storage Type: CHARACTER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Competitor was moving close into seals face to obtain prey.

General Data Type: CHARACTER
Allowed Values: "J, SN = JACK AND SNAPPER; J = JACK; S = SHARK; SJ = JACK AND SHARK; SNJS = SNAPPER, JACK, AND SHARK

ESCORT

CC ID: 1263283
Seq. Order: 27
Data Storage Type: CHARACTER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Competitor was following the seal from place to place as it travelled.

General Data Type: CHARACTER
Allowed Values: J = JACK; JS = JACK AND SHARK; JSN = JACK AND SNAPPER; S = SHARK; SJ = SHARK AND JACK; SN = SNAPPER; SNJS = SNAPPER, JACK AND SHARK; SNS = SNAPPER AND SHARK

FEEDING

CC ID: 1263284
Seq. Order: 28
Data Storage Type: CHARACTER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Competitor seen to feed on prey flushed by the seal.

General Data Type: CHARACTER
Allowed Values: J = JACK

KLEPTO

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

Competitor seen to steal or try to steal a prey item the seal has captured.

General Data Type: CHARACTER
Allowed Values: S = SHARK

COMMENTS

CC ID: 1263286
Seq. Order: 30
Data Storage Type: CHARACTER
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Any observations added, nothing required.

General Data Type: CHARACTER

TALUS PRESENT

CC ID: 1263287
Seq. Order: 31
Data Storage Type: CHARACTER
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Loose rock is present in the segment.

General Data Type: CHARACTER

NUMBER SEARCHES

CC ID: 1263288
Seq. Order: 32
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Number of times the seal searches the bottom in the segment.

General Data Type: NUMBER

SECS ON BOTTOM

CC ID: 1263289
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Number of secs in the video segment spent on the bottom.

General Data Type: NUMBER

TOTAL MINS IN TRANSIT

CC ID: 1263290
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 8
Required: No
Primary Key: No
Precision: 7
Scale: 6
Status: Active
Description:

Total time that the seal was traveling and searching the bottom in the segment.

General Data Type: CHARACTER
Unit of Measure: MINUTES

Catalog Details

Catalog Item ID: 70356
GUID: gov.noaa.nmfs.inport:70356
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2023-07-28 18:35+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2023-09-01 22:24+0000
Metadata Record Published: 2023-09-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year