CREATE TABLE data_for_bitume_et_al_2024_biolcont_192_105489 (
"weatherstation" VARCHAR,
"weathersitecode" VARCHAR,
"weatherregionrepresented" VARCHAR,
"monitoringyear" VARCHAR,
"monitoringyearcode" DOUBLE,
"annualavgtmin" DOUBLE,
"annual_avgtmax" DOUBLE,
"totalannualprecipitationincm" DOUBLE,
"totalannualheatunits" VARCHAR,
"weathercity" VARCHAR,
"weatherregion" VARCHAR,
"year" DOUBLE,
"month" DOUBLE,
"monthlytotalprecipcm" DOUBLE,
"monthavgtmindegc" DOUBLE,
"monthavgtmaxdegc" DOUBLE,
"monthlytotal_heatunits" DOUBLE,
"region" VARCHAR,
"site" VARCHAR,
"plot" VARCHAR,
"cuttingtreatment" VARCHAR,
"n_2017pre_cutavgliveshootht" DOUBLE -- 2017Pre-cutAvgLiveShootHt,
"n_2017liveshootsacrossthreesubplots" VARCHAR -- 2017LiveShootsAcrossThreeSubplots,
"n_2017pre_cutliveshootdensityperm" DOUBLE -- 2017Pre-cutLiveShootDensityperm,
"n_2018countlivemarkedmsplot1year" DOUBLE -- 2018CountLiveMarkedMSPlot1Year,
"n_2018prolivemarkedmsplot1year" DOUBLE -- 2018ProLiveMarkedMSPlot1Year,
"n_2018sumlivemarkedmslengthplot1yearm" DOUBLE -- 2018SumLiveMarkedMSLengthPlot1Yearm,
"n_2018sumssonlivemarkedmsplot1year" DOUBLE -- 2018SumSSonLiveMarkedMSPlot1Year,
"n_2018ssdensperlivemarkedshootplot1year" VARCHAR -- 2018SSdensperLiveMarkedShootPlot1Year,
"n_2018ssdensperlivemarkedshootlengthplot1yearm" VARCHAR -- 2018SSdensPerLiveMarkedShootLengthPlot1Yearm,
"n_2018sumehonlivemsandssplot1year" DOUBLE -- 2018SumEHonLiveMSandSSPlot1Year,
"n_2018ehdensperlivemarkedshootplot1year" DOUBLE -- 2018EHdensperLiveMarkedShootPlot1Year,
"n_2018ehdensperlivemarkedshootlengthinmplot1year" DOUBLE -- 2018EHdensperLiveMarkedShootLengthinmPlot1Year,
"n_2022fiveyearavgliveshootht" DOUBLE -- 2022FiveYearAvgLiveShootHt,
"n_2022fiveyearliveshootsacrossthreesubplots" VARCHAR -- 2022FiveYearLiveShootsAcrossThreeSubplots,
"n_2022fiveyearliveshootdensityperm2" VARCHAR -- 2022FiveYearLiveShootDensityperm2,
"n_2022fiveyearwaspexitholedensityperm2" VARCHAR -- 2022FiveYearWaspExitHoleDensityperm2,
"n_2022fiveyearwaspexitholedensityperliveshoot" VARCHAR -- 2022FiveYearWaspExitHoleDensityperliveshoot,
"n_2022fiveyearwaspexitholedensitypermliveshootlength" VARCHAR -- 2022FiveYearWaspExitHoleDensitypermliveshootlength,
"year_1" BIGINT,
"region_1" VARCHAR,
"site_1" VARCHAR,
"surveypoint" BIGINT,
"twominuteexitholes" DOUBLE,
"twominutegalls" DOUBLE,
"region_2" VARCHAR,
"site_2" VARCHAR,
"trap" DOUBLE,
"n_2023totalwaspscaptured" VARCHAR -- 2023TotalWaspsCaptured,
"n_2023waspgalls2minsurvey" DOUBLE -- 2023WaspGalls2minsurvey,
"n_2023waspexitholes2minsurvey" DOUBLE -- 2023WaspExitHoles2minSurvey,
"doublecutsite" VARCHAR,
"doublecutplot" DOUBLE,
"doublecuttreatment" VARCHAR,
"numofmarkedshoots" VARCHAR,
"nummarkedliveateroneyear" DOUBLE,
"proportionmarkedliveafteroneyear" DOUBLE,
"totalnumofsideshootsacrossallmarkedmainshoots" DOUBLE,
"totallengthofsideshootsfrommarkedmainshoots" DOUBLE,
"sideshootspermarkedmainshoot" DOUBLE,
"summedlengthoflivemarkedmainshoots" DOUBLE,
"sideshootspermeterlengthoflivemarkedmainshoot" DOUBLE,
"totalwaspexitholesfound" DOUBLE,
"totalimmwaspfoundinsidesideshoots" DOUBLE,
"exitholeandimmwaspdensitypermarkedmainshoot" DOUBLE,
"exitholeandimmwaspdensitypermetermakedlivemainshootlength" DOUBLE
);