← Work library

Technical assessment / Full-Stack

USSD & Geospatial Reporting

A data-driven USSD flow and PostGIS proximity search.

Contribution
Assessment implementation
Status
Engineering assessment
Project type
Technical assessment

01 / Context

Overview & purpose

A Blue ICT × Horse Capital assessment combining a PHP crime-reporting flow, spatial-search API, JavaScript dashboard and defensive log-cleanup utility.

A data-driven USSD flow and PostGIS proximity search.

02 / Contribution

My work

Developed the application components and integration work described in the project’s source and documentation.

03 / Functionality

Inside the application

  • Nested, data-driven USSD navigation
  • Geospatial proximity search
  • Vanilla JavaScript dashboard
  • Synthetic benchmark dataset and query plans

04 / Engineering

Technical perspective

The assessment explores explicit state handling, spatial indexing and defensive filesystem operations without relying on an application framework.

Have a similar challenge?

Let’s discuss it