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 >

View: IMAGES_VW

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

Summary

Abstract

View of photo with decodes

Description

View of photo with decodes

Entity Information

Entity Type
Data View

Data Attribute / Type Description
IMAGE_ID
NUMBER 		Image Key
IMAGE_NAME
VARCHAR2 		Name Of image
DOLPHIN_ID
VARCHAR2 		Link to DolphinID Table
DOLPHIN_NAME
VARCHAR2 		Name Of Dolphin
PARTNER_CODE
VARCHAR2 		Link to Partner Table
PARTNER_NAME
VARCHAR2 		Partner (Agency) Name
SURVEY_DATE
VARCHAR2 		Date Of Survey
FIN_TYPE_CODE
NUMBER 		Code to indicate type of Fin
FIN_TYPE_NAME
VARCHAR2 		Type Of Fin
DORSAL_RATIO
VARCHAR2 		Dorsal ratio
STANDARD_ID
VARCHAR2 		Standard ID
DESCRIPTION
VARCHAR2 		Description Of Standard ID
IS_PUBLISHABLE
NUMBER 		Indicates If Image is publishable
PUBLIC_NOTES
VARCHAR2 		Any public notes On this record
RANGEMAP_NAME
VARCHAR2 		Name Of file associated with image

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: View: IMAGES_VW
Short Name: IMAGES_VW
Status: Completed
Abstract:

View of photo with decodes
Notes:

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

Entity Information

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

View of photo with decodes

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 IMAGE_ID NUMBER Image Key
100
 IMAGE_NAME VARCHAR2 Name Of image
100
 DOLPHIN_ID VARCHAR2 Link to DolphinID Table
100
 DOLPHIN_NAME VARCHAR2 Name Of Dolphin
100
 PARTNER_CODE VARCHAR2 Link to Partner Table
100
 PARTNER_NAME VARCHAR2 Partner (Agency) Name
100
 SURVEY_DATE VARCHAR2 Date Of Survey
100
 FIN_TYPE_CODE NUMBER Code to indicate type of Fin
100
 FIN_TYPE_NAME VARCHAR2 Type Of Fin
100
 DORSAL_RATIO VARCHAR2 Dorsal ratio
100
 STANDARD_ID VARCHAR2 Standard ID
100
 DESCRIPTION VARCHAR2 Description Of Standard ID
100
 IS_PUBLISHABLE NUMBER Indicates If Image is publishable
100
 PUBLIC_NOTES VARCHAR2 Any public notes On this record
100
 RANGEMAP_NAME VARCHAR2 Name Of file associated with image

Attribute Details

IMAGE_ID

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

Image Key
General Data Type: NUMBER

IMAGE_NAME

CC ID: 30895
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

Name Of image
General Data Type: VARCHAR2

DOLPHIN_ID

CC ID: 30891
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Link to DolphinID Table
General Data Type: VARCHAR2

DOLPHIN_NAME

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

Name Of Dolphin
General Data Type: VARCHAR2

PARTNER_CODE

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

Link to Partner Table
General Data Type: VARCHAR2

PARTNER_NAME

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

Partner (Agency) Name
General Data Type: VARCHAR2

SURVEY_DATE

CC ID: 30892
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Date Of Survey
General Data Type: VARCHAR2

FIN_TYPE_CODE

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

Code to indicate type of Fin
General Data Type: NUMBER

FIN_TYPE_NAME

CC ID: 30890
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

Type Of Fin
General Data Type: VARCHAR2

DORSAL_RATIO

CC ID: 30887
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Dorsal ratio
General Data Type: VARCHAR2

STANDARD_ID

CC ID: 30894
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Standard ID
General Data Type: VARCHAR2

DESCRIPTION

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

Description Of Standard ID
General Data Type: VARCHAR2

IS_PUBLISHABLE

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

Indicates If Image is publishable
General Data Type: NUMBER

PUBLIC_NOTES

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

Any public notes On this record
General Data Type: VARCHAR2

RANGEMAP_NAME

CC ID: 30893
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Name Of file associated with image
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7813
GUID: gov.noaa.nmfs.inport:7813
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