Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Mammal Projects > Marine Mammals Miami > Biscayne Bay Dolphin Photo ID System > Biscayne Bay Dolphin Photo ID System >

Table: SIGHTING

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7818  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data table contining sighting information

Description

Data table contining sighting information

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential key
SURVEY_ID
NUMBER 		Key to survey table
SIGHTING_NUMBER
NUMBER 		Number Of Dolphins Sighted
TRANSECT_NUMBER
NUMBER 		Number Of Record Associated With The Survey Id
START_TIME
VARCHAR2 		Start Time Of SIghting
END_TIME
VARCHAR2 		End Time Of SIghting
BEGIN_LATITUDE
NUMBER 		Begin Latitude Of Sighting
END_LATITUDE
NUMBER 		End Latitude Of Sighting
BEGIN_LONGITUDE
NUMBER 		Begin Longitude Of Sighting
END_LONGITUDE
NUMBER 		End Longitude Of Sighting
WEATHER_CODE
NUMBER 		Code to indicate weather
BEAUFORT_STATE_CODE
NUMBER 		Beaufort State Code
TIDE_CODE
NUMBER 		Code to indicate tide
WATER_DEPTH
NUMBER 		In Fathoms
WATER_TEMPERATURE
NUMBER 		Water Temperature In degrees Farenhite
INITIAL_HEADING_CODE
NUMBER 		Code to indicate initial heading of Boat
BOATS_IN_AREA
NUMBER 		Number Of Boats In Area Of Dolphin
DISTANCE_TO_BOAT
NUMBER 		Distance Of Dolphins To Boat
ADULT_HIGH_ESTIMATE
NUMBER 		High Estimate of the Number Of Adult Dolphins Seen
ADULT_LOW_ESTIMATE
NUMBER 		Low Estimate of the Number Of Adult Dolphins Seen
ADULT_BEST_ESTIMATE
NUMBER 		Best Estimate of the Number Of Adult Dolphins Seen
CALF_HIGH_ESTIMATE
NUMBER 		High Estimate of the Number Of Dolphin Calfs Seen
CALF_LOW_ESTIMATE
NUMBER 		Low Estimate of the Number Of Dolphin Calfs Seen
CALF_BEST_ESTIMATE
NUMBER 		Best Estimate of the Number Of Dolphin Calfs Seen
YOY_HIGH_ESTIMATE
NUMBER 		High Estimate YOY
YOY_LOW_ESTIMATE
NUMBER 		Low Estimate YOY
YOY_BEST_ESTIMATE
NUMBER 		Best Estimate YOY
TOTAL_HIGH_ESTIMATE
NUMBER 		Sum Total High Estimate
TOTAL_LOW_ESTIMATE
NUMBER 		Sum Total Low Estimate
TOTAL_BEST_ESTIMATE
NUMBER 		Sum Total Best Estimate
TOTAL_IDED_FINS
NUMBER 		Total Number Of Indentified Fins
TOTAL_IDED_SLIDES
NUMBER 		Total Number Of Indemtified Slides
TOTAL_UNIDENTIFIED
NUMBER 		Totsl unidentified slides
TOTAL_NON_DESCRIPT_FINS
NUMBER 		Total Of Fins not described
TOTAL_NON_DESCRIPT_SLIDES
NUMBER 		Total Of Slides not described
ADULTS_CAPTURED
NUMBER 		Number Of Adults captured
FISHERY_CODE
NUMBER 		Fishery Code
COMMENTS
VARCHAR2 		Any special comments On This record
CREATED_BY_USER_ID
NUMBER 		Oracle User Code Of Person Who Created This Record
CREATED_DATE
DATE 		Control Column Indicating When This Record Was Created
MODIFIED_BY_USER_ID
NUMBER 		Oracle User Code Of Person Who Last Modified This Record
MODIFIED_DATE
DATE 		Control column indicating Date of last record modification

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

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

Data table contining sighting information
Notes:

Loaded by batch 2223, 08-11-2008 14:27

Entity Information

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

Data table contining sighting information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER Sequential key
100
 SURVEY_ID NUMBER Key to survey table
