CREATE TABLE ingest (
  title varchar(255),
  ocode varchar(50),
  mapname varchar(255),
  state varchar(50),
  refcode varchar(50),
  w_b_coord double,
  e_b_coord double,
  n_b_coord double,
  s_b_coord double,
  year int(11),
  begin date,
  end date,
  mbytesize_tif integer,
  bytesize_browse int(11),
  bytesize_thumb int(11),
  assigned_terms varchar(255),
  subject_related_text varchar(255),
  alltext varchar(255),
  local_call_num VARCHAR


);