1	What’s inside the building envelope? Bugs A Practical Approach to Managing Pest Control Data Rachael Perkins Arenstein, Aaron Crayne, Neil Duncan, Lisa Kronthal, Athena LaTocha, Scott Merritt, Chris Norris & George Ramos
2	OBJECTIVES Record the results of pest trapping Associate results with building features Doors Windows Gaps or cracks in walls, floors Map results onto building floor plans Relate to environmental preferences of pest species
3	FIRST IDEA: Aperture Computer Assisted Design (CAD) & Information Management program PROS Used by AMNH construction Has floor plans for whole Museum Powerful underlying database to store results
4	FIRST IDEA: Aperture CONS Very expensive Requires trained operator Not very visual
5	SECOND IDEA: Use ‘off-the-shelf’ database software Cheaper Easier to use Likely to be more widely used
6	FINAL CHOICE Microsoft Access Widely available in AMNH Widely available to other institutions Experienced in its use Reasonably priced
7	What information is collected? What was caught? Species, life stage, pest or predator When was it caught? Trap surroundings? Near walls, doors, windows, specimens, inside cabinets, etc. What does it tell us? Environmental preferences
8	How do we query? Date of capture Species Environmental preferences Room Trap Room features
9	How did we want to display results? Visually on a floor plan Grid Traps Colors Visually using charts Proportional (e.g. pie chart) Quantified (e.g. bar chart, column chart) Raw data in tables
10	Solution! Pest Manager Database Access Database Data queried via form Query results displayed as… Embedded bitmap floor plan Column chart (generated using MS Excel) Data table
11	TRAP INFORMATION
12	PEST EVENTS
13	Querying the data
14	Displaying results: Floor Plans
15	Displaying results: Column Charts
16	Displaying results: Data Table
17	Pilot Study Department of Mammalogy Building 17 Self-contained facility 5 collection rooms Prep lab & dermestid colony Problematic HVAC system 109 traps 20 months of data
18	Experiences so far Time intensive to collect data Trap placement & pick-up Identification of captured insects Inputting data into database Database has helped to pin-point localized problems
19	Mold Problems in Building 17
20	Setting up traps
21	Placing traps
22	Picking up traps
23	Giant Mosquito
24	TRANSITION
25	Research Branch (RB) Bronx, NY
26	OUTLINE History of Research Branch facility Collaboration with AMNH Database modifications Bar coding & scanning Image database Future developments
27	RB Facility
28	SYSTEM I: Lists & Tables
29	SYSTEM II: Transparencies
30	SYSTEM III: Excel Spreadsheet Used at RB & CRC Categorizes captures Occasional invaders Environmental indicators Museum pests
31	Bon Voyage
32	Collaboration on Pest Manager Database NMAI committed to: Troubleshooting & adapting program Developing barcoding data entry system Creating image database
33	Adaptation of PMD to NMAI Data
34	Revising NMAI Floor Plans for Import
35	Modified Graphics
36	Time Trials Recorded times for bi-monthly monitoring Retrieving traps Making & Placing new traps Identifying captures Inputting data 19.5 hours average with Excel spreadsheet 16 hours average with PMD
37	Barcodes & Scanning
38	What is a barcode?
39	Barcode Symbologies
40	Barcode Density
41	How readers work
42	Scannable fields in pest events screen Trap name Pest common name Quantity Lifestage Dust Cover
43	In Lab Pros Microscope Good lighting More space to work Cons Less convenient More time consuming? Risk of something crawling off trap
44	In-Situ Pros Convenient Fast Less messy Cons Poor lighting Lower magnification Possibly less accurate Less space to work
45	Portable Pocket PC Compaq iPAQ 3630 $600 ISC Socket in-hand scan card attachment & accessories $350 Pros portable Cons Hard to direct laser Added extra step
46	WAND READER Wasp Bar Code Wand Reader & Decoder $100 Wasp Bar Code USBi interface $80 Pros Reasonably priced Cons Low resolution Unreliable scans
47	Laser SCANNER Symbol LS400i Triggered Laser Scanner $350 650 nm laser & working range of 16 in. Pros Quick & easy to use Cons Expensive Features like good working range unnecessary
48	CCD SCANNER Symbol CCD (charge coupled device) scanner $ Pros Quick & easy to use despite limited depth of field Reasonably priced
49	Goals for Barcoding Create a worksheet for common entries Self-adhesive barcode labels for sticky traps
50	Choice of symbology Code 39 Pros Widely used and supported by readers Cons Less dense – longer barcodes Does not always support full character set Code 128 Pros Capable of high density barcodes Supports full ASCII 128 character set Cons Not readable by all scanners
51	Free? shareware software
52	Avery Design Pro Deluxe
53	WASP Fontware
54	Sticky Trap Labels
55	Extensis Portfolio Image Database
56	Searchable fields
57	Associated metadata
58	THE PROSCOPE USB Microscope
59	Magnification & Imaging
60	CONCLUSIONS PMD has allowed for… Associated data to explain context of pest captures Increasing data manageability Better visualization of trends Customizable for different facilities
61	Future Development? Survey of interest in databases for pest management IPM list serve for discussion and updates on future developments Send e-mail to listserve@zaks.com In body of message type “subscribe pmd your_full_name”