Fleet Carbon Route Optimization Metrics
This dataset provides detailed metrics for fleet delivery routes, including carbon emissions, fuel consumption, route optimization status, and ESG compliance. It enables transportation managers to monitor and reduce environmental impact, optimize fuel costs, and support sustainability initiatives with actionable, route-level data.
Sample rows
preview · 8 of 120 rows · all 27 columns| route_idstring | fuel_typestring | distance_kmfloat | route_optimizedboolean | optimization_methodstring | fleet_idstring | vehicle_idstring | route_datedate | start_timedatetime | end_timedatetime | start_location_streetstring | start_location_citystring | start_location_statestring | start_location_postal_codestring | start_location_countrystring | end_location_streetstring | end_location_citystring | end_location_statestring | end_location_postal_codestring | end_location_countrystring | fuel_consumed_litersfloat | carbon_emissions_kgfloat | number_of_stopsinteger | average_speed_kmhfloat | driver_idstring | esg_compliantboolean | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RTE0001 | electric | 6.3 | true | nearest-neighbor | FLEET01 | VH101 | 2024-05-01 | 2024-05-01T08:10:00 | 2024-05-01T09:41:00 | 15 Market St | San Francisco | CA | 94103 | USA | 200 Pine St | San Francisco | CA | 94111 | USA | 8.1 | 3.1 | 7 | 8.7 | DRV013 | true | Urban delivery route with multiple stops in the Financial District. Used electric vehicle and optimized for carbon reduction. |
| RTE0002 | hybrid | 2.8 | true | genetic-algorithm | FLEET02 | VH102 | 2024-05-03 | 2024-05-03T12:22:00 | 2024-05-03T18:36:00 | 51 Fleet St | London | ENG | EC4Y 1AA | UK | 73 Oxford St | London | ENG | W1D 2ES | UK | 2.2 | 2.6 | 5 | 5.1 | DRV014 | true | Dense city delivery between major retail locations. Hybrid vehicle selected for ESG compliance. |
| RTE0003 | diesel | 584.2 | false | blank | FLEET01 | VH103 | 2024-05-02 | 2024-05-02T23:58:00 | 2024-05-03T06:07:00 | 1100 Highway 1 | Los Angeles | CA | 90001 | USA | 1000 Folsom St | San Francisco | CA | 94107 | USA | 115.7 | 309.1 | 1 | 87.5 | DRV018 | false | Long-haul overnight transfer between LA and SF. Diesel truck used, no carbon optimization performed. |
| RTE0004 | electric | 4.4 | true | ant-colony | FLEET03 | VH104 | 2024-05-05 | 2024-05-05T10:15:00 | 2024-05-05T11:03:00 | 5 Rue de Rivoli | Paris | IDF | 75001 | France | 52 Avenue de l'Opera | Paris | IDF | 75002 | France | 6.8 | 2.4 | 6 | 7.1 | DRV005 | true | Electric van used for central Paris document delivery. Route optimized for low emissions. |
| RTE0005 | other | 0 | false | blank | FLEET04 | VH105 | 2024-05-06 | 2024-05-06T08:00:00 | 2024-05-06T08:00:00 | 120 Queen St | Auckland | AUK | 1010 | NZ | 120 Queen St | Auckland | AUK | 1010 | NZ | 0 | 0 | 0 | 0 | blank | false | Test route for system calibration. No actual movement or emissions recorded. |
| RTE0006 | hybrid | 8.2 | true | tabu-search | FLEET05 | VH106 | 2024-05-07 | 2024-05-07T14:00:00 | 2024-05-07T17:11:00 | 55 Yonge St | Toronto | ON | M5E 1J4 | Canada | 200 Bloor St E | Toronto | ON | M4W 1A8 | Canada | 7.6 | 3.6 | 12 | 9.9 | DRV009 | true | Downtown Toronto parcel delivery, hybrid vehicle. Optimized for delivery time and carbon output. |
| RTE0007 | diesel | 386.7 | false | blank | FLEET06 | VH107 | 2024-05-09 | 2024-05-09T06:45:00 | 2024-05-09T23:41:00 | 1 Bahnhofstr. | Frankfurt | HE | 60329 | Germany | 88 Karlstr. | Munich | BY | 80335 | Germany | 77.2 | 206.9 | 2 | 41.7 | DRV010 | false | Long-haul intercity freight between Frankfurt and Munich. Diesel truck, no optimization. |
| RTE0008 | electric | 7.1 | true | brute-force | FLEET07 | VH108 | 2024-05-10 | 2024-05-10T13:30:00 | 2024-05-10T14:35:00 | 68 Orchard Rd | Singapore | SG | 238839 | Singapore | 15 Raffles Blvd | Singapore | SG | 039803 | Singapore | 6.2 | 2.4 | 10 | 6.5 | blank | true | VIP document delivery in Singapore, security protocol, electric van and optimized for emissions. |
| RTE0009 | electric | 4.8 | true | nearest-neighbor | FLEET08 | VH109 | 2024-05-12 | 2024-05-12T08:00:00 | 2024-05-12T16:45:00 | 9 Zhongguancun St | Beijing | BJ | 100080 | China | 88 Chaoyang St | Beijing | BJ | 100020 | China | 5.8 | 2.5 | 6 | 8.1 | DRV002 | true | Central Beijing express delivery for government offices. Route optimized for speed and carbon reduction. |
| RTE0010 | gasoline | 386.7 | false | blank | FLEET09 | VH110 | 2024-05-13 | 2024-05-13T07:05:00 | 2024-05-13T11:27:00 | 34 Main St | Boston | MA | 02108 | USA | 500 Park Ave | New York | NY | 10022 | USA | 89.5 | 210.7 | 1 | 99.7 | DRV016 | false | Intercity express delivery from Boston to NYC, gasoline van used. No optimization for carbon. |
| RTE0011 | hybrid | 2 | true | tabu-search | FLEET03 | VH111 | 2024-05-14 | 2024-05-14T09:45:00 | 2024-05-14T10:18:00 | 22 Downing St | London | ENG | SW1A 2AA | UK | 15 Parliament Sq | London | ENG | SW1P 3JX | UK | 1.7 | 1.9 | 3 | 4.5 | blank | true | VIP government delivery in London. Hybrid vehicle used, security protocol, optimized for ESG. |
| RTE0012 | electric | 1.4 | true | ant-colony | FLEET02 | VH112 | 2024-05-15 | 2024-05-15T18:00:00 | 2024-05-15T21:42:00 | 380 Wellington St | Ottawa | ON | K1A 0A9 | Canada | 77 Rideau St | Ottawa | ON | K1N 5A9 | Canada | 1.9 | 0.7 | 2 | 6.5 | DRV007 | true | Short-range Ottawa office delivery, electric van and ant-colony optimization. |
| RTE0013 | electric | 8.2 | true | dynamic-programming | FLEET10 | VH113 | 2024-05-16 | 2024-05-16T10:20:00 | 2024-05-16T15:47:00 | 88 Champs-Élysées | Paris | IDF | 75008 | France | 23 Rue Saint-Dominique | Paris | IDF | 75007 | France | 7.2 | 2.9 | 13 | 9.4 | DRV015 | true | Urban Paris pharmaceutical delivery, multiple stops. Electric van, dynamic-programming optimization. |
| RTE0014 | diesel | 541 | false | blank | FLEET08 | VH114 | 2024-05-17 | 2024-05-17T05:50:00 | 2024-05-17T17:34:00 | 2000 Hwy 401 | Montreal | QC | H3Z 2Y7 | Canada | 500 King St W | Toronto | ON | M5V 1M3 | Canada | 106.3 | 283.9 | 2 | 34.7 | DRV004 | false | Long-haul Canadian intercity delivery, diesel truck, express delivery, no optimization. |
| RTE0015 | electric | 2.8 | true | linear-programming | FLEET06 | VH115 | 2024-05-18 | 2024-05-18T09:05:00 | 2024-05-18T09:28:00 | 32 Nanjing Rd | Shanghai | SH | 200001 | China | 88 Huaihai Rd | Shanghai | SH | 200021 | China | 3.5 | 1.3 | 4 | 10.2 | blank | true | Urban Shanghai delivery, electric van, route optimized for time and emissions. |
| RTE0016 | diesel | 642.6 | false | blank | FLEET09 | VH116 | 2024-05-19 | 2024-05-19T14:50:00 | 2024-05-19T17:11:00 | 19 Queen St | Auckland | AUK | 1010 | NZ | 2 Victoria St | Wellington | WLG | 6011 | NZ | 124.8 | 333.5 | 2 | 99.1 | DRV011 | false | Long-haul NZ delivery, Auckland to Wellington, two stops, diesel truck, no carbon optimization. |
| RTE0017 | electric | 1.4 | true | simulated-annealing | FLEET10 | VH117 | 2024-05-20 | 2024-05-20T08:15:00 | 2024-05-20T09:44:00 | 99 Wall St | New York | NY | 10005 | USA | 85 Broadway | New York | NY | 10007 | USA | 2.1 | 0.8 | 3 | 6.1 | DRV003 | true | Manhattan micro-delivery, electric van, optimized for delivery sequence and ESG. |
| RTE0018 | hybrid | 2 | true | brute-force | FLEET01 | VH118 | 2024-05-21 | 2024-05-21T10:00:00 | 2024-05-21T16:31:00 | 555 Wellington St | Ottawa | ON | K1A 0A9 | Canada | 360 Sussex Dr | Ottawa | ON | K1N 7B9 | Canada | 2.4 | 1.8 | 5 | 4.8 | blank | true | Short Ottawa government delivery, hybrid van, brute-force optimization, security protocol. |
| RTE0019 | hybrid | 4.4 | true | ant-colony | FLEET02 | VH119 | 2024-05-22 | 2024-05-22T07:00:00 | 2024-05-22T08:37:00 | 10 King St | Toronto | ON | M5C 1C3 | Canada | 35 Queen St W | Toronto | ON | M5H 2M7 | Canada | 3.9 | 2.2 | 7 | 8.5 | DRV019 | true | Toronto urban delivery, hybrid van, optimized for carbon reduction, multi-stop route. |
| RTE0020 | electric | 6.3 | true | dynamic-programming | FLEET03 | VH120 | 2024-05-23 | 2024-05-23T16:00:00 | 2024-05-23T22:45:00 | 1 Rue de Lyon | Marseille | PAC | 13001 | France | 45 Avenue du Prado | Marseille | PAC | 13008 | France | 7.4 | 3.7 | 10 | 12.1 | DRV012 | true | Marseille delivery for medical supplies, electric van and dynamic-programming optimization. |
What the 120 rows show
from the 120-row sampleDiesel (fuel type) stands out: mean distance_
- 73%route_
optimized = true - 6.3median distance_
km - 9start location countries
- 9end location countries
- 20fleets
- 23start location cities
Median 6.3, from 0.0 to 642.6.
- string 17
- integer 1
- float 4
- date 1
- datetime 2
- boolean 2
Columns
27 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
route_id | string | Unique identifier for the delivery routeunique | RTE0001 |
fleet_id | string | Unique identifier for the fleet executing the route | FLEET01 |
vehicle_id | string | Unique identifier for the vehicle used on the route | VH101 |
start_location_street | string | Street address where the route started | 15 Market St |
start_location_city | string | City where the route started | San Francisco |
start_location_state | string | State where the route started | CA |
start_location_postal_code | string | Postal code of the route start location | 94103 |
start_location_country | string | Country of the route start location9 countries | USA |
end_location_street | string | Street address where the route ended | 200 Pine St |
end_location_city | string | City where the route ended | San Francisco |
end_location_state | string | State where the route ended | CA |
end_location_postal_code | string | Postal code of the route end location | 94111 |
end_location_country | string | Country of the route end location9 countries | USA |
fuel_type | string | Type of fuel used by the vehicle (e.g., diesel, gasoline, electric)diesel · gasoline · electric · hybrid · other | electric |
driver_id | string | Unique identifier for the driver assigned to the routeoptional | DRV013 |
optimization_method | string | Method or algorithm used for route optimization (if applicable)8 methods · optional | nearest-neighbor |
notes | string | Additional notes or comments about the route or optimizationoptional | Urban delivery route with… |
| Numbers 5 columns | |||
distance_km | float | Total distance covered on the route in kilometers0 or more | 6.3 |
fuel_consumed_liters | float | Total fuel consumed during the route in liters (or kWh for electric)0 or more | 8.1 |
carbon_emissions_kg | float | Total carbon emissions generated during the route in kilograms0 or more | 3.1 |
number_of_stops | integer | Total number of delivery stops made on the route0 or more | 7 |
average_speed_kmh | float | Average speed of the vehicle during the route in kilometers per hour0 or more · optional | 8.7 |
| Dates and times 3 columns | |||
route_date | date | Date the route was executed | 2024-05-01 |
start_time | datetime | Timestamp when the route started | 2024-05-01T08:10:00 |
end_time | datetime | Timestamp when the route ended | 2024-05-01T09:41:00 |
| True or false 2 columns | |||
route_optimized | boolean | Indicates if the route was optimized for carbon reduction | true |
esg_compliant | boolean | Indicates if the route meets ESG (Environmental, Social, Governance) compliance criteriaoptional | true |
Use it for
A transportation dashboard
The route_
optimized rate, distance_ km by fuel_ type and a breakdown of optimization_ method. Excel, Power BI or Tableau. Why do the 15 diesel rows have a mean distance_
km of 369.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Routes120RTE00016.3electricRTE00022.8hybridRTE0003584.2diesel
A software demo
Believable routes with fleet_
id, vehicle_ id and route_ date to fill a screen in front of a buyer.
This dataset120 rows27 columns
Yours1,000 rows27 columnsstart_location_street: UK only
blueprint · fleet-carbon-route-optimization-metrics
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 27 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Each row represents a unique fleet route completed on a given day.
- Carbon emissions are calculated per route segment using vehicle type and distance.
- Include fuel type, load weight, average speed, and weather conditions for each entry.
- Flag routes with emissions above target thresholds for manager review.
- Capture proposed alternative routes with projected emission reductions.
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- fleet-carbon-route-optimization-metrics