Keywords
database
portal
webpage
tree improvement units лісові генетичні ресурси
база даних
портал
вебсторінка
селекційний об’єкт
How to Cite
Abstract
Introduction
Nowadays, an important forest genetic resources (FGR) conservation activity is the systematization of information on gene pool conservation units in electronic databases. It should be noted, however, that the existing international databases mainly relate only to units represented by populations (stands), which are visualized as polygons on the map. As the scientists from the Department of New Information Technologies in URIFFM have implemented the website “Geoportal: Forests of Ukraine”, it became technically possible to add information on plus trees to its functionality and combine data on tree locations and their characteristics in a united electronic database.
The study aimed to improve the organization of information on plus trees, their accounting, survey, and use as improvement units by applying free software (Python, JavaScript) and the PostgreSQL relational database with the PostGIS module.
Materials and Methods
In 2021, one of the work stages was to develop software and methodology for forming the Plus Trees database and to provide a user manual. In particular, a data schema was created to store both attribute and geographical information on tree improvement units in Ukraine. In addition, attribute and geographical information of forest inventory are used. The database of plus trees contains basic information from plus tree Passports or selection/inventory data from the reports.
Results
The proposed database consists of several panels. The first panel contains elements for setting coordinates and entering plus tree numbers. The second panel is intended for selecting a species name of trees. The third panel of the data entry form contains mandatory attributes (total height of a plus tree and its diameter at a height of 1.3 m). The fourth panel contains other tree characteristics.
During the testing of the developed database structure and the working out of the instruction, the information on plus trees in seven regions of Ukraine (Kharkiv, Poltava, Sumy, Dnipro, Zaporizhzhia, Luhansk, and Donetsk) was entered, which is about 25% of the country’s plus tree pool. In addition, the design of the web pages was finalized in parallel with the data entry.
The developed software can be useful to both scientists and forest managers. Its use will simplify the search for plus trees in forest stands for their inventory, and survey, as well as in cases where it is necessary to collect seeds or cuttings for the seed orchards or progeny tests creation in forest enterprises or at forest seed centers. For scientists, it will provide an opportunity to systematize, analyze, and generalize information, in particular, to improve methodical approaches to the selection of the plus trees.
Conclusions
A data schema was created to store both attribute and geographic information on forest tree species tree improvement units in Ukraine. The schema considers the complex structure of coordinated units and includes the developed algorithms for data verification which will allow the effective use of the proposed database for the plus tree accounting.
8 Figs., 1 Table, 20 Refs.
References
Baliuckas, V. Pliura, A., Eriksson, G. 2004. Forest tree breeding strategies in Nordic and Baltic countries and the possible implications on Lithuanian tree breeding strategy. [Electronic resource]. Baltic Forestry, 10 (1): 95–103. Available at: https://balticforestry.lammc.lt/bf/PDF_Articles/2004-10[1]/95_103%20Baliuckas%20Pliura%20Eriksson.pdf (accessed 26.06.2023).
Davydova, N. I. 1967. Selection of plus trees of Quercus robur L., testing the progeny and their vegetative propagation. PhD thesis. Kharkiv, 214 p. (in Russian).
Ditlevsen, B. 1979. A forest tree improvement information system. [Electronic resource]. Forest Genetic Resources Information No 9. Forestry Occasional Paper. FAO, Rome. Available at: https://www.fao.org/3/n2511e/N2511E06.htm (accessed 26.06.2023).
EUFGIS [European Information System on Forest Genetic Resources]. 2023. Establishment of a European information system on forest genetic resources. [Electronic resource]. Available at: http://www.eufgis.org (accessed 26.06.2023).
EUFORGEN [European Forest Genetic Resources Programme]. 2023. European forest genetics programme. [Electronic resource]. Available at: https://www.euforgen.org/ (accessed 02.07.2023).
Guidelines for forest seed production (2nd edition, supplemented and revised). 2017. Los, S. A., Tereshchenko, L. I., Hayda, Yu. I., Shlonchak, G. A., Mitrochenko, V. V., Shlonchak, G. V., Vysotska, N. Yu., Torosova, L. O., Neyko, I. S., Samodai, V. P., Grigorieva, V. G., Obozny, O. I., Kokhany, S. G., Yatsyk, R. M., Grechanyk, R. M., Sapiton, O. A., Kornienko, V. P., Kuklyshyn, V. O., Mikhailov, P. P., Yurkiv, Z. M., Blystiv, V. I., Gula, L. O., Petrichenko, N. V., Guz, M. M., Danchuk, O. T. (Eds.). Kharkiv, URIFFM, 107 p. (in Ukrainian).
Hayda, Yu. I., Popadynets, I. M., Yatsyk, R. M., Parpan, V. I., Humeniuk, I. R., Kukharskyi, T. V., Tyrchyk, A. M., Kozatska, N. Ya., Trentovskyi, V. V. 2008. Forest genetic resources and their conservation in Ternopil region. Ternopil, Textbooks and Manuals, 276 p. (in Ukrainian).
Los, S. A., Tereshchenko, L. I., Grygoryeva, V. G., Volosyanchuk, R. T., Neiko, I. S., Demyanenko, L. V. 2011. The in situ gene pool conservation units of forest tree species in Chernihiv region. Forestry-ecological problems of the Eastern Polissia of Ukraine: Scientific Bulletin, 2: 28–35 (in Ukrainian).
Los, S. A., Tereshchenko, L. I., Grygoryeva, V. G., Vysotska, N. Yu., Korotkova, T. M. 2007. The current state of the in situ gene pool conservation units of the of deciduous tree species in the Left Bank Steppe of Ukraine. Forestry and Forest Melioration, 111: 182–192 (in Ukrainian).
Los, S. A., Tereshchenko, L. I., Shlonchak, G. A., Samoday, V. P., Neyko, I. S. 2015. Results of pine and oak plus trees selection in the plains of Ukraine and in Crimea in 2010–2014. Forestry and Forest Melioration, 126: 139–147 (in Ukrainian).
Molotkov, P. I., Patlai, I. N., Davydova, N. I. et al. 1982. Breeding of forest tree species. Moscow, Forest Industry, 224 p. (in Russian).
Nakada, R. 2022. Breeding and genetic resource conservation of forest trees in Japan. Eurasian J. For. Res., 22: 15–18. DOI:10.14943/EJFR.22.15
Neyko, I., Yurkiv, Z., Matusiak, M., Kolchanova, O. 2019. The current state and efficiency use of in situ and ex situ conservation units for seed harvesting in the central part of Ukraine. Folia Forestalia Polonica, Series A – Forestry, Vol. 61 (2), 146–155. https://doi.org/10.2478/ffp-2019-0014
Piatnytskyi, S. S. 1967. Forest tree breeding and seed production in Ukraine. Forestry and Forest Melioration, 9: 3–14 (in Russian).
Romeder, E. and Shenbakh, G. 1962. Genetics and breeding of forest species. Moscow, Selkhozizdat, 268 p. (in Russian).
Rosvall, O., St?hl, P., Almqvist, C., Anderson, B., Berlin, M., Ericsson, T., Eriksson, M., Gregorsson, B., Hajek, J., Hallander. J., H?gberg, K., Jansson, G., Karlsson, B., Kroon, J., Lindgren, D., Mullin, T., Stener, L. 2011. Review of the Swedish tree breeding programme. Sweden, Skogforsk, 84 р.
Volosyanchuk, R., Yatsyk, R., Los, S. 2002. Conservation of genetic resources of broadleaved forest tree species in Ukraine. [Electronic resource]. In: Dynamics and conservation of genetic diversity in forest ecosystems: International conference DYGEN. France, Strasbourg, р. 201. Available at: http://dspace.wunu.edu.ua/bitstream/316497/9612/1/32_T_02.pdf (accessed 26.06.2023).
Volosyanchuk, R. T., Los, S. A., Tereshchenko, L. I., Grygoryeva, V. G. Orlovska T.V., Neyko, I. S. 2009. Conservation in situ of gene resources of decidious tree species in Crimea. [Electronic resource]. Forestry and Forest Melioration, 115: 11–15 (in Ukrainian). Available at: https://forestry-forestmelioration.org.ua/index.php/journal/issue/view/18/115-pdf (accessed 26.06.2023).
Voytyuk V. P., Volosyanchuk, R. T., Los, S. A., Neyko, I. S., Grygoryeva, V. G. 2005. The current state of gene pool conservation units in situ of deciduous species in Volyn region. In: Scientific foundations of sustainable forestry: Materials of the international conference dedicated to the 80th anniversary of the birth of P.S. Pasternak. Ivano-Frankivsk, р. 80–83 (in Ukrainian).
Yatsyk, R., Vorobchuk, V., Parpan, V., Hayda, Yu., Stupar, V. , Kashpor V. 2008. Genetic breeding and seed production units in the forests of Bukovyna. Ternopil, Textbooks and Manuals, 288 p. (in Ukrainian).
Yatsyk, R. M., Deineka, A. M., Parpan, V. I., Tselen, Ya. P., Hayda, Yu. I., Stupar, V. I., Bryk, S. V., Matveieva, N. V. 2006. Forest genetic resources, tree improvement and seed production of the Lviv region. Ivano-Frankivsk, Ed.-design. department CIT, 312 р. (in Ukrainian).
This work is licensed under a Creative Commons Attribution 4.0 International License.