Tournevia

A planner that builds each day’s delivery rounds, on the company’s own server.

My personal open-source project (Apache-2.0 licence), built for companies in France. It plans trucks on the real road network, with their capacity, time windows and access limits.

Nothing goes to the drivers until a dispatcher has checked the plan and marked it ready: only a ready plan can be printed or exported, and editing it clears that status.

Tools
  • Open-source software
  • Python
  • FastAPI
  • PostgreSQL
  • React
  • MapLibre
  • Valhalla
  • VROOM
Planning one day: the deliveries, the calculation, the routes on the map, then the plan marked ready. Fictional data (Transports Lemoine); the wait for the calculation is shortened. Maps: © OpenMapTiles © OpenStreetMap contributors.

At a glance

2.85%

less driving time than a simple fixed split (ten consecutive deliveries per vehicle), with all 250 deliveries served. Paris test on fictional data.

Trucks
Capacity, delivery windows, equipment, refrigerated loads, height and road access
Roads
The real road network from OpenStreetMap, with travel times for each direction
Checks
Every plan passes an independent check, then a dispatcher’s review
Tests
Up to 25 vehicles and 250 deliveries, on fictional data
Routing
Valhalla for travel times, VROOM for the optimisation
Status
Community 0.8, in development; interface in French and English

How it works

  1. CSV import preview: the count of new deliveries, then each row with its identifier, address and time window

    1Import the deliveries

    A CSV file is previewed row by row before anything is saved; deliveries can also be entered by hand.

  2. Reviewing the vehicle entrance of delivery LEM-1001: the address field, a Needs review notice and a pin on the map, Rue de Charenton in Paris

    2Check each address

    The French IGN geocoder finds the address, then the pin is moved to the vehicle entrance on the map.

  3. Route sheet for truck PL-01: it leaves the Ivry-sur-Seine depot at 10:30 and is back at 13:38, with 6 stops, 24 km and 12 Euro pallets, then the first stops

    3Hand out the route sheets

    Only a plan marked ready can be printed or exported. Editing it clears Ready.