ATMs in quiet streets, for a cash-in-transit risk review

What it does

Every quarter: the ATMs in your city with the fewest shops and restaurants within 300 m (quiet at night), the 30 quietest first, for the cash-in-transit risk review.

In one sentence: Monthly on the 1st at 08:00, in Lagos, find ATMs in the area, count the restaurants, convenience stores and gas stations within 250 m of each, sort them by nearby_count and keep the top 30, write a summary of each with xMap AI, then add row in Google Sheets and email the list to you.

Why it is useful

Quiet streets at night are where cash crews are most exposed. This list puts the review where risk is highest.

Who it is for

Security, safety & emergency services. Security companies, alarm installers, police, fire and ambulance services and safety teams covering people and places. Every use case for security & emergency services

Best use cases

• A cash-in-transit company
• A bank’s security team
• An ATM network operator

What each run gives you

• A Google Sheet

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: 8 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. ATMsxMap 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. Activity 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 30 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. Note the risk with xMap AIxMap AI · xMap LLMTell the AI what to do in plain words.
7. Add them to the risk review sheetApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
8. Email me the resultsAction · 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.