test Browse by Author Names Browse by Titles of Works Browse by Subjects of Works Browse by Issue Dates of Works

Advanced Search
& Collections
Issue Date   
Sign on to:   
Receive email
My Account
authorized users
Edit Profile   
About T-Space   

T-Space at The University of Toronto Libraries >
P. E. Hallett (2011) Farmed Solitary Bees & Wasps, Data Set (generations 1997-2008) >

11.03 Overview: the 'SOURCE' and 'COUNTS' files

Collection home page

or browse 
Subscribe to this collection to receive daily e-mail notification of new additions

Each locality is currently represented by two collections, named 'SOURCE' and 'COUNT'. 'SOURCE' spreadsheets are named by the equipment stand and the generation. An example of 'COUNTS' is the 'NEST_COUNT_BY_FATE' files which are pooled as the 'grand'   overview 'SUMMARY_OF_NEST_COUNTS_BY_FATE' of 11.01.

Example.  For Saugeen, the stand MID and generation 2005, there is the sheet 'MID05SOURCE' in 11.11; its summary counts appear as columns BA to BJ on the page 'MID' in 'SAUGEEN_NEST_COUNTS_BY_FATE' in 11.12.

Other 'COUNTS' are planned. For recent work see the various population in 11.09.

The SOURCE files for year 2004 onwards show, for each nest, counts of immatures at 6 survival stages. Only the later stages were counted in years 2001-3 and so SOURCE sheets for those years are offered in a conservative SOURCE_1 form, where missing counts are simply marked as such, and a SOURCE_0 form where the missing early stage counts are underestimated by simple extrapolation from later survival stages.

The 'SOURCE' sheets often show management information and logging dates (in YYYY.MM.DD or MM.DD formats) as 'titles' to each stack of nest blocks, because a stack was the smallest unit for fieldwork (for convenient sorting, stack titles are given dummy 'block row' numbers). Fieldwork dates and management issues may also appear in the 'SOURCE' sheet's 'dated events' and 'comment' columns.

The columns in a 'SOURCE' spreadsheet are titled. Most of the columns should be directly analyzable by spreadsheet, database, Python or R language methods.

As described in 04.10, 'SOURCE' columns  AD, CA, DX, FU and HR are 'dated events' columns (alias the 'dot segment' of 02.1 Glossary and the Python modules). As an experiment these columns have been expanded in the 'dotSOURCE' files for the JOKERS locality. The event codes are listed within 04.01; the dates follow the letter codes in YYMMDD format. 'Female on the nest' and 'eggs' are fairly brief and so well-dated events but most other events are dated after their start; for these other events only the earliest few dates for that stand or locality are relevant. The 'dotSOURCE' files are an interesting experiment but for the present it is less trouble to use Python to extract data from 'SOURCE' files into 'COUNT' files or similar (see 04.09).

The current intention, then, is not to create any more varieties of 'SOURCE' file for the 2001-8 period, but to rely on the 'SOURCE' files and Python programs. Other data occur in '05.0 Ancilliary data', '07.0 Manuscripts and analyses' (often pilot studies) and '08.03 Talks at Entomological Societies'. .

Recent Submissions


  No Submissions


RSS Feeds

RSS Feed
RSS Feed
RSS Feed