{ TABLE "nilsson".us_all2 row size = 271 number of columns = 26 index size = 12 }
create table "nilsson".us_all2 
  (
    arc_status_flag smallint not null constraint "nilsson".n298_9402,
    arc_identifier serial not null constraint "nilsson".n298_9403,
    name char(64),
    min_x_axis_coord float not null constraint "nilsson".n298_9404,
    max_x_axis_coord float not null constraint "nilsson".n298_9405,
    min_y_axis_coord float not null constraint "nilsson".n298_9406,
    max_y_axis_coord float not null constraint "nilsson".n298_9407,
    reach_num char(11) not null constraint "nilsson".n298_9408,
    huc char(8) not null constraint "nilsson".n298_9409,
    type char(1) not null constraint "nilsson".n298_9410,
    segment_length float,
    miles_terminus float,
    sum_drain_length float,
    primary_name char(30),
    primary_code char(11),
    open_water_name char(30),
    open_water_code char(11),
    down_reach_num char(11) not null constraint "nilsson".n298_9411,
    down_huc char(8) not null constraint "nilsson".n298_9412,
    up_direction char(1),
    stream_level smallint,
    down_junct_code smallint,
    terminal_id integer,
    terminal_base_lev smallint,
    divergence_code smallint,
    sequence_num char(11) not null constraint "nilsson".n298_9413,
    unique (arc_identifier) constraint "nilsson".u298_9401
  );
revoke all on "nilsson".us_all2 from "public";





