Smart Waste Collection Route Optimizer

This dataset provides granular, real-time data on municipal waste collection routes, including bin fill levels, geolocations, traffic conditions, vehicle assignments, and environmental impact metrics. Designed for smart city planners and sustainability analysts, it enables optimization of collection schedules, reduction of operational costs, and monitoring of carbon emissions for greener urban waste management.

  • opened 7 times
  • last updated 31 Dec 2025
  • by GoMask
The brief that made it

Optimizing municipal waste collection schedules and routes

Sample rows

preview · 8 of 85 rows · all 27 columns
route_idstringvehicle_typestringfuel_consumed_litersfloatoptimizedbooleanbin_address_citystringroute_namestringvehicle_idstringdriver_idstringbin_idstringbin_typestringbin_location_latitudefloatbin_location_longitudefloatbin_address_streetstringbin_address_statestringbin_address_postal_codestringbin_address_countrystringbin_fill_level_percentfloatbin_last_collected_datetimedatetimescheduled_collection_datetimedatetimeactual_collection_datetimedatetimetraffic_conditionstringtraffic_delay_minutesfloatroute_distance_kmfloatroute_duration_minutesfloatco2_emissions_kgfloatoptimization_timestampdatetimenotesstring
R1001diesel5.1trueNew YorkCentral Park NorthV201D405B3001general40.7917-73.9646101 W 110th StNY10026USA85.22024-06-04T08:20:002024-06-11T08:15:002024-06-11T08:17:00moderate7.212.648.513.22024-06-10T16:05:00On-time collection, mild traffic
R1002electric0trueBronxRiverdale SouthV202D406B3002recyclable40.9007-73.9126330 W 261st StNY10471USA63.52024-06-05T07:45:002024-06-12T07:45:002024-06-12T07:48:00free-flow28.933.12.42024-06-11T14:10:00Electric vehicle, low emissions
R1003hybrid2.9trueNew YorkDowntown LoopV203D407B3003organic40.715-74.00922 Beaver StNY10004USA97.72024-06-03T09:00:002024-06-10T09:00:002024-06-10T09:07:00heavy18.66.456.27.12024-06-09T11:30:00Heavy traffic downtown
R1004diesel4.7falseBrooklynWilliamsburg EastV204D408B3004hazardous40.7099-73.957385 Roebling StNY11211USA44.82024-06-06T10:30:002024-06-13T10:30:002024-06-13T10:35:00moderate9.49.74112.6blankHazardous waste handled
R1005hybrid3.2falseQueensQueens VillageV205D409B3005general40.7268-73.7429212-12 99th AveNY11429USA23.32024-06-07T08:10:002024-06-14T08:10:00blankfree-flow1.115.3528.8blankblank
R1006electric0trueQueensAstoria BoulevardV206D410B3006recyclable40.7693-73.917131-15 Astoria BlvdNY11102USA76.92024-06-06T11:45:002024-06-13T11:45:002024-06-13T11:46:00free-flow37.128.51.62024-06-12T18:12:00Quick recyclable bin route
R1007diesel5.3trueNew YorkHarlem WestV207D411B3007organic40.8198-73.9508225 W 125th StNY10027USA91.42024-06-08T09:15:002024-06-15T09:15:002024-06-15T09:18:00moderate10.710.236.814.12024-06-14T17:50:00Organic waste, moderate delay
R1008hybrid2.3falseBrooklynBrooklyn HeightsV208D412B3008recyclable40.6958-73.993610 Montague StNY11201USA54.22024-06-09T07:40:002024-06-16T07:40:00blankheavy11.811.339.55.6blankblank

What the 85 rows show

from the 85-row sample

Electric (vehicle type) stands out: mean fuel_consumed_liters is 0.0, against 4.6 for the rest.

  • 58%optimized = true
  • 3.5median fuel_consumed_liters
  • 5bin types
  • 5traffic conditions
  • 25bin address states
  • 61.7median bin_fill_level_percent
Mean fuel_consumed_liters by vehicle_type85 rows
0486.0diesel33 rows0.0electric19 rows3.1hybrid31 rows4.5other2 rows
fuel_consumed_liters85 rows, in bands of 1
015301911221511772059fuel_consumed_liters →

Median 3.5, from 0.0 to 9.0.

