On the development of the INTS databank: hydrometeorological information

by

A.V. Gubarev, A.A. Valle, A.B. Polonsky

Institute of Natural and Technical Systems, RF, Sevastopol, Gogol St., 14

E-mail: alexgub@inbox.ru; ogorodovaa.a@mail.ru

DOI: 10.33075/2220-5861-2025-3-90-101

UDC 004.65 (262.5)                               

EDN: https://elibrary.ru/xqkifk

Abstract:

Previously, the Institute of Natural and Technical Systems had established a regional oceanographic databank, which contained a certain amount of hydrometeorological information. This paper describes the development of this bank by replenishing the database with hydrometeorological information and improving the software. The current version of the bank contains data obtained at 34 hydrometeorological stations located in the Black Sea region. Four of these stations are represented by arrays of standard hydrometeorological observations at the main synoptic times (00, 06, 12, and 18 hours GMT) from 1950 to 2008, while the remaining 30 stations provide calculated monthly and daily average values (i.e., average daily/monthly values calculated for each day/month of each year) for more than a century, from 1900 to 2010. The bank also contains the results of measurements of parameters characterizing the interaction of the sea with the atmospheric surface layer, carried out in the northwestern part of the Black Sea at the offshore stationary gas production platform “Golitsyno-4”. The databank is based on the free SQLite software. Its advantages include ease of use, high speed of data processing, and presentation of information in a user-friendly format.

Keywords: database, database management systems, hydrometeorological station, hydrometeorological state of the waters of the Azov-Black Sea basin

Full text in PDF(RUS)

