TB-Copters Agrar GmbH•2024 – Present•gis
TB-Copters – PSMCheck: EU Plant Protection & Cadastral GIS Platform
Enterprise precision agriculture and regulatory compliance platform deployed at psmcheck.de. Built to enforce European Commission Implementing Regulation (EU) 2023/564 for mandatory electronic documentation and validation of plant protection product (PPP/PSM) treatments.
Executive Overview & Key Engineering Deliverables
- Regulatory API Integration: Direct integration with the German Federal Office of Consumer Protection (BVL) registry for real-time crop approval validation, EPPO pest code checks, and tank-mix safety verification.
- Official Cadastral GIS: Integrates Germany's official ALKIS cadastre via Web Feature Service (WFS from LGL BW), resolving parcel boundaries and municipalities against uploaded shapefiles and Leaflet GIS vector layers.
- Serverless AWS Architecture: Fully serverless deployment via Terraform utilizing Bref PHP on AWS Lambda, Amazon Aurora Serverless MySQL, Amazon SQS, and CloudFront edge CDN.
- Compliance Automation: Generates audit-ready, tamper-evident regulatory compliance dossiers in PDF format for European agricultural inspection authorities.
LaravelVue.jsInertia.jsTypeScriptTailwind CSSAWS LambdaTerraformLeafletMySQLDockerREST API
EU Regulation
IR (EU) 2023/564
Production Status
Live on psmcheck.de
Architecture
AWS Serverless + Bref
Cadastre System
ALKIS WFS (LGL BW)
LIVE SYSTEM SIMULATION & INTERACTIVE PREVIEW
STATUS: ACTIVE WEBGL/SIMPSMCHECK EU PLANT PROTECTION // ALKIS CADASTRE & BVL COMPLIANCE ENGINE
ALKIS WFS (LGL BW) • BVL CHEMICAL REGULATION • AWS SERVERLESS BREFPSMCHECK REGULATORY VERIFICATION ENGINEIR (EU) 2023/564
ALKIS Cadastre (LGL-BW WFS) • BVL Chemical Catalog • AWS Lambda Bref PHP 8.4
LAMBDA: 14.2msAURORA: 0.5 ACUWIND: 2.1 m/s (SAFE)
Select Agricultural Cadastral Parcel:
WFS LGL-BW: EPSG:25832 (UTM 32N)RTK FIXED (±1.2cm)
PARCEL:4821/1(268m ASL, 1.2% (Arable Plain))
CROP:Winter Wheat (TRZAX)
WATER BUFFER:5m SETBACK VERIFIED
SPRAY COVERAGE:3% (0.1 ha)
Select Authorized PPP / PSM Product:
Ascra Xpro✅ BVL APPROVED
ACTIVE INGREDIENTS:Fluopyram (65 g/l) + Bixafen (65 g/l) + Prothioconazol (130 g/l)
TARGET PEST:Septoria Leaf Blotch (Zymoseptoria tritici) (SEPTTR)
AUTHORIZED DOSE:1.5 L/ha (200 L/ha H₂O)
WAITING PERIOD:35 Days prior to harvest
AWG PARTNER TANK-MIX DETECTED:
Karate Zeon (0.075 L/ha) • psm_awg_partner: Authorized Insecticide Partner
TOTAL FORMULATION NEEDED:
6.30 Liters
Field: 4.2 ha
@ 1.5 L/ha rate
FULL-STACK SYSTEM ARCHITECTURE SPECIFICATION
CLIENT & UI TIER
- Vue Single-Page Application with Inertia.js, TypeScript, Tailwind CSS, and accessible UI component architecture.
- Interactive geospatial mapping engine utilizing Leaflet for vector parcel editing and Turf.js for topological validation.
- Multi-lingual internationalization (vue-i18n) across 4 languages (German, English, French, Spanish) with responsive smartphone-first layouts.
- Client-side geospatial ingestion pipeline parsing ESRI shapefiles with coordinate reprojection and topological validation.
API & REAL-TIME ENGINE
- Domain-Driven Design (DDD) & Clean Architecture on Laravel: decoupled Controllers, Command Pattern Actions, Domain Services, and Repositories.
- Automated BVL synchronization engine mapping German plant protection authorizations, authorized application areas, waiting periods, and chemical partner combinations.
- ALKIS Web Feature Service (WFS) integration querying official Baden-Württemberg cadastral parcel boundaries via GeoJSON/GML spatial intersections.
- Asynchronous cadastral parcel background verification jobs and artisan CLI daemons executed via Amazon SQS with optimized parcel caching.
DATA & INFRASTRUCTURE
- Amazon Aurora Serverless (MySQL) with automated dynamic capacity scaling and private VPC subnet isolation.
- Normalized schema modeling agricultural parcel geometries, multi-field groupings, and treatment application records with multi-tenant user isolation.
- BVL regulatory catalog schema storing plant protection products, application areas, crop associations, target pests, and tank-mix partners.
- Audited compliance ledger ensuring 3-year tamper-evident documentation retention conforming to EU 2023/564 legal recordkeeping mandates.
- Infrastructure as Code (IaC) via HashiCorp Terraform orchestrating multi-region AWS serverless cloud resources.
- Serverless PHP runtime powered by Bref on AWS Lambda with dedicated Web, CLI, and asynchronous SQS queue worker handlers.
- Amazon API Gateway coupled with Amazon CloudFront CDN for zero-latency static asset distribution and origin access control.
- Automated CI/CD deployment pipeline via GitHub Actions deploying releases with zero-downtime database migrations and automated asset sync to S3.
ROLE-BASED WORKFLOW SPECIFICATION (RBAC)
Super Administrator / Platform ManagerPLATFORM GOVERNANCE & REGULATORY CONTROL
- ▸Administer user accounts, company profiles, and subscription tiers across agricultural enterprises
- ▸Monitor BVL synchronization pipelines and inspect ALKIS WFS query telemetry and error logs
- ▸Supervise platform-wide application activity, shapefile volume statistics, and system health metrics
- ▸Manage regulatory compliance updates, legal disclaimers, and official advisory office directories
Agricultural Business Owner / AgronomistFARM ENTERPRISE & COMPLIANCE MANAGEMENT
- ▸Import and manage farm boundary shapefiles, create multi-field parcel groups, and draw field boundaries
- ▸Plan and record plant protection measures with automatic BVL legality checks and AWG partner detection
- ▸Export legally compliant documentation dossiers (PDF/Excel) for government inspection and auditing
- ▸Inspect interactive crop distribution, pest frequency, and chemical application analytics on the dashboard
Drone Pilot / Field ApplicatorTACTICAL FIELD SPRAYING OPERATIONS
- ▸Access designated field parcel geometries and application parameters on mobile and tablet devices
- ▸Log real-time application telemetry: weather conditions (wind speed, temperature), equipment IDs, and actual dosage
- ▸Review field-specific buffer zones, water body protection distances, and maximum authorized spray rates
- ▸Verify cadastral parcel boundaries on Leaflet satellite maps prior to drone launch and swath execution
Key Technical Achievements
- 01EU 2023/564 Legal Compliance Engine: Engineered the end-to-end digital documentation pipeline satisfying Commission Implementing Regulation (EU) 2023/564 with tamper-evident 3-year recordkeeping and instant audit PDF generation.
- 02ALKIS Cadastre Integration: Integrated Baden-Württemberg's official Web Feature Service (LGL BW WFS) to query cadastral parcels, districts, and municipalities from GeoJSON spatial polygons with spatial query caching.
- 03BVL Regulatory Verification & Partner Detection: Architected real-time verification against the Federal Office of Consumer Protection registry, validating crop approvals, EPPO pest codes, and detecting chemical partner compatibility.
- 04Client-Side Vector GIS Processing: Built in-browser ESRI shapefile parsing and Leaflet vector drawing with standard projection coordinate conversion and Turf.js topology validation.
- 05AWS Serverless Cloud Architecture: Provisioned complete AWS infrastructure via Terraform using Bref PHP on AWS Lambda, Amazon Aurora Serverless MySQL, SQS queues with dead-letter reliability, and CloudFront edge CDN for psmcheck.de.
- 06Strict Layered Laravel Architecture: Implemented Clean Architecture with Command Pattern Actions, dedicated Domain Services, Repository interfaces, and comprehensive test coverage.
Measurable Impact & Production Verification
Successfully architected and launched PSMCheck as an enterprise agricultural compliance SaaS on AWS Serverless, enabling German farmers and commercial drone operators to seamlessly comply with EU 2023/564 while automating cadastral parcel resolution.
Key Production Deliverables & Verification
Production Platform Deployment
Live commercial deployment at psmcheck.de provisioned via Terraform on AWS Serverless.
Official ALKIS Cadastre Integration
Validated WFS spatial intersection pipeline querying Baden-Württemberg cadastral parcels with sub-second response times.
BVL Regulatory Pipeline
Real-time validation of plant protection authorizations, EPPO crop/pest codes, and automatic tank-mix partner detection.
EU 2023/564 Compliance Verification
Automated generation of audit-ready documentation dossiers with verified 3-year digital archive compliance.