Search similar hydrological data series using correlation coefficients
DOI:
https://doi.org/10.34185/1562-9945-5-136-2021-10Keywords:
коефіцієнти кореляції, схожі ряди даних, гідрологічний моніторинг, інформаційна технологіяAbstract
Water resources are an important part of the social and economic development of countries. A large number of hydrological studies are carried out using MS Excel, Statistica, Mathlab, Matcad and only a small number of studies for calculations partially used special-ized software solutions. An even smaller amount of research is carried out on the software implementation of computational schemes and algorithms in high-level programming lan-guages.
Therefore, the development of software for the analysis of hydrological data is relevant. The aim of this work is to develop, describe and implement a technology to search for similar hydrological posts on the series of data represented by certain samples.
The paper describes the developed software component for determining similar series of data represented by hydrological samples. The computational scheme is based on the determination of the geometric similarity of data series, and the correlation coefficients of Spearman and Pearson are chosen for the calculations. The analysis involves a step-by-step calculation of the scores used in the regression analysis, which allows controlling the progress of the analysis and interpreting the results. Among the selected scores are MAPE, R2, MSE and MAE.
The paper presents the results of a computational experiment conducted on water level samples in the period from 01.01.2000 to 31.12.2014 years, the data of the post wich located on the river Turia in the city of Kovel, Volyn region, were selected as the studied series. Ac-cording to the results of the analysis, three hydrological posts were found, the data of which have a strong correlation with the data of the studied post. However, the MAPE, R2, MSE and MAE scores show that only two of them can be considered sufficiently similar to the studied series.
References
Hopchenko E.D., Ovcharuk V.A., Todorova E.Y. Maksymalnyi stok dozhdevykh pavodkov rek Hornoho Kryma // Visnyk Odeskoho derzhavnoho ekolohichnoho universytetu. – 2014. – Vyp.17. – S.133-140.
Obodovskyi O.H. ta in. Uzahalnennia serednoho richnoho stoku vody richok vidpovidno do hidrohrafichnoho raionuvannia Ukrainy// Visnyk Kharkivskoho natsionalnoho universytetu imeni VN Karazina, ceriia «Heolohiia. Heohrafiia. Ekolohiia» – 2019. – Vyp. 51. – S. 158-170.
Mozghovyi A. O. Doslidzhennia koreliatsiinoi zalezhnosti maksymalnoi tovshchyny lodu za statystychnymy danymy sposterezhen u vodoskhovyshchakh hidrovuzliv Dniprovskoho kaskadu // Naukovyi visnyk budivnytstva – 2018. – T.– 3 (93). – S. 149-155.
Obodovskyi O.H. ta in. Serednii richnyi stik vody v mezhakh raioniv richkovykh baseiniv Ukrainy. Hidrolohiia, hidrokhimiia i hidroekolohiia – 2019. – T. 3. –
S. 65-66.
Oshurok D.O., Skrynyk O.Ia., Osadchyi V.I. Pryvedennia vymirianykh znachen shvydkosti vitru do umov vidkrytoho horyzontu // Hidrolohiia, hidrokhimiia i hidroekolohiia – 2019. – T.3. – S. 139-141.
Chen Lu, Singh Vijay P., Guo Shenglian. Measure of correlation between river flows using the copula-entropy method. Journal of Hydrologic Engineering, 2013, 18.12: r. 1591-1606.
Mudra K. V. Vidnovlennia stoku vody na hidrolohichnykh postakh richky Dnister z metoiu vyvchennia yoho dovhoperiodnykh kolyvan // Hidrolohiia, hidrokhimiia i hidroekolohiia. – 2017. – T. 2. – S. 30-39.
Artemenko V. A., Petrovych V. V. Metod vosstanovlenyia sverkhbolshykh propuskov v hydrolohycheskykh vremennыkh riadakh // Avtomobilni dorohy i dorozhne budivnytstvo, 2015, 93: 150-156.
Chornomorets Yu. O., Pavlenko P. O.; Lukianets O. I. Vidnovlennia serednoho richnoho stoku vody richky Dnipro. Hidrolohiia, hidrokhimiia i hidroekolohiia – 2017. – T. 4 (47). – S. 36-47.
Bazhanova L. V. Otsenka hydrolohycheskoho montorynha i vosstanovlenye stoka rek metodom parnoi korreliatsyy // Nauka, novye tekhnolohyy i innovatsii Kurhuzstana, 2018, 3: 134-140.
