create table ge_wildfire(
PBKEY CHAR(12),
WR_ID CHAR(12),
STATE_ABBR CHAR(2),
FIPSCODE VARCHAR(15),
WR_CLS CHAR(1),
WR_MODEL CHAR(9),
RISKDESC CHAR(9),
RISK50 INTEGER,
SEVERITY INTEGER,
FREQUENCY INTEGER,
COMMUNITY INTEGER,
DAMAGE INTEGER,
MITIGATION INTEGER,
INTENSITY INTEGER,
CROWN_FIRE INTEGER,
WIND_SPD INTEGER,
EMBER_CAST INTEGER,
BURN_PROB INTEGER,
HIST_PERIM INTEGER,
PROB_IGNIT INTEGER,
LINE_DIST INTEGER,
STRUCTURE INTEGER,
W_ALIGN_RD INTEGER,
ACC_EGRESS INTEGER,
VEG_COVER INTEGER,
HIST_LOSS INTEGER,
I_AND_D INTEGER,
F_STN_DIST INTEGER,
WATER_DIST INTEGER,
TOPO_POS INTEGER,
BURNABLE INTEGER,
FPOBJECTID INTEGER,
FPACRES FLOAT,
FPAGENCY CHAR (15),
FPYEAR CHAR (4),
FPFIRENAME char (50),
FPDATE DATE,
DISTWUI FLOAT,
DISTHIGH FLOAT,
DISTVH FLOAT
)