NDC Banner

NDC Home
Data
Back

U.S. Waterway Data Title
U.S. Coast Guard
Marine Casualty and Pollution Investigations
Data Dictionary


Description Table Name Size (bytes)
Casualty and pollution activities MisleActivities 67,517
Casualty or pollution at facility MisleFacilityEvents 11,281
Casualty or pollution on vessel MisleVslEvents 86,416
Detail information on Other events MisleOtherEvents 3,729
Detail information on injury MisleInjury 9,621
Detail on facility pollution MisleFacPoll 8,010
Detail on vessel pollution MisleVslPoll 13,066
Detail on other pollution MisleOtherPoll 6,906
Detail information on facilities MisleFacility 52,607

MisleActivities - contains common data for casualty and pollution activities in 2010.
There are 4618 records in this file.

In file activities these column definitions are:



 Column No       Type       Column_name              Length      

 ----------     -----       -----------              ------      

  1              int        activity_id                4        

  2              int        case_id                    4        

  3              varchar    incident_dt               10       

  4              varchar    dept_name                 80       

  5              varchar    activity_type             60       

  6              varchar    activity_status           60       

  7              varchar    activity_status_subtype   60       

 *8              numeric    vessel_property_damage     9  

 *9              numeric    cargo_property_damage      9  

*10              numeric    facility_property_damage   9  

*11              numeric    other_property_damage      9 

* New fields - added April 2009

MisleFacEvents - contains casualty or pollution incident on facility in 2010.
There are 509 records in this file.
Top

In file MisleFacEvents these column definitions are:



 Column No       Type       Column_name              Length       

  ----------     -----       -----------             ------      

   1             int        activity_id                 4        

   2             int        case_id                     4        

 **3             datetime   timeline_dt                 8       

  *4             int        fk_d_facility               4       

   5             int        msn_non_vessel_id           4        

  *6             varchar    facility_name               50       

  *7             varchar    facility_type               40       

   8             varchar    facility_activity_role_desc 50      

   9             varchar    waterway_name               50       

  10             varchar    event_type                  60       

  11             varchar    event_class                 60 

  12             varchar    event_subclass              60
  
  13             varchar    damage_status               50  

  14             varchar    latitude                     9       

  15             varchar    longitude                    9       
 
  * New fields - added January 2009
 ** New field - added July 2009 

MisleVslEvents - contains casualty or pollution incident on vessel in 2010.
There are 7,465 records in this file.
Top


In file MisleVslEvents these column definitions are:



 Column No       Type       Column_name              Length       

 ----------     -----       -----------              ------       

   1            int          activity_id               4       
   2            int          case_id                   4       
  *3            datetime     timeline_dt               8       
 **4            int	      fk_d_vessel	       4 
   5            int          vessel_id                 4 
 **6	        varchar	     vin		      30
 **7	        varchar	     vessel_name	      50
 **8  	        varchar	     vessel_service	      30
 **9	        varchar	     vessel_class	      50
 **10		varchar	     vessel_type	      50
 **11           varchar	     vessel_subtype	      50
 **12	 	varchar	     flag_desc	              30
   13           varchar	     vessel_activity_role_desc 50
   14           varchar      waterway_name             50 
   15           varchar      event_type                60
   16           varchar      event_class               60
   17           varchar      event_subclass            60
   18           varchar      damage_status             50
   19           numeric      latitude                   9
   20           numeric      longitude                  9

*  New field the actual date/time of the event - added May 2008
** New fields - added January 2009

MisleOtherEvents - contains other subject events in 2010.
There are 153 records in this file.
Top


In file MisleOtherEvents these column definitions are:



 Column No       Type         Column_name           Length       

 ----------     -----         -----------           ------       

 1		 int	        activity_id		4
 2		 int	        case_id			4
 3		 datetime       timeline_dt		8
 4		 int	        fk_d_other_subject      4
 5		 varchar        subject_name	      255
 6		 varchar        waterway_name	       50
 7		 varchar        event_type	       60
 8		 varchar        event_class	       60
 9		 varchar	event_subclass	       60
10		 numeric	latitude		9
11		 numeric	longitude		9

*New table – added January 2009

MilseInjury - contains a listing of reportable casualties and deaths occurring on a vessel in 2010
There are 666 records in this file.
Top


