https://openprairie.sdstate.edu/oak-lake_presentations/1003/thumbnail.jp

Nilson, Ashlee

Troelstrup, Nels H., Jr.

English

Public Research Access Institutional Repository and Information Exchange

South Dakota State UniversityOpen PRAIRIE: Open Public Research Access InstitutionalRepository and Information ExchangeOak Lake Field Station 30th Anniversary Retreat Presentations2019South Dakota Aquatic Invertebrate Collection andDatabaseAshlee NilsonNels H. Troelstrup Jr.Follow this and additional works at: https://openprairie.sdstate.edu/oak-lake_presentationsPart of the Biodiversity Commons, Entomology Commons, and the Systems Biology CommonsSOUTH DAKOTA AQUATIC INVERTEBRATE COLLECTION & DATABASEASHLEE NILSON AND NELS H. TROELSTRUP, JR.Helophorus sp. C1D4T1V1GVALUE OF NATURAL HISTORY COLLECTIONS▪ Baseline inventory of aquatic invertebrate distributions throughout South Dakota▪ Support of state biodiversity programs▪ Support of state water quality monitoring and assessment needs• Can’t monitor something we don’t know exists• Can’t establish observed/expected ratios if we don’t know what is there• Q/A of biological assessments▪ Support of systematics and biodiversity research programs in and outside of South Dakota▪ Project initiated in early 2008▪ Database design manipulated and modified through first year▪ Scope, camera, cabinets acquired▪ Pilot database of 105 vouchers created in SPECIFY 5.3▪ We are now using SPECIFY 6.7.01▪ The collection has nearly 6000 entries, with ~1000 waiting upload and ~500 which need completion▪ Backlog of vouchers remain to be curatedPROJECT OVERVIEWTHE CURATION PROCESSVouchers Received and InventoriedAssociated Metadata InventoriedDatabase Information EnteredSpecimens Measured and CountedSpecimen Pictures TakenSpecimens Transferred to VialsSpecimen Labels PrintedCurated Specimens Placed in Cabinet423156▪ Average specimens/ voucher = ~5 (40,422 specimens)▪ Total Complete in Specify: 5842 vouchers▪ Total Complete in Specify waiting upload: 6841▪ Total entered in Excel, not complete: 589▪ Total Number of Vials and Slides: 7431WHAT WE CURRENTLY HAVE…PlanorbidaeC1D3T1V2JTHE SPECIFY PROJECT• SPECIFY is a collections database package• Originally funded by NSF• Has now transformed into a consortium• Designed and supported through University of Kansas• Now in version 7• No cost for package• No cost for upgrades• Allows different permission levels• Allows multiple collections to be managed within one database packagehttp://specifysoftware.org/Screen shot of the SPECIFY workbench where collection records are edited and added to the database. Data can be imported from EXCEL into workbench and then into the database.  Taxonomy in SPECIFY is cross-checked against the ITIS database.A taxonomic tree of specimens in the database can be quickly generated. OTHER DATABASE FUNCTIONS• Reports tracks loans and labels created in Specify• Interactions can create and keep a record of loans from the collection• Statistics and charts can be generated within Specify, this pie chart, generated by specify, is of the top 5 Species counts in Specify• Query tool allows a user to search the collection for specific criteria, which can then be used to generate reports. Queries can be saved for future reference. • Batch editing can modify thousands of records at once with the click of a mouse. Example screen shot of Google Earth (within SPECIFY) showing the point distribution of every Class in the existing collection. Each point represents where a sample was collected and what Class was collected there. Specify is designed to show selected data directly into Google Earth. FUNDING• The aquatic Invertebrate collection is the only Natural History collection on campus that is supported by state agencies• They have supported the project since its founding 10 years ago• These agencies give grants to fund the maintenance required to curate the collection• The University does not provide funding for this collection SPECIFY 6▪ Stand alone software▪ Software must be installed on a computer▪ Not available from the field▪ Can set administrative privilege to control who can add or edit data▪ Currently state agencies do not have access to the database because security updates wipe the information from computersSPECIFY 7▪ Data is hosted on a server▪ Available on any device with internet, can access the database from the field▪ Can set administrative privilege to control who can add or edit data▪ Uses Specify 6 features to work▪ Security updates will not be an issueSPECIFY 7ACKNOWLEDGMENTSWe thank: South Dakota Game, Fish and Parks as well as the South Dakota Department of Environment and Natural Resources for their continued support and dedication to this project; SPECIFY for assisting us in the process of developing the database, and transferring it online to be accessible to all agencies; and the South Dakota Agricultural Experiment Station for supporting faculty time as well as providing the equipment necessary to continue this project.Special thanks are extended to Oak Lake Field Station for providing its continued support of this project as well as the faculty and students who have worked on it. 

South Dakota Aquatic Invertebrate Collection and Database

https://openprairie.sdstate.edu/cgi/viewcontent.cgi?article=1003&amp;context=oak-lake_presentations

South Dakota Aquatic Invertebrate Collection and Database

Abstract

Similar works

Full text

Available Versions

Public Research Access Institutional Repository and Information Exchange