100
 SIGHTING_NUMBER NUMBER Number Of Dolphins Sighted
100
 TRANSECT_NUMBER NUMBER Number Of Record Associated With The Survey Id
100
 START_TIME VARCHAR2 Start Time Of SIghting
100
 END_TIME VARCHAR2 End Time Of SIghting
100
 BEGIN_LATITUDE NUMBER Begin Latitude Of Sighting
100
 END_LATITUDE NUMBER End Latitude Of Sighting
100
 BEGIN_LONGITUDE NUMBER Begin Longitude Of Sighting
100
 END_LONGITUDE NUMBER End Longitude Of Sighting
100
 WEATHER_CODE NUMBER Code to indicate weather
100
 BEAUFORT_STATE_CODE NUMBER Beaufort State Code
100
 TIDE_CODE NUMBER Code to indicate tide
100
 WATER_DEPTH NUMBER In Fathoms
100
 WATER_TEMPERATURE NUMBER Water Temperature In degrees Farenhite
100
 INITIAL_HEADING_CODE NUMBER Code to indicate initial heading of Boat
100
 BOATS_IN_AREA NUMBER Number Of Boats In Area Of Dolphin
100
 DISTANCE_TO_BOAT NUMBER Distance Of Dolphins To Boat
100
 ADULT_HIGH_ESTIMATE NUMBER High Estimate of the Number Of Adult Dolphins Seen
100
 ADULT_LOW_ESTIMATE NUMBER Low Estimate of the Number Of Adult Dolphins Seen
100
 ADULT_BEST_ESTIMATE NUMBER Best Estimate of the Number Of Adult Dolphins Seen
100
 CALF_HIGH_ESTIMATE NUMBER High Estimate of the Number Of Dolphin Calfs Seen
100
 CALF_LOW_ESTIMATE NUMBER Low Estimate of the Number Of Dolphin Calfs Seen
100
 CALF_BEST_ESTIMATE NUMBER Best Estimate of the Number Of Dolphin Calfs Seen
100
 YOY_HIGH_ESTIMATE NUMBER High Estimate YOY
100
 YOY_LOW_ESTIMATE NUMBER Low Estimate YOY
100
 YOY_BEST_ESTIMATE NUMBER Best Estimate YOY
100
 TOTAL_HIGH_ESTIMATE NUMBER Sum Total High Estimate
100
 TOTAL_LOW_ESTIMATE NUMBER Sum Total Low Estimate
100
 TOTAL_BEST_ESTIMATE NUMBER Sum Total Best Estimate
100
 TOTAL_IDED_FINS NUMBER Total Number Of Indentified Fins
100
 TOTAL_IDED_SLIDES NUMBER Total Number Of Indemtified Slides
100
 TOTAL_UNIDENTIFIED NUMBER Totsl unidentified slides
100
 TOTAL_NON_DESCRIPT_FINS NUMBER Total Of Fins not described
100
 TOTAL_NON_DESCRIPT_SLIDES NUMBER Total Of Slides not described
100
 ADULTS_CAPTURED NUMBER Number Of Adults captured
100
 FISHERY_CODE NUMBER Fishery Code
100
 COMMENTS VARCHAR2 Any special comments On This record
100
 CREATED_BY_USER_ID NUMBER Oracle User Code Of Person Who Created This Record
100
 CREATED_DATE DATE Control Column Indicating When This Record Was Created
100
 MODIFIED_BY_USER_ID NUMBER Oracle User Code Of Person Who Last Modified This Record
100
 MODIFIED_DATE DATE Control column indicating Date of last record modification

Attribute Details

ID

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

Sequential key
General Data Type: NUMBER

SURVEY_ID

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

Key to survey table
General Data Type: NUMBER

SIGHTING_NUMBER

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

Number Of Dolphins Sighted
General Data Type: NUMBER

TRANSECT_NUMBER

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

Number Of Record Associated With The Survey Id
General Data Type: NUMBER

START_TIME

CC ID: 30956
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Start Time Of SIghting
General Data Type: VARCHAR2

END_TIME

CC ID: 30955
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

