I require a list of data on UK cities giving longitude and latitude details. Preferably in CSV or Excel format.

migrated from gis.stackexchange.com Apr 19 '17 at 7:55

This question came from our site for cartographers, geographers and GIS professionals.

  • 1
    Possible duplicate of Geodata to make a map of the UK with counties outlined – marfi Apr 19 '17 at 8:14
  • I'm not so sure that is a duplicate, because it asks for county boundaries. The OP may need central coordinates. @NWTH please edit your question to tell us exactly what you need. – Jan Doggen Apr 19 '17 at 12:25
  • I reverted the last few edits - the question was changed to asking for cinema locations, thereby invalidating all answers. – Jan Doggen Jan 11 at 12:20
  • As the OP of the "possible duplicate" I can assure you that this is not a duplicate. The OP here is not asking for "outline", just one lat/long per city – Mawg Apr 5 at 8:41

You can probably use OpenStreetMap (OSM) for this. OSM is a open database of geographical features. OSM features are described by tags, that are combination of key-value pairs.

The entry point to look at the geographical features of OSM is this page: https://wiki.openstreetmap.org/wiki/Map_Features, which describes the major features that are mapped in OSM. Look at https://wiki.openstreetmap.org/wiki/Map_Features#Places for the section about places. "Cities" in OSM are be described by place=city. If you need more little towns, you can search for place=town, place=village, etc. (see the above link for more tags of places in OSM).

To query the data in OSM, you can use http://overpass-turbo.eu/. Use the wizard (one of the top tab), type "city in UK", increase the timeout up to 60s and run the query. Or just click on this share link since I just tried it ;-) : http://overpass-turbo.eu/s/orK. You can then export the result in geojson and convert it to a csv with the city name, latitude, longitude. There is also additional information that you may discard.

I'm not aware of open UK gov data, but it might be an other possible source.



Probably the best source of GB data is the Ordnance Survey - in this case you want the Open-Names product.


Go to GeoNames:

The GeoNames geographical database covers all countries and contains over eleven million placenames that are available for download free of charge.

Here is the data info for the files that you can download here, you need the file with the two-character ISO country code GB.ZIP, currently containing 61069 entries in CSV format.

They have all kinds of support as well.


Areas/ boundaries of UK cities and major towns from the Open Geography Portal at the UK Office for National Statistics:

Major Towns and Cities (December 2015) Boundaries

Available as .csv/.kml/.shp

  • The OP here is not asking for "boundaries ", just one lat/long per city – Mawg Apr 5 at 8:43
  • 1. The OP is vague and requests "giving longitude and latitude details". That doesn't explicitly say boundaries or one lat/long. – Sam Apr 5 at 14:16
  • 2. From the boundaries you can extract one lat/long, either a centroid or a randomly generated point. – Sam Apr 5 at 14:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy