Method of creating WEB-GIS of polish burials at Kyiv Baikove cemetery

Faculty of Land Management of the National University of Life and Environmental Sciences of Ukraine
Lviv polytechnic National University
Ivan Franko National University of Lviv
Department of Geodesy and Cartography of the National University of Life and Environmental Sciences of Ukraine
Department of Geodesy and Cartography of the National University of Life and Environmental Sciences of Ukraine
Department of Geodesy and Cartography of the National University of Life and Environmental Sciences of Ukraine
Department of Geodesy and Cartography of the National University of Life and Environmental Sciences of Ukraine

Elaboration of the method of creating a web-GIS of Polish burials at the Baikove Cemetery in Kyiv. Achieving this goal involves the following tasks: to develop the structure of the geographic information system, its framework and to fill the file database. For realization of the set tasks the technological scheme consisting of 12 stages of work is offered. The first stage involved the collection of cartographic and descriptive data on the territory of the object of study, as well as the search for possible registers of Polish burials within the object under study. In the second stage, field surveys were performed to determine the coordinates of each grave of the Polish burials at the Baikove Cemetery using a GIS tablet with an RTK antenna LT700H (accuracy up to 0.30 m). The total number of coordinated points was 565, which were concentrated in 7 sections of the cemetery. The third stage included the coordination of reference points and the binding of this support in the GIS MapInfo environment of the fragment of the topographic plan of Kyiv on a scale of 1: 2000 to the territory of the Baikove Cemetery. There were a total of 11 landmarks. The maximum binding error is 0.2 m. In the fourth stage, all point objects were displayed according to their coordinates on the basis of the map and the corresponding symbols were selected. The next step was to develop and populate a relational database for point objects. The database contained the following columns: grave number, name and surname of the buried person, grave coordinates and hyperlinks to burial information in the file database. Next, all map layers were exported to html format, and the point object layer was exported to kml format using a universal translator, which allowed to view burial data in GoogleEarth. At the eighth stage of the technological scheme the structure of layouts of each html-page of the created online GIS was developed. All map data had hyperlinks to the selected AOI objects. In the case of the Baikove Cemetery scheme, plots with Polish burials were marked. Clicking on them opened a topographic plan with marked point objects of burials. In turn, when you click on them, information about the burial appeared from the file database. At the tenth stage, 5 sheets of topographic plans with burials were generated. One sheet of scale 1: 2000 and four sheets of scale 1: 500, for better "spreading" and initialization of burials.  The eleventh stage is devoted to the creation and filling of a file database on Polish burials. This database contained the following structure: photo of the burial, coordinates, surname and name, years of life, additional photographs (if available), sex of the buried person, interpreted inscription on the tombstone, as well as, if possible, detailed information and belonging of the buried person to a certain profession, its outstanding achievements and accomplishments. At the last stage, the hyperlinks of the transition between the pages were configured and the system was tested. The scientific novelty lies in the development of the concept of joint use of various applications of geoinformation and non-geoinformation purposes. The technological scheme of creation of WEB-GIS of Polish burials of the Baikove Cemetery in Kyiv is offered. Implemented geographic information system is designed for inventory of burials, analysis of the condition of tombstones and their spatial location in the cemetery. In addition, the created GIS can be used for tourism purposes and in the study of historical figures of Polish origin.

