Originally published by Guilherme Viegas in collaboration with colleagues at Aquarela Advanced Analytics.


There is immense analytical value in representing reality through spatial visualizations. When exploring geographic data, we instinctively look at maps constructed from political and administrative boundaries: nations, states, municipalities, and neighborhoods.

However, political boundaries produce irregular polygons of vastly different shapes, land areas, and perimeter ratios. This irregularity introduces severe statistical distortion—a phenomenon deeply studied in spatial data science known as the Modifiable Areal Unit Problem (MAUP).

Standard Business Intelligence (BI) dashboards often fail to account for this bias. In this article, we examine what happens when georeferenced data is distorted by arbitrary boundaries, how Geographic Normalization resolves this challenge through regular hexagonal tessellation, and its direct implications for machine learning and decision-making.


1. The Core Problem: The Bias of Irregular Polygons

Consider a typical territory subdivided into irregular statistical districts:

Figure 1: Distortions of Irregular Polygons vs. Regular Hexagonal Normalization Figure 1 – Source: Adapted from Commercial and Industrial Geography research / Aquarela Advanced Analytics.

Notice the green point marker in Figure 1b:

  • It sits near the boundary of polygon 14, immediately adjacent to polygons 16 and 18.
  • Which region exerts the strongest economic or geographic pull on this point?
  • Is it representative of region 14, 16, or 18?

Under traditional choropleth analysis, this point is lumped exclusively into region 14, ignoring the reality that spatial processes operate continuously across human-drawn borders.

The Inherent Flaws of Administrative Polygons:

  1. Asymmetric Area Comparisons: Large rural districts naturally dominate visual perception despite having low population density, while dense urban clusters vanish into tiny geographic slivers.
  2. Mandatory Relativization: Analysts cannot reliably interpret raw counts (crimes, hospital beds, store sales) without normalizing by population or land area, adding cognitive overhead.
  3. Artificial Granularity Limits: Administrative units cannot easily be subdivided or aggregated continuously.
  4. Boundary Artifacts: True spatial clusters that straddle municipal lines are split apart and artificially diluted.

2. What Is Geographic Normalization?

To overcome the distortions of irregular political geography, advanced analytics systems (such as Aquarela’s Vorteris platform) implement Geographic Normalization.

Definition: Geographic Normalization is the transformation of a continuous geographic territory into a uniform tessellation of regular polygons of identical shape, area, and spatial properties.

By overlaying a regular grid across the landscape, spatial data points (customers, addresses, sensors, points of interest) can be aggregated into homogeneous spatial cells. This permits direct comparison using both absolute counts and relative ratios free of area-induced distortion.

Why Hexagons? (Hexagonal Tessellation)

While a regular grid can mathematically be formed using squares, equilateral triangles, or hexagons, hexagons are mathematically superior for spatial modeling:

  • Consistent Neighbor Distance: In a square grid, diagonal neighbors are $\sqrt{2} \approx 1.414$ times farther apart than orthogonal neighbors. In a hexagonal grid, the distance between the centroid and all six adjacent neighbors is identical.
  • Minimization of Perimeter-to-Area Ratio: The regular hexagon minimizes perimeter distortion and edge effects, offering the closest planar approximation to a circle.
  • Enhanced Spatial Autocorrelation: The First Law of Geography states:

“All things are related to everything else, but near things are more related than distant things.” — Waldo Tobler

Because all neighboring cells share equidistant contact borders, machine learning algorithms that detect spatial autocorrelation (such as Moran’s $I$, spatial lag models, and convolutional graph networks) perform with far higher stability and statistical validity.


3. Real-World Application: Mesoregions vs. Hexagonal Grids

In enterprise applications, replacing administrative divisions with uniform spatial tessellations reveals patterns that were previously masked.

Below is a direct comparison across the state of São Paulo and Southeastern Brazil:

Figure 2: Analysis with Irregular Mesoregions vs. Uniform Hexagons across Southeastern Brazil Figure 2 – Source: Aquarela Advanced Analytics (2020).

  • Left (Traditional Mesoregions): The visual weight is heavily skewed toward expansive western agricultural regions, obscuring the hyper-concentrated economic reality of the metropolitan and coastal industrial hubs.
  • Right (Normalized Hexagonal Grid): Every hexagonal cell covers an identical physical territory. Spatial density contrasts stand out clearly, enabling direct like-for-like comparisons across the entire state.

4. Multi-Resolution Exploration & Interactive Analytics

Normalized spatial geography is especially powerful when paired with multi-scale interactive maps.

In the visualization below, schools and educational facilities in the city of Curitiba (Paraná, Brazil) are dynamically aggregated into regular hexagonal clusters:

Figure 3: Interactive Hexagonal Aggregation of Schools in Curitiba Figure 3 – Source: Aquarela Advanced Analytics (2020).

Key Properties of Multi-Resolution Grids:

  • Dynamic Scale Adjustment: As analysts zoom in or out, hexagonal apertures can dynamically adapt (e.g., utilizing hierarchical discrete global grid systems like Uber H3).
  • Density Invariance: The color gradient reflects true spatial density rather than administrative district size.
  • Point-in-Polygon Summaries: Millions of raw GPS telemetry points, transaction logs, or epidemiological occurrences can be indexed into uniform spatial buckets in $O(1)$ lookup time.

5. Methodological Limitations to Keep in Mind

While regularized spatial grids provide immense value, they do not render traditional boundaries obsolete:

  1. Jurisdictional Realities: Taxation, municipal budgeting, electoral districts, and police jurisdictions are inherently bound to legal political divisions. When reporting to statutory bodies, data must ultimately be reconciled with official boundaries.
  2. Data Sparsity in Rural Zones: In extremely sparse territories with few recorded observations, regular grids can produce large numbers of empty cells unless multi-resolution hierarchies are used.
  3. Computational Complexity: Projecting, aggregating, and joining millions of geocoded records across fine-grained global grids for thousands of cities requires distributed computing architectures (such as Apache Spark or GPU-accelerated spatial databases).

6. Conclusion & Recommendations

Geographic normalization bridges the gap between raw spatial telemetry and statistically sound business intelligence. By neutralizing the distortive artifacts of arbitrary political lines, data teams can uncover the true geographic patterns governing markets, logistics, and demographic movements.

Strategic Recommendations:

  • Adopt Multi-Faceted Visualizations: Use regular hexagonal tessellations for predictive modeling, hotspot discovery, and spatial machine learning; reserve administrative boundaries for legal, budgetary, and operational reporting.
  • Standardize on Discrete Global Grids: Consider adopting standardized spatial indexing frameworks (such as H3 or S2) to unify data lakes across varied spatial resolutions.
  • Acknowledge Spatial Continuity: Remember that human behavior and economic flows do not halt at county lines—and our analytical models shouldn’t either.

For further discussion on enterprise AI architectures and spatial data engineering, visit the original publication at Aquarela.