FlowsBook a callSign inCreate free accountSign up
Business and places data

How to list every business on one street

A street is a line, not a circle, so a radius search gets it wrong. How to trace one street on the map, gather every business along it and keep the list clean.

Part of the guide Location intelligence automation

By the xMap team · · 5 min read

To list every business on one street, trace the street itself rather than drawing a circle around its middle: drop a row of small search points along it (or draw a thin shape that follows it), search every kind of place inside them, keep only the places whose address names that street, and remove the duplicates where the searches overlap. A circle catches the side streets and misses the far ends; a traced line gives you the street as a shopper walks it.

You might want this for a shopping street survey, a business improvement district's membership list, a sales rep's walk, a planning consultation or a landlord's view of a parade. The article explains why streets are awkward for place data, the method step by step, how to check the result, and how to keep the list current without doing it again by hand.

Why a street is awkward for place data

Most place searches are built around a point and a distance: everything within 500 metres of here. That suits a question like "what is near my shop". A street is different. Bourke Street in Melbourne or Rue Sainte-Catherine in Montreal runs for kilometres but is only a few doors deep. A circle big enough to reach both ends sweeps up thousands of places on parallel streets; a circle small enough to stay on the street covers only one block.

There is a second catch. A business on a corner can have its address on the cross street, and a shopping centre on the street may list its shops under the centre's own address. So "on the street" needs a rule you decide on, not one the data decides for you.

The method, step by step

  1. Trace the street. In the Area of interest block, open the drawing window and place points along the street every 200 to 300 metres, each with 250 m around it. For a short street, a thin drawn shape that follows the kerbs works too.
  2. Search every kind of place. In Nearby places, leave the type of place empty so every kind is searched, with Where set to the Area of interest. Only places inside each point's circle or the shape are kept.
  3. Remove the overlap. Neighbouring circles overlap, so the same shop is found twice. Remove duplicates by the same place.
  4. Keep the street's own addresses. A Filter on the address field, set to contains and the street's name, drops the side streets. Decide whether corner businesses with the cross street's address stay; if they do, add a second rule for them.
  5. Order the list. Sort by name, or by distance from the first point, so the list reads roughly from one end to the other.

Checking the result

Before relying on the list, check it against the street itself, either on a walk or on a map view.

  • Look at the ends. If the first or last block is thin, add a point closer to the end of the street.
  • Look for gaps between points. A stretch with no businesses in the list but shops on the map means a point is missing.
  • Look for the wrong side of a junction. A place on a crossing street that slipped through the address rule is easy to spot when sorted by distance.
  • Look at status. Each place says whether the database last saw it open or closed; a survey usually keeps the closed ones in a separate column, because an empty unit is a fact about the street too.

Expect the list to hold the businesses that have a public listing. A small office upstairs with no listing, or a market stall, will not be there. For a survey that must be complete, the list is the starting sheet that the person walking the street corrects.

A worked example

This one is made up. A business association on a long shopping street in Cape Town wants a list of every member it could invite, with phone and website, and wants to know which units changed since its last count.

A volunteer places nine points along the street, 250 metres apart. The search returns several hundred places, which drop to a little over two hundred once duplicates and side-street addresses are removed. Grouped by kind, the street is mostly food, clothing and personal services, with a handful of offices. Eleven places are marked closed. The association exports the list to a sheet, adds a column for whether each one is already a member, and the chair has a call list by lunchtime.

Keeping the street list current

A street changes every month: a café opens, a bank branch closes. An AI employee in xMap Flows can repeat the count and report only the change.

  1. Schedule: on the 1st of every month.
  2. Area of interest: the points traced along the street.
  3. Nearby places: every kind of place, Where set to the Area of interest.
  4. Remove duplicates: the same place once.
  5. Filter: address contains the street's name.
  6. Only new for the new arrivals, or What changed for closures and new phone numbers.
  7. Google Sheets or Email: add the month's changes to the association's sheet, or send them.

For a second view of the same street, Map business scan with Cover the whole area and your own search words looks at online maps live, which can catch a new business before the monthly places data has it.

Questions

Why not just search a radius around the middle of the street?

Because a street is long and narrow. A circle big enough to reach both ends brings in neighbouring streets, and a small one covers only part of it. Points traced along the street fit its shape.

Will the list include every business on the street?

It includes the businesses with a public listing in the places data. Upstairs offices with no listing, stalls and very new openings may be missing, so check it on the ground for a complete survey.

How do I handle shops on a corner?

Decide your own rule. A Filter on the address keeps only the street's own addresses; add the cross street's name as a second rule if you want corner businesses too.

Can I get the phone and website of each business?

Yes. Nearby places brings the phone, website, rating and status where the database has them, and the list can go straight into a Google Sheets file.

Templates that do this

Read next

More on business and places data · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.