Amanda amandasaurus

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

	{{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.