Colleagues,
I have the data set similar to the extract below:
I would like to match that data with the sample data provided in the extract below. In particular, I'm interested in matching values by the latitude and longitude values by assigning each postcode to the Geo* category where latitude and longitude indicate greatest proximity. Broadly speaking I'm looking to recreate functionality that is available via the Hub Distance tool in the MMQGIS plug-in in QGIS. With respect to this particular assignment, I would rather avoid working in QGIS as I'll be refreshing this data set so it's more efficient for me to have one do file that I can run when needed instead of joggling between software packages and merging the data.
I took the liberty of visualising the process in the figure below:

The data is publicly available and was taken from the Free Map Tools website.
I have the data set similar to the extract below:
Code:
input str7 postcode latitude longitude AB101XG 57.14416516 -2.114847768 AB106RN 57.13787976 -2.121486688 AB107JB 57.12427377 -2.127189644 AB115QN 57.14270109 -2.093014619 AB116UL 57.13754663 -2.112695886 end
Code:
input str4 outcode latitude longitude GeoA 57.131086 -2.122482 GeoB 57.13121 -2.082261 GeoC 57.098381 -2.1724 GeoD 57.108 -2.237 GeoE 57.101 -2.27 end
The data is publicly available and was taken from the Free Map Tools website.
Comment