Time Series ForecastingSmart CityProphetLSTMCausal InferencePolicy Analysis

Municipal waste logistics forecasting, Jakarta Smart City

Jakarta Smart City, Data Scientist (Jan 2021, June 2021) · Lead Data Scientist

End-to-end pipeline diagram: JAKI · Qlue reports (citywide citizen data) → Prophet ensemble (vs ARIMA · SARIMA) → DiD analysis (plastic-bag ban rollout) → Route planning (Tableau · per district)
Pipeline overview

Jakarta’s waste agency serves more than 10 million residents across hundreds of collection points. Fixed schedules sent too few trucks to overflowing areas and too many to empty routes. Therefore, this mismatch increased complaints, fuel use, and emissions.

Waste at each collection point follows noisy, irregular patterns. Lebaran, Christmas, market days, heavy rain, and floods create sudden peaks. Therefore, route planning needs forecasts for individual districts and sites. The system needed hundreds of these forecasts from data of uneven quality.

I developed a forecasting pipeline that combined models, with Facebook Prophet as the primary model. Prophet made seasonal patterns easier to explain and handled holidays. Then I benchmarked it against ARIMA, SARIMA, and exponential smoothing, which model patterns in past observations. I also explored LSTM neural networks to capture complex changes over time in high-density districts. Moreover, I included public holiday calendars, rainfall, temperature, and local event schedules.

I used more than 100,000 JAKI and Qlue reports to study Jakarta’s 2020 plastic bag ban. First, I measured complaint volumes before and after the ban. Then I used difference-in-differences to compare changes over time between affected and comparison groups. This controlled for seasonal and wider economic effects, with explicit controls for COVID-19 mobility restrictions. The results provided statistically significant evidence that complaints fell after the ban.

I built Tableau dashboards showing how district waste volumes changed across locations and time. Then I translated these patterns into route recommendations for logistics planners. Moreover, I presented the results and policy findings to 500+ attendees at ICISS 2021. This was an IEEE-sponsored international conference.

The forecasts improved collection efficiency by 15% across a city of more than 10 million residents. Therefore, fuel use and emissions fell. Moreover, the causal study provided evidence on the plastic bag ban and a method for testing future city policies. I presented the first-authored paper internationally at an IEEE-sponsored conference.

15 waste efficiency improvement pct 10M+ residents impacted 100,000+ complaint records analyzed 500 conference attendees
PythonRFacebook ProphetARIMASARIMALSTMstatsmodelsTableauMatplotlibscikit-learnpandasnumpyDifference-in-differenceshypothesis testing