The evidence that got a school its crossing

The challenge

Cars race past at pick up time. She had asked the council for a crossing three times. Each time the answer was the same: show us the numbers. She had none, only a near miss in March.

How the flow works

With xMap Flows, Alba built Kestrel. Kestrel is an AI employee: a flow of 5 blocks.

1. Every school day at a quarter to three,

   School days at 2:45 (Schedule)

2. at each of the three gates,

   The three school gates (My data)

3. Kestrel measures how fast the traffic moves,

   Speed on the road (Traffic Flow)

4. works out how far over the limit it is,

   Over the limit? (Calculated field)

5. and adds a row to her evidence sheet.

   The evidence sheet (Google Sheets)

What it solves

• Cars too fast: solved by Traffic Flow and Calculated field
• No numbers to show: solved by Google Sheets
• Three requests refused: solved by Google Sheets

The result

After one term, Kestrel’s sheet showed cars passing the main gate at almost twice the limit on most afternoons. Alba sent it to the council in May. The crossing was painted in September.

Alba stopped asking for a crossing. She sent the proof instead.

An illustrative scenario: the figures are modelled to show what the flow produces, not a customer's results.

The flow, block by block

1. 1

   School days at 2:45

   Schedule

   Starts the flow on a timetable.

2. 2

   The three school gates

   My data

   Brings in a table you uploaded or a list you saved on the My data page: your stores, customers, target accounts or sites.

3. 3

   Speed on the road

   Traffic Flow

   How the traffic is moving on the roads around each place, right now: the current speed and the free-flow speed in km/h, how jammed the roads are (a jam factor from 0, free, to 10, standstill), the congestion as a percentage, the level in words, how many roads were measured and closed, and the busiest road.

4. 4

   Over the limit?

   Calculated field

   Adds fields worked out from the others: a number, a text or a yes/no.

5. 5

   The evidence sheet

   Google Sheets

   Create, edit, and collaborate on spreadsheets online

Templates to build it

Ready-made flows with the same blocks. Open one, change the city and the kind of place, and run it.

• Week ahead at my solar and wind sitesThe week ahead at every solar and wind site, with the best days for maintenance.
• Irrigation plan for my fields, every morningAn irrigation plan for each field from the week's heat and rain.
• Competitor density around each sitePeople per competitor around each of your sites, ranked.
• Branch network review: which branches the area needsA monthly review of which branches their area needs, with a note for the committee.
• Trade counters near each van baseThe best trade counters near each van base, for parts.
• Hotels and campgrounds for contractors near remote sitesPlaces to stay near each remote site, for shutdown contractors.

Industries

Learn how it works

• Data enrichmentAdding details to records you already have.
• How to score candidate store sitesCompare sites on residents, competitors and neighbours, with an AI score and a reason.
• How to skip your existing customersOnly prospects reach your team, never someone you already serve.
• Your own tables and lists (My data)Upload a CSV, save lists of results, and use them in flows.
• Compare sites side by sideTwo 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 spotPaused for now while xMap improves the data behind it. Reports already made still open.

More stories from Education

• Forty school buses, no surprise road closuresSaeed coordinates transport for a group of eight schools in Abu Dhabi. Forty buses, three thousand children.
• The tutoring school that answers parents at midnightNisha owns a small English tutoring school in Colombo, with three branches across the city.
• A reading tutor down the street, for every new childMaya is the only coordinator at a small reading charity in Atlanta. She pairs children with volunteer tutors.
• Two thousand students, never stranded by a strikeLuca leads the international office at one of Rome’s largest universities. Two thousand exchange students a year.

All 137 stories →