This is the fourth part of our series How to Add Postcode-Based Proximity Search With Open Data. In this article we will show you how to take a geocoded dataset and a postcode, and order the dataset by proximity to the postcode. This is used to find the nearest pub to a user specified location.
A little over a year ago, Google released a new product called Google Fusion Tables. Fusion Tables allows you to upload, merge, share, and visualize large tables of tabular data. Basically, we wanted to answer the question “I have a spreadsheet. I want to share it with people and create a map/bar chart/storyline/other visualization.” Google Spreadsheets, while powerful, couldn’t handle the 100 meg upload we allow for Fusion Tables. And, being Google, we also provided something for developers.