Theoretical aspects of collecting, processing and storing spatial data in solving location and planning problems

Cover Page

Cite item

Full Text

Open Access Open Access
Restricted Access Access granted
Restricted Access Subscription Access

Abstract

The relevance of the article lies in the description of mechanisms and tools for working with spatial data in the process of solving problem of location and planning. The main purpose of the research is to detail such aspects of solving spatial location problems as coordinate systems, geographic coordinates and their representations, hierarchical indexing systems, and spatial DBMS. The article defines the concepts of a coordinate system, a geographic coordinate system, geographic coordinates, longitude, latitude, geometric objects (point, multipoint, lines, multiline, polygon, multipolygon), as well as how they are related to each other. The difference between global and regional geodetic coordinate systems is shown. The three most popular hierarchical index systems are analyzed: Geohash, S2, H3, their characteristics are formed and weaknesses are identified. The concept of a database management system is outlined, the main categories of DBMSs are highlighted based on their specifics and the range of problems they solve. The most popular tools in the field of spatial database management systems are described: PostgreSQL and PostGIS, Microsoft SQL Server, Oracle Database and Oracle Spatial, MySQL. The result of the research is the formation of a general overview and a description of the specific theoretical aspects necessary for interacting with spatial data in the process of solving location and planning problems.

About the authors

Natalia V. Grineva

Financial University under the Government of the Russian Federation

Author for correspondence.
Email: ngrineva@fa.ru
ORCID iD: 0000-0001-7647-5967
SPIN-code: 1140-9636

Cand. Sci. (Econ.), Associate Professor, Associate Professor of the Department of Information Technology

Russian Federation, Moscow

Alexey D. Topyrkin

Russian Presidential Academy of National Economy and Public Administration

Email: topyrkinalexei@yandex.ru
SPIN-code: 1128-6044

Post-graduate Student

Russian Federation, Moscow

References

  1. Woods F.S. (1922). Higher Geometry: An Introduction to Advanced Methods in Analytic Geometry. Boston: Ginn And Company, p. 423.
  2. Chang K.T. (2019). Introduction to Geographic Information Systems. NY: McGraw-Hill Education, 9, p. 444.
  3. GOST 22268–76. Geodeziya. Terminy i opredeleniya. Utverzhden i vveden v deistvie Postanovleniem Gosudarstvennogo komiteta standartov Soveta Ministrov SSSR ot 21 dekabrya 1976 g. № 2791-st: data vvedeniya 1978-01-01. M.: Izdatel'stvo standartov, 1976. 34 p.
  4. Grineva N.V., Topyrkin A.D. Geoanalytics: collection, analysis, and visualization of geographic data for solving commercial organization location problems. Innovation and Investment. 2023. No. 5. Pp. 296–302. (In Rus.).
  5. H3: Uber’s Hexagonal Hierarchical Spatial Index // Uber / Electronic resource — Access mode: https://www.uber.com/en-IN/blog/h3/ (Date of access: 02.12.2024)/
  6. Tables of Cell Statistics Across Resolutions // H3Geo / Electronic resource — Access mode: https://h3geo.org/docs/core-library/restable/ (Date of access: 02.12.2024)/
  7. Uber H3 for Data Analysis with Python // Towards Data Science / Electronic resource — Access mode: https://towardsdatascience.com/uber-h3-for-data-analysis-with-python-1e54acdcc908 (Date of access: 02.12.2024)/
  8. GOST 20886–85. Organizatsiya dannykh v sistemakh obrabotki dannykh. Terminy i opredeleniya. Utverzhden i vveden v deistvie Postanovleniem Gosudarstvennogo komiteta SSSR po standartam ot 31 yanvarya 1985 g. № 240-st: data vvedeniya 1986-07-01. M.: Izdatel'stvo standartov, 1985. 8 p.
  9. GOST R 43.0.11–2014. Informatsionnoe obespechenie tekhniki i operatorskoi deyatel'nosti. Bazy dannykh v tekhnicheskoi deyatel'nosti. Utverzhden i vveden v deistvie Prikazom Federal'nogo agentstva po tekhnicheskomu regulirovaniyu i metrologii ot 16 sentyabrya 2014 g. № 1087-st: data vvedeniya 2015-09-01. M.: Standartinform, 2018. 28 p.
  10. Chapter 7. PostGIS Reference // PostGIS / Electronic resource — Access mode: https://postgis.net/docs/reference.html (Date of access: 10.12.2024).
  11. OGC methods applied to geographic objects // Microsoft / Electronic resource — Access mode: https://learn.microsoft.com/ru-ru/sql/t-sql/spatial-geography/ogc-methods-on-geography-instances?view=sql-server-ver17 (Date of access: 10.12.2024).
  12. Part III Reference Information // Oracle / Electronic resource — Access mode: https://docs.oracle.com/en/database/oracle/oracle-database/26/spatl/reference-information.html (Date of access: 10.12.2024).
  13. Shukla D., Shivnani C. and Comp D.S. Comparing Oracle Spatial and Postgres PostGIS. International Journal of Computer Science & Communication. 2016. No. 7 (2). Pp. 95–100.
  14. Spatial Function Reference // MySQL / Electronic resource — Access mode: https://dev.mysql.com/doc/refman/8.4/en/spatial-function-reference.html (Date of access: 10.12.2024).

Supplementary files

Supplementary Files
Action
1. JATS XML
Download


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Согласие на обработку персональных данных

 

Используя сайт https://journals.rcsi.science, я (далее – «Пользователь» или «Субъект персональных данных») даю согласие на обработку персональных данных на этом сайте (текст Согласия) и на обработку персональных данных с помощью сервиса «Яндекс.Метрика» (текст Согласия).