** all fields in metric units where applicable.

CREATE TABLE PIT_TABLE

(

PIT_DATA LONGTEXT,

AIR_TEMP DECIMAL(3, 1),

ASPECT SMALLINT,

CROWN_OBS BOOL,

OBS_DATE DATE,

TIMESTAMP DATE,

INCLINE SMALLINT,

LOC_NAME TEXT,

LOC_ID TEXT,

STATE TEXT,

RANGE TEXT,

LAT DECIMAL(6, 4),

LONGITUDE DECIMAL(7, 4),

NORTH BOOL,

WEST BOOL,

ELEVATION INT,

USERNAME TEXT,

WINDLOADING BOOL,

HASLAYERS BOOL,

PIT_NAME TEXT);

CREATE TABLE OCC_TABLE

(

OCC_DATA LONGTEXT,

OBS_DATE DATE,

TIMESTAMP DATE,

ELV_START INT,

ELV_DEPOSIT INT,

ASPECT SMALLINT,

TYPE TEXT,

TRIGGER_TYPE TEXT,

TRIGGER_CODE TEXT,

US_SIZE TEXT,

CDN_SIZE DECIMAL(2, 1),

AVG_FRACTURE_DEPTH INT,

MAX_FRACTURE_DEPTH INT,

WEAK_LAYER_TYPE TEXT,

WEAK_LAYER_HARDNESS TEXT,

SNOW_PACK_TYPE TEXT,

FRACTURE_WIDTH INT,

FRACTURE_LENGTH INT,

AV_LENGTH INT,

AVG_START_ANGLE SMALLINT,

MAX_START_ANGLE SMALLINT,

MIN_START_ANGLE SMALLINT,

ALPHA_ANGLE SMALLINT,

DEPTH_DEPOSIT INT,

LOC_NAME TEXT,

LOC_ID TEXT,

STATE TEXT,

RANGE TEXT,

LAT DECIMAL(6, 4),

LONGITUDE DECIMAL(7, 4),

NORTH BOOL,

WEST BOOL,

USERNAME TEXT,

NAME TEXT);