Застосування ГІС-технологій для обліку плюсових дерев
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 p...
Saved in:
| Date: | 2023 |
|---|---|
| Main Authors: | , , , , |
| Format: | Article |
| Language: | English |
| Published: |
Ukrainian Research Institute of Forestry and Forest Melioration named after G. M. Vysotsky (URIFFM)
2023
|
| Subjects: | |
| Online Access: | https://forestry-forestmelioration.org.ua/index.php/journal/article/view/388 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Journal Title: | Forestry and Forest Melioration |
Institution
Forestry and Forest Melioration| _version_ | 1856543478800973824 |
|---|---|
| author | Zhadan, I. B. Los, S. A. Torosova, L. O. Plotnikova, O. M. Grygoryeva, V. G. |
| author_facet | Zhadan, I. B. Los, S. A. Torosova, L. O. Plotnikova, O. M. Grygoryeva, V. G. |
| author_sort | Zhadan, I. B. |
| baseUrl_str | |
| collection | OJS |
| datestamp_date | 2024-02-22T12:24:37Z |
| description | 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. |
| first_indexed | 2026-02-08T08:03:52Z |
| format | Article |
| id | oai:ojs2.forestry-forestmelioration.org.ua:article-388 |
| institution | Forestry and Forest Melioration |
| language | English |
| last_indexed | 2026-02-08T08:03:52Z |
| publishDate | 2023 |
| publisher | Ukrainian Research Institute of Forestry and Forest Melioration named after G. M. Vysotsky (URIFFM) |
| record_format | ojs |
| spelling | oai:ojs2.forestry-forestmelioration.org.ua:article-3882024-02-22T12:24:37Z Application of GIS technologies for accounting plus trees Застосування ГІС-технологій для обліку плюсових дерев Zhadan, I. B. Los, S. A. Torosova, L. O. Plotnikova, O. M. Grygoryeva, V. G. forest genetic resources database portal webpage tree improvement units лісові генетичні ресурси база даних портал вебсторінка селекційний об’єкт 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. Наведено результати одного з етапів робіт зі створення бази даних селекційних об’єктів лісових деревних видів України, який стосується обліку плюсових дерев. Метою досліджень було вдосконалення впорядкування інформації щодо плюсових дерев, їхного обліку, обстеження та використання як селекційних об’єктів за допомогою безкоштовного програмного забезпечення (Python, JavaScript) та використання реляційної бази даних PostgreSQL з модулем PostGIS. На основі методики формування бази плюсових дерев складено інструкцію для користування розробленого та опрацьованого програмного забезпечення. Створено вебсторінку, яка за відповідним запитом демонструє інформацію про плюсові дерева, зокрема їхнє розташування на території виділу, а також зведені відомості щодо плюсових дерев у певному лісовому господарстві або області. На цей час до бази внесено інформацію про плюсові дерева семи областей України (Харківська, Полтавська, Сумська, Дніпропетровська, Запорізька, Луганська і Донецька), що становить близько 25 % фонду плюсових дерев країни. Ukrainian Research Institute of Forestry and Forest Melioration named after G. M. Vysotsky (URIFFM) 2023-12-26 Article Article application/pdf https://forestry-forestmelioration.org.ua/index.php/journal/article/view/388 10.33220/1026-3365.143.2023.50 Forestry and Forest Melioration; No. 143 (2023): Forestry and Forest Melioration; 50-60 Лісівництво і Агролісомеліорація; № 143 (2023): Лісівництво і Агролісомеліорація; 50-60 2663-4147 1026-3365 10.33220/1026-3365.143.2023 en https://forestry-forestmelioration.org.ua/index.php/journal/article/view/388/354 http://creativecommons.org/licenses/by/4.0 |
| spellingShingle | лісові генетичні ресурси база даних портал вебсторінка селекційний об’єкт Zhadan, I. B. Los, S. A. Torosova, L. O. Plotnikova, O. M. Grygoryeva, V. G. Застосування ГІС-технологій для обліку плюсових дерев |
| title | Застосування ГІС-технологій для обліку плюсових дерев |
| title_alt | Application of GIS technologies for accounting plus trees |
| title_full | Застосування ГІС-технологій для обліку плюсових дерев |
| title_fullStr | Застосування ГІС-технологій для обліку плюсових дерев |
| title_full_unstemmed | Застосування ГІС-технологій для обліку плюсових дерев |
| title_short | Застосування ГІС-технологій для обліку плюсових дерев |
| title_sort | застосування гіс-технологій для обліку плюсових дерев |
| topic | лісові генетичні ресурси база даних портал вебсторінка селекційний об’єкт |
| topic_facet | forest genetic resources database portal webpage tree improvement units лісові генетичні ресурси база даних портал вебсторінка селекційний об’єкт |
| url | https://forestry-forestmelioration.org.ua/index.php/journal/article/view/388 |
| work_keys_str_mv | AT zhadanib applicationofgistechnologiesforaccountingplustrees AT lossa applicationofgistechnologiesforaccountingplustrees AT torosovalo applicationofgistechnologiesforaccountingplustrees AT plotnikovaom applicationofgistechnologiesforaccountingplustrees AT grygoryevavg applicationofgistechnologiesforaccountingplustrees AT zhadanib zastosuvannâgístehnologíjdlâoblíkuplûsovihderev AT lossa zastosuvannâgístehnologíjdlâoblíkuplûsovihderev AT torosovalo zastosuvannâgístehnologíjdlâoblíkuplûsovihderev AT plotnikovaom zastosuvannâgístehnologíjdlâoblíkuplûsovihderev AT grygoryevavg zastosuvannâgístehnologíjdlâoblíkuplûsovihderev |