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

Capa

Citar

Texto integral

Acesso aberto Acesso aberto
Acesso é fechado Acesso está concedido
Acesso é fechado Somente assinantes

Resumo

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.

Sobre autores

Natalia Grineva

Financial University under the Government of the Russian Federation

Autor responsável pela correspondência
Email: ngrineva@fa.ru
ORCID ID: 0000-0001-7647-5967
Código SPIN: 1140-9636

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

Rússia, Moscow

Alexey Topyrkin

Russian Presidential Academy of National Economy and Public Administration

Email: topyrkinalexei@yandex.ru
Código SPIN: 1128-6044

Post-graduate Student

Rússia, Moscow

Bibliografia

  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).

Arquivos suplementares

Arquivos suplementares
Ação
1. JATS XML
Baixar


Creative Commons License
Este artigo é disponível sob a Licença Creative Commons Atribuição–NãoComercial–SemDerivações 4.0 Internacional.

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

 

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