1. Apollonio, F. I., Gaiani, M., & Sun, Z. (2013). 3D modeling and data enrichment in digital reconstruction of architectural heritage. International archives of the photogrammetry, remote sensing and spatial information sciences, 5, W2.
2. Arnoud de Boer (2010, February). Processing old maps and drawings to create virtual historic landscapes. In Proceedings of the 5th International Workshop on Digital Approaches in Cartographic Heritage (pp. 66-74). ICA/TU Wien.
3. Clini, P., El Mehtedi, M., Nespeca, R., Ruggeri, L., & Raffaelli, E. (2018). A digital reconstruction procedure from laser scanner survey to 3d printing: the theoretical model of the Arch of Trajan (Ancona). SCIRES-IT-SCIentific RESearch and Information Technology, 7(2), 1-12.
4. Chetverikov, B., Bondar, K., Homenko, R., Dіdenko, S., & Sheyhet, M. (2017). Determination of location of the historical objects using photogrammetric methods and methods of non-destructive ground research. Geodesy, cartography and aerial photography, (85), 94-103.
5. Chetverikov, B. (2019). Methods for determining the foundations of destroyed buildings from archival aerial photographs for the restoration of historical and cultural heritage sites. Modern achievements of geodetic science and production. Vip. And (37). Pp. 100-105.  (in Ukrainian)
6. Chetverikov, B. (2020). Methods of creating GIS concentration camps of Nazi Germany in the period 1941-1944. Modern achievements of geodetic science and production, Vol. I (39), pp. 103-109.
7. Fiedukowicz, A., Głażewski, A., Kołodziej, A., Koszewski, K., Kowalski, P., Olszewski, R., & Włochyński, L. (2018). Map portal as a tool to share information on cultural heritage illustrated by the national heritage board geoportal. In Advances in Digital Cultural Heritage (pp. 48-64). Springer, Cham.
8. Gregory, I. N., & Ell, P. S. (2007). Historical GIS: technologies, methodologies, and scholarship (Vol. 39). Cambridge University Press.
9. Knowles, A. K., & Hillier, A. (2008). Placing history: how maps, spatial data, and GIS are changing historical scholarship. ESRI, Inc..
10. Martyn, A., Openko, I., Ievsiukov, T., Shevchenko, O., & Ripenko, A. (2019). Accuracy of geodetic surveys in cadastral registration of real estate: value of land as determining factor. In 18th International Scientific Conference. Engineering for Rural Development (pp. 22-24).
11. McKeague, P., Corns, A., & Shaw, R. (2012). Developing a spatial data infrastructure for archaeological and built heritage. International Journal of Spatial Data Infrastructures Research, 7, 38-65.
12. Pidlisetska. I. O. (2015). Development of the structure of the atlas "Cultural and natural heritage of Ukraine". Intellectual potential of the XXI century '2015. 10-22 November 2015. Electronic resource. Access mode: http: // (in Ukrainian).
13. Polyvach, K. A (2007). Cultural heritage and its influence on the development of the regions of Ukraine (socio-geographical research): author's ref. dis. for science. degree of Cand. geogr. Science: special. 11.00.02 "Economic and social geography". K., 24 p. (in Ukrainian).
14. Prasul, Yu. I. (2004). Scientific bases of system mapping of regions of Ukraine for the needs of tourism (on the example of Kharkiv region): author's ref. dis. for science. degree of Cand. geogr. Sciences: special: 11.00.12 "Geographical cartography". K., 20 p. (in Ukrainian)
15. Remondino, F. (2008). Digital preservation, documentation and analysis of heritage with active and passive sensors. Lasers in the Conservation of Art Works, 387-92.
16. Rhein, U. (1996). The Role of Remote Sensing and GIS for an Operational Statewide Environmental Monitoring. International Archives of Photogrammetry and Remote Sensing, 31, 684-689.
17. Vacca, G., Fiorino, D. R., & Pili, D. (2018). A spatial information system (SIS) for the architectural and cultural heritage of sardinia (Italy). ISPRS International Journal of Geo-Information, 7(2), 49.

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'uid': INSERT INTO {sessions} (sid, ssid, uid, cache, hostname, session, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => RF8ftpHFoVEZ0YD8YCvsMoV4Arc5x-u-A6oFQoMsTC4 [:db_insert_placeholder_1] => RF8ftpHFoVEZ0YD8YCvsMoV4Arc5x-u-A6oFQoMsTC4 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => nodeviewcount_views_limit|a:1:{i:26033;O:8:"DateTime":3:{s:4:"date";s:26:"2023-03-27 16:53:11.000000";s:13:"timezone_type";i:3;s:8:"timezone";s:15:"Europe/Helsinki";}} [:db_insert_placeholder_6] => 1679925191 ) in _drupal_session_write() (line 209 of /home/science/public_html/includes/