Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out Qlik.com. I write this blog to showcase some technical bits that I hope will be useful to others.
adamcooke@webofwork.com

Tags

All UK Postcodes.CSV with Lat and Longs for Qlik Sense

Webofwork > Data Modelling  > All UK Postcodes.CSV with Lat and Longs for Qlik Sense

All UK Postcodes.CSV with Lat and Longs for Qlik Sense

Hello!

This is a file I created by scraping data from a freely available Geographical API. It has proven really useful for Qlik Sense Mapping visualizations.

It contains the latitude and longitude of every uk postcode. It also includes the Easting, Northing, Grid Reference, District, Ward, District Code, Ward Code and Country.

 

You can use this file in a tool like Qlik Sense to make fancy maps like the one below:

MappingExample_Large 625x349

You can follow these video instructions to get one of these pretty interactive maps up and running:

 

Download all UK Latitude and Longitudes CSV File Here


Your Name (required)

Your Email (required)

What are you using this for?

user-gravatar
Adam Cooke

I currently work as a consultant for Qlik, a software company doing some interesting stuff in business intelligence. Check it out Qlik.com. I write this blog to showcase some technical bits that I hope will be useful to others.

13 Comments
  • Posted at 12:47 pm, 4th July 2016

    Hi, I have requested a link and got the e-mail, but it takes me to a picture, rather than a download.

      • Posted at 2:51 pm, 4th July 2016

        Hi Adam,

        sorry to be a pain, but it seems that the file ends at 1,048,574 rows or NG34.

        I am doing a simple load * from file in QlikView and it runs without issue. Is the file complete at your end?

        Thanks,

        James.

          • Posted at 9:46 am, 5th July 2016

            Hi Adam,

            I’m aware of the limit, which is why I’m wondering if this is the full list of postcodes.

            I am querying the csv directly from QlikView, so I wouldn’t expect to hit a hard limit on the extract, unless the original file was truncated.

            Regards,

            James.

  • Posted at 2:22 pm, 4th July 2016

    Hi Adam,

    it’s working now, just need to split it out into smaller files!

    Thanks for your hard work and the prompt reply!

  • Posted at 9:46 am, 28th April 2017

    Hi so is this a full list of all postcode or do you need to send the sheet in a couple of files?

    It seems like Jakmes above had the same question?

  • Posted at 9:46 am, 28th April 2017

    Hi so is this a full list of all postcode or do you need to send the sheet in a couple of files?

    It seems like James above had the same question?

  • Posted at 1:03 pm, 13th September 2017

    … [Trackback]

    […] Find More here|Find More|Find More Informations here|There you can find 37311 more Informations|Infos to that Topic: webofwork.com/all-uk-postcodes-csv-with-lat-and-longs-for-qlik-sense/ […]

  • Posted at 7:26 pm, 14th September 2017

    Hi, all I get when i download the file is this on over 1 million lines in excel.

    Warning: feof() expects parameter 1 to be resource, boolean given in /home/cookiejest/webofwork.com/wp-content/plugins/email-before-download/download.php on line 233

  • Posted at 11:42 am, 19th September 2017

    … [Trackback]

    […] Read More here|Read More|Read More Infos here|There you can find 64021 more Infos|Informations on that Topic: webofwork.com/all-uk-postcodes-csv-with-lat-and-longs-for-qlik-sense/ […]

Post a Comment

Comment
Name
Email
Website