Table: SEALCOUNTS
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33541 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
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 |