Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Sightings Data
Short Name: Sightings Data
Abstract:

Sightings Data from Visual Sightings Surveys

Entity Information

Entity Type: Data File
Description:

Sightings Data from Visual Sightings Surveys

Data Attributes

Note: Metadata requirements do not apply to attributes for non-tabular entities.

Attribute Summary

Rubric Score Primary Key? Name Type Description
N/A
tripid varchar Trip ID
N/A
platformvlts varchar Always B (Shipboard)
N/A
oneffort varchar Flag (Y/N) to indicate on effort.
N/A
speciescode varchar Species code by provider
N/A
comname varchar Common name
N/A
kingdom varchar Kingdom
N/A
phylum varchar Phylum
N/A
class varchar Class
N/A
order_sci varchar Order
N/A
family varchar Family
N/A
scientificname varchar Scientific name
N/A
references_ varchar References
N/A
observationheight number Altitude of aircraft in feet above sea level
N/A
platformspeed number Speed of the platform at the time of the sighting in knots
N/A
higherinstitutioncode varchar Higher institution code "DOC:NOAA:NEFSC"
N/A
institutioncode varchar Institution code "NEFSC"
N/A
ownerinstitutioncode varchar Institution who owns the data "NEFSC"
N/A
basisofrecord varchar Basis of record "HumanObservation"
N/A
recordtype varchar Record type "VLTS" (visual line transect survey)
N/A
sightid number Sight ID
N/A
individualcount number Individual count
N/A
latitude number Latitude in decimal degrees
N/A
typevlts varchar Always "F"
N/A
longitude number Longitude in decimal degrees
N/A
datasetid varchar Dataset ID
N/A
datasetname varchar Dataset name
N/A
eventdate datetime Date and time of the sigthing at local time
N/A
eventdatetimezone number The time zone of the observation event
N/A
time datetime Date and time of the sighting in UTC
N/A
effortid number Effort ID
N/A
cue varchar The sighting cue that initially drew the observers attention
N/A
behavior varchar Behavior

Attribute Details

tripid

CC ID: 736061
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Trip ID

platformvlts

CC ID: 736062
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Always B (Shipboard)

oneffort

CC ID: 736063
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Flag (Y/N) to indicate on effort.

speciescode

CC ID: 736064
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Species code by provider

comname

CC ID: 736065
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Common name

kingdom

CC ID: 736066
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Kingdom

phylum

CC ID: 736067
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Phylum

class

CC ID: 736068
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Class

order_sci

CC ID: 736069
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Order

family

CC ID: 736070
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Family

scientificname

CC ID: 736071
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Scientific name

references_

CC ID: 736072
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

References

observationheight

CC ID: 736073
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Altitude of aircraft in feet above sea level

platformspeed

CC ID: 736074
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Speed of the platform at the time of the sighting in knots

higherinstitutioncode

CC ID: 736075
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Higher institution code "DOC:NOAA:NEFSC"

institutioncode

CC ID: 736076
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Institution code "NEFSC"

ownerinstitutioncode

CC ID: 736077
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Institution who owns the data "NEFSC"

basisofrecord

CC ID: 736078
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Basis of record "HumanObservation"

recordtype

CC ID: 736079
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Record type "VLTS" (visual line transect survey)

sightid

CC ID: 736080
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Sight ID

individualcount

CC ID: 736081
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Individual count

latitude

CC ID: 736082
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees

typevlts

CC ID: 736083
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Always "F"

longitude

CC ID: 736084
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees

datasetid

CC ID: 736085
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Dataset ID

datasetname

CC ID: 736086
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Dataset name

eventdate

CC ID: 736087
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date and time of the sigthing at local time

eventdatetimezone

CC ID: 736088
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

The time zone of the observation event

time

CC ID: 736089
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date and time of the sighting in UTC

effortid

CC ID: 736090
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Effort ID

cue

CC ID: 736091
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

The sighting cue that initially drew the observers attention

behavior

CC ID: 736092
Data Storage Type: varchar
Required: No
Primary Key: No
Status: Active
Description:

Behavior

Catalog Details

Catalog Item ID: 51813
GUID: gov.noaa.nmfs.inport:51813
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2018-02-28 17:16+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-03-01
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-03-01
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-03-01