Today sees the release of the latest instalment of Open Supermarkets, we have now renamed this Retail Points.

There have been changes in the UK supermarket world since the last release with the most notable one being:

Capture

  • Morrisons selling their M Locals to Mike Green which have now been rebranded My Local

Test2

Along with the incorporation of openings and closings across the retailers over a few months we have also expanded our freezer store fascias. After Iceland’s were included in the September release we have now included Farmfoods, Fulton Foods and Heron. The retailers and their store count within the dataset can be soon below:

Retailer Fascia Count
Aldi Aldi 621
Asda Asda 319
Asda Asda Living 33
Asda Asda PFS 17
Asda Asda Supercentre 46
Asda Asda Supermarket 199
Booths Booths 29
Budgens Budgens 160
Costco Costco 26
Dansk Supermarked Netto 13
Farmfoods Farmfoods 328
Fulton Foods Fulton Foods 86
Heron Cooltrader 11
Heron Heron 195
Iceland Iceland 791
Lidl Lidl 673
Makro Makro 30
Marks And Spencer Marks And Spencer 327
Marks And Spencer Marks And Spencer BP 226
Marks And Spencer Marks And Spencer Food Hall 8
Marks And Spencer Marks And Spencer Food Outlet
Marks And Spencer Marks And Spencer Home 1
Marks And Spencer Marks And Spencer MSA 36
Marks And Spencer Marks And Spencer Outlet 40
Marks And Spencer Marks And Spencer Simply Food 232
Marks And Spencer Marks And Spencer Travel SF 50
Morrisons Morrisons 494
Morrisons Morrisons Local 0
Sainsburys Sainsburys 605
Sainsburys Sainsburys Local 760
Tesco Tesco 488
Tesco Tesco Express 1,524
Tesco Tesco Express Esso 196
Tesco Tesco Extra 252
Tesco Tesco Homeplus
Tesco Tesco Metro 171
The Co-operative Group The Co-operative Food 3,763
The Co-operative Group The Co-operative Food PFS 193
Waitrose Little Waitrose 44
Waitrose Little Waitrose Shell 13
Waitrose Waitrose 294
Whole Foods Market Whole Foods Market 9

 

Another new feature to the April release is a size band for each store, this is based on a four way classification.

A – Less than 3,013 ft² (280 m²)

C-Store with unlimited Sunday hours in England and Wales.

B – 3,013 to 15,069 ft² (280 m² to 1,400 m²)

Mid-sized grocer as defined by the CMA. Restricted Sunday hours, typically the large majority is food.

C – 15,069 to 30,138 ft² (1,400 to 2,800 m²)

Large supermarkets as defined by the CMA. Typical ‘large’ supermarket with GM and fashion offer.

D – 30,138+ ft² (2,800+ m²)

Also large as classified by the CMA. This is a GeoLytix arbitrary banding to equate roughly to a hypermarket, typically with significant clothing and GM departments and large free car park.

 

If you have any comments or contributions then as always please get in touch.

The data and supporting documentation can be downloaded here.

With every release of the open supermarkets GeoLytix aim to improve and build on the previous version. The long awaited addition of the rest of the Co-operative societies has been a focus, along with adding in Iceland stores as the latest retailer in the database.

Version6ImageFurniture

The highlights of the version 6 open supermarkets release are:

  • 790 Iceland stores
  • 1,125 Co-operative societies
  • Final 6 Tesco Homeplus closures
  • 41 stores added

We added The Co-operative Group stores into the database earlier in the year, and knew it was vital for us to capture the other societies to make it a complete dataset. With so many stores under different co-operative bodies this took time and effort but we are delighted to have added these in now.

This shows a breakdown and number of stores by Co-operative Society in the database:

COopTable

This is a great extension to the open supermarkets database. Amongst the 41 added stores is a mix of new stores and the odd stores we were missing in previous versions – striving to keep this as an up to date and accurate as possible. After 6 of the 12 Tesco Homeplus stores were closed and captured in the previous version, now the final 6 remaining stores have been closed and removed from the database.

We have also added a new column ‘OpenDate’, this currently has a very small proportion of stores attributed, but this is a column we will now start to update for every release.

As always please get in touch if you can contribute any missing stores to the open supermarkets and if you have suggestions for other retailer additions.

The data and supporting documentation can be downloaded from here.

 

 

The latest updated open supermarkets is now available. A total of 349 stores have been added since the previous release. This is a mixture of new stores and capturing missing stores from the dataset.

Highlights of the release:

  • 43 Tesco closures
  • 10 Morrison closures
  • 15 new Asda PFS
  • 349 stores added

