7802 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 https://ror.org/0396y0w87 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 https://ror.org/0396y0w87 ONLINE RESOURCE Not Chked https://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 7805 Entity 7806 Entity 7807 Entity 7808 Entity 7809 Entity 7810 Entity 7811 Entity 7812 Entity 7814 Entity 7815 Entity 7816 Entity 7817 Entity 7818 Entity 7819 Entity 7820 Entity 7821 Entity 7822 Entity 7823 Entity 7813 Entity gov.noaa.nmfs.inport:7802 Lee Weinberger 2008-08-11T14:12:56 SysAdmin InPortAdmin 2026-03-04T19:17:18 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 No 2021-04-29 1 Year 2022-04-29