7802
Biscayne Bay Dolphin Photo ID System
Dolphin Photo ID Data
Data Set
Published / External
3739
Biscayne Bay Dolphin Photo ID System
Project
Completed
It has been shown through a variety of photo-identification studies that populations of bottlenose dolphin inhabit the various embayments along the coast of Florida. Knowledge of population stock structure is critical to developing management plans and understanding how stressors impact individual populations. Researchers have found that photo-identification is one of the best ways to study populations of bottlenose dolphin in near shore environments. Unlike aerial and ship-board surveys, individual dolphins can be identified and tracked temporally and spatially, giving investigators a more comprehensive picture of population stock structure
The bottlenose dolphin is a heterogenous species found throughout temperate and tropical waters. In past years, aerial surveys, photo-identification studies, and, more recently, genetic studies have begun to divide this worldwide species into population stocks. In 1998, the National Marine Fisheries Service (NMFS) reported to the Marine Mammal Commission that there appears to be at least four discrete population stocks of bottlenose dolphin in the U.S. Atlantic waters:
Dolphin sighting surveys are conducted by boat. Environmental conditions are recorded and linked back to sightings of individuals, which are identified by photos, which are also stored in an Oracle database.
Theme
abundance
Theme
distribution
Theme
dolphin
Theme
environmental data
Theme
fisheries-independent data
Theme
protected species
Theme
survey data
Spatial
Biscayne Bay
Southeast Fisheries Science Center
Miami
FL
USA
Location Of The Main Office Of The South East Fisheries Science Center
Data Set
None Planned
Table (digital)
Digital Camera
NOAA Small Vessel
N/A
7804
Table: BEHAVIOR
BEHAVIOR
Published / External
Completed
Data Table Describing the Behavior of a Dolphin When The dolphin is Seen
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data Table Describing the Behavior of a DOlphin When The ophin is Seen
1
BEHAVIOR_CODE
NUMBER
22
Yes
No
38
Active
Beahvior Code (Link to Behavior Code Table)
NUMBER
2
SIGHTING_ID
NUMBER
22
Yes
No
38
Active
Link To SIghting Table
NUMBER
3
WHEN_OCCUR
VARCHAR2
1
No
No
Active
Code to indicate when behavior Took place
VARCHAR2
7805
Table: BEHAVIOR_CODES
BEHAVIOR_CODES
Published / External
Completed
Table Of Dolphin Beahvior Codes
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Of Dolphin Beahvior Codes
1
CODE
NUMBER
22
Yes
Yes
38
Active
Behavior Code
NUMBER
2
NAME
VARCHAR2
30
Yes
No
Active
Description Of Bahavior Code
VARCHAR2
7806
Table: DOLPHIN_HISTORY
DOLPHIN_HISTORY
Published / External
Completed
Data table listing history of the sightings of a dolphin
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data table listing history of the sightings of a dolphin
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
DOLPHIN_ID
VARCHAR2
20
No
No
Active
Foreign Key To Dolphin ID Table
VARCHAR2
3
SIGHTING_ID
NUMBER
22
Yes
No
38
Active
Link To SIghting Table
NUMBER
4
PRELIMINARY_LETTER_ID
VARCHAR2
3
Yes
No
Active
Preliminary Letter ID
VARCHAR2
5
DOLPHIN_INFO_ID
NUMBER
22
Yes
No
38
Active
Link to Dolphin Photo Record
NUMBER
6
DORSAL_RATIO
VARCHAR2
5
No
No
Active
Dorsal Ratio
VARCHAR2
7
FIN_CATEGORY_CODE
VARCHAR2
3
No
No
Active
Category Code to Describing Fin
VARCHAR2
8
HAS_SCARS
VARCHAR2
1
No
No
Active
Are there scars on the dolphin
VARCHAR2
9
SCAR_DESCRIPTION
VARCHAR2
4000
No
No
Active
Description of scars
VARCHAR2
10
HAS_LESIONS
VARCHAR2
1
No
No
Active
Are The lesions on the dolphin
VARCHAR2
11
LESION_DESCRIPTION
VARCHAR2
4000
No
No
Active
Description Of The Lesions
VARCHAR2
12
FIN_TYPE_CODE
NUMBER
22
No
No
38
Active
Type Of Fin Code
NUMBER
13
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle Userid of the creator of this record
NUMBER
14
CREATED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Created
DATE
15
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle Userid of the person who last modified
NUMBER
16
MODIFIED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Last Modified
DATE
7807
Table: DOLPHIN_ID
DOLPHIN_ID
Published / External
Completed
Data table containing descriptive information about a dolphin
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data table containing descriptive information about a dolphin
1
ID
VARCHAR2
20
Yes
Yes
Active
Sequential Key
VARCHAR2
2
SURVEY_ID
NUMBER
22
No
No
38
Active
Foreign Key To Survey Table
NUMBER
3
NAME
VARCHAR2
30
No
No
Active
Name Of Dolphin (If known)
VARCHAR2
4
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Foreign Key To Partner Table
VARCHAR2
5
SEX_CODE
VARCHAR2
1
No
No
Active
Code To Indicate Sex Of Dolphin
VARCHAR2
6
LIFE_STAGE_CODE
VARCHAR2
1
No
No
Active
Life Stage Code
VARCHAR2
7
COMMENTS
VARCHAR2
4000
No
No
Active
Any extra comments On Dolphin Photo
VARCHAR2
8
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle Userid of the creator of this record
NUMBER
9
CREATED_DATE
DATE
7
No
No
Active
Date Record was created
DATE
10
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle Userid of the one who last modifed this record
NUMBER
11
MODIFIED_DATE
DATE
7
No
No
Active
Date Record was last modified
DATE
12
HAS_BIOPSY_ATTEMPT
VARCHAR2
1
No
No
Active
Was A Biopsy Attempted
VARCHAR2
13
HAS_HIT
VARCHAR2
1
No
No
Active
Was Dolphin Hit
VARCHAR2
14
HAS_SAMPLE_TAKEN
VARCHAR2
1
No
No
Active
Has a Biopsy Sample Been Taken From The Dolphin
VARCHAR2
7808
Table: DOLPHIN_INFO
DOLPHIN_INFO
Published / External
Completed
Data table listing INFORMATION ABOUT THE DOLPHIN
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data table listing INFORMATION ABOUT THE DOLPHIN
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
SIGHTING_ID
NUMBER
22
Yes
No
38
Active
Foreign Key to SIghtings Table
NUMBER
3
DOLPHIN_ID
VARCHAR2
20
No
No
Active
Foreign Key to Dlphin_ID Table
VARCHAR2
4
NUMBER_OF_EXTRAS
NUMBER
22
No
No
38
Active
Number Of Extras
NUMBER
5
PRELIMINARY_LETTER_ID
VARCHAR2
3
No
No
Active
Preliminary Letter ID
VARCHAR2
6
IS_NEW_SIGHTING
VARCHAR2
1
No
No
Active
Is This A New Sighting
VARCHAR2
7
COMMENTS
VARCHAR2
4000
No
No
Active
Any Comments About Dolphin
VARCHAR2
8
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle Userid of the creator of this record
NUMBER
9
CREATED_DATE
DATE
7
No
No
Active
Date Record was create
DATE
10
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle Userid of the person who last changed this record
NUMBER
11
MODIFIED_DATE
DATE
7
No
No
Active
Date That this record was last modified
DATE
7809
Table: FIN_TYPE_CODES
FIN_TYPE_CODES
Published / External
Completed
Table Of Valid Fin Type Codes
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Of Valid Fin Type Codes
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
NAME
VARCHAR2
5
Yes
No
Active
Mnemonic Code
VARCHAR2
3
DESCRIPTION
VARCHAR2
100
No
No
Active
Code Description
VARCHAR2
7810
Table: FISHERY_CODES
FISHERY_CODES
Published / External
Completed
Table Of Valid Fishery Codes
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Of Valid Fishery Codes
1
CODE
VARCHAR2
5
Yes
Yes
Active
Fishery Code
VARCHAR2
2
NAME
VARCHAR2
30
Yes
No
Active
Fishery Name
VARCHAR2
7811
Table: HEADING_CODES
HEADING_CODES
Published / External
Completed
Table Of Valid Headings
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Of Valid Headings
1
ID
VARCHAR2
20
Yes
Yes
Active
Sequential Key
VARCHAR2
2
NAME
VARCHAR2
30
Yes
No
Active
Heading Name
VARCHAR2
7812
Table: IMAGE
IMAGE
Published / External
Completed
This is a test
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
This is a test
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
IMAGE
BLOB
4000
No
No
Active
Actual image file
BLOB
3
FILE_NAME
VARCHAR2
255
Yes
No
Active
Actual name of image file
VARCHAR2
4
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Partner Code
VARCHAR2
5
SURVEY_DATE
DATE
7
No
No
Active
Date Of Survey
DATE
6
FIN_CATEGORY_CODE
VARCHAR2
5
No
No
Active
Fin category code
VARCHAR2
7
DESCRIPTION
VARCHAR2
4000
No
No
Active
Description of photo
VARCHAR2
8
DOLPHIN_ID
VARCHAR2
20
Yes
No
Active
Key to dolphin table
VARCHAR2
9
DORSAL_RATIO
NUMBER
22
No
No
38
Active
Dorsal ratio
NUMBER
10
PUBLIC_NOTES
VARCHAR2
4000
No
No
Active
Any public notes on the image
VARCHAR2
11
IS_PUBLISHABLE
NUMBER
22
No
No
38
Active
Indicates if the photo is publishable
NUMBER
12
UPLOADED_DATE
DATE
7
No
No
Active
Uploaded date
DATE
13
HAS_SCARS
VARCHAR2
1
No
No
Active
Indicates if there are scars in the image
VARCHAR2
14
HAS_LESIONS
VARCHAR2
1
No
No
Active
Indicates if there are lesions in the image
VARCHAR2
15
FIN_TYPE_CODE
NUMBER
22
No
No
38
Active
Fin type code
NUMBER
16
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle User Code Of Person Who Created This Record
NUMBER
17
CREATED_DATE
DATE
7
No
No
Active
Date record was created
DATE
18
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle User Code Of Person Who LAST MODIFIED This Record
NUMBER
19
MODIFIED_DATE
DATE
7
No
No
Active
time that record was last modified
DATE
20
STANDARD_ID
VARCHAR2
20
No
No
Active
Standard Id for linking
VARCHAR2
7813
View: IMAGES_VW
IMAGES_VW
Published / External
Completed
View of photo with decodes
Loaded by batch 2223, 08-11-2008 14:27
Data View
Yes
DOLPHINPHOTO
View of photo with decodes
1
IMAGE_ID
NUMBER
22
Yes
No
38
Active
Image Key
NUMBER
2
IMAGE_NAME
VARCHAR2
255
Yes
No
Active
Name Of image
VARCHAR2
3
DOLPHIN_ID
VARCHAR2
20
Yes
No
Active
Link to DolphinID Table
VARCHAR2
4
DOLPHIN_NAME
VARCHAR2
30
No
No
Active
Name Of Dolphin
VARCHAR2
5
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Link to Partner Table
VARCHAR2
6
PARTNER_NAME
VARCHAR2
30
No
No
Active
Partner (Agency) Name
VARCHAR2
7
SURVEY_DATE
VARCHAR2
10
No
No
Active
Date Of Survey
VARCHAR2
8
FIN_TYPE_CODE
NUMBER
22
No
No
38
Active
Code to indicate type of Fin
NUMBER
9
FIN_TYPE_NAME
VARCHAR2
100
No
No
Active
Type Of Fin
VARCHAR2
10
DORSAL_RATIO
VARCHAR2
9
No
No
Active
Dorsal ratio
VARCHAR2
11
STANDARD_ID
VARCHAR2
20
No
No
Active
Standard ID
VARCHAR2
12
DESCRIPTION
VARCHAR2
4000
No
No
Active
Description Of Standard ID
VARCHAR2
13
IS_PUBLISHABLE
NUMBER
22
No
No
38
Active
Indicates If Image is publishable
NUMBER
14
PUBLIC_NOTES
VARCHAR2
4000
No
No
Active
Any public notes On this record
VARCHAR2
15
RANGEMAP_NAME
VARCHAR2
255
No
No
Active
Name Of file associated with image
VARCHAR2
7814
Table: PARTNER_CODES
PARTNER_CODES
Published / External
Completed
Table Of Organizations Associated With Dolphin Data
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Of Organizations Associated With Dolphin Data
1
CODE
VARCHAR2
5
Yes
Yes
Active
Mnemonic Code
VARCHAR2
2
NAME
VARCHAR2
30
Yes
No
Active
Organization Name
VARCHAR2
7815
Table: PHASE_MOON_CODES
PHASE_MOON_CODES
Published / External
Completed
Code Table Giving Valid Phases Of The Moon
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Code Table Giving Valid Phases Of The Moon
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
NAME
VARCHAR2
30
Yes
No
Active
Name Of Pahse Of The Moon
VARCHAR2
7816
Table: RANGE_MAP
RANGE_MAP
Published / External
Completed
Data table listing images with dolphin counts
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Data table listing images with dolphin counts
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
IMAGE
BLOB
4000
No
No
Active
Actual Image Of Dolphin
BLOB
3
DOLPHIN_ID
VARCHAR2
20
Yes
No
Active
Link to Doplhin_id table
VARCHAR2
4
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Link to Partner table
VARCHAR2
5
FILE_NAME
VARCHAR2
255
Yes
No
Active
Name Of the image file
VARCHAR2
6
FROM_DATE
DATE
7
No
No
Active
Start Date Of Count
DATE
7
TO_DATE
DATE
7
No
No
Active
End Date Of Count
DATE
8
OBS_COUNT
NUMBER
22
No
No
38
Active
Obsert Count Of Dolphins
NUMBER
9
IS_PUBLISHABLE
NUMBER
22
No
No
38
Active
Is This image publishable
NUMBER
10
UPLOADED_DATE
DATE
7
No
No
Active
Upload Date
DATE
11
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle User Code Of Person Who Created This Record
NUMBER
12
CREATED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Created
DATE
7817
Table: SECURITY_LEVELS
SECURITY_LEVELS
Published / External
Completed
Table Defining System Access Privileges
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Defining System Access Privileges
1
ID
VARCHAR2
5
Yes
Yes
Active
Sequential Key
VARCHAR2
2
NAME
VARCHAR2
30
Yes
No
Active
System Role
VARCHAR2
7818
Table: SIGHTING
SIGHTING
Published / External
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
7819
Table: SURVEY
SURVEY
Published / External
Completed
Master Survey Data Table
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Master Survey Data Table
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Link to Partner Table
VARCHAR2
3
ZONE_CODE
VARCHAR2
5
No
No
Active
Lnk To Zone Table
VARCHAR2
4
SURVEY_DATE
DATE
7
Yes
No
Active
Date of Survey
DATE
5
IS_COMPLETE
VARCHAR2
1
No
No
Active
Is The Survey Complete
VARCHAR2
6
START_TIME
VARCHAR2
4
No
No
Active
Local Time Of Day That The Survey Started
VARCHAR2
7
END_TIME
VARCHAR2
4
No
No
Active
Local Time Of Day That The Survey Ended
VARCHAR2
8
TOTAL_TIME
VARCHAR2
4
No
No
Active
Total Time In Survey Where Hundred and Yhousands Place Indicates Hours and Ten and Ones place indicates minutes
VARCHAR2
9
TOTAL_HOUR
NUMBER
22
No
No
38
Active
Total Number Of Hours In Survey
NUMBER
10
TOTAL_MINUTES
NUMBER
22
No
No
38
Active
Total Number Of mInutes In The Survey. THis is a number between 0 and 59
NUMBER
11
WEATHER_CODE
NUMBER
22
No
No
38
Active
Code Indicating Weather Coditions At Time Of Survey
NUMBER
12
BEAUFORT_STATE_CODE
NUMBER
22
No
No
38
Active
Beaufort State Code
NUMBER
13
MOON_PHASE_CODE
NUMBER
22
No
No
38
Active
Code To Indicate Phase Of The Moon
NUMBER
14
WATER_TEMPERATURE
NUMBER
22
No
No
38
Active
Code To Indicate Water Temperature
NUMBER
15
START_TIDE_CODE
NUMBER
22
No
No
38
Active
Code Indicating Tide Code At Start Of The Survey
NUMBER
16
END_TIDE_CODE
NUMBER
22
No
No
38
Active
Code Indicating Tide Code At Endt Of The Survey
NUMBER
17
COMMENTS
VARCHAR2
4000
No
No
Active
Any Other Pertinent Comments ABout This Record
VARCHAR2
18
CREATED_BY_USER_ID
NUMBER
22
Yes
No
38
Active
Oracle User Code Of Person Who Created This Record
NUMBER
19
CREATED_DATE
DATE
7
Yes
No
Active
Control Column Indicating When This Record Was Created
DATE
20
MODIFIED_BY_USER_ID
NUMBER
22
No
No
38
Active
Oracle User Code Of Person Who Last Modified This Record
NUMBER
21
MODIFIED_DATE
DATE
7
No
No
Active
Control Column Indicating When This Record Was Last Modified
DATE
7820
Table: TIDE_CODES
TIDE_CODES
Published / External
Completed
Table Describing Data Entry Personnel and managers for the Dolphin Photo Is System
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Describing Data Entry Personnel and managers for the Dolphin Photo Is System
1
CODE
NUMBER
22
Yes
Yes
38
Active
Sequential Key
NUMBER
2
NAME
VARCHAR2
5
Yes
No
Active
Name Of Tide
VARCHAR2
7821
Table: USER_PROFILE
USER_PROFILE
Published / External
Completed
System profile/security table
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
System profile/security table
1
ID
NUMBER
22
Yes
Yes
38
Active
Sequential Key/Code
NUMBER
2
USERNAME
VARCHAR2
20
Yes
No
Active
Oracle Userid/Usercode
VARCHAR2
3
PASSWORD
VARCHAR2
20
Yes
No
Active
Encoded Password
VARCHAR2
4
PARTNER_CODE
VARCHAR2
5
Yes
No
Active
Foreign Key To Partner Table
VARCHAR2
5
SECURITY_LEVEL_ID
NUMBER
22
Yes
No
38
Active
Code To Indicate Privileges Of The Indicated User
NUMBER
6
FIRST_NAME
VARCHAR2
50
No
No
Active
Data Manger/User First Name
VARCHAR2
7
LAST_NAME
VARCHAR2
50
No
No
Active
Data Manager/User Last Name
VARCHAR2
8
ORGANIZATION
VARCHAR2
100
No
No
Active
Organization Associated With User/Manager
VARCHAR2
9
TELEPHONE
VARCHAR2
10
No
No
Active
Telephone Numer Associated With User/Manager
VARCHAR2
10
EMAIL
VARCHAR2
100
No
No
Active
Electronic Mail Address of User/Manager
VARCHAR2
11
CREATED_DATE
DATE
7
No
No
Active
Control Column Indicating WHen This Record Was Created
DATE
12
UPLOADED_DATE
DATE
7
No
No
Active
Control Column To Indicate When Record as Last Uploaded
DATE
13
MODIFIED_DATE
DATE
7
No
No
Active
Control COlumn Indiccating When This Record Was Last Modified
DATE
7822
Table: WEATHER_CODES
WEATHER_CODES
Published / External
Completed
Table Of Valid Weather Codes
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Table Of Valid Weather Codes
1
ID
NUMBER
22
Yes
Yes
38
Active
Weather Code
NUMBER
2
NAME
VARCHAR2
30
Yes
No
Active
Description Of Weather Code
VARCHAR2
7823
Table: ZONE_CODES
ZONE_CODES
Published / External
Completed
Tabke Of Valid Zone Codes
Loaded by batch 2223, 08-11-2008 14:27
Data Table
Yes
DOLPHINPHOTO
Tabke Of Valid Zone Codes
1
ID
NUMBER
22
Yes
Yes
38
Active
Numeric Zone Code
NUMBER
2
NAME
VARCHAR2
30
Yes
No
Active
Alphabetic Zone COde
VARCHAR2
Data Steward
1990
Person
Garrison, Lance
Lance.Garrison@noaa.gov
75 Virginia Beach Dr
Miami
FL
33149
305-361-4488
305-361-4478
8:00 AM - 4:30 PM EST/EDT
Contact by email preferred.
Distributor
1990
Organization
Southeast Fisheries Science Center
SEFSC
75 Virginia Beach Drive
Miami
FL
33149
USA
(305)361-5761
https://www.fisheries.noaa.gov/about/southeast-fisheries-science-center
About SEFSC
Online Resource
8:00 a.m. - 4:30 p.m. EST
Contact by email preferred.
Metadata Contact
1990
Person
Garrison, Lance
Lance.Garrison@noaa.gov
75 Virginia Beach Dr
Miami
FL
33149
305-361-4488
305-361-4478
8:00 AM - 4:30 PM EST/EDT
Contact by email preferred.
Point of Contact
1990
Person
Garrison, Lance
Lance.Garrison@noaa.gov
75 Virginia Beach Dr
Miami
FL
33149
305-361-4488
305-361-4478
8:00 AM - 4:30 PM EST/EDT
Contact by email preferred.
Ground Condition
-80.5
-80.1
25.9
25.18
Atlantic Ocean, U.S. South
Continuing
1990
Unclassified
To fishery Scientists and other qualified researchers upon request.
Contact someone who has one of the support roles
None
Data set is not for use in litigation. While efforts have been made to ensure that these data are accurate and reliable, NOAA cannot assume liability for any damages or misrepresentations caused by inaccuracies in these data, or as a result of these data being used on a particular system. NOAA makes no warranty, expressed or implied, nor does distribution constitute any such warranty
none
none
https://www.sefsc.noaa.gov/species/mammals/photos.htm
1990
Organization
Southeast Fisheries Science Center
ONLINE RESOURCE
Not Chked
http://www.spc.noaa.gov/faq/tornado/beaufort.html
Beufort wind scale
Oracle Database
Visual sightings and effort data are reviewed and verified by field leads after each survey day. Identifications of individual animals are reviewed and verified by multiple indivisuals using tools within the FinBase database system. Key entered data are verified by comparison to written data sheets.
No
0
Yes
Yes
No
365
This data is currently wavered under the current NOAA guidelines for relational databases.
To Be Determined
365
The data resides on a secure database server only accessible through the NMFS network requiring separate multi-factor authentication for both network and database access.
1
Data are collected on paper data sheets in the field which are then key-entered into database systems. Collected photographs are are reviewed and individual dolphins are identified and compared to previous images of indivudals wthin the catalog. These identifications are then reviewed and verified.
7804
Entity
Table: BEHAVIOR
7805
Entity
Table: BEHAVIOR_CODES
7806
Entity
Table: DOLPHIN_HISTORY
7807
Entity
Table: DOLPHIN_ID
7808
Entity
Table: DOLPHIN_INFO
7809
Entity
Table: FIN_TYPE_CODES
7810
Entity
Table: FISHERY_CODES
7811
Entity
Table: HEADING_CODES
7812
Entity
Table: IMAGE
7814
Entity
Table: PARTNER_CODES
7815
Entity
Table: PHASE_MOON_CODES
7816
Entity
Table: RANGE_MAP
7817
Entity
Table: SECURITY_LEVELS
7818
Entity
Table: SIGHTING
7819
Entity
Table: SURVEY
7820
Entity
Table: TIDE_CODES
7821
Entity
Table: USER_PROFILE
7822
Entity
Table: WEATHER_CODES
7823
Entity
Table: ZONE_CODES
7813
Entity
View: IMAGES_VW
gov.noaa.nmfs.inport:7802
Lee Weinberger
2008-08-11T14:12:56
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