7818
Table: SIGHTING
SIGHTING
Entity
Published / External
7802
Biscayne Bay Dolphin Photo ID System
Data Set
Completed
Data table contining sighting information
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data table contining sighting information
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential key
NUMBER
2
SURVEY_ID
NUMBER
22
Yes
No
38
Active
Key to survey table
NUMBER
3
SIGHTING_NUMBER
NUMBER
22
Yes
No
38
Active
Number Of Dolphins Sighted
NUMBER
4
TRANSECT_NUMBER
NUMBER
22
Yes
No
38
Active
Number Of Record Associated With The Survey Id
NUMBER
5
START_TIME
VARCHAR2
4
No
No
Active
Start Time Of SIghting
VARCHAR2
6
END_TIME
VARCHAR2
4
No
No
Active
End Time Of SIghting
VARCHAR2
7
BEGIN_LATITUDE
NUMBER
22
No
No
38
Active
Begin Latitude Of Sighting
NUMBER
8
END_LATITUDE
NUMBER
22
No
No
38
Active
End Latitude Of Sighting
NUMBER
9
BEGIN_LONGITUDE
NUMBER
22
No
No
38
Active
Begin Longitude Of Sighting
NUMBER
10
END_LONGITUDE
NUMBER
22
No
No
38
Active
End Longitude Of Sighting
NUMBER
11
WEATHER_CODE
NUMBER
22
No
No
38
Active
Code to indicate weather
NUMBER
12
BEAUFORT_STATE_CODE
NUMBER
22
No
No
38
Active
Beaufort State Code
NUMBER
13
TIDE_CODE
NUMBER
22
No
No
38
Active
Code to indicate tide
NUMBER
14
WATER_DEPTH
NUMBER
22
No
No
38
Active
In Fathoms
NUMBER
15
WATER_TEMPERATURE
NUMBER
22
No
No
38
Active
Water Temperature In degrees Farenhite
NUMBER
16
INITIAL_HEADING_CODE
NUMBER
22
No
No
38
Active
Code to indicate initial heading of Boat
NUMBER
17
BOATS_IN_AREA
NUMBER
22
No
No
38
Active
Number Of Boats In Area Of Dolphin
NUMBER
18
DISTANCE_TO_BOAT
NUMBER
22
No
No
38
Active
Distance Of Dolphins To Boat
NUMBER
19
ADULT_HIGH_ESTIMATE
NUMBER
22
No
No
38
Active
High Estimate of the Number Of Adult Dolphins Seen
NUMBER
20
ADULT_LOW_ESTIMATE
NUMBER
22
No
No
38
Active
Low Estimate of the Number Of Adult Dolphins Seen
NUMBER
21
ADULT_BEST_ESTIMATE
NUMBER
22
No
No
38
Active
Best Estimate of the Number Of Adult Dolphins Seen
NUMBER
22
CALF_HIGH_ESTIMATE
NUMBER
22
No
No
38
Active
High Estimate of the Number Of Dolphin Calfs Seen
NUMBER
23
CALF_LOW_ESTIMATE
NUMBER
22
No
No
38
Active
Low Estimate of the Number Of Dolphin Calfs Seen
NUMBER
24
CALF_BEST_ESTIMATE
NUMBER
22
No
No
38
Active
Best Estimate of the Number Of Dolphin Calfs Seen
NUMBER
25
YOY_HIGH_ESTIMATE
NUMBER
22
No
No
38
Active
High Estimate YOY
NUMBER
26
YOY_LOW_ESTIMATE
NUMBER
22
No
No
38
Active
Low Estimate YOY
NUMBER
27
YOY_BEST_ESTIMATE
NUMBER
22
No
No
38
Active
Best Estimate YOY
NUMBER
28
TOTAL_HIGH_ESTIMATE
NUMBER
22
No
No
38
Active
Sum Total High Estimate
NUMBER
29
TOTAL_LOW_ESTIMATE
NUMBER
22
No
No
38
Active
Sum Total Low Estimate
NUMBER
30
TOTAL_BEST_ESTIMATE
NUMBER
22
No
No
38
Active
Sum Total Best Estimate
NUMBER
31
TOTAL_IDED_FINS
NUMBER
22
No
No
38
Active
Total Number Of Indentified Fins
NUMBER
32
TOTAL_IDED_SLIDES
NUMBER
22
No
No
38
Active
Total Number Of Indemtified Slides
NUMBER
33
TOTAL_UNIDENTIFIED
NUMBER
22
No
No
38
Active
Totsl unidentified slides
NUMBER
34
TOTAL_NON_DESCRIPT_FINS
NUMBER
22
No
No
38
Active
Total Of Fins not described
NUMBER
35
TOTAL_NON_DESCRIPT_SLIDES
NUMBER
22
No
No
38
Active
Total Of Slides not described
NUMBER
36
ADULTS_CAPTURED
NUMBER
22
No
No
38
Active
Number Of Adults captured
NUMBER
37
FISHERY_CODE
NUMBER
22
No
No
38
Active
Fishery Code
NUMBER
38
COMMENTS
VARCHAR2
4000
No
No
Active
Any special comments On This record
VARCHAR2
39
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle User Code Of Person Who Created This Record
NUMBER
40
CREATED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Created
DATE
41
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle User Code Of Person Who Last Modified This Record
NUMBER
42
MODIFIED_DATE
DATE
7
No
No
Active
Control column indicating Date of last record modification
DATE
gov.noaa.nmfs.inport:7818
Lee Weinberger
2008-08-11T14:27:39
SysAdmin InPortAdmin
2022-08-09T17:11:01
2021-04-29
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
www.sefsc.noaa.gov
8:00 a.m. - 4:30 p.m. EST
1001
Public
No
2021-04-29
1 Year
2022-04-29