5

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

Improve this question
4
  • 1
    Possible duplicate of Geodata to make a map of the UK with counties outlined
    – marfi
    Commented Apr 19, 2017 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.
    – user4293
    Commented Apr 19, 2017 at 12:25
  • I reverted the last few edits - the question was changed to asking for cinema locations, thereby invalidating all answers.
    – user4293
    Commented Jan 11, 2019 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
    Commented Apr 5, 2019 at 8:41

4 Answers 4

Reset to default
4

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.

J.

Improve this answer
4

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

Improve this answer
4

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.

Improve this answer
4

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

Improve this answer
3
  • The OP here is not asking for "boundaries ", just one lat/long per city
    – Mawg
    Commented Apr 5, 2019 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
    Commented Apr 5, 2019 at 14:16
  • 2. From the boundaries you can extract one lat/long, either a centroid or a randomly generated point.
    – Sam
    Commented Apr 5, 2019 at 14:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.