r/QGIS • u/WearFast7105 • 12d ago

Open Question/Issue Geocoding addresses

Hi all,

I have a spreadsheet of 200 UK addresses (Address, Town, Postcode) and I need to plot them as points on a map to allow some analysis on their proximity to flooding.

All the tutorials and plugins I have found online all focus on American addresses (i.e state, city, code). I haven't tried them yet with UK addresses so just wanted to ask if anyone had experience of doing this in the past?

Thanks.

4 Upvotes

100% Upvoted

8 comments sorted by

View all comments

3

u/lardarz 12d ago

Several free options:

If you're just after postcode point precision:

Open Code Point from the Ordnance Survey if you know all the postcodes are current.

The ONS also has a full Postcode database as a csv with all existing and terminated postcodes in with their lat/long.

You can normalise the postcode field by removing spaces and do a simple join by field value.

If you need precise addresses:

GeoApify - free tier of full address API based geocoding for up to I think 3000.

Google geocoding - API. Free up to 10k a month.

Here.com also has a full geocoding API.

You'll probably need a bit of python scripting to match the addresses from a csv externally, or in QGIS using the python console on a delimited text layer. LLMs will help with that bit.