Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: SEALCOUNTS
Short Name: SEALCOUNTS
Status: Completed
Abstract:

Counts from analyzed photos

Notes:

Loaded by batch 9050, 07-27-2016 13:48

Entity Information

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

Counts from analyzed photos

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key ID NUMBER unique sequence number
100
SURVEYDATE DATE date of survey
100
HAULOUTSITE VARCHAR2 codes in table HAULOUTS
100
IMAGENUM NUMBER frame number of photograph
100
PVNONPUP NUMBER count of non-pup harbor seals
100
PVPUP NUMBER count of harbor seal pups
100
PVINH2O NUMBER count of harbor seals in the water
100
HGNONPUP NUMBER count of non-pup gray seals
100
HGPUP NUMBER count of gray seal pups
100
HGINH2O NUMBER count of gray seals in the water
100
HGMALE NUMBER count of male gray seals
100
HGORPVNONPUP NUMBER count of those seals that could be either harbor or gray seals
100
HGORPVPUP NUMBER count of pups that could be harbor or gray seal pups
100
HGORPVINH2O NUMBER count of seals that could be harbor or gray seals
100
COUNTDATE DATE date of count
100
COUNTERS VARCHAR2 person or people counting seals in the phots
100
REPLICATE VARCHAR2 Replicate count - do not include in sums
100
NOTES VARCHAR2 comment field
100
HI VARCHAR2 Human Interaction
100
HARP NUMBER count of harp seals
100
HOODED NUMBER count of hooded seals
100
UNIDICESEAL NUMBER count of unidentified ice seals (harp/hooded)
100
MAYBESEAL NUMBER count of things that could be a seal (or rock, etc)
100
UE VARCHAR2 User of entry
100
DE DATE Date of entry
100
REMOTE_USER VARCHAR2 Not used
100
FISHLOGIN VARCHAR2 Not used

Attribute Details

ID

CC ID: 333242
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

unique sequence number

General Data Type: NUMBER

SURVEYDATE

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

date of survey

General Data Type: DATE

HAULOUTSITE

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

codes in table HAULOUTS

General Data Type: VARCHAR2

IMAGENUM

CC ID: 333263
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

frame number of photograph

General Data Type: NUMBER

PVNONPUP

CC ID: 333264
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of non-pup harbor seals

General Data Type: NUMBER

PVPUP

CC ID: 333265
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of harbor seal pups

General Data Type: NUMBER

PVINH2O

CC ID: 333266
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of harbor seals in the water

General Data Type: NUMBER

HGNONPUP

CC ID: 333267
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of non-pup gray seals

General Data Type: NUMBER

HGPUP

CC ID: 333268
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of gray seal pups

General Data Type: NUMBER

HGINH2O

CC ID: 333243
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of gray seals in the water

General Data Type: NUMBER

HGMALE

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

count of male gray seals

General Data Type: NUMBER

HGORPVNONPUP

CC ID: 333245
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of those seals that could be either harbor or gray seals

General Data Type: NUMBER

HGORPVPUP

CC ID: 333246
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of pups that could be harbor or gray seal pups

General Data Type: NUMBER

HGORPVINH2O

CC ID: 333247
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of seals that could be harbor or gray seals

General Data Type: NUMBER

COUNTDATE

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

date of count

General Data Type: DATE

COUNTERS

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

person or people counting seals in the phots

General Data Type: VARCHAR2

REPLICATE

CC ID: 333250
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Replicate count - do not include in sums

General Data Type: VARCHAR2

NOTES

CC ID: 333251
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 80
Required: No
Primary Key: No
Status: Active
Description:

comment field

General Data Type: VARCHAR2

HI

CC ID: 333252
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Human Interaction

General Data Type: VARCHAR2

HARP

CC ID: 333254
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of harp seals

General Data Type: NUMBER

HOODED

CC ID: 333255
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of hooded seals

General Data Type: NUMBER

UNIDICESEAL

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

count of unidentified ice seals (harp/hooded)

General Data Type: NUMBER

MAYBESEAL

CC ID: 333257
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

count of things that could be a seal (or rock, etc)

General Data Type: NUMBER

UE

CC ID: 333258
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

User of entry

General Data Type: VARCHAR2

DE

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

Date of entry

General Data Type: DATE

REMOTE_USER

CC ID: 333260
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Not used

General Data Type: VARCHAR2

FISHLOGIN

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

Not used

General Data Type: VARCHAR2

Catalog Details

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