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
- 01
Data
Express routes over SQL Server tables for pallets, bags, inventory, picklists, zones, events, history and alerts.
- 02
State
A single MobX observable store shares location, pallet, inventory, palletisation and picking data across workflow tabs.
- 03
Indoor geospatial
Zones stored as pixel rectangles on floor-plan images; pallet-label search highlights the matching zone as a W3C annotation.
- 04
Outdoor routing
Parallel Azure Maps Route Directions calls split each journey into covered and remaining legs, rendered as separate line layers.
- 05
Operations
SheetJS parses inventory workbooks in-browser for reviewed bulk inserts; picking and dispatch flows end in printable, barcoded documents.
- 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.