Table Name: VESSEL (Vessel Identification) updated Oct 2009 Column No. Type Column Name Length 1 char gk_d_vessel 28 2 char vessel_id 15 3 varchar vessel_name 50 4 char managing_owner_id 28 5 varchar managing_owner 120 6 varchar gross_ton 8 7 varchar net_ton 8 8 varchar length 7 9 varchar breadth 7 10 varchar depth 7 11 varchar itc_breadth 7 12 varchar itc_depth 7 13 varchar itc_gross_ton 8 14 varchar itc_length 7 15 varchar itc_net_ton 8 16 varchar draft_design 8 17 char draft_design_units 2 18 char dead_weight_ton 8 19 char deadweighttonnage_units 2 20 char flag_abbr 2 21 varchar hailing_port 50 22 varchar hailing_port_state 2 23 varchar hailing_port_province 50 24 varchar route_type 50 25 varchar classification_society 80 26 varchar cargo_authorization_type 30 27 char documented_ind 1 28 varchar documented_status_type 30 29 char inspected_ind 1 30 varchar inspected_desc 30 31 char state_vessel_ind 1 32 varchar state_vessel_desc 30 33 char lloyds_ind 1 34 varchar lloyds_desc 30 35 char solas_ind 1 36 varchar solas_desc 30 37 varchar insp_subchapter_type 255 38 varchar vessel_class 50 39 varchar vessel_type 50 40 varchar vessel_subtype 50 41 varchar vessel_service 30 42 varchar max_passengers_allowed 6 43 varchar max_crew 6 44 varchar self_propelled_ind 1 45 varchar propulsion_type 30 46 varchar hull_material 30 47 varchar hull_design_type 30 48 varchar hull_double_bottom_type 30 49 varchar hull_double_side_type 30 50 varchar call_sign 8 51 varchar official_number 10 52 varchar primary_vin 30 53 varchar hull_number 30 54 varchar rbs_hull_number 30 55 varchar imo_number 30 56 varchar vessel_age 4 57 varchar build_shipyard 50 58 char build_year 4 59 varchar hull_build_party_name 80 60 varchar completed_by_party_name 80 61 varchar horsepower_ahead 5 62 varchar horsepower_astern 5 63 varchar forebody_type_desc 30 64 varchar hull_configuration 30 65 varchar hull_shape 30 66 char filler 1 Number of Records: 1,019,693 1. Gk_v (GK_D_VESSEL): is a computer generated field used to uniquely identify a vessel. Other tables in the Coast Guard's Data Warehouse use this field to reference vessel information. 2. Vid (VESSEL_ID): The vessel_id field is another computer generated field. Other tables in the Coast Guard's Marine Information for Safety and Law Enforcement(MISLE) use this field to join vessel records with other Marine Safety subject files. 3. Vname (VESSEL_NAME) 4. owner_id (MANAGING_OWNER_ID): The field is another computer generated field. 5. owner (MANAGING_OWNER) 6. grosstons (GROSS_TON_WT) 7. Net_tons (NET_TON) 8. length (LENGTH) 9. breadth (BREADTH) 10. depth (DEPTH) 11. itc_breadt 12. itc_depth 13. itc_gross 14. itc_length 15. itc_net_to 16. d_design (DRAFT_DESIGN): the unit is feet 17. d_unit (DRAFT_DESIGN_UNITS) : FT (feet), MT (ton), IN (inch), MR (meter) 18. deadweight (DEAD_WEIGHT_TON) 19. deadw_unit (DEADWEIGHTTONNAGE_UNITS) 20. flag_abbr (FLAG_ABBR) 21. Hail_port (HAILING_PORT_DESC) 22. hport_st (HAILING_PORT_STATE) 23. hport_prov (HAILING_PORT_PROV) 24. Route_type (ROUTE_TYPE_DESC): operating route 25. Classify (CLASSIFICATION_SOCIETY_DESC) 26. Cargo_typ (CARGO_AUTHORIZATION_TYPE_DESC) 27. Docu_ind (DOCUMENTED_INDICATOR): '1' means the vessel is a documented vessel of the U.S. '0' means the vessel is undocumented. 28. Docu_desc (DOCUMENTED_DESC): is a decoded value indicating a vessel is documented. If the vessel is documented, the value should show '1' and read 'certificate of documentation.' 29. Inspect_in (INSPECTED_IND): Mr. Krevait explains that some data fields are not fully populated and they will try to correct these errors in July. The following fields from 22 to 25 don't have any data in the fields. 30. Inspect_ds (INSPECTED_DESC) 31. state_in (STATE_VESSEL_IND) 32. state_ds (STATE_VESSEL_DESC) 33. lloyds_ind 34. llods_des 35. Solas_ind (SOLAS_IND): Solas stands for safety of life at sea. These are standards for specific vessels to maintain international safety standards for rescue equipment, fire prevention, etc. The indicator is turned on when the vessel holds a solas document. 36. Solas_ds (SOLAS_DESC): 'solas' means the vessel holds a solas document. 37. Insp_type (INSP_SUBCHAPTER_TYPE_DESC): The value 'N-Dangerous Cargoes' means the vessel has the authority to carry the materials. 38. V_class (VESSEL_CLASS_DESC): The values include: Barge, Bulk Carrier, Fishing Vessel, General Dry Cargo Ship, Miscellaneous Vessel, Offshore, Passenger Ship, Refrigerated Cargo Ship, Research Ship, Ro-Ro Cargo ship, School ship, Tank Ship, Towing Vessel, Warship and Unspecified. 39. V_type (VESSEL_TYPE_DESC): Detailed description of type of vessels. For example, Fishing Vessel could be Fish Catching Vessel. 40. V_sbtype (VESSEL_SUBTYPE_DESC): More details are listed although most data show 'unspecified' or 'General.' The values include Cabin Cruiser, Crude & Products Tank ship, Dredger and Flat deck barge etc. 41. V_service (VESSEL_SERVICE_DESC): The purpose of vessels. The common values include: Commercial Fishing Vessel, Freight Barge, Passenger (More than 6), Recreational, Towing Vessel and Unspecified. 42. Max_person (MAX_PASSENGERS_ALLOWED) 43. Max_crew (MAX_CREW) 44. Selfprop (SELF_PROPELLED_IND): The indicator field is '1'/'0' data type, but may be blank. A '1' means the vessel is self-propelled, a '0' means not self-propelled. If a vessel is propelled by sail and machinery, it is considered self propelled. 45. Prop_type (PROPULSION_TYPE_DESC) 46. Hull_mat (HULL_MATERIAL_DESC) 47. Hull_dsgn (HULL_DESIGN_TYPE_DESC): describes the general design of the vessel's hull. Listed below are the design types allowed with explanation. Note: most data indicates 'unspecified.' 48. Dblbott (HULL_DOUBLE_BOTTOM_TYPE_DESC) 49. Dblside (HULL_DOUBLE_SIDE_TYPE_DESC) 50. Callsign (CALL_SIGN) 51. officalno (OFFICIAL_NUMBER): is a six or seven digit number that has been awarded to each merchant and recreational vessel of the United States. In this data file, 'D' does not precede the official number as was the case in MSIS. The official number is permanently marked on some structural part of the hull interior. A vessel's official number should not be confused with the manufacturer's hull identification number. 52. prim_vin (PRIMARY_VIN) 52. Hull_num (HULL_NUMBER) 53. Rbs_num (RBS_HULL_NUMBER) 54. Imo_num (IMO_NUMBER): is the Lloyd's Registry "Register of Ships" 7-digit identification number. This is a unique number that has been assigned by Lloyd's Registry for the life of the vessel. Most vessels with an IMO number are self propelled, over 100 gross tons, and operate on ocean and/or coastwise waters. 55. Vage (VESSEL_AGE) 56. bld_shipyd (BUILD_SHIPYARD) 57. Bld_yr (BUILD_YEAR) 58. hull_party 59. completed 60. Hp_head (MAIN_AHEAD_HP) 61. Hp_astern (MAIN_ASTERN_HP) 62. Fore_type (FOREBODY_TYPE_DESC) 63. Hull_cnfg (HULL_CONFIGURATION): Values: Monohull, Trimaran, Catamaran, Unknown 64. Hull_shape (HULL_SHAPE): Box, Ship, Sail (Faired Keel), Sail (Distinct Keel) 65. filler