Street Tree Inventory - 1990s

CREATE TABLE table_1 (
  "trees_id" BIGINT,
  "trees_id2" VARCHAR,
  "tr_rec" DOUBLE,
  "locarea" VARCHAR,
  "locunit" BIGINT,
  "locsubunit" VARCHAR,
  "locsite" BIGINT,
  "spp" DOUBLE,
  "common" VARCHAR,
  "botanical" VARCHAR,
  "on_strt" VARCHAR,
  "from_strt" VARCHAR,
  "to_strt" VARCHAR,
  "gisno" DOUBLE,
  "ext" VARCHAR,
  "area" VARCHAR,
  "treeloc" VARCHAR,
  "dbh" VARCHAR,
  "inv_date" VARCHAR,
  "drgmapname" VARCHAR,
  "drglayer" VARCHAR,
  "drgxcoord" DOUBLE,
  "drgycoord" DOUBLE,
  "x_original" DOUBLE,
  "y_original" DOUBLE,
  "dir" VARCHAR,
  "des_spp1" DOUBLE,
  "trunks" VARCHAR,
  "ht" VARCHAR,
  "cond" VARCHAR,
  "mt" VARCHAR,
  "pest" VARCHAR,
  "veg" VARCHAR,
  "wellstat" VARCHAR,
  "wellcov" VARCHAR,
  "guard" VARCHAR,
  "ut" VARCHAR,
  "utob" VARCHAR,
  "cd" DOUBLE,
  "dist" VARCHAR,
  "tg_pg" DOUBLE,
  "tg_coord" VARCHAR,
  "cmap" VARCHAR,
  "hd" VARCHAR,
  "grow" DOUBLE,
  "hist_id" VARCHAR,
  "exp_id" VARCHAR,
  "up_date" VARCHAR,
  "staff" VARCHAR,
  "un" DOUBLE,
  "blsd" DOUBLE,
  "download" VARCHAR,
  "notes" VARCHAR,
  "city_name" VARCHAR,
  "blsdval" DOUBLE,
  "mdist" VARCHAR,
  "growmatl" VARCHAR,
  "growsize" VARCHAR,
  "growtype" VARCHAR,
  "type" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "utdescription" VARCHAR,
  "utdescription_other" VARCHAR,
  "curb" VARCHAR,
  "stock_size" VARCHAR,
  "sidewalk" VARCHAR,
  "trees_street_id" DOUBLE,
  "date_root_prune_curb" VARCHAR,
  "date_root_prune_driveway" VARCHAR,
  "date_root_prune_sidewalk" VARCHAR,
  "note_id" VARCHAR,
  "location_1" VARCHAR
);