Keywords
ABCD standard
Darwin Core
database structure
conversion
validation
IT system
import
iconography
backups
How to Cite
Number of views: 16
Number of downloads: 5
Abstract
This paper describes the procedures and operational aspects related to the proper storage and handling of taxonomic, biogeographic and ecological data of biological specimens digitised under the AMUNATCOLL project. In the introductory phase of this process, the definition of the metadata is carried out, which is the formal handler of the structure, based upon the analysis of existing standards. The set of parameters derived from the standard is extended by data that is important according to the point of view of the specificity and functionality of the developed system. Subsequently, the database, as a key element in many IT systems, must be set up for data storage along with the suitable structure that reinforces efficiency. The process of preparing and casting a large amount of data requires automated procedures with dedicated tools attached. These approaches address a variety of processes starting from data preparation, where occasionally conversion must occur, aggregation and finally validation, which guarantees that data apply defined rules. Above all, dedicated operational procedures must be defined and applied to enable proper handling of the entire process.
Funding
This work has been supported by the AMUNATCOLL project and has been partly funded by the European Union and Ministry of Digital Affairs from the European Regional Development Fund as part of the Digital Poland Operational Program under grant agreement number: POPC.02.03.01-00-0043/18.
References
ABCD. 2021. Access to Biological Collections Data standard. https://www.tdwg.org/standards/abcd/
ANC. 2022. AMUNATCOLL project. http://anc.amu.edu.pl/eng/index.php
ANCPortal. 2022. AMUNATCOLL Portal. https://amunatcoll.pl/
ANDR. 2022. AMUNATCOLL Mobile Application – Android. https://play.google.com/store/apps/details?id=pl.pcss.amunatcoll.mobile
Baldwin R. F. & Fouch N. T. 2018. Understanding the Biodiversity Contributions of Small Protected Areas Presents Many Challenges. Land 7(4): (123).
Ballard H. L., Robinson L. D., Young A. N., Pauly G. B., Higgins L. M., Johnson R. F. & Tweddle J. C. 2017. Contributions to conservation outcomes by natural history museum-led citizen science: Examining evidence and next steps. Biol Conserv 208: 87-97.
Beaman R., Wieczorek J. & Blum S. 2004. Determining Space from Place for Natural History Collections. D-Lib Magazine 10 (5). https://herbarium.millersville.edu/471/Beaman_et_al_2004.pdf
BioCASe. 2021. Biological Collection Access Service. http://www.biocase.org/
BIS. 2021. Biodiversity Information Standards. https://www.tdwg.org/
Butchart S. H. M., Scharlemann J. P. W., Evans M. I., Quader S., Aricò S., Arinaitwe J., Balman M., Bennun L. A., Bertzky B., Besançon Ch., Boucher T. M., Brooks T. M., Burfield I. J., Burgess N. D., Chan S., Clay R. P., Crosby M. J., Davidson N. C., De Silva N., Devenish Ch., Dutson G. C. L., Día z Fernández D. F., Fishpool L. D. C., Fitzgerald C., Foster M., Heath M. F., Hockings M., Hoffmann M., Knox D., Larsen F. W., Lamoreux J. F., Loucks C., May I., Millett J., Molloy D., Morling P., Parr M., Ricketts T. H., Seddon N., Skolnik B., Stuart S. N., Upgren A. & Woodley S. 2012. Protecting Important Sites for Biodiversity Contributes to Meeting Global Conservation Targets. PLoS ONE 7(3). e32529.
DCMI. 2022. The Dublin Core™ Metadata Initiative. https://www.dublincore.org/
DL. 2022. Digital library. https://en.wikipedia.org/wiki/Digital_library
dLibra. 2021. Digital Library Framework. https://www.psnc.pl/digital-libraries-dlibra-the-most-popular-in-poland/
DwC. 2021. Darwin Core standard. https://dwc.tdwg.org/
DwCS. 2009. Darwin Core Standard terms. http://rs.tdwg.org/dwc/terms.htm
EXIF. 2021. Exchangeable Image File Format. https://en.wikipedia.org/wiki/Exif
FAIR. 2022. FAIR Principles. https://www.go-fair.org/fairprinciples/
FBAMU. 2022. Faculty of Biology of the Adam Mickiewicz University in Poznań. http://biologia.amu.edu.pl/
Feest A., van Swaay Ch., Aldred T. D. & Jedamzik K. 2011. The biodiversity quality of butterfly sites: A metadata assessment. Ecol Indic 11(2): 669-675.
GBIF. 2021. Global Biodiversity Information Facility. https://www.gbif.org/en/
Güntsch A., Berendsohn W. G. & Mergen P. 2007. The BioCASE Project – a Biological Collections Access Service for Europe. Ferrantia 51: 103-108.
Hardisty A. R., Michener W. K., Agosti D., García E. A., Bastin L., Belbin L., Bowser A., Buttigieg P. L., Canhos D. A. L., EgloffW., De Giovanni R., Figueira R., Groom Q., Guralnick R. P., Hobern D., Hugo W., Koureas D., Ji L., Los W., Manuel J., Manset D., Poelen J., Saarenmaa H., Schigel D., Uhlir P. F. & Kissling W. D. 2019. The Bari Manifesto: An interoperability framework for essential biodiversity variables. Ecol Infor 49: 22-31.
ImMag. 2021. ImageMagick – cross-platform image processing software. https://imagemagick.org/
IOS. 2021. AMUNATCOLL Mobile Application – iOS. https://apps.apple.com/pl/app/amunatcoll/id1523442673
Jackowiak B., Błoszyk J., Dylewska M., Nowak M. M., Szkudlarz P., Lawenda M. & Meyer N. 2022. Digitization and online access to data on natural history collections of Adam Mickiewicz University in Poznan: assumptions and implementation of the AMUNATCOLL project. Biodiv. Res. Conserv. 65: 23 34.
Kacprzak E., Koesten L., Ibáñez L.D., Blount T., Tennison J. & Simperl E. 2018. Characterising dataset search – An analysis of search logs and data requests. J Web Semant 55: 37-55.
Kays R., McShea W. J. & Wikelski M. 2020. Born-digital biodiversity data: Millions and billions. Divers Distrib 26(5): 644-648.
libvips. 2021. libvips – An image processing library. https://www.libvips.org/
Löffler F., Wesp V., König-Ries B. & Klan F. 2021. Dataset search in biodiversity research: Do metadata in data repositories reflect scholarly information needs? PLoS ONE 16(3): e0246099.
MMDBMS. 2022. Multimedia Database Management System. https://en.wikipedia.org/wiki/Multimedia_database
MSSQL. 2022. Microsoft SQL Server. https://www.microsoft.com/en-us/sql-server
MySQL. 2022. MySQL – database management system. https://www.mysql.com/
Nowak M. M., Słupecka K. & Jackowiak B. 2021. Geotagging of natural history collections for reuse in environmental research. Ecol Indic 131: 108131.
Nowak M. M, Lawenda M., Wolniewicz P., Urbaniak M. & Jackowiak B. 2022. The Adam Mickiewicz University Nature Collections IT system (AMUNATCOLL): portal, mobile application and graphical interface. Biodiv. Res. Conserv. 65: 49-67.
Oracle. 2022. Oracle Database. https://www.oracle.com/database/
PostgreSQL. 2021. PostgreSQL database web site. https://www.postgresql.org/
PSNC. 2021. Poznan Supercomputing and Networking Center. https://www.psnc.pl/
Seafile. 2021. Open Source File Sync and Share Software. https://www.seafile.com/en/home/
Silva da J. R., Castro J. A., Ribeiro C., Honrado J., Lomba A. & Gonçalves J. 2014. Beyond INSPIRE: An Ontology for Biodiversity Metadata Records. In: R. Meersman, H. Panetto, A. Mishra, R. Valencia-García, A. L. Soares, I. Ciuciu, F. Ferri, G. Weichhart, T. Moser, M. Bezzi & H. Chan (eds.). OTM 2014 Workshops, LNCS 8842, pp. 597-607. Springer-Verlag Berlin Heidelberg.
Torres R. d. S., Medeiros C. B., Gonçcalves M. A. & Fox E. A. 2006. A digital library framework for biodiversity information systems. International Journal on Digital Libraries 6: 3-17.
UTM. 2022. The Universal Transverse Mercator. https://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system
Walls R. L., Deck J., Guralnick R., Baskauf S., Beaman R., Blum S., Bowers S., Buttigieg P. L., Davies N., Endresen D., Gandolfo M. A., Hanner R., Janning A., Krishtalka L., Matsunaga A., Midford P., Morrison N., Tuama É. Ó., Schildhauer M., Smith B., Stucky B. J., Thomer A., Wieczorek J., Whitacre J. & Wooley J. 2014. Semantics in Support of Biodiversity Knowledge Discovery: An Introduction to the Biological Collections Ontology and Related Ontologies. PLOS ONE 9(3). e89606.
Whitlock M. C. 2011. Data archiving in ecology and evolution: best practices. Trends Ecol Evol 26: 61 65.
XML. 2016. Extensible Markup Language. https://www.w3.org/XML/
Zając A. 1978. Atlas of distribution of vascular plants in Poland (ATPOL). Taxon 27: 481-484.
Zalani L. A. M., Jye K. S., Balakrishnan S. & Dhillon S. K. 2019. Biodiversity Databases and Tools. Encyclopedia of Bioinformatics and Computational Biology 2: 1110-1123.
License
Copyright (c) 2023 Marcin Lawenda, Justyna Wiland-Szymańska, Maciej M. Nowak, Damian Jędrasiak, Bogdan Jackowiak
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.