Table: STRANDINGSAMPLEMETADATA
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35921 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Animal level information on stranded animals.
DescriptionAnimal level information on stranded animals.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TAGNUM
VARCHAR2 |
unique identifier of animal, link to samples |
DATESTRAND
DATE |
date of stranding |
SPECIES
VARCHAR2 |
4 letter code for species |
LAT
NUMBER |
decimal latitude of stranding location |
LON
NUMBER |
decimal longitude of stranding location |
STRANDINGSTATE
VARCHAR2 |
geographical state of stranding |
NATLDATABASENUM
VARCHAR2 |
national database id number |
COMMENTS
VARCHAR2 |
notes |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NEFSC) for inquiries on this record.
Item Identification
Title: | Table: STRANDINGSAMPLEMETADATA |
---|---|
Short Name: | STRANDINGSAMPLEMETADATA |
Status: | Completed |
Abstract: |
Animal level information on stranded animals. |
Notes: |
Loaded by batch 9570, 12-12-2016 13:35 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | TTS |
Description: |
Animal level information on stranded animals. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
TAGNUM | VARCHAR2 | unique identifier of animal, link to samples | |
100
|
DATESTRAND | DATE | date of stranding | |
100
|
SPECIES | VARCHAR2 | 4 letter code for species | |
100
|
LAT | NUMBER | decimal latitude of stranding location | |
100
|
LON | NUMBER | decimal longitude of stranding location | |
100
|
STRANDINGSTATE | VARCHAR2 | geographical state of stranding | |
100
|
NATLDATABASENUM | VARCHAR2 | national database id number | |
100
|
COMMENTS | VARCHAR2 | notes |
Attribute Details
TAGNUM
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
unique identifier of animal, link to samples |
General Data Type: | VARCHAR2 |
DATESTRAND
Seq. Order: | 2 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
date of stranding |
General Data Type: | DATE |
SPECIES
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
4 letter code for species |
General Data Type: | VARCHAR2 |
LAT
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
decimal latitude of stranding location |
General Data Type: | NUMBER |
LON
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
decimal longitude of stranding location |
General Data Type: | NUMBER |
STRANDINGSTATE
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
geographical state of stranding |
General Data Type: | VARCHAR2 |
NATLDATABASENUM
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
national database id number |
General Data Type: | VARCHAR2 |
COMMENTS
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
notes |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 35921 |
---|---|
GUID: | gov.noaa.nmfs.inport:35921 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-12-12 13:35+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-12-12 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-12-12 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-12-12 |