I have recently discovered Cartodb and I am trying to create a bubble/thematic map of postcodes. I have a csv document with one column of postcodes from around the UK. I have uploaded the dataset and when georeferencing the data i choose from the postal code tab and enter United Kingdom as a country.

The issue is that only a handful of the post codes got georeferenced while the rest remain null. The postcodes are valid so not sure why it's not working.

Is there something I am doing wrong?

EDIT here is an screenshot of the data, you can see a few have their long/lats while others don't

enter image description here

  • 1
    Welcome to GSE. You might want to add an example (screenshots / table) of what you're trying to achieve - this will make it easier to understand the issue. – dru87 Jun 27 '16 at 15:10
  • 1
    I have added a screenshot, please let me know if there is anything else – Sai Jun 27 '16 at 15:16
  • the_geom is the field that is required for location so only the lat/lng values will work, CartoDB does not geocode GB postcodes. your better uploading Open Code-Point from Ordnance Survey ordnancesurvey.co.uk/business-and-government/products/… - you will have to re-project OSGB36 to WGS84 for lat/lng and not OS grid references. – Mapperz Jun 27 '16 at 18:23
  • to save reprojection use freemaptools.com/download-uk-postcode-lat-lng.htm CSV ukpostcodes.zip (33MB zipped, 96MB unzipped) but check the dates (16th November 2015) that is 2 updates behind OS releases. – Mapperz Jun 27 '16 at 18:26

Your Answer

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

Browse other questions tagged or ask your own question.