Spatial indexing for access to cartographic archives in GIS/AI systems: A case study of the Warsaw Local Coordinate System (W-25/W-75)
More details
Hide details
1
Department of Geodesy, University of Agriculture in Krakow
Submission date: 2025-10-13
Acceptance date: 2025-10-29
Publication date: 2026-01-09
Corresponding author
Mariusz Zygmunt
Katedra Geodezji, Uniwersytet Rolniczy im. H. Kołłątaja w Krakowie, Poland
Geomatics, Landmanagement and Landscape 2025;(4)
KEYWORDS
TOPICS
ABSTRACT
Historical city plans and rasters of Warsaw are contained within local coordinate systems (Warsaw-25/75), which makes it difficult to address and integrate them quickly into contemporary data processing pipelines. This paper systematises the problem by defining rigorous rocedures for section encoding and decoding: 1) transforming planar coordinates (X, Y) → a sheet code compliant with the N/S–O/W grammar (row, column), and 2) mapping a sheet code → the section envelope [Xmin, Ymin, Xmax, Ymax]. The proposed approach has constant time complexity O(1), employs unambiguous boundary rules, and is parameterisable (sheet dimensions, the position of the Warsaw origin), which simplifies adaptation to heterogeneous cartographic series. We demonstrate how these mechanisms plug into practical workflows: they allow one to identify the target sheet immediately from a given point, reconstruct its bounding box before loading data, and verify consistency between a code stored in metadata and a code computed from coordinates. These procedures interoperate with transformations to PUWG 2000 (PL-2000), enabling the seamless linkage of Warsaw materials with current reference databases. In AI/ML scenarios, the section code acts as a stable spatial identifier that facilitates sample selection and dataset organisation. We additionally provide numerical recommendations (ε and floor) that stabilise the classification of edge cases and remove ambiguities. The algorithms were implemented in Bentley MicroStation with Visual Basic for Applications, ensuring portability to other VBA-capable environments such as Microsoft Office. The solution requires no series lookup tables, operates directly on a metric grid, and is robust to coordinate precision variations, thereby supporting ETL automation and quality control across public administration and industry.
REFERENCES (13)
2.
Goodchild M.F. 2007. Citizens as sensors: The world of volunteered geography. GeoJournal, 69(4), 211–221.
3.
Longley P.A., Goodchild M.F., Maguire D.J., Rhind D.W. 2005. Geographic Information Systems and Science (2nd ed.). Wiley.
4.
Natural Resources Canada, 2007. National Topographic System (NTS) of Canada.
5.
Ordnance Survey. 2016. A Guide to the National Grid (Great Britain). Ordnance Survey.
6.
Parry R.B., Perkins C.R. 2002. World Mapping Today (2nd ed.). K.G. Saur.
7.
Pearson A.W., Collier P., Forrest D. 2006. Cartographic ideals and geopolitical realities: International maps of the world from the 1890s to the present. The Canadian Geographer, 50(2), 149–171.
9.
Samet H. 2006. Foundations of Multidimensional and Metric Data Structures. Morgan Kaufmann.
10.
Smith de M.J., Goodchild M.F., Longley P.A. 2018. Geospatial Analysis: A Comprehensive Guide to Principles, Techniques and Software Tools (6th ed.). The Winchelsea Press.
11.
Worboys M.F., Duckham M. 2004. GIS: A Computing Perspective (2nd ed.). CRC Press.
12.
Zygmunt M., Gniadek M., Szewczyk R. 2021. The method of determining the International Map of the World sheet number based on geographic coordinates on the example of Poland. Geomatics, Landmanagement and Landscape, 1(1), 69–77.
13.
Zygmunt M., Michałowska K., Ślusarski M. 2023. The possibilities of the use of GUGIK’s resources and functionalities in the spatial data processing and geocoding process. Geomatics, Landmanagement and Landscape, 1(3), 31–46.