vessel_directory
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:46084 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | vessel_directory |
---|---|
Status: | In Work |
Abstract: |
This data contains vessel information and representative contact information |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
This data contains vessel information and representative contact information |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
Vsl_Num | numeric | vessel number (primary key) |
100
|
Vsl_Name | character | vessel name | |
100
|
Area1 | numeric | primary landing area | |
100
|
Area2 | numeric | Secondary landing area | |
100
|
Region | Character | Region Code | |
100
|
Port_Num | numeric | port number | |
100
|
Port_Add1 | Character | first line of port street address | |
100
|
Port_Add2 | Character | Second line of port street address | |
100
|
State | Character | Two letter State Postal abbreviation of port | |
100
|
City | Character | port City | |
100
|
zip | character | Five number port zipcode | |
100
|
Website | Character | website Contact Comments | |
100
|
In_Survey | Numeric | vessel is currently in survey | |
100
|
Active | numeric | vessel is currently active | |
100
|
Cooperative | numeric | vessel is currently cooperative | |
100
|
Permit_Hold | numeric | vessel is currently on permit hold | |
100
|
Comments | Character | captain or owner is contact | |
100
|
Capt_First | Character | First Name Of Vessel Captain C_Fon3 C_Fon4 C_Email Same | |
100
|
Capt_Last | character | Last Name Of Vessel Captain | |
100
|
C_Suffix | character | Suffix (if present) in the name of the vessel captain | |
100
|
Capt_Add1 | character | first line of the address of the vessel captain | |
100
|
Capt_Add2 | character | second line (if present) of the address of the vessel captain | |
100
|
Capt_Add3 | character | third line (if present) of the address of the vessel captain | |
100
|
Capt_City | character | City of the address of the vessel captain | |
100
|
Capt_State | character | State Postal abbreviation of the address of the vessel captain | |
100
|
Capt_Zip | numeric | Zip Code (only 5 numbers) of the address of the vessel captain | |
100
|
C_Fon1 | Numeric | First phone Number of the vessel Captain | |
100
|
C_Fon21 | numeric | second phone Number of the vessel Captain | |
100
|
C_Fon3 | numeric | third phone Number of the vessel Captain | |
100
|
C_Fon4 | numeric | fourth phone Number of the vessel Captain | |
100
|
c_email | character | email address of the vessel of the vessel Captain | |
100
|
c_same | character | Are the vessel captain and the owner the same | |
100
|
owner_first name | character | First Name of Vessel owner owner city owner state owner zip owner phone owner phone owner phone owner phone owner email address US Coast Guard Number | |
100
|
owner suffix | character | Suffix (if present) of Owner's Name | |
100
|
owner last name | character | Last Name of Vessel owner | |
100
|
Owner_Add1 | character | first line of owner address | |
100
|
Owner_Add2 | character | second line (if present) of owner address | |
100
|
Owner_Add3 | character | third line if present of owner address | |
100
|
Owner_City | character | city of the owner address | |
100
|
Owner_State | character | Two letter state abbreviation of the owner address | |
100
|
Owner_Zip | character | five digit zip code of owner address | |
100
|
O_Fon1 | numeric | first contact phone number of owner | |
100
|
O_Fon2 | numeric | second contact phone number of owner | |
100
|
O_Fon3 | numeric | third contact phone number of owner | |
100
|
O_Fon4 | numeric | fourth contact phone number of owner | |
100
|
o_email | character | owner email address | |
100
|
vsl_id | numeric | us Coast Guard Id of the Vessel |
Attribute Details
Vsl_Num
Seq. Order: | 10 |
---|---|
Data Storage Type: | numeric |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
vessel number (primary key) |
Vsl_Name
Seq. Order: | 20 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
vessel name |
Area1
Seq. Order: | 40 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Status: | Active |
Description: |
primary landing area |
Area2
Seq. Order: | 50 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Status: | Active |
Description: |
Secondary landing area |
Region
Seq. Order: | 70 |
---|---|
Data Storage Type: | Character |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Region Code |
Allowed Values: | AT (Atlantic) GU (Gulf) |
Port_Num
Seq. Order: | 80 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Status: | Active |
Description: |
port number |
Port_Add1
Seq. Order: | 90 |
---|---|
Data Storage Type: | Character |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
first line of port street address |
Port_Add2
Seq. Order: | 100 |
---|---|
Data Storage Type: | Character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Second line of port street address |
State
Seq. Order: | 110 |
---|---|
Data Storage Type: | Character |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two letter State Postal abbreviation of port |
City
Seq. Order: | 120 |
---|---|
Data Storage Type: | Character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
port City |
zip
Seq. Order: | 130 |
---|---|
Data Storage Type: | character |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Status: | Active |
Description: |
Five number port zipcode |
Website
Seq. Order: | 140 |
---|---|
Data Storage Type: | Character |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
website Contact Comments |
In_Survey
Seq. Order: | 150 |
---|---|
Data Storage Type: | Numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
vessel is currently in survey |
Active
Seq. Order: | 160 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
vessel is currently active |
Cooperative
Seq. Order: | 170 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
vessel is currently cooperative |
Permit_Hold
Seq. Order: | 180 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
vessel is currently on permit hold |
Comments
Seq. Order: | 190 |
---|---|
Data Storage Type: | Character |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
captain or owner is contact |
Capt_First
Seq. Order: | 210 |
---|---|
Data Storage Type: | Character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First Name Of Vessel Captain C_Fon3 C_Fon4 C_Email Same |
Capt_Last
Seq. Order: | 220 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last Name Of Vessel Captain |
C_Suffix
Seq. Order: | 230 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Suffix (if present) in the name of the vessel captain |
Capt_Add1
Seq. Order: | 240 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
first line of the address of the vessel captain |
Capt_Add2
Seq. Order: | 250 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
second line (if present) of the address of the vessel captain |
Capt_Add3
Seq. Order: | 260 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
third line (if present) of the address of the vessel captain |
Capt_City
Seq. Order: | 270 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
City of the address of the vessel captain |
Capt_State
Seq. Order: | 280 |
---|---|
Data Storage Type: | character |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
State Postal abbreviation of the address of the vessel captain |
Capt_Zip
Seq. Order: | 290 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Status: | Active |
Description: |
Zip Code (only 5 numbers) of the address of the vessel captain |
C_Fon1
Seq. Order: | 300 |
---|---|
Data Storage Type: | Numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
First phone Number of the vessel Captain |
C_Fon21
Seq. Order: | 310 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
second phone Number of the vessel Captain |
C_Fon3
Seq. Order: | 320 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
third phone Number of the vessel Captain |
C_Fon4
Seq. Order: | 330 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
fourth phone Number of the vessel Captain |
c_email
Seq. Order: | 340 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
email address of the vessel of the vessel Captain |
c_same
Seq. Order: | 350 |
---|---|
Data Storage Type: | character |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Are the vessel captain and the owner the same |
owner_first name
Seq. Order: | 360 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First Name of Vessel owner owner city owner state owner zip owner phone owner phone owner phone owner phone owner email address US Coast Guard Number |
owner suffix
Seq. Order: | 370 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Suffix (if present) of Owner's Name |
owner last name
Seq. Order: | 380 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last Name of Vessel owner |
Owner_Add1
Seq. Order: | 390 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
first line of owner address |
Owner_Add2
Seq. Order: | 400 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
second line (if present) of owner address |
Owner_Add3
Seq. Order: | 410 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
third line if present of owner address |
Owner_City
Seq. Order: | 420 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
city of the owner address |
Owner_State
Seq. Order: | 430 |
---|---|
Data Storage Type: | character |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two letter state abbreviation of the owner address |
Owner_Zip
Seq. Order: | 440 |
---|---|
Data Storage Type: | character |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Status: | Active |
Description: |
five digit zip code of owner address |
O_Fon1
Seq. Order: | 450 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
first contact phone number of owner |
O_Fon2
Seq. Order: | 460 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
second contact phone number of owner |
O_Fon3
Seq. Order: | 470 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
third contact phone number of owner |
O_Fon4
Seq. Order: | 480 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
fourth contact phone number of owner |
o_email
Seq. Order: | 490 |
---|---|
Data Storage Type: | character |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
owner email address |
vsl_id
Seq. Order: | 500 |
---|---|
Data Storage Type: | numeric |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Status: | Active |
Description: |
us Coast Guard Id of the Vessel |
Catalog Details
Catalog Item ID: | 46084 |
---|---|
GUID: | gov.noaa.nmfs.inport:46084 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2017-05-18 06:56+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-05-07 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-05-07 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-05-07 |