Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: obis_seamap_dataset_2036_points.xls
Abstract:

Sightings data for an aerial survey on the continental shelf waters of the US east coast, from New Jersey to the Florida Keys. The survey was conducted between 18 May and 24 June 2019 aboard a NOAA Twin Otter aircraft. Survey tracklines were oriented perpendicular to the shoreline and latitudinally spaced 20 km apart

Entity Information

Entity Type: Data Table
Description:

Aerial Sightings Data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
dataset_id number OBIS_SEAMAP Dataset Id. This is a sequential number assigned by OBIS_SEAMAP to each dataset that it archives
100
row_id text is the concatenation of the dataset_id with the record number of the record in the datat set.
100
LATITUDE number Latitude (decimal degrees)
100
LONGITUDE number Longitude (decimal degrees)
100
species_name text Common name of animal sighted as determined by data collector/provider
100
scientific_name text scientific name of animal sited as determined by data provider/collector
100
common_name text common_name is the name associated with the itis species codes. This was provided by obis_seamap during data ingestion.
100
its_tsn number A Taxonomic Serial Number (TSN) is a unique, persistent, non-intelligent identifier for a scientific name in the context of the Integrated Taxonomic Information System (ITIS). This value was supplied OBIS-SEAMAP as part of the data ingestion process
100
GROUP_SIZE number The number of individuals in the group (minimum used when uncertain)
100
series_id text This is always blank for this dataset
100
date_time date yyyy-mm-dd hh24:MN:SS
100
timezone text Always blank
100
ds_type text Type of data collected (always ptobs)
100
platform Character Platform of Data Collection. (always plane as this is an aerial survey)
100
provider text Provider of the data (always NOAA Southeast Fisheries Science Center (SEFSC) )
100
lprecision text OBIS_SEAMAP generated column having to do with precision on the collected data
100
tprecision text OBIS_SEAMAP generated column having to do with precision on the collected data
100
oceano Character An OBIS_SEAMAP generated column.
100
notes text Any textual notes that may be associated with the record
100
last_mod Date/Time Control Column which indicates data/time stamp of when record was last updated by OBIS-SEAMAP
100
effortid number Link to effort record
100
oid_orig text Initials of the observer who made the sighting
100
type text Type of animal observed.
100
comname number Common Name Of Observed Animal per data collector/provider.
100
individualcount number Code that indicates whether or not photos were taken (1=no, 2=yes)
100
eventdate Date Date/Time of the sighting
100
transect text Transect
100
BEAUFORT number Beaufort sea state. Coded Value.
100
cloudcover number Cloud cover code
100
glare number Glare code for the observer
100
conditions text post flight edit tracking column
100
haze text Code for presence or abscence of haze 0 No 1 Yes
100
fog text Presence or absence of fog during sightings
100
sunpen number Coded Value for amount of sun pernetration. 0 Poor 1 Fair 2 Good 3 Excellent
100
turbidity text Coded value for turbidity 0 Poor 1 Fair 2 Good 3 Excellent
100
tripid text Trip ID
100
platformvlts text One-character string to flag survey platform type for visual line transect surveys. For aerial surveys: All records flagged A. For boat-based surveys: All records flagged B.
100
oneffort text Effort status designating if observers were on effort (i.e. actively scanning for marine mammals) or off effort at the moment of data recording.
100
observationheight number Height of each observationLocation from the water surface.
100
platformspeed number Aircraft speed (knots)
100
sighttype number Sea surface temperature (degrees Celsius)
100
datasetid Character Assigned textual data set id. Always TOSE19WIN
100
datasetname Character Name of the dataset. always Twin Otter Southeast 2019 Winter
100
eventdatetimezone number Number of time zones the sampling was from gmt/standard time

Attribute Details

dataset_id

CC ID: 1223907
Seq. Order: 10
Data Storage Type: number
Required: Yes
Primary Key: No
Status: Active
Description:

OBIS_SEAMAP Dataset Id. This is a sequential number assigned by OBIS_SEAMAP to each dataset that it archives

row_id

CC ID: 1223931
Seq. Order: 20
Data Storage Type: text
Required: Yes
Primary Key: No
Status: Active
Description:

is the concatenation of the dataset_id with the record number of the record in the datat set.

LATITUDE

CC ID: 1223901
Seq. Order: 30
Data Storage Type: number
Required: Yes
Primary Key: No
Status: Active
Description:

Latitude (decimal degrees)

LONGITUDE

CC ID: 1223902
Seq. Order: 40
Data Storage Type: number
Required: Yes
Primary Key: No
Status: Active
Description:

Longitude (decimal degrees)

species_name

CC ID: 1223935
Seq. Order: 60
Data Storage Type: text
Required: Yes
Primary Key: No
Status: Active
Description:

Common name of animal sighted as determined by data collector/provider

scientific_name

CC ID: 1223932
Seq. Order: 70
Data Storage Type: text
Required: Yes
Primary Key: No
Status: Active
Description:

scientific name of animal sited as determined by data provider/collector

common_name

CC ID: 1223904
Seq. Order: 80
Data Storage Type: text
Required: Yes
Primary Key: No
Status: Active
Description:

common_name is the name associated with the itis species codes. This was provided by obis_seamap during data ingestion.

its_tsn

CC ID: 1223919
Seq. Order: 90
Data Storage Type: number
Required: Yes
Primary Key: No
Status: Active
Description:

A Taxonomic Serial Number (TSN) is a unique, persistent, non-intelligent identifier for a scientific name in the context of the Integrated Taxonomic Information System (ITIS). This value was supplied OBIS-SEAMAP as part of the data ingestion process

GROUP_SIZE

CC ID: 1223900
Seq. Order: 100
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

The number of individuals in the group (minimum used when uncertain)

series_id

CC ID: 1223933
Seq. Order: 110
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

This is always blank for this dataset

date_time

CC ID: 1223910
Seq. Order: 120
Data Storage Type: date
Required: Yes
Primary Key: No
Status: Active
Description:

yyyy-mm-dd hh24:MN:SS

Display Example: 2020-01-02 09:49:07

timezone

CC ID: 1223937
Seq. Order: 130
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Always blank

ds_type

CC ID: 1223911
Seq. Order: 140
Data Storage Type: text
Required: Yes
Primary Key: No
Status: Active
Description:

Type of data collected (always ptobs)

platform

CC ID: 1223927
Seq. Order: 150
Data Storage Type: Character
Required: Yes
Primary Key: No
Status: Active
Description:

Platform of Data Collection. (always plane as this is an aerial survey)

provider

CC ID: 1223930
Seq. Order: 160
Data Storage Type: text
Required: Yes
Primary Key: No
Status: Active
Description:

Provider of the data (always NOAA Southeast Fisheries Science Center (SEFSC) )

lprecision

CC ID: 1223921
Seq. Order: 170
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

OBIS_SEAMAP generated column having to do with precision on the collected data

tprecision

CC ID: 1223938
Seq. Order: 180
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

OBIS_SEAMAP generated column having to do with precision on the collected data

oceano

CC ID: 1223924
Seq. Order: 190
Data Storage Type: Character
Required: Yes
Primary Key: No
Status: Active
Description:

An OBIS_SEAMAP generated column.

notes

CC ID: 1223922
Seq. Order: 200
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Any textual notes that may be associated with the record

last_mod

CC ID: 1223920
Seq. Order: 210
Data Storage Type: Date/Time
Required: Yes
Primary Key: No
Status: Active
Description:

Control Column which indicates data/time stamp of when record was last updated by OBIS-SEAMAP

effortid

CC ID: 1223912
Seq. Order: 220
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Link to effort record

oid_orig

CC ID: 1223925
Seq. Order: 230
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Initials of the observer who made the sighting

type

CC ID: 1223942
Seq. Order: 235
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Type of animal observed.

Allowed Values: Mammal Turtle

comname

CC ID: 1223905
Seq. Order: 240
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Common Name Of Observed Animal per data collector/provider.

individualcount

CC ID: 1223918
Seq. Order: 250
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Code that indicates whether or not photos were taken (1=no, 2=yes)

eventdate

CC ID: 1223913
Seq. Order: 260
Data Storage Type: Date
Required: Yes
Primary Key: No
Status: Active
Description:

Date/Time of the sighting

transect

CC ID: 1223939
Seq. Order: 270
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Transect

BEAUFORT

CC ID: 1223899
Seq. Order: 300
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Beaufort sea state. Coded Value.

Allowed Values: 0 Calm, mirror like seas 1 Waves <1ft, rippled surface 2 Small wavelets (<2 ft), no white caps 3 Large wavelets (<3ft), scattered white caps 4 Swell 3-4 ft, numerous white caps 5 Swell >5 ft, many white caps, some spray 6 Swell >10 ft, white caps everywhere, spray

cloudcover

CC ID: 1223903
Seq. Order: 310
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Cloud cover code

Allowed Values: 0 Clear 1 0-25% Cloudy 2 26-50% Cloudy 3 51-75% Cloudy 4 76-100% Cloudy 5 Overcast

glare

CC ID: 1223916
Seq. Order: 320
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Glare code for the observer

Allowed Values: 0 No Impairment 1 Slight Impairment 2 Moderate Impairment 3 Severe

conditions

CC ID: 1223906
Seq. Order: 340
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

post flight edit tracking column

haze

CC ID: 1223917
Seq. Order: 350
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Code for presence or abscence of haze

0 No 1 Yes

Default Value: 0 Clear 1 Mist 2 Light Rain 3 Heavy

fog

CC ID: 1223915
Seq. Order: 380
Data Storage Type: text
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

Presence or absence of fog during sightings

Allowed Values: 0 No 1 Yes

sunpen

CC ID: 1223936
Seq. Order: 390
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Coded Value for amount of sun pernetration.

0 Poor 1 Fair 2 Good 3 Excellent

turbidity

CC ID: 1223941
Seq. Order: 400
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Coded value for turbidity

0 Poor 1 Fair 2 Good 3 Excellent

tripid

CC ID: 1223940
Seq. Order: 410
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Trip ID

platformvlts

CC ID: 1223929
Seq. Order: 640
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

One-character string to flag survey platform type for visual line transect surveys. For aerial surveys: All records flagged A. For boat-based surveys: All records flagged B.

oneffort

CC ID: 1223926
Seq. Order: 650
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Effort status designating if observers were on effort (i.e. actively scanning for marine mammals) or off effort at the moment of data recording.

observationheight

CC ID: 1223923
Seq. Order: 660
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Height of each observationLocation from the water surface.

Unit of Measure: Meters

platformspeed

CC ID: 1223928
Seq. Order: 670
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Aircraft speed (knots)

sighttype

CC ID: 1223934
Seq. Order: 680
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Sea surface temperature (degrees Celsius)

datasetid

CC ID: 1223908
Seq. Order: 690
Data Storage Type: Character
Required: Yes
Primary Key: No
Status: Active
Description:

Assigned textual data set id. Always TOSE19WIN

datasetname

CC ID: 1223909
Seq. Order: 700
Data Storage Type: Character
Required: No
Primary Key: No
Status: Active
Description:

Name of the dataset. always Twin Otter Southeast 2019 Winter

eventdatetimezone

CC ID: 1223914
Seq. Order: 710
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Number of time zones the sampling was from gmt/standard time

Support Roles

Distributor

CC ID: 1223943
Date Effective From: 2020
Date Effective To:
Contact (Organization): OBIS-SEAMAP (OBIS-SEAMAP)
Address: Marine Geospatial Ecology Lab A328 Levine Science Rsch Ctr at Duke
Durham, NC 27708
Email Address: seamap-contact@duke.edu
Phone: 919-613-8021
URL: OBIS-SEAMAP Home Page

Distribution Information

Distribution 1

CC ID: 1223944
Start Date: 2020
End Date: Present
Distributor: OBIS-SEAMAP (OBIS-SEAMAP) (2020 - Present)
File Name: obis_seamap_dataset_2036_points.xls
Description:

This file was found contained in the zip file provided by OBIS_SEAMAP when the data is provided.

File Date/Time: 2021-09-07 18:12:00
File Type (Deprecated): tabular digital data (Microsoft Excel, CSV, or other tabular format)
Distribution Format: CSV - Comma Separated Values (Text)
File Size: 14262K
Review Status: Chked Viruses Inapp Content

Catalog Details

Catalog Item ID: 69447
GUID: gov.noaa.nmfs.inport:69447
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2023-03-20 17:04+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2023-10-17 16:12+0000
Metadata Record Published: 2023-03-20
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-03-08
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-03-08