In file MisleInjury these column definitions are: 



 Column No       Type       Column_name                  Length       

 ----------      -----      -----------                  ------       

   1             int          activity_id                  4 
  *2             int          fk_d_vessel		   4
   3	         int	      vessel_id			   4
  *4		 varchar      vin			  30 
  *5	         varchar      vessel_name		  50
  *6		 varchar      vessel_service		  30
  *7		 varchar      vessel_class	          50
  *8		 varchar      vessel_type	          50
  *9		 varchar      vessel_subtype		  50
 *10             varchar      flag_desc			  30
 *11 		 varchar      vessel_activity_role_desc   50
 *12		 int	      facility_id                  4
 *13             varchar      facility_name	          50
 *14		 varchar      facility_type_desc          40
 *15    	 varchar      facility_activity_role_desc 50 
  16             varchar      relationship_type           80 
  17             varchar      waterway_name               50 
  18             varchar      accident_type               60 
  19             varchar      casualty_type_desc          30 
  20             numeric      latitude                     9 
  21             numeric      longitude                    9 

* New fields - added January 2009


  

MisleFacPoll - contains list of facilities pollution in 2010.
There are 216 records in this file.
Top

In file MisleFacPoll these column definitions are: 



  Column No       Type          Column_name                Length        

 ----------       -----         -----------                ------        

 1 		     int	  activity_id                   4 
 2 		     int	  case_id                       4 
*3		     int	  fk_d_facility	                4
 4		     int	  facility_id	                4
*5		 varchar          facility_name                50
*6	  	 varchar	  facility_type                40
 7		 varchar	  facility_activity_role_desc  50
 8 		 varchar   	  waterway_name                50 
 9 		 varchar          chris_cd                      3 
10		 varchar          substance_name              255 
11 		 varchar          substance_class              15 
12 		 varchar   	  substance_subclass           32
13	 	 varchar   	  substance_type              100 
14 		 varchar   	  substance_subtype           180 
15 		 numeric   	  latitude                      9 
16 		 numeric   	  longitude                     9 
17 		 numeric   	  discharge_amnt_total          9  
18 		 numeric   	  discharge_amnt_water          9
19 		 numeric   	  discharge_amnt_land           9
20 		 numeric   	  discharge_amnt_air            9
21 		 numeric   	  discharge_amnt_enclosed       9
22 		 numeric          potential_amnt_total          9
23 	         numeric   	  potential_amnt_water          9
24 		 numeric          potential_amnt_land           9
25 	         numeric          potential_amnt_air            9
26 		 numeric          potential_amnt_enclosed       9
27 		 numeric          contained_amnt                9
28 		 varchar          discharge_potential_type     20 
29 		 varchar   	  discharge_situation_type     50 
30 		 varchar          discharge_estimated_land     60
31 		 varchar          discharge_estimated_air      60
32 		 varchar          discharge_estimated_water    60
33 		 varchar          discharge_estimated_encl     60
34 		 varchar   	  potential_case	       60
35 		 varchar          potential_estimated          60
36 		 varchar   	  contained_estimated	       60
37 		 varchar         unit_of_measure               50
38 		 varchar         damage_status                 50

* New fields - added January 2009                    

MisleVslPoll - contains list of vessel pollution in 2010.
There are 368 records in this file.
Top


