From catchment planning to continental expansion, data specialist allmapdata helps join the dots

Tesco-LogoDigital map data assembled, prepared and formatted by CACI (formerly Mapmechanics) is playing a key role in the continuing expansion of Tesco.com, Britain’s biggest grocery home shopping retail business.

Having originally supplied map data to Tesco for strategic analysis and planning, CACI is now also the supplier of the mapping used in the daily scheduling of Tesco.com’s fleet of home delivery vehicles.

In the latest development by the retailer, CACI has also provided mapping to support the expansion of Tesco.com’s home delivery service into continental European markets such as the Czech Republic and Slovakia.

CACI is a leading UK-based specialist supplier of digital mapping and business and demographic data, which it not only sources, but also formats to suit the specific needs of customers and their software.

For some years Tesco analysts have used map data from CACI to help define store delivery catchment areas. They have also used data from CACI to help them understand where the uptake of the company’s home delivery service was likely to be highest.

Data products supplied by the allmapdata team at CACI for these activities include INRIX road speed data for modelling catchments, and postcode sector boundary data for analysing the propensity of consumers to use the internet for online shopping.

In a separate initiative, road speed data supplied by CACI has been in continuous use by Tesco.com’s transport planners in connection with the routing and scheduling system it employed for its delivery fleet in the past.

Latterly Tesco.com has introduced a new, more advanced routing and scheduling system, Oracle Real-Time Scheduler, to plan home deliveries by its fleet of over 2,000 vans; and in the light of its established relationship with CACI, the retailer again turned to the company to supply appropriate digital map data for both the UK and Ireland.

To work with the Oracle software, CACI has supplied Tesco with HERE map content: Premium vector street-level map data, which includes essential routing information such as one-way streets, banned turns and address ranges. It has also supplied Andes raster mapping, which is derived from the HERE data and provides a visually pleasing version of the data for display and presentational purposes.

Tesco trucks used for home delivery

Mapping and speed data from CACI underpin Tesco.com’s delivery proposition

Tesco.com generally delivers to homes from 8am right through to 11pm from Monday to Friday, as well as up to 10pm at weekends, so it is vital for the company to be able to route its vehicles to take account of changing traffic speeds and flows at different times of day and at weekends.

CACI has therefore also supplied Tesco.com with HERE Traffic Patterns, a data set that contains average traffic speed on individual road segments, calculated from past traffic flow measurements and differentiated by time of day and day of the week.

According to Ben Dito Smith, the Location Strategy and Analysis Manager for Tesco.com : “Efficient, timely delivery is a fundamental feature of our home shopping proposition, so it is essential for us to use the most appropriate software and data available for our delivery planning system.”

He adds:

We have found that CACI is very well equipped to provide exactly the mapping and demographic data we need. The CACI team are responsive and helpful when it comes to advising on the best products for our requirements, and good at supplying the data in an appropriate format.

David Cockrell, CACI’s Associate Director at allmapdata, comments: “Over the years we have gained detailed knowledge of many of the analytical and scheduling systems in use the marketplace, and built up special expertise in providing appropriate data products in a suitable form.”

He says this wide-ranging knowledge can be particularly useful when people in different departments of the same company ask questions about mapping or digital data, which has happened from time to time at Tesco, or approach CACI with new requirements.

“We can quickly join the dots together, and suggest seamless approaches to problem solving.”

Tesco.com delivers to consumers’ homes from larger retail stores and from a small number of specially designed dotcom stores. The home shopping business on its own now turns over more than £2 billion.