Where to put glass recycling banks

Spots with the most bars and restaurants, for glass recycling banks.

MediumMonthlyAI

Water & waste utilitiesUtilitiesEnvironment

Use this template

What it does

Every year: the spots in your city with the most bars and restaurants within 300 m, ranked by xMap AI as glass recycling bank sites, emailed and mapped.

In one sentence: Monthly on the 1st at 08:00, in Prague, find bars, restaurants and pubs in the area, count the bars and restaurants within 250 m of each, sort them by nearby_count and keep the top 25, score and rank them with xMap AI, sort them by fit score and keep the top 10, then show them on a map and email the list to you.

Why it is useful

Glass comes from bars and restaurants. Banks where they cluster fill up fast.

Who it is for

Water & waste utilities. Water utilities, waste collectors and recyclers planning routes, winning commercial contracts and keeping services running in bad weather. Every use case for water & waste utilities

Best use cases

  • A city recycling programme
  • A glass recycler
  • A brewery’s sustainability team

What each run gives you

  • A map
  • An email

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 90 minutes each time; it runs about 1 time a month, so it saves about 2 hours a month (an estimate). It is medium: 9 blocks.

The flow, block by block

  1. On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
  2. My cityWhere · Area of interestSets where the flow looks: countries, cities or specific places, or areas you draw on a map.
  3. Bars and restaurantsxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
  4. Bars and restaurants within 300 mxMap data · Nearby placesPlaces around a point from xMap’s own places database (300M+ places, refreshed every month): pick the types of place (more than 5,000, such as Restaurant, Cafe, Pharmacy, Hospital or Gas station, or a whole group of them) and how far to look.
  5. Best 25 firstLogic · Sort and limitPuts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
  6. Score each spot with xMap AIxMap AI · xMap LLMTell the AI what to do in plain words.
  7. Best 10 firstLogic · Sort and limitPuts the items in order, and can keep only the first ones: the 10 best rated, the 20 nearest, the highest fit scores.
  8. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.
  9. Email me the listAction · EmailSends one email per run with all the items, or one email per item.

Every block can be changed after you use the template: the city, the type of place, the score, where the results go.

Use it now

Answer a few questions, enter your work email, and it runs in your own account, kept running until you pause it. Use this template.

How to set it up

More for Water & waste utilities