In file vessel_pollution these column definition are:



  Column No       Type       Column_name             Length        

 ----------       -----      -----------             ------        

   1             int        activity_id                  4        

   2             int        case_id                      4        

  *3             int        fk_d_facility                4
	
   4             int        vessel_id                    4       

  *5             varchar    vin                         30        

  *6             varchar    vessel_name                 50       

  *7             varchar    vessel_service              30        
	
  *8		 varchar    vessel_class                50

  *9             varchar    vessel_type                 50        

 *10             varchar    vessel_subtype              50       

 *11             varchar    flag_desc                   30        

  12             varchar    vessel_activity_role_desc   50        

  13             varchar    waterway_name               50        

  14             varchar    chris_cd                     3        

  15             varchar    substance_name             255        

  16             varchar    substance_class             15       

  17             varchar    substance_subclass          32  

  18             varchar    substance_type             100  

  19             varchar    substance_subtype          180

  20             numeric    latitude                     9  

  21             numeric    longtitude                   9  

  22             numeric    discharge_amnt_total         9  

  23             numeric    discharge_amnt_water         9  

  24             numeric    discharge_amnt_land          9  

  25             numeric    discharge_amnt_air           9  

  26             numeric    discharge_amnt_enclosed      9  

  27             numeric    potential_amnt_total         9  

  28             numeric    potential_amnt_water         9        

  29             numeric    potential_amnt_land          9        

  30             numeric    potential_amnt_air           9        

  31             numeric    potential_amn_enclosed       9        

  32             numeric    contained_amnt               9        

  33             varchar    discharge_pontential_type   20        

  34             varchar    discharge_situation_type    50        

  35             varchar    discharge_estimated_land    60        

  36             varchar    discharge_estimated_air     60        
  
  37             varchar    discharge_estimated_water   60
  
  38             varchar    discharge_estimated_encl    60

  39             varchar    potential_case              60

  40             varchar    potential_estimated         60

  41             varchar    contained_estimated         60

  42             varchar    unit_of_measure             50        

  43             varchar    damage_status               50        

  * New fields - added January 2009  

MisleOtherPoll - contains the information on other pollution in 2010.
There are 107 records in this file.
Top

In file Milse_Other_Sources_Pollution these column definitions are:

 

  Column No       Type       Column_name              Length        

 ----------       -----      -----------              ------        

   1             int        activity_id                  4        

   2             int        case_id                      4        

   3             int        other_id                     4        

   4             varchar    subject_name               255
   
   5             varchar    wataerway_name              50       

   6             varchar    chris_id                     3        

   7             varchar    subject_name               255        

   8             varchar    substance_class             15       

   9             varchar    substance_subclass          32        

  10             varchar    substance_type             100        

  11             varchar    substance_subtype          180        

  12             numeric    latitude                     9        

  13             numeric    longitude                    9        

  14             numeric    discharge_amnt_total         9        

  15             numeric    discharge_amnt_water         9        

  16             numeric    discharge_amnt_land          9        

  17             numeric    discharge_amnt_air           9 

  18             numeric    discharge_amnt_enclosed      9  

  19             numeric    potential_amnt_total         9  

  20             numeric    potential_amnt_water         9  

  21             numeric    potential_amnt_land          9  

  22             numeric    potential_amnt_air           9  

  23             numeric    potential_amnt_enclosed      9  

  24             numeric    contained_amnt               9  

  25             varchar    discharge_potnetial_type    20  

  26             varchar    discharge_situation_type    20  

  27             varchar    discharge_estimated_land    60  

  28             varchar    discharge_estimated_air     60        

  29             varchar    discharge_estimated_water   60        

  30             varchar    discharge_estimated_encl    60        

  31             varchar    potential_case              60        

  32             varchar    potential_estimated         60       

  33             varchar    contained_estimated         60        
  
  34             varchar    unit_of_measure             50        

MisleFacility - this file provides detail information on facilities in 2007
There are 47,038 records in this file.
Top

In file Facilities these column definitions are:



 

  Column No       Type       Column_name              Length        

 ----------       -----      -----------              ------        

   1              int        gk_d_facility               4        

   2              int        msn_non_vessel_id           4        

   3              varchar    facility_name              60        

   4              varchar    facility_type_desc         40        

   5              varchar    facility_subtype_desc      80        

   6              varchar    facility_state_abbr         2        

   7              varchar    nav_hazard_desc            30        

   8              varchar    pollution_source_desc      30        

   9              varchar    public_safety-risk_desc    30 
   
  10              varchar    primary_id-type-desc       30    

  11              varchar    primary_id                 30        
  
  12              numeric    latitude                    9        

  13              numeric    longitude                   9        

  14              varchar    manned_platform_desc       30        

  15              varchar    helo_deck_facility_desc    30        

  16              varchar    inspected_facility_desc    30        

  17              numeric      current_ind               5       


TopContact for Additional Information:
U.S. Coast Guard (CG-5453)
2100 Second Street, S.W.
Washington, DC 20593-7581
Point of Contact: Dawn Patterson
Tel: (202)-372-1282
Fax: (202)-372-1922
E-mail: dawn.patterson@uscg.mil