| Placename | population | Distance to Wetherspoons (km) | Wetherspoons name |
|---|---|---|---|
| Stow-on-the-Wold | unknown | 29 | The Golden Bee |
| Moreton-in-Marsh | unknown | 22 | The Golden Bee |
| Cirencester | unknown | 21 | The Moon Under Water |
| Market Rasen | unknown | 21 | The White Horse |
| Norton-on-Derwent | unknown | 27 | The Postern Gate |
| Berwick-upon-Tweed | 12043 | 70 | The Electrical Wizard |
| Wadebridge | 7900 | 20 | The Rann Wartha |
| Camelford |
Amanda amandasaurus
amandasaurus
/ towns_wo_spoons.md
Created
November 12, 2025 13:42
2025-11-12 English Towns without a Wetherspoons, full list https://gist.github.com/amandasaurus/ef012e3b68113e4eae0479747a6600f2
amandasaurus
/ towns_wo_spoons.sql
Created
November 12, 2025 13:22
2025-11-12 English towns without a Wetherspoons
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {{data:sql,server=https://postpass.geofabrik.de/api/0.2/}} | |
| -- Source was a fedi post: “I dare you to find a town in England without a Wetherspoons” <https://cupoftea.social/@moof/115521240053010548> | |
| -- “Is location A inside “city B”?” is hard to answer for England. People don't | |
| -- Simplier rule: An OSM place location which is >20 km from the nearest Wetherspoons. | |
| -- This is written for Postpass <https://postpass.geofabrik.de/>, and takes about | |
| -- As of 2025-11-12 there are 62 towns or cities with no Wetherspoons in England. | |
| -- The output is a list of lines, from the town/city to the nearest 'Spoons. | |
| -- See below for changing that geo output. | |
| -- Here starts the code! We use a big ol' postgresql CTE. |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ 2023-04-25-primary-wo-maxspeed.geojson
Created
April 25, 2023 07:12
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ 2022-11-14-osm-nodes-website-ne-contact:website.geojson
Last active
November 16, 2022 16:49
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ 2022-10-07-osm-landuse-residential-area≥100km².geojson
Last active
October 7, 2022 20:10
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ 2022-09-30-p_club_ff_distances_ge20km.geojson
Created
October 1, 2022 08:32
Distance to the nearest take away for every night club, only ≥20km Map Data © OpenStreetMap contributors 2022-09-30. Open data ODbL osm.org/copyright
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ 2022-09-30-p_club_ff_distances_all.geojson
Created
October 1, 2022 08:21
Distance to the nearest take away for every night club. Map Data © OpenStreetMap contributors 2022-09-30. Open data ODbL osm.org/copyright
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ ie_convenience_self_distances.geojson
Last active
September 30, 2022 15:04
2022-09-30 ireland convience stores, distance to the next nearest one
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
amandasaurus
/ 2022-09-24_p_guns_banks_distance.geojson
Created
September 24, 2022 15:27
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
NewerOlder