Data From: Establishment And Dispersal Of The Armored Scale Rhizaspidiotus Donacis For Biological Control Of Arundo Donax In Northern California.
Department of Agriculture
@usgov.usda_gov_data_from_establishment_and_dispersal_of_the__5572932f
Department of Agriculture
@usgov.usda_gov_data_from_establishment_and_dispersal_of_the__5572932f
CREATE TABLE metadata_moran_et_al_2025_arundo_armored_scale_establi_3247235d (
"column_name" VARCHAR,
"explanation" VARCHAR
);
CREATE TABLE n__moran_et_al_2025_arundo_armored_scale_establishment_f7258015 (
"stationweatherdata" VARCHAR,
"stationid" VARCHAR,
"armored_scale_release_sites_represented_by_this_station" VARCHAR,
"year" DOUBLE,
"annextrememintemp" DOUBLE,
"avgdailymintemp" DOUBLE,
"avgdailymaxtemp" DOUBLE,
"annextrememaxtemp" DOUBLE,
"totannprecipcm" DOUBLE,
"sitenameforlocation" VARCHAR,
"latitude" DOUBLE,
"longtiude" DOUBLE,
"habitat" VARCHAR,
"soiltype" VARCHAR,
"scale_sourcecode" DOUBLE,
"year_released" DOUBLE,
"numberofreleaseplotsatsite" DOUBLE,
"microplantsperplot" VARCHAR,
"plotsselectedfordispersalstudy" VARCHAR,
"siteforstestablishmentstudy" VARCHAR,
"yearofrelease" DOUBLE,
"plotforstestab" VARCHAR,
"plotcuttingtreatmentst" VARCHAR,
"femalescollectedstestab" DOUBLE,
"crawlersproducedstestab" VARCHAR,
"plotcodeifusedfordispersalstudy" VARCHAR,
"hadfemales" VARCHAR,
"ifnodistancetoclosestplotwithfemales_m" VARCHAR,
"ifnofemalesinthatplot" VARCHAR,
"ifnocrawlersinthatplot" VARCHAR,
"sitewideproportionofplotswfemales" VARCHAR,
"sitewideproportionofplotswcrawlers" VARCHAR,
"sitewidetotfemalesstestab" DOUBLE,
"sitewidetotcrawlersstestab" VARCHAR,
"sitewidetotcrawlersperfemalestestab" VARCHAR,
"siteforltestablishementstudy" VARCHAR,
"plotforltestab" VARCHAR,
"plotcuttingtreatmentlt" VARCHAR,
"numberofnodesassessedinplotlt" VARCHAR,
"numberofnodeswfemalescalelt" DOUBLE,
"proportionofnodeswithadultfemaleslt" VARCHAR,
"longtermestablishmentinplotlt" VARCHAR,
"plotcodeifusedfordispersalstudy_1" VARCHAR,
"proportionofplotspersiteassessedwithfemalesonnodeslt" VARCHAR,
"sitewidtotalenodesexaminedlt" DOUBLE,
"sitewideproportionofpositivenodespersitelt" DOUBLE,
"nondeltasitestlt" VARCHAR,
"estabsitestlt" VARCHAR,
"estabplotstlt" VARCHAR,
"estabcuttechniquestlt" VARCHAR,
"oneormultmpsstlt" VARCHAR,
"stestabyn" VARCHAR,
"ltestabyn" VARCHAR,
"sitedispersal" VARCHAR,
"dispersaltransect" VARCHAR,
"distanceondispersaltransect_m" BIGINT,
"pronodespositivedispersal" DOUBLE,
"numberofnodespickedforfemalecollectiondispersal" BIGINT,
"sumfemalescollecteddispersal" VARCHAR,
"sumcrawlersproduceddispersal" DOUBLE,
"crawlersperfemaledispersal" VARCHAR,
"densfemaleperdissectednodedispersal" VARCHAR,
"sitedispersalsummary" VARCHAR,
"dispersaltransectplotsummary" VARCHAR,
"numberofdistanceschecked" DOUBLE,
"totnodesexaminedontransect" DOUBLE,
"totnodesexaminedatdistwfemonly" DOUBLE,
"numposnodestransect" DOUBLE,
"pronodesbytransect" DOUBLE,
"pronodesbytransectdistwfemonly" DOUBLE,
"weekscheckedforcrawlers" DOUBLE,
"totfemalesisolatedalldist" DOUBLE,
"totcrwproducedalldist" DOUBLE,
"crwperfemalealldist" DOUBLE,
"avgcrwperfemalenonzeroonly" DOUBLE,
"sdavgcrwperfemale" DOUBLE,
"seavgcrwperfemale" DOUBLE,
"maxdistwithreprofemale" DOUBLE,
"dispersalperyrsincereleasereprofemalesonly" DOUBLE,
"maxdistwithfemale" DOUBLE,
"dispersalperyrsincerelease" DOUBLE,
"crwperfematmaxdistwithrepro" DOUBLE,
"maxdistchecked" VARCHAR,
"arundolim" VARCHAR,
"yearrel" DOUBLE,
"yearsandscalegenerationsfromreleasetodispersalstudy2024" DOUBLE
);
Anyone who has the link will be able to view this.