REFERENCES

  1. Izrajel’ Ju.A., Anohin Ju.A., Gruza G.V., Ivanov V.N., Egorov V.I., Kruchenitskiy G.M., Savchenko A.V., and Petrov N.N. Razrabotka i nekotorye rezul’taty funkcionirovanija sistemy monitoringa osnovnyh klimatoobrazujushhih faktorov v srednej atmosfere (Development and results of some effective systems for monitoring the main climate-forming factors in the middle atmosphere). Meteorologija i gidrologija, 2013, Vol. 7, pp. 5–14.
  2. Mnogoletnie dannye: nauchno-prikladnoj spravochnik po klimatu SSSR, serija 3 (Scientific and applied reference book on the climate of the USSR, series 3 “Long-term data”). Leningrad: Gidrometeoizdat, 1990, Iss. 10, pp. 604.
  3. Evstigneev V.P., Naumova V.A., Voronin D.Yu., and Evstigneev M.P. Obosnovanie postroenija adaptivnoj regional’noj sistemy klimaticheskogo monitoringa (Justification for the construction of an adaptive regional climate monitoring system). Sistemy kontrolja okruzhajushhej sredy, 2020, No. 4 (42), pp. 20–28. DOI: 10.33075/2220-5861-2020-4-20-28
  4. Kuznecov S.D. Osnovy baz dannyh (Database Basics). Moscow: Nacional’nyj Otkrytyj Universitet INTUIT, 2024, pp. 350, ISBN 5-9556-00028-0.
  5. Mel’nikov D.A., Mihajlov N.N., Vyazilov E.D., Voroncov A.A., Belova K.V., Puzova N.V., and Vjazilova N.A. Modernizaciya informacionno-tekhnologicheskogo uzla Edinoj gosudarstvennoj sistemy informacii ob obstanovke v Mirovom okeane (Modernization of the information technology node of the Unified State System of Information on the Situation in the World Ocean). Trudy Vserossijskogo nauchno-issledovatel’skogo instituta gidrometeorologicheskoj informacii – Mirovogo centra dannyh, 2024, No. 192, pp. 7–27.
  6. Voroncov A.A. Godin E.A., Ingerov A.V.,and Isaeva E.A. Bazy dannyh po CHernomu moryu FGBUN MGI i FGBU VNIGMI-MCD: rezul’taty sravneniya (Databases on the Black Sea of the Federal State Budgetary Institution of Science MGI and the Federal State Budgetary Institution VNIGMI-MCD: comparison results), Morya Rossii: metody, sredstva i rezul’taty issledovanij: Vserossijskaya nauchnaya konferenciya (All-Russian scientific conference “Seas of Russia: methods, means and results of research”), Sevastopol’, pgt. Kaciveli 24–28 September 2018, Sevastopol’: FGBUN MGI, 2018, рр. 225–225.
  7. Andryushchenko E.G., Galkovskaya L.K., Godin E.A., Zhuk E.V., Ingerov A.V., Isaeva E.A., Kas’yanenko T.E., Plastun T.V., and Haliulin A.H. Bank okeanograficheskih dannyh MGI NAN Ukrainy: informacionnye resursy i dostup k dannym (Oceanographic Data Bank of the MHI NAS of Ukraine: information resources and access to data). Sevastopol: Izdatel’stvo NPC «EKOSI-Gidrofizika», 2010, 59 p.
  8. D’yakov N.N. Levickaya O.V., Lipchenko A.E., Belogudov A.A., and Martynov E.S. Bank okeanograficheskih dannyh Azovskogo i Chernogo morej (Oceanographic data bank of the Azov and Black Seas). Trudy Gosudarstvennogo okeanograficheskogo institute, 2017, No. 18, pp. 287–297.
  9. D’jakov N.N., Berdnikov S.V., Kulygin V.V., Levickaja O.V., Dashkevich L.V. and Lihtanskaja N.V. Informacionnaja osnova dlja novogo klimaticheskogo atlasa Azovskogo morja (Information basis for a new climate atlas of the Sea of Azov). Trudy Gosudarstvennogo okeanograficheskogo institute, 2022, No. 223, pp. 33–48.
  10. Matishov G.G., Berdnikov S.V., Zhichkin A.P., Makarevich P.R., Dzhenyuk S.L., Kulygin V.V., Yaickaya N.A., Povazhnyj V.V., Sheverdyaev I.V., Tret’yakova I.A., and Cygankova A.E. Atlas klimaticheskih izmenenij v bol’shih morskih ekosistemah Severnogo polushariya (1878–2013). Region 1. Morya Vostochnoj Arktiki. Region 2. Chyornoe, Azovskoe i Kaspijskoe moray (Atlas of Climate Change in Large Marine Ecosystems of the Northern Hemisphere (1878–2013). Region 1. Eastern Arctic Seas. Region 2. Black, Azov, and Caspian Seas). Rostov-on-Don: Izdatel’stvo YUNC RAN, 2014, 256 p.
  11. Lezhneva N. G. Obedinennaja baza operativnyh gidrometeorologicheskih dannyh po morjam Evropejskoj territorii Rossii (United database of operational hydrometeorological data on the seas of the European territory of Russia). Trudy Gidrometeorologicheskogo nauchno-issledovatel’skogo centra Rossijskoj Federacii, 2015, No. 354, pp. 155–167.
  12. Haliulin A.H., Godin E.A., Ingerov A.V., Zhuk E.V., Galkovskaja L.K., and Isaeva E.A. Bank okeanograficheskih dannyh Morskogo gidrofizicheskogo instituta: informacion-nye resursy dlja podderzhki issledovanij pribrezhnoj zony Chernogo morja (Oceanographic Data Bank of the Marine Hydrophysical Institute: Information Resources to Support Research in the Coastal Zone of the Black Sea). Jekologicheskaja bezopasnost’ pribrezhnoj i shel’fovoj zon morja, 2016, No. 1, pp. 82–89. EDN VUYZPJ.
  13. Naumov V.A. Ispol’zovanie specializirovannyh massivov dannyh dlja klimaticheskih issledovanij (Using specialized data sets for climate research). Vestnik nauchno-metodicheskogo soveta po prirodoobustrojstvu i vodopol’zovaniju, 2020, No. 18, pp. 52–59.
  14. Valle A.A., Gubarev A.V., and Polonskij A. B. Sovremennoe sostojanie banka okeanologicheskih dannyh Instituta prirodno-tehnicheskih system (Current state of the oceanographic data bank of the Institute of Natural and Technical Systems). Sistemy kontrolja okruzhajushhej sredy, 2024, No. 3 (57), pp. 88–98. DOI: 10.33075/2220-5861-2024-3-88-98
  15. Mel’nikov V.V., Polonskij A.B., Kotolupova A.A., Grebneva E.A., Mel’nik L.A., and Biryukova M.A. GIS Instituta prirodno-tekhnicheskih sistem (GIS of the Institute of natural and technical systems). Sistemy kontrolya okruzhayushchej sredy. 2016, No. 2 (24), pp. 49–55.
  16. Novikova A.M. Ispol’zovanie SUBD i GIS dlja razvitija i analiza regional’noj okeanologicheskoj bazy dannyh po Chjornomu morju (Using DBMS and GIS for the development and analysis of a regional oceanographic database for the Black Sea). Sistemy kontrolya okruzhayushchej sredy, 2018. No. 2 (32), pp. 52–56. DOI: 10.33075/2220-5861-2018-2-52-56
  17. Novikova A.M. and Polonskij A.B. Mezhdesyatiletnyaya izmenchivost’ temperatury poverhnosti i holodnogo promezhutochnogo sloya v Chyornom more (Decadal variability of surface temperature and the cold intermediate layer in the Black Sea). Sistemy kontrolya okruzhayushchej sredy, 2018, No. 4 (34), pp. 110–115. DOI: 10.33075/2220-5861-2018-4-110-115
  18. Polonskij A.B. and Valle A.A. Stoletnjaja izmenchivost’ kisloroda, rastvorennogo v poverhnostnom sloe vod Chernogo morja (Centennial variability of oxygen dissolved in the surface layer of the Black Sea waters). Meteorologija i gidrologija, 2024, No. 12, pp. 110–120. DOI: 10.52002/0130-2906-2024-12-110-120
  19. Il’in Ju. P. Klimaticheskie izmenenija gidrometeorologicheskih uslovij Chernogo morja (Climate changes in hydrometeorological conditions of the Black Sea). Global’nye i regional’nye izmenenija klimata, Kiev: Nika-Centr, 2011, рр. 247–254.
  20. Lemeshko N.A., Evstigneev V.P., and Naumova V.A. Izmenenija temperatury vozduha v Azovo-Chernomorskom bassejne i na territorii Kryma (Changes in air temperature in the Azov-Black Sea basin and in the Crimea). Vestnik Sankt-Peterburgskogo universiteta. Nauki o Zemle, 2014, No. 4. pp. 131–143.
  21. Gruza G.V., and Rejtenbah R.G. Statistika i analiz gidrometeorologicheskih dannyh (Statistics and analysis of hydrometeorological data). Leningrad: Gidrometeoizdat, 1982, pp. 216.
  22. https://sqlite.org/ (July 10, 2025).
  23. https://pydocs.ru/sqlite-vvedenie/ (July 10, 2025).
  24. https://aglamov.biz//jazyki-progra-mmirovanija/bazy-dannyh/sqlite/optimizaciya-proizvoditelnosti-sqlite-urok-8 (July 10, 2025).
  25. Garmashov A.V. and Polonskij A.B. Izmenchivost’ vetra v severo-zapadnoj chasti Chernogo morya po dannym nablyudenij na morskoj stacionarnoj platforme (Wind variability in the northwestern part of the Black Sea based on observations from an offshore fixed platform). Meteorologija i gidrologija, 2011, No. 12, pp. 52–62.
  26. Garmashov A.V., Kubryakov A.A., Korovushkin A.I., Polonskij A.B., Stanichnyj S.V., and Toloknov Ju.N. Verifikaciya dannyh skatterometrov Oceansat-2 i ASCAT na osnove izmerenij skorosti vetra na stacionarnoj okeanograficheskoj platforme (Verification of Oceansat-2 and ASCAT scatterometer data based on wind speed measurements at a stationary oceanographic platform). Ukrainskij metrologicheskij zhurnal, 2014, No. 1, pp. 50–54.
  27. Garmashov A.V., Kubryakov A.A., Shokurov M.V., Stanichnyj S.V., Toloknov Ju.N., and Korovushkin A.I. Sopostavlenie skorosti vetra nad Chernym morem po sputnikovym i meteorologicheskim dannym (Comparison of wind speeds over the Black Sea using satellite and meteorological data). Izvestiya RAN. Fizika atmosfery i okeana, 2016, Vol. 52, No. 3, pp. 351–360.
  28. Garmashov A.V., Toloknov Ju.N., and Korovushkin A.I. Vetrovoe volnenie v severo-zapadnoj chasti Chernogo morja v 1995–2002 gg. (Wind Waves in the Northwest Black Sea in 1995 – 2002). Jekologicheskaja bezopasnost’ pribrezhnoj i shel’fovoj zon morja, 2017, No. 2, pp. 4–10. EDN ZCPHH.
  29. Svidetel’stvo o gosudarstvennoj registracii programmy dlja JeVM № 2023685280. Programma vizualizacii polej koncentracii rastvorennogo kisloroda dlja ocenki klimaticheskih izmenenij (Certificate of state registration of the computer program No. 2023685280. Program for visualization of dissolved oxygen concentration fields for assessing climate change.). Author Valle A.A. Copyright holder Valle A.A. No. 2023684746, date of receipt 11.15.2023, registered 11.24.2023.
  30. Svidetel’stvo o gosudarstvennoj registracii programmy dlja JeVM № 2024669874. Programma dlja rascheta stoletnej izmenchivosti koncentracii rastvorennogo kisloroda, temperatury i solenosti v Chernom more dlja ocenki klimaticheskih izmenenij (Certificate of state registration of computer program No. 2024669874. Program for calculating the centennial variability of dissolved oxygen concentration, temperature and salinity in the Black Sea to assess climate change.). Author Valle A.A. Copyright holder Valle A.A., No. 2024668409, date of receipt 08.05.2024, registered 08.22.2024.

Loading