DEEM First
Real-Time GPS Fleet Tracking Platform
Real-time GPS trailer tracking platform for a multi-state fleet, replacing manual whiteboard tracking with automated monitoring and instant location visibility.
Platform Overview
Dashboard View
Interactive Map View
Geofence Management
GPS Device Management
Mobile Dashboard
The Challenge
DEEM First needed clarity on the real-time location of their fleet of 200+ trailers deployed to jobsites across multiple states. Manual whiteboard tracking consumed valuable staff time, introduced errors, and left the company vulnerable to theft, loss, and damage. Without GPS visibility, operational inefficiencies mounted as teams struggled to locate available units, verify delivery status, and coordinate returns.
Key Problems to Solve:
- No Real-Time Visibility: Manual whiteboard tracking couldn't keep up with 200+ trailers across multiple states
- Theft & Loss Risk: No way to detect unauthorized movement, theft, or equipment left at completed jobsites
- Operational Inefficiency: Hours wasted locating available trailers, coordinating deliveries, and verifying returns
- Manual Processes: Staff spending time updating physical whiteboards instead of managing operations
- Battery Failures: No proactive monitoring of GPS device health leading to tracking gaps
- Complex Integration: Needed to connect GPS tracking with existing SQL Server business management system
Our Solution
We developed a comprehensive enterprise-grade GPS tracking web application built on Next.js 15 with dual SQL Server database integration. The system combines Teltonika TAT-141 GPS hardware with Azure Function serverless processing, automated point-in-polygon geofence detection, and real-time dashboard views. The architecture features a sophisticated dual-database system connecting GPS tracking data with business management data for unified project manager contacts and job assignments.
Staff can now monitor all trailers on an interactive Google Maps interface with custom markers, receive automated alerts for geofence transitions and low-battery conditions, and manage GPS device assignments through drag-and-drop—all replacing the manual whiteboard with a modern solution deployed on IIS/Windows Server.
Technical Architecture Highlights:
Azure Migration
Migrated from Firebase to Azure Functions with static IP addressing for secure SQL Server connectivity.
Smart Caching
30-second refresh for critical data, 5-minute cache for static reference data using React Query.
Dual-Database Integration
Seamlessly integrates GPS tracking database with business management system via optimized views.
Component Architecture
31+ reusable React components reducing code duplication by 50-67%.
Key Features Built:
Interactive Map View with Custom Markers
Real-time Google Maps visualization of 200+ trailers with custom SVG + emoji markers and hybrid mode default.
Automated Geofencing
Point-in-polygon detection alerts when trailers enter/exit warehouse, jobsite, branch, or repair locations.
Dual-Event Tracking System
Complete GPS coordinate trail plus business-meaningful events (geofence transitions, low-battery alerts).
Load Status Management
Drag-and-drop GPS device assignment with multi-job support and persistent digital notes system.
Battery Health Monitoring
Proactive 6.7V threshold alerts for Teltonika TAT-141 devices with 2.5-year Li-SOCl2 batteries.
Three Dashboard Views
SSO Groups, Project Manager, and Unassigned views with integrated contact information and filtering.
Advanced Filtering System
Multi-field search, GPS status filtering (Active/Recent/Stale/No GPS), and location reference logic.
Azure Function GPS Processing
Serverless Node.js 22 pipeline processing Flespi webhook data with static IP connectivity and GitHub Actions CI/CD.
Technology Stack:
- Frontend: Next.js 15.4.1, React 19.1.0, TypeScript 5, Tailwind CSS v4
- Data Fetching: React Query (@tanstack/react-query) with optimized caching strategies
- Maps: Google Maps JavaScript API (direct integration, custom SVG markers)
- Authentication: NextAuth 4.24.11 with Azure AD (Entra ID) integration
- Backend: Dual SQL Server databases (GPS tracking + business management), mssql v11.0.1
- GPS Processing: Azure Functions (Node.js 22, Flex Consumption), Flespi.io platform
- GPS Hardware: Teltonika TAT-141 GPS trackers with Li-SOCl2 batteries (2.5-year lifespan)
- DevOps: GitHub Actions CI/CD, IIS/Windows Server hosting
- Security: Static IP whitelisting, parameterized queries, Azure VNet with NAT Gateway
Results & Impact
DEEM First now tracks 200+ trailers in real time across warehouse, jobsite, branch, and repair-shop locations spanning multiple states. The automated system eliminated hours of daily administrative whiteboard work, reduced theft and loss risk through instant location visibility and geofence alerts, and improved operational efficiency with 30-second dashboard refresh rates and 10-second event monitoring. Project managers access trailer status, GPS coordinates, battery health, and contact information instantly through three specialized dashboard views—transforming fleet management from reactive to proactive.
Key Metrics & Achievements:
Need Real-Time Fleet Visibility?
Let's build a tracking solution that transforms your operations.