FishSuite Software for annotating, photographing, tracking, and reporting on physiological condition. FishSuite! has 5 platforms that expedite annotation, photographing, tracking, data entry, and reporting of biological data. The programs facilitate the documentation of fish physiological condition for several applications such as collection, tagging, and laboratory-based studies. FishBooth! documents the surgical procedures, effect of surgery including incisions and wound closing outcomes, external and internal condition, wound healing, and other activities. Since 2010, FishBooth! has catalogued over 120,000 photos of fish and surgical incisions. Fisheye! is an integrated recording system used to document thousands of injuries, maladies, and other meta-data that was subsequently stored in a relational database management system (RDBMS). FishNote! mines the FishBooth! image files for meta-data and the FishEye! RDBMS to merge and produce reports in .doc, .ppt, or .csv file format. In addition, FishNote! can query and integrate .csv P3 (PTAGIS) data. For holding and release activities, another set of programs, FishBucket! and FreeWilly!, can be used to identify and document the assigned tags implanted in the fish, assign a holding vessel, and track fish and vessels to release locations via GPS (including time and date). All applications are built to work independently or in concert with each other.
1 of 24
More Related Content
2013 ICEEFP FishSuite_Christa Woodley
1. CHRISTA M. WOODLEY, AARON PHILLIPS, BRIAN
LAMARCHE, NATHAN TRIMBLE, AND MARK WEILAND
July 14, 2013 1
Pacific Northwest National Laboratory
ICEEFP Annual Meeting, 2013
FishSuite!
Software for annotating, photographing,
tracking, and reporting on fish and
physiological condition
2. Monitoring Program Challenges
Since 2004 the Juvenile Salmon Acoustic Telemetry System (JSATS)
has been used to study salmon and lamprey survival and passage in
the Columbia River basin
In 2012, over 72 days (April-July) 25,850 fish were tagged and released
during 448 events.
Between 0.5 and 1 petabyte of data are collected each year, from at
least 8 locations and processed at 4 locations
Studies of this size pose challenges for data management, collection,
and processing.
Biological Opinion needs
Linked data
Project protocols
Assess fish condition 2
3. Why FishSuite!
Data automation
Faster photography to reduce stress on fish
Reduce to eliminate technological and data entry errors
Increase number of quality control checks
Photo log with retrievable metadata
Survival model assumptions
BiOp records
Long-term searchable data recall
Integration and reporting
July 14, 2013 3
4. FishSuite!
Multi-level fish condition assessments were used to quantify fish
health as a variable for survival and passage studies
FishSuite is a novel and user-friendly tool to collect and coordinate
metadata, fish condition and tagging activities
FishSuite is a series of software programs that expedites
annotation, photographing, tracking, and reporting data for tagging
studies
Programs operate independently or as a suite; and interface with
touchscreen monitors, digitizer boards and balances
Code for each application is shared in a central library for maximum
return on investment
July 14, 2013 4
6. FishBooth! Imagery Program
Records:
Images by assigning PIT, JSATS AT, GUID, or text strings
Image location or description (left, right, wound, etc.)
Species, Surgeon, Location
Date and Time
Metadata embedded in JPEG EXIF fields
FishBooth! Editor manages EXIF data
Utilities:
Canon EOS DSLR
BioMark FS2001 and antenna
Hope Industries Industrial Touchscreen
Hands-free using web cameras
Over 120K photographs taken since 2010
6
9. FishEye! Morphological and Physiological
Database Program
Records Real-time input (SQL, exportable .csv)
Injury and health observations
Location, Observer, Treatment, Species, Date and Time
QR coded samples
Programmable:
User-based template system
Count, Severity, Binary
Identification PIT, JSATS AT, GUID, or text strings
Utilizes:
BioMark FS2001 Reader and Antenna
Digitizer databoard (FL and other metadata)
Ohaus scale
Motorola handheld scanner
Hope Industrial Touchscreen 9
10. July 14, 2013 10
FishEye! Morphological and Physiological
Database Program
11. July 14, 2013 11
FishEye! Morphological and Physiological
Database Program
12. July 14, 2013 12
FishEye! Morphological and Physiological
Database Program
13. FishNote! Reporting Program
Generates reports
Powerpoints
PDFs
Excel spreadsheets
Searches
Imagery, Metadata, SQL
FishBooth!
FishEye!
Uses
GUID
PIT or JSATS AT
July 14, 2013 13
16. QR Coding
July 14, 2013 16
QR codes are double-coded with readable text
Location, Continuous Sample Number, Treatment, Day
Sample Number, Tissue Type
Release Code, Release Time, Day/Night, Bucket Number
17. Fish Bucket! Tag Accounting Program
Records
Count tags (fish) in holding container
Verify tags in holding container
Associated tags to barcode (holding container) reader
Utilities
PIT reader and wand
Barcode reader
17
19. Free Willy! Location Tracking Program
Records:
Bucket release barcode
Location (GPS) of each use
Date and time of transfer and release
Utilities
Mobile rugged platform (Windows CE 6.5)
Opticon H21
July 14, 2013 19
20. July 14, 2013 20
Free Willy! Location Tracking Program
22. Conclusions
Developed a software suite to assist fisheries researchers and
professionals in biological and environmental assessments
FishSuite!
Reduced labor costs
Minimized tracking, tagging, and entry errors
Tracked condition more than 50K juvenile salmon with centralized
database
Other applications
Off shore and coastal environmental and biological assessments
Aquaculture
July 14, 2013 22
23. Acknowledgements
USACE Portland District
Brad Eppard
PNNL Staff
Tom Carlson
Katie Wagner
Shon Zimmerman
Eric Fischer
Amanda Bryson
Rhonda Karls
Kathleen Carter
Pacific States Marine Fisheries
Commission (PSMFC)
Scott Carpenter
Kasey Knox