Comparative Use Of Alnus, Betula, And Upright Salix Shrubs By Passerines In Above-treeline Regions Of Arctic And Subarctic Alaska

CREATE TABLE grids50m_all (
  "sa" BIGINT,
  "d_rtset1" DOUBLE,
  "d_rtset2" DOUBLE,
  "d_rtset3" DOUBLE,
  "near_rtset1" BIGINT,
  "near_rtset2" BIGINT,
  "near_rtset3" BIGINT,
  "near_rtid1" BIGINT,
  "near_rtid2" BIGINT,
  "near_rtid3" BIGINT,
  "rtset1_intersect" VARCHAR,
  "rtset2_intersect" VARCHAR,
  "rtset3_intersect" VARCHAR,
  "pixelid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "cellid" BIGINT,
  "d_rtset4" VARCHAR,
  "d_rtset5" VARCHAR,
  "near_rtset4" VARCHAR,
  "near_rtset5" VARCHAR,
  "near_rtid4" VARCHAR,
  "near_rtid5" VARCHAR,
  "rtset4_intersect" VARCHAR,
  "rtset5_intersect" VARCHAR
);

CREATE TABLE surveys2015_2024 (
  "sa" BIGINT,
  "studyarea" VARCHAR,
  "year" BIGINT,
  "route" VARCHAR,
  "cell_dategps" VARCHAR,
  "cellobs" BIGINT,
  "juldate" BIGINT,
  "visit" BIGINT,
  "gps" VARCHAR,
  "effort" DOUBLE,
  "time000" DOUBLE,
  "timeadjcakn" DOUBLE,
  "observerid" BIGINT,
  "noise" VARCHAR,
  "rt_dategps" VARCHAR,
  "rtvisit" VARCHAR
);