TB Copters GmbH•Jan 2020 – Aug 2026•fullstack
TB Copters Fleet Portal – Geospatial GIS & Autonomous Flight Operations
Enterprise flight operations, geospatial GIS, and fleet dispatch platform engineered for commercial agricultural drone fleets. Architected the core Laravel REST API backend with MySQL Spatial extensions and Pusher WebSockets to coordinate live pilot tracking, autonomous flightpaths, and biocontrol supply chain logistics across European farmland.
Executive Overview & Key Engineering Deliverables
- System Architecture: Robust Laravel REST API paired with MySQL Spatial extensions (Points, LineStrings, Polygons) and spatial indexes for multi-region farm boundary mapping.
- Autonomous Trajectory Engine: Custom geometric solver calculating discrete swath flightpaths, mission acreage, and sub-meter Trichogramma biocontrol capsule drop waypoints.
- Real-Time Telemetry & AI: Pusher WebSocket pipeline streaming live pilot GPS coordinates under 200ms latency, integrated with a TypeScript Model Context Protocol (MCP) server for autonomous flight dispatching.
- Business Impact: Boosted commercial flight dispatch efficiency by 40% across European farms while automating German municipal police flight clearance workflows.
LaravelMySQL SpatialReactTypeScriptModel Context Protocol (MCP)Pusher WebSocketsAWS S3Shapefile GISDockerJenkinsOAuth2 PassportPHPUnit
Uptime
99.9%
GPS Latency
< 200ms
Spatial Precision
GIS Swath
Dispatch Boost
+40%
LIVE SYSTEM SIMULATION & INTERACTIVE PREVIEW
STATUS: ACTIVE WEBGL/SIMGEOSPATIAL FLEET SIMULATION & SWATH COVERAGE MAP
LARAVEL REST API • MYSQL SPATIAL • PUSHER WSS • MCP AI DISPATCHPUSHER WSS: CONNECTED (24ms)MYSQL SPATIAL: RTREE INDEXEDMCP AI AGENT: DISPATCH READYWIND: 2.1 m/s NW (OPTIMAL)
Sortie Sector36.2 ha TOTAL
Pusher Live Pilots2 ON ROUTE
Pilot H. MüllerTB-AGRI-01
GPS FIX:51°14'02"N, 06°45'22"E
VELOCITY / STAGING:5.2 km/h • Plot A Base
Tech K. SchmidtTB-AGRI-02
GPS FIX:51°13'45"N, 06°46'18"E
CROSSING BRIDGE:Culvert Deck • Route 2
Airspace ClearanceCLEARED
AUTHORITY:DFS Deutsche Flugsicherung
DISTRICT:Polizeipräsidium Freiburg
PERMIT CODE:ED-R-4821/A-2025
ALTITUDE CEILING:120m AGL (EASA Specific)
IoT Weather StationSTATION #04-RUR
WIND SPEED2.1 m/s (Max 5.0)
AIR TEMP19.4°C
HUMIDITY62% RH
RAIN SENSOR0.0 mm/h (DRY)
Biocontrol Supply & TelemetryTRICHOGRAMMA
TARGET PESTOstrinia nubilalis
COLD CHAIN+4.2°C (Optimal)
DISPENSER RATE100 caps / ha
SUPPRESSION EFF.98.4% (EC Reg)
DISPENSED: 834 / 3,62023%
TB COPTERS // FLIGHT RADAR
Sec A: 0%•Sec B: 39%•RTK FIXED
GIS VECTOR // 4.5m SWATH|EPSG:25832
COVERAGE:8.3 / 36.2 ha (23% )
CAPSULES DROPPED:834 / 3,620
SWATH SPACING:4.5m LANES
ACTIVE LAYER:CAD SWATH (4.5m)
Live Swath Trajectory & Sortie TelemetryMISSION ACTIVE (RTK FIXED ±1.2cm)
ACTIVE WAYPOINTWP-01 (Swath 1)Sub-meter drop trigger
AVIONICS TELEMETRY915 MHz • -64 dBm (100%)18 GPS/Galileo satellite locks
ENVIRONMENTAL GEOFENCE10m Rur River Buffer0 Breaches • Bridge transit OK
Sector A (Winter Wheat - 14.8 ha • TB-AGRI-01):0%
Sector B (Canola & Pasture - 21.4 ha • TB-AGRI-02):39%
SWATH PATTERNParallel LineStrings (4.5m)
DRONE FLEET2 Drones Active in Polygons
GROUND CREW2 Pilots on Route (Pusher WSS)
MAPPING STATUSAutonomous Coverage Active
FULL-STACK SYSTEM ARCHITECTURE SPECIFICATION
CLIENT & UI TIER
- React SPA with React-Bootstrap and i18next dual-language support (German / English).
- Interactive Leaflet & Google Maps GIS overlays rendering polygon boundaries, exclusion zones, and riparian buffer margins.
- Live WebSocket pilot radar displaying real-time drone telemetry and fleet flight vectors.
- Embedded Pilot Planner scheduling application for mission coordination and availability.
API & REAL-TIME ENGINE
- Laravel REST API utilizing MySQL Spatial extensions (Point, LineString, Polygon) and spatial indexes.
- Autonomous algorithmic swath trajectory solver calculating discrete flightpaths, hectares, and capsule drop triggers.
- Pusher WebSocket server broadcasting real-time pilot and drone GPS telemetry with optimized spatial query filtering.
- TypeScript Model Context Protocol (MCP) server enabling intelligent autonomous dispatching and spatial data operations.
- Municipal police flight clearance automation matching flight districts with police headquarters in German airspace.
DATA & INFRASTRUCTURE
- Spatial GIS database with spatial indexes across farm fields, waypoint trajectories, and IoT devices.
- Geospatial boundary ingestion pipeline extracting agricultural parcels, landscape obstacles, and environmental buffer margins.
- IoT telemetry gateway processing GNSS coordinates and field-deployed weather station meteorological feeds.
- Cold-chain logistics tracking for biological pest control (Trichogramma) capsules across central storehouses.
- Containerized microservices testing stack with isolated relational databases and S3-compatible storage, deployed via Jenkins CI/CD.
- Resilient background queue workers, automated task schedulers, and secure AWS S3 storage for flight records and geospatial assets.
Key Technical Achievements
- 01Geospatial Boundary Pipeline: Ingested official German agricultural cadastral files with WKT/GeoJSON conversion to extract farm plots, landscape features, and water buffer margins.
- 02Autonomous Swath Trajectory Engine: Computed discrete flightpaths (LineString) via custom geometric trajectory solver, calculating mission length, hectares, trigger distances, and Trichogramma capsule drop targets.
- 03Live Pilot Telemetry & WebSockets: Broadcasted real-time pilot and drone GPS fixes via Pusher WebSockets with optimized spatial subquery filtering eliminating stale radar coordinates.
- 04Model Context Protocol (MCP) AI Server: Built a TypeScript MCP server enabling AI coding and dispatch agents to autonomously execute flight coordination workflows and spatial queries.
- 05Regulatory Aviation Clearances: Automated municipal police clearance workflows matching flight mission districts with regulatory police jurisdictions in German airspace.
- 06Biocontrol Logistics & IoT Weather Stations: Managed cold-chain flow of goods for biological pest control capsules alongside field IoT weather station sensors (wind, temperature, GNSS).
Measurable Impact & Production Verification
Transformed agricultural drone operations across European farms, eliminating manual waypoint calculations, boosting flight dispatch efficiency by 40%, and pioneering MCP AI agent integration for autonomous fleet management.
Key Production Deliverables & Verification
Autonomous Trajectory Precision
Algorithmic trajectory engine generates sub-meter accurate swath flightpaths with automated Trichogramma capsule drop waypoint coordinates.
Real-Time GPS Telemetry Stream
Pusher WebSocket engine broadcasts live pilot coordinates with sub-200ms latency and high-performance spatial subquery filtering.
Model Context Protocol (MCP) Tools
Standardized agent tool suite for AI-driven workpackage assignment, field parcel queries, and pilot scheduling.
Regulatory Aviation Clearances
Municipal police flight clearance matching German airspace jurisdictions with automated PDF manifest generation.