Skip to main content
Joseph AroGeospatial Intelligence
Data Strategy12 min read

From Field Acquisition to Executive Insight: Designing the Full Geospatial Chain

Joseph Aro

Joseph Aro

Lead Data & Information · Teck Resources Ltd.

The geospatial chain is technically mature at acquisition and analysis. It breaks at communication. Here is how to complete it — all the way to executive decision.

If your dashboard needs another analyst to interpret it, it is not a dashboard. It is a problem wearing a beautiful mask.

The Chain Exists. The Break is Real.

I have been in rooms where the data was right, the analysis was solid, and the map was technically flawless — and the director across the table still could not tell me what decision to make next.

Not because he lacked intelligence. Not because he did not care. But because what we handed him was designed for us, not for him.

This is the defining failure of geospatial work in most organisations today. We have mastered the craft of data collection. We know how to deploy KoboToolbox in the field, geo-reference survey points, run AHP-weighted multi-criteria analysis, and render outputs in ArcGIS or QGIS with layers that would make a cartographer weep with joy. We have built flood risk models using hazard indices that integrate drainage density, precipitation, slope, soil type, and population density. We have mapped building footprints across entire urban corridors to estimate population to a high degree of accuracy. We have done the work.

But somewhere between the GPS point captured at 7am on a Lagos street and the moment a Commissioner signs a budget decision, the chain breaks.

That break is not technical. It is communicative. And it is costing us the very outcomes our work is supposed to drive.

What We Actually Do in the Field

Let me be specific about what the geospatial chain looks like, because the executives reading this deserve to understand what they are funding — and the analysts reading this need to see where the handoff goes wrong.

The chain starts in the field. A survey team, trained and equipped, deploys with smartphones loaded with ODK or KoboCollect. Every data point carries a GPS coordinate. Quality assurance protocols run across four stages — pilot testing, enumerator training, on-ground supervision, and incoming data review. This is not casual. In the Lagos slum upgrading studies I have been part of, enumerators were trained on skip patterns, regex constraints on phone numbers and addresses, and on-the-spot validity checks. The data integrity at this stage is high.

From field collection, data flows into a processing environment — QGIS, ArcGIS, or a model-based pipeline. Spatial joins link survey points to administrative boundaries. Raster analysis layers elevation models over flood risk parameters. We run geometric network analysis to trace drainage flow. We model. We validate. We iterate.

The output is technically sophisticated. A flood risk map for a Lagos Local Government Area integrates six variables into a single composite score:

Flood Risk = Hazard Index × Vulnerability Index
Hazard Index = 0.13×D + 0.07×ST + 0.25×S + 0.55×P
Vulnerability Index = 0.26×PD + 0.64×LULC + 0.1×ED

Where D = drainage density, ST = soil type, S = slope, P = precipitation, PD = population density, LULC = land use land cover, ED = Euclidean distance.

Every coefficient in that formula was derived from literature and weighted through Analytical Hierarchy Process. There are academic papers behind it. There are validation datasets behind it. It is rigorous.

And then we put it in a dashboard with seven map layers, a 16-colour legend, a spatial statistics panel, and a sidebar of charts — and call the Commissioner in.

The Dashboard Problem Is Not a Design Problem

I want to be careful here, because the easy answer is to say “make it prettier.” That is wrong.

The problem is not aesthetics. The problem is audience confusion at the point of design. We build dashboards to demonstrate technical competence, not to drive decisions. We include every layer because removing one feels like admitting it was unnecessary. We use every colour in the palette because the data genuinely has that many categories. We add the confidence intervals and the p-values because our academic training taught us that omitting them is dishonest.

None of this is wrong in intent. All of it is wrong in effect when the audience is an executive whose cognitive budget in a meeting is already stretched, whose mandate is to allocate resources, approve interventions, or redirect programmes — not to interpret spatial autocorrelation.