In January Tesco announced plans to close 43 stores through March and April to cut costs. These were comprised of 18 Express, 12 Metro, 7 Superstores and 6 Homeplus. Earlier this week it was reported that the remaining 6 Homeplus stores would be closed on 27th June.

Also in January, Morrisons declared the closure of 10 unprofitable stores. In March, they further informed the public that an additional 23 stores will be closed however the locations of these have not been disclosed yet.

On a more positive note for a supermarket chain, in February Asda purchased 15 standalone petrol stations from Rontec LTD. This will expand their operation in London and the South East. These are gradually being opened running through to summer; all locations have been added to the database.

As always please get in touch if you can contribute any missing supermarkets so we can continue to update this.

The data and supporting documentation can be downloaded from here.

Version 4 of open supermarkets is now available with the following notable additions to its predecessor:

  • The Co-operative Group
  • Makro
  • Costco
  • Tesco Homeplus
  • Netto

You might notice not all Co-ops are in this version of the database, about 900 are run by societies other than the Co-operative Group, we have just added tCG stores for now but aim to have the remaining Co-ops ready for the next release. A huge thank you for the Co-operative Group support, without their input the large number of store locations would have meant some long nights for the GeoLytix team.

A map of GeoLytix' Open Supermarkets

We’ve also included the additions and closures we’ve heard about – most notably the 6 closed Morrison Local stores. We aim to capture store openings that have occurred between the Open Supermarket dataset releases.

This table shows the count of new additions by fascia since the version 3 release:

Additions to GeoLytix' Open Supermarkets

Anyone familiar with the last releases will immediately notice an improvement in the ID logic; all GeoLytix datasets will be prefixed with a 3 digit number unique to that dataset. All GLUIDs within the open supermarkets will consist of 10 digits with the first three being 101 and the version 3 store ID will form the last digits of this new identifier. These GLUIDs are now persistent; an ID will only ever be used once, the same store will keep the same ID release to release. New additions to the dataset will get a unique ID that hasn’t been used before and where a store re-locates the old ID  is retired and a new ID is created, but stores that get extended keep the same ID.

A quality flag column has been introduced to clarify the locations provided:

PQI 1 – Rooftop geocoded by GeoLytix

PQI 2 – Rooftop geocoded by third party

PQI 3 – Postcode geocoded

As with all data, definitive accuracy can’t be 100% guaranteed, but we try our very best.

GeoLytix will maintain the open supermarkets data for the foreseeable future with the next release in 3 months (April 2015) and will include any changes in retailers such as those resulting from the recent Tesco and Morrisons announcements.

We are excited to announce that we’re in the process of developing a new website that will include interactive maps letting people explore all of our datasets. This is coming in April 2015. Another prominent update will be the publishing of the data as Linked Data.

DATA:

You can download the Open Supermarkets database and supporting documentation here.

 

A drive or walk round any suburb or city nowadays seems to reveal at least one recently opened supermarket. Retailers and their different formats are opening up thick and fast, providing customers with choice. With so many new stores do we all know where the competition is? Supermarket information is available and online for everyone to access but not in one file.

Owen Boswarva’s article ‘It’s time for the private sector to release some open data too’ encouraged us to crack on with our existing plan to release a list of supermarket locations as open data. There is no commercially sensitive information attached to the stores, just the store name, and an address from the retailers store locator, our GeoLytix town and locality names, and an exact rooftop location (in British National Grid and web friendly WGS84 lat/long). Yes, we have probably spent more time directing ourselves around the country in google street view than the google van spent capturing the imagery (and yes, we have manually located each of the 7,490 stores with the aim to get a really good dataset). GeoLytix work on so many projects that start with the ground work of supermarket locations, and anyone working with data of any kind knows that the results of any processes can only be as good as the quality of data going in in the first instance.

Data is never perfect, so before the first person finds a store out of place, and please try and be that first person, we put a disclaimer out: yes there may be the odd typo and perhaps (but hopefully not too many) we are missing the odd store.

Our ultimate vision is that the retailers and public grab hold of this dataset and we enrich and improve it; for example ‘we’ could add in features- fish counter, electrical department, pharmacy; accessibility and so on, the possibilities are endless. We’d love to hear about your ideas.

Finally, some thank yous. We wouldn’t be doing this without the support of the supermarkets themselves; and our discussions with them have shown just how willing the private sector is to share data – everyone we have talked to has been nothing but supportive which bodes well for the future.

DATA:

You can download the Open Supermarkets database and supporting documentation here.

You will also be able to access the data on the Consumer Data Research Centre (CDRC), whose aim is to deliver consumer-related data to a range of end users to drive economic and social benefit.