Westwide Weather and Avalanche Database Structure

S is a number (No decimal point)

N is a number (decimal point+ )

Axx is a string xx characters long (it can be less but not more.)

Strings can have quote marks at each end, optional

All fields have a , (comma) seperating them.

AVALANCHE TABLE
Field Name                 Field Type
-------------------------  ----------
Station                    S*
Date                       D*
Time                       S*   
Path Name                  A25*        
Path Number                S  
Control Measures-Type      S    
Control Measures-Count     S
Control Measures-Occur     S   
Type                       A2 
Trigger                    A2
Size                       S
Surface                    A1
Airblast                   A1
Motion                     A1
Depth                      S
Layers                     A1
Percent                    S
Start Vert                 A1
Start Horiz                A1
Elevation                  S      
Aspect                     S      
Vertical                   S
Debris                     A1
Road Depth                 S
Road Length                S
Caught                     S
Buried                     S
Injured                    S
Killed                     S
Cars Buried                S
Cars Damaged               S
Buildings                  S
Lifts                      S
Misc.                      S
Comments                   A120  


WEATHER TABLE
Field Name                 Field Type
-------------------------  ----------
Station                    S*
Date                       D*
Time                       S  
MaxTemp                    S   
MinTemp                    S  
Temp                       S
SnowTemp                   N  
Total                      N
New                        N
H20                        N
Rain                       N
Int0-6                     S  
Int6-12                    S
Int12-18                   S   
Int18-24                   S   
Dir0-6                     S  
Spd0-6                     S   
Dir6-12                    S
Spd6-12                    S
Dir12-18                   S
Spd12-18                   S  
Dir18-24                   S
Spd18-24                   S
OneHourDir                 S
OneHourSpd                 S   
TestSki                    S
AMHaz                      S
PMHaz                      S 
Closure                    S    
Comments                   A120