bin_address_city85 rows · top 10 of 37 values
  1. New York18
  2. Brooklyn11
  3. Queens11
  4. Bronx6
  5. Philadelphia3
  6. Los Angeles2
  7. Seattle2
  8. Chicago2
  9. Indianapolis2
  10. Staten Island1
27 columns by typefrom the column list below
  • string 14
  • float 8
  • datetime 4
  • boolean 1

Columns

27 columns in four groups
blueprint · 27 columns
columntypedescriptionexample
Text 14 columns
route_idstringUnique identifier for each waste collection routeuniqueR1001
route_namestringDescriptive name for the waste collection routeCentral Park North
vehicle_idstringUnique identifier for the vehicle assigned to the routeV201
vehicle_typestringType of vehicle used for waste collection (e.g., diesel, electric, hybrid)diesel · electric · hybrid · otherdiesel
driver_idstringUnique identifier for the driver assigned to the routeoptionalD405
bin_idstringUnique identifier for each waste bin serviced on the routeB3001
bin_typestringType of waste bin (e.g., general, recyclable, organic, hazardous)general · recyclable · organic · hazardous · othergeneral
bin_address_streetstringStreet address of the waste bin locationoptional101 W 110th St
bin_address_citystringCity where the waste bin is locatedoptionalNew York
bin_address_statestringState or province where the waste bin is locatedoptionalNY
bin_address_postal_codestringPostal code for the waste bin locationoptional10026
bin_address_countrystringCountry where the waste bin is locatedoptionalUSA
traffic_conditionstringTraffic condition on the route segment (e.g., free-flow, moderate, heavy, closed)free-flow · moderate · heavy · closed · unknown · optionalmoderate
notesstringAdditional notes or comments about the route or collection eventoptionalHeavy traffic downtown
Numbers 8 columns
bin_location_latitudefloatLatitude coordinate of the waste bin location-90 to 9040.7917
bin_location_longitudefloatLongitude coordinate of the waste bin location-180 to 180-73.9646
bin_fill_level_percentfloatCurrent fill level of the waste bin as a percentage (0-100)0 to 10085.2
traffic_delay_minutesfloatEstimated traffic delay in minutes for the route segment0 or more · optional7.2
route_distance_kmfloatTotal distance of the route in kilometers0 or more12.6
route_duration_minutesfloatEstimated duration of the route in minutes0 or more48.5
fuel_consumed_litersfloatAmount of fuel consumed on the route in liters0 or more · optional5.1
co2_emissions_kgfloatEstimated CO2 emissions for the route in kilograms0 or more · optional13.2
Dates and times 4 columns
bin_last_collected_datetimedatetimeDate and time when the bin was last collectedoptional2024-06-04T08:20:00
scheduled_collection_datetimedatetimeScheduled date and time for the next bin collectionoptional2024-06-11T08:15:00
actual_collection_datetimedatetimeActual date and time when the bin was collectedoptional2024-06-11T08:17:00
optimization_timestampdatetimeTimestamp when the route optimization was performedoptional2024-06-10T16:05:00
True or false 1 column
optimizedbooleanIndicates if the route was optimized using the system (true/false)true

Use it for

  • optimized58%49 of 85 rowsmean fuel consumed li…6.0dies…0.0elec…3.1hybr…4.5other

    A logistics dashboard

    The optimized rate, fuel_consumed_liters by vehicle_type and a breakdown of bin_address_city. Excel, Power BI or Tableau.

  • Why do the 19 electric rows have a mean fuel_consumed_liters of 0.0?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable routes with route_name, vehicle_id and vehicle_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 27 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset85 rows27 columns
Yours1,000 rows27 columnsbin_location_latitude: UK only

blueprint · smart-waste-collection-route-optimizer

Behind this dataset

Same schema. As many rows as you need.

These 85 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 daily route for a waste truck.
  • Include bin locations, fill percentages, and priority ranking.
  • Traffic congestion must be factored into route sequencing.
  • Estimate fuel usage and emissions for each route.
  • Routes must avoid restricted zones during peak hours.
Rows
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
smart-waste-collection-route-optimizer

More in Logistics

Browse all
Also in LogisticsUrban Waste IoT Sensor AlertsSupply Chain Delivery Delay LogsSupplier Lead Time VariabilityAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.