Skip to content
← All workDeployed

Warehouse Pallet & Fleet Tracking

Built a warehouse and logistics visibility console that locates pallets and forklifts on annotated floor plans, tracks trucks on Azure Maps with covered-versus-remaining routing, and digitises inbound-to-dispatch operations over an Express and SQL Server API.

Role
Frontend engineer · geospatial & tracking UI
Year
2021–2023
Type
IoT & digital twins
Stack
React · Azure Maps (Route Directions, Search) · Node.js · Express · Microsoft SQL Server · MobX · Material UI · amCharts · Annotorious · SheetJS · Azure App Service
stage inbound-to-dispatch workflow digitised
5
pallet ageing bands tracked per zone
5

The problem

Warehouse teams running tagged pallets and forklifts needed to know which zone each pallet was in, how long it had aged there, whether forklifts were working and where outbound trucks were on route. Inbound and outbound work, from receiving through palletisation and picking to dispatch, was still spreadsheet-driven.

Architecture

  1. 01

    Data

    Express routes over SQL Server tables for pallets, bags, inventory, picklists, zones, events, history and alerts.

  2. 02

    State

    A single MobX observable store shares location, pallet, inventory, palletisation and picking data across workflow tabs.

  3. 03

    Indoor geospatial

    Zones stored as pixel rectangles on floor-plan images; pallet-label search highlights the matching zone as a W3C annotation.

  4. 04

    Outdoor routing

    Parallel Azure Maps Route Directions calls split each journey into covered and remaining legs, rendered as separate line layers.

  5. 05

    Operations

    SheetJS parses inventory workbooks in-browser for reviewed bulk inserts; picking and dispatch flows end in printable, barcoded documents.

  6. 06

    Hosting

    Static build on Azure App Service behind Azure AD sign-in.

Engineering highlights

  • 01

    Covered vs remaining routing

    Split each truck journey into two parallel Azure Maps Route Directions requests around the current position, drew covered and remaining legs as distinct line layers, and derived departure, arrival and total distance from a full-route call.

  • 02

    Floor-plan pallet search

    Built the indoor map: Inbound and Dispatch zones modelled as pixel rectangles on a floor-plan image, with dynamic pallet-label search resolving the pallet's zone and highlighting it as a W3C annotation in Annotorious.

  • 03

    Pallet journey tracking

    Built the pallet view page, a status-tracking progress bar across each pallet's journey, and dynamic dashboard charts for pallet and forklift KPIs.

  • 04

    In-browser bulk ingestion

    Excel and CSV inventory workbooks are parsed client-side with SheetJS, staged for user review in a dialog, then committed through the API into the inventory table.

  • 05

    Lightweight shared state

    A single MobX observable store shares pallet, inventory, palletisation and picking data across the five inbound/outbound tabs without Redux boilerplate.

  • 06

    Re-hosting pass

    Delivered the 2026 bug-fix and re-hosting pass: sidebar and monitoring-map fixes, plus identity client and API endpoint reconfiguration for the new App Service deployment.

Next projectAngular 10 → 21 SPA Migration