Where families need after-school activities

What it does

Every month: the blocks of your city with the most children, the sports, dance, music and art schools within 2 km, children per activity, the 10 most underserved emailed and mapped.

In one sentence: Monthly on the 1st at 08:00, in Kuala Lumpur, count who lives around, sort them by children_0_19 and keep the top 30, count the martial arts schools, dance schools and 3 more within 2 km of each, work out new fields, sort them by kids_per_activity and keep the top 10, then email the list to you and show them on a map.

Why it is useful

After-school clubs fill where many children live and few clubs exist. This flow finds those blocks every month.

Who it is for

Education & training. Schools, nurseries, universities and training companies planning campuses, enrolment and partners. Every use case for education & training

Best use cases

• A sports academy
• A music or art school
• A city youth services team

What each run gives you

• An email with the list
• A map of the results

The time it saves

Monthly on the 1st at 08:00. Doing the same work by hand takes about 120 minutes each time, so it saves about 8 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. Children in every blockxMap 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).
4. 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.
5. Activities nearbyxMap 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.
6. Children per activityLogic · Calculated fieldAdds fields worked out from the others: a number, a text or a yes/no.
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. Email me the listAction · EmailSends one email per run with all the items, or one email per item.
9. Show them on a mapAction · Show on a mapShows the results as points on a map, with the area of interest.

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.