End Time Of SIghting
General Data Type: VARCHAR2

BEGIN_LATITUDE

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

Begin Latitude Of Sighting
General Data Type: NUMBER

END_LATITUDE

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

End Latitude Of Sighting
General Data Type: NUMBER

BEGIN_LONGITUDE

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

Begin Longitude Of Sighting
General Data Type: NUMBER

END_LONGITUDE

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

End Longitude Of Sighting
General Data Type: NUMBER

WEATHER_CODE

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

Code to indicate weather
General Data Type: NUMBER

BEAUFORT_STATE_CODE

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

Beaufort State Code
General Data Type: NUMBER

TIDE_CODE

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

Code to indicate tide
General Data Type: NUMBER

WATER_DEPTH

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

In Fathoms
General Data Type: NUMBER

WATER_TEMPERATURE

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

Water Temperature In degrees Farenhite
General Data Type: NUMBER

INITIAL_HEADING_CODE

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

Code to indicate initial heading of Boat
General Data Type: NUMBER

BOATS_IN_AREA

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

Number Of Boats In Area Of Dolphin
General Data Type: NUMBER

DISTANCE_TO_BOAT

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

Distance Of Dolphins To Boat
General Data Type: NUMBER

ADULT_HIGH_ESTIMATE

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

High Estimate of the Number Of Adult Dolphins Seen
General Data Type: NUMBER

ADULT_LOW_ESTIMATE

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

Low Estimate of the Number Of Adult Dolphins Seen
General Data Type: NUMBER

ADULT_BEST_ESTIMATE

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

Best Estimate of the Number Of Adult Dolphins Seen
General Data Type: NUMBER

CALF_HIGH_ESTIMATE

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

High Estimate of the Number Of Dolphin Calfs Seen
General Data Type: NUMBER

CALF_LOW_ESTIMATE

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

Low Estimate of the Number Of Dolphin Calfs Seen
General Data Type: NUMBER

CALF_BEST_ESTIMATE

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

Best Estimate of the Number Of Dolphin Calfs Seen
General Data Type: NUMBER

YOY_HIGH_ESTIMATE

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

High Estimate YOY
General Data Type: NUMBER

YOY_LOW_ESTIMATE

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

Low Estimate YOY
General Data Type: NUMBER

YOY_BEST_ESTIMATE

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

Best Estimate YOY
General Data Type: NUMBER

TOTAL_HIGH_ESTIMATE

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

Sum Total High Estimate
General Data Type: NUMBER

TOTAL_LOW_ESTIMATE

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

Sum Total Low Estimate
General Data Type: NUMBER

TOTAL_BEST_ESTIMATE

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

Sum Total Best Estimate
General Data Type: NUMBER

TOTAL_IDED_FINS

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

Total Number Of Indentified Fins
General Data Type: NUMBER

TOTAL_IDED_SLIDES

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

Total Number Of Indemtified Slides
General Data Type: NUMBER

TOTAL_UNIDENTIFIED

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

Totsl unidentified slides
General Data Type: NUMBER

TOTAL_NON_DESCRIPT_FINS

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

Total Of Fins not described
General Data Type: NUMBER

TOTAL_NON_DESCRIPT_SLIDES

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

Total Of Slides not described
General Data Type: NUMBER

ADULTS_CAPTURED

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

Number Of Adults captured
General Data Type: NUMBER

FISHERY_CODE

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

Fishery Code
General Data Type: NUMBER

COMMENTS

CC ID: 30923
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Any special comments On This record
General Data Type: VARCHAR2

CREATED_BY_USER_ID

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

Oracle User Code Of Person Who Created This Record
General Data Type: NUMBER

CREATED_DATE

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

Control Column Indicating When This Record Was Created
General Data Type: DATE

MODIFIED_BY_USER_ID

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

Oracle User Code Of Person Who Last Modified This Record
General Data Type: NUMBER

MODIFIED_DATE

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

Control column indicating Date of last record modification
General Data Type: DATE

Catalog Details

Catalog Item ID: 7818
GUID: gov.noaa.nmfs.inport:7818
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-08-11 14:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29