In Nigeria, I have sat in rooms with LAMATA executives, with State Ministry of Works directors, with FERMA representatives. Smart, accomplished people. In every case, when we deployed a technically rich dashboard without a decision framework, the meeting drifted. Questions came back to us: “What does this mean for our priority?” “Which area do we act on first?” “Is this telling us to stop the project or continue?”

Those are not questions that indicate the executive failed to read the dashboard. Those are questions that indicate the dashboard failed to do its job.

The Two Dashboard Archetypes

The Beautiful But Broken Dashboard

This is what most geospatial teams produce. Characterised by:

  • Multiple simultaneous map layers with opacity blending
  • A colour ramp that spans the full spectrum from red to blue, with intermediate values that are genuinely ambiguous to the human eye
  • Statistics panels displaying outputs like Moran’s I, NDVI values, or kernel density estimates without contextual interpretation
  • Charts that show the distribution of every variable rather than the relationship between the variables that matters for the decision
  • A title that describes what the data is, not what the data means

It looks professional. It is informationally dense. It communicates nothing actionable.

I have produced dashboards exactly like this. The pivot map of the Ogun-Oshun River Basin water resources study, the flood vulnerability outputs for Lagos flood events, the drainage sedimentation models — all technically valid, all requiring a GIS analyst in the room to walk a decision-maker through what they were looking at.

That is not a dashboard. That is a presentation dependency.

The Functional Decision Dashboard

A functional executive dashboard answers exactly one question per view. Not one category of questions. One question.

For a flood risk intervention programme, the question might be: “Which three LGAs require immediate infrastructure prioritisation based on combined hazard and vulnerability scores?”

Everything on that dashboard serves that question. The map shows those three LGAs, highlighted, with the others greyed. A single ranked table below the map shows the score, the key driver variable, and the recommended intervention type. A traffic-light indicator tells the executive whether the situation in each area is stable, deteriorating, or critical. The chart, if there is one, shows one comparison — last season versus this season — not seven years of trend data.

The number of clicks to reach a decision: zero. The number of additional analysts required: zero. The time from opening the dashboard to knowing what to recommend: under ninety seconds.

That is the standard. Not beautiful. Decisive.

What the executive sees: technically dense, decision-absent

  • Multi-layer opacity blending (7 active layers)
  • Moran's I = 0.743 (z=4.21, p<0.001)
  • NDVI mean ± σ: 0.31 ± 0.08
  • 16-colour composite risk legend
  • Precipitation anomaly 2016–2023

Result: The Commissioner asks “What does this mean for our priority?” The analyst is called back in. No decision is made in the meeting.

What a Functional Geospatial Dashboard Looks Like

The anatomy of a functional decision dashboard has five elements, in strict hierarchy:

1. The Decision Header
A plain-language statement of the question this dashboard is designed to answer. Not a title. Not a project name. A question. Example: “Where should we deploy the next phase of drainage intervention?”

2. The Primary Signal
One number, one zone, or one map — the single most important output the decision-maker needs to see first. It should be visible without scrolling, without hovering, without clicking. It should be large enough to read from across a conference table.

3. The Context Layer
The supporting data that explains the primary signal. This is where the analyst’s work lives — the composite scores, the ranked comparisons, the trend lines. But it is subordinate to the primary signal, not parallel to it.

4. The Boundary Conditions
The constraints the decision-maker already knows about — budget limits, political boundaries, institutional mandates — surfaced explicitly so the dashboard speaks the language of the executive’s actual decision environment.

5. The Next Action
A specific recommended action, stated in operational language. “Prioritise drainage desiltation in Oshodi-Isolo and Alimosho LGAs before the next rainy season.” Not “data suggests elevated risk in western LGAs.” An action.

The Conversion Question

Geospatial teams that want to remain relevant — especially in contexts like Nigeria where GIS adoption is still fighting for legitimacy in government and enterprise — need to understand that dashboards are not deliverables. They are conversion tools.

The conversion we are after is not page views or session time. It is decision adoption. Did the executive act on what the data said? Did the Commissioner sign the intervention order? Did the planning director change the resource allocation?

Every design decision in a functional dashboard should be evaluated against that conversion question. Does adding this layer increase the likelihood that the right decision gets made? Does this chart help or complicate? Does this colour choice make the signal clearer or more ambiguous?

In Lagos, the government spent billions of Naira in 2008 setting up the Lagos Enterprise GIS. A decade later, that platform had not driven the planning outcomes it was built to enable. Not because the data was wrong. Because the chain from data to decision was never completed. The field acquisition happened. The analysis happened. The visualisation happened. The executive insight layer — the part that turns a map into a mandate — was missing.

That layer is what we build now.

Designing the Full Chain

The full geospatial chain, designed to drive decisions, has six stages:

Stage 1: Question-First Field Design
Before a single GPS point is collected, the decision the data must inform should already be defined. What is the Commissioner going to be asked to approve? What does the director need to allocate? Field instruments, sampling strategies, and quality assurance protocols flow from that question — not from a data catalogue.

Stage 2: Analyst-Grade Processing
This is where technical rigour belongs. Multi-criteria analysis. Spatial statistics. Model validation. The full technical stack. This stage is for the analyst. It should not be visible to the executive.

Stage 3: Insight Translation
The hardest stage, and the one most teams skip. Taking the outputs of Stage 2 and translating them into the language of the decision. What does a flood risk score of 0.74 actually mean for a Commissioner? It means: this community will flood in a moderate rain event, 6,000 residents are at risk, and the infrastructure investment to reduce that risk to acceptable levels is a specific kind of intervention, in a specific sequence.

Stage 4: Dashboard Architecture
One question. One primary signal. One next action. Everything else is context, subordinated, collapsible, available on request but not defaulted to visible.

Stage 5: Executive Briefing Protocol
The dashboard does not replace the briefing. It replaces the confusion in the briefing. A sixty-second verbal orientation to the decision question, a pointer to the primary signal, a clear statement of the recommendation. Then the executive engages with specifics.

Stage 6: Decision Audit
Was the action taken? Was the recommendation followed? If not, where in the chain did the conversion fail? This closes the loop and improves the next iteration.

The GIS Adoption Problem Is a Communication Problem

I have given hundreds of talks on GIS. I tore through five drafts preparing for a ministerial session years ago, and I still walked in unsure what would move the needle. The single most difficult challenge GIS adoption faces in Nigeria — and across most of the global south — is its misunderstanding by the executives who are meant to sign off on its implementation.

That misunderstanding is our responsibility to address. Not theirs.

We are the ones who designed the dashboards they could not read. We are the ones who put Moran’s I in a presentation to a Cabinet-level audience. We are the ones who, when asked what GIS means, instinctively reach for “it is like Google Maps” because we have learned, through experience, that the technically accurate answer loses the room in forty seconds.

If we want GIS to drive the decisions it is capable of driving — flood risk managed at scale, transport planned efficiently, health infrastructure located where it is needed, climate-vulnerable populations protected — we need to close the chain. All the way to the executive insight layer.

The field work is already good. The analysis is already solid. The gap is the last ten metres from dashboard to decision.

Call to Action

Build dashboards that answer one question. Hire for translation, not just for analysis. Design for the Commissioner, not for the conference paper.

And if your dashboard still needs another analyst standing next to it to explain what it means — you have not finished the job.


Joseph Aro is a Geospatial Intelligence Analyst, Climate Change Analyst, and Co-founder of OEA Consults. He has over fifteen years of experience deploying geospatial solutions across urban development, flood risk management, infrastructure planning, and climate adaptation in Nigeria and North America. He is Lead Data & Information at Teck Resources Ltd. and is licensed by Transport Canada as a UAV pilot.

For consulting, strategic advisory, or speaking engagements: josepharo.me/contact

Enjoyed this?

Get future essays and field notes delivered direct. No spam.

Share this article

All articles

Category

Data Strategy

Tags

GISDashboard DesignExecutive IntelligenceLocation IntelligenceNigeria

Reading time

12 min

Published

April 18, 2026