create table ge_coastal_risk(
PBKEY CHAR (12),
DC_NAME VARCHAR (40),
DC_CNTY CHAR (5),
DC_STATE CHAR (2),
DC_TYPE INTEGER,
DC_ADJNAME VARCHAR (40),
DC_ADJTYPE INTEGER,
DC_DIST FLOAT,
DC_WINDPOOL VARCHAR (40),
DC_HIST_CAT_I_SPEEDMIN INTEGER,
DC_HIST_CAT_I_SPEEDMAX INTEGER,
DC_HIST_CAT_I_WINDDEBRIS VARCHAR (70),
DC_HIST_CAT_II_SPEEDMIN INTEGER,
DC_HIST_CAT_II_SPEEDMAX INTEGER,
DC_HIST_CAT_II_WINDDEBRIS VARCHAR (70),
DC_HIST_CAT_III_SPEEDMIN INTEGER,
DC_HIST_CAT_III_SPEEDMAX INTEGER,
DC_HIST_CAT_III_WINDDEBRIS VARCHAR (70),
DC_HIST_CAT_IV_SPEEDMIN INTEGER,
DC_HIST_CAT_IV_SPEEDMAX INTEGER,
DC_HIST_CAT_IV_WINDDEBRIS VARCHAR (70),
DC_REC_CAT_I_SPEEDMIN INTEGER,
DC_REC_CAT_I_SPEEDMAX INTEGER,
DC_REC_CAT_I_WINDDEBRIS VARCHAR (70),
DC_REC_CAT_II_SPEEDMIN INTEGER,
DC_REC_CAT_II_SPEEDMAX INTEGER,
DC_REC_CAT_II_WINDDEBRIS VARCHAR (70),
DC_REC_CAT_III_SPEEDMIN INTEGER,
DC_REC_CAT_III_SPEEDMAX INTEGER,
DC_REC_CAT_III_WINDDEBRIS VARCHAR (70),
DC_REC_CAT_IV_SPEEDMIN INTEGER,
DC_REC_CAT_IV_SPEEDMAX INTEGER,
DC_REC_CAT_IV_WINDDEBRIS VARCHAR (70))