Using PostgreSQL and shiny with a dynamic leaflet map: monitoring trash cans

A dynamic map that shows when trash cans are full helps us to optimize our resources and pick them up at the right time. When there is increased social activity, the trash cans can get full quicker. On the contrary, during very cold weather, the trash cans can take one or a couple of more days to get full. Therefore, knowing when the trash cans are full lets us pick them up right away rather than waiting for a specific day of the week to come. In this video blog post, we will create a dynamic map that shows when trash cans are full, when one or more of the sensors fail or when the gateway is not transferring data. Video tutorial available here