Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > Atlantic Marine Assessment Program for Protecte... > AMAPPS Southeast Aerial Cruise Winter 2011 at O... >

obis_seamap_dataset_1277_points.xls

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:69393  |  Updated: October 17, 2023  |  Published / External 

Item Identification

Title: obis_seamap_dataset_1277_points.xls
Abstract:

Sightings data for an aerial survey on the continental shelf waters of the US east coast, from New Jersey to Florida. The survey was conducted during 2011 between 7 February and 13 March.

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: 1222271
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: 1222295
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: 1222265
Seq. Order: 30
Data Storage Type: number
Required: Yes
Primary Key: No
Status: Active
Description:

Latitude (decimal degrees)

LONGITUDE

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

Longitude (decimal degrees)

species_name

CC ID: 1222299
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: 1222296
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: 1222268
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: 1222283
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: 1222264
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: 1222297
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: 1222274
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: 1222301
Seq. Order: 130
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Always blank

ds_type

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

Type of data collected (always ptobs)

platform

CC ID: 1222291
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: 1222294
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: 1222285
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: 1222302
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: 1222288
Seq. Order: 190
Data Storage Type: Character
Required: Yes
Primary Key: No
Status: Active
Description:

An OBIS_SEAMAP generated column.

notes

CC ID: 1222286
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: 1222284
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: 1222276
Seq. Order: 220
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Link to effort record

oid_orig

CC ID: 1222289
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: 1222306
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: 1222269
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: 1222282
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: 1222277
Seq. Order: 260
Data Storage Type: Date
Required: Yes
Primary Key: No
Status: Active
Description:

Date/Time of the sighting

transect

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

Transect

BEAUFORT

CC ID: 1222263
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: 1222267
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: 1222280
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: 1222270
Seq. Order: 340
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

post flight edit tracking column

haze

CC ID: 1222281
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: 1222279
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: 1222300
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: 1222305
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: 1222304
Seq. Order: 410
Data Storage Type: text
Required: No
Primary Key: No
Status: Active
Description:

Trip ID

platformvlts

CC ID: 1222293
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: 1222290
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: 1222287
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: 1222292
Seq. Order: 670
Data Storage Type: number
Required: No
Primary Key: No
Status: Active
Description:

Aircraft speed (knots)

sighttype

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

Sea surface temperature (degrees Celsius)

datasetid

CC ID: 1222272
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: 1222273
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: 1222278
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: 1222307
Date Effective From: 2015
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: 1222308
Start Date: 2015
End Date: Present
Distributor: OBIS-SEAMAP (OBIS-SEAMAP) (2015 - Present)
File Name: obis_seamap_dataset_1277_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 19:05:00
File Type (Deprecated): tabular digital data (Microsoft Excel, CSV, or other tabular format)
Distribution Format: CSV - Comma Separated Values (Text)
File Size: 153K
Review Status: Chked Viruses Inapp Content

Catalog Details

Catalog Item ID: 69393
GUID: gov.noaa.nmfs.inport:69393
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2023-03-02 16:30+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2023-10-17 16:12+0000
Metadata Record Published: 2023-03-02
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