Villages with no health centre nearby
Villages with no health care within 5 km, for the mobile clinic.
What it does
Every quarter: the villages in your table with no clinic or health centre within 5 km, with how many people live around each, so the mobile clinic visits them first, emailed and kept in a sheet.
In one sentence: Monthly on the 1st at 08:00, take your table, count the community health centers, medical clinics and hospitals within 5 km of each, sort them by nearby_count and keep the top 20, count who lives around, then add row in Google Sheets and email the list to you.
Why it is useful
A mobile clinic has a few days a month. Visiting the villages furthest from care first gives those days the most impact.
Who it is for
Non-profits, charities & humanitarian. NGOs, charities, aid agencies and community groups who need to reach people in need, find partners and report their impact. Every use case for non-profits & humanitarian
Best use cases
- A health NGO
- A mobile clinic programme
- A district health office
What each run gives you
- A Google Sheet
- An email
The time it saves
Monthly on the 1st at 08:00. Doing the same work by hand takes about 120 minutes each time; it runs about 1 time a month, so it saves about 2 hours a month (an estimate). It is medium: 7 blocks.
The flow, block by block
- On the 1st of every monthTrigger · ScheduleStarts the flow on a timetable.
- Our villagesYour data · My dataBrings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.
- Health care within 5 kmxMap 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.
- The least served 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.
- Who lives aroundxMap data · DemographicsWho lives in an area: the number of residents, men and women, and nine age groups, from xMap’s population grid (hexagons of about 0.1 km², about 100 countries).
- Add them to the mobile clinic planApp · Google SheetsCreate, edit, and collaborate on spreadsheets online
- 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
- Ask the map a question: How many of a kind of place, how many people for each, and where the gaps are, answered on the spot.
- Count what is around each of your places: Competitors, footfall magnets or services within a distance of each site.
- Compare sites side by side: Two or three spots measured the same way, one column each, the best of every row marked and the best site and why.
- An instant site report of any spot: Paused for now while xMap improves the data behind it. Reports already made still open.
- How to score candidate store sites: Compare sites on residents, competitors and neighbours, with an AI score and a reason.
- Location intelligence: Using where things are, and what is around them, to make business decisions.
- Catchment area: The area a store or service draws its customers from.
More for Non-profits, charities & humanitarian
- Growing companies to invite as donors: Fast-growing local companies with a decision maker, as donors.
- Neighbourhoods far from a food bank: The blocks furthest from food help, for the next distribution point.
- Cooling centres near the most seniors: Cool places near the most seniors, with a public message, on heatwave days.
- Bakeries and supermarkets to ask for surplus food: Food shops near you, asked for their surplus with an approved message.
- Where school kits are needed most: Where children are most stretched for schools, for kit distribution.
- Where to hold the next blood drives: Busy places far from a blood bank, scored as blood drive sites.