topic Postcodes in Google Maps in QlikView

Postcodes in Google Maps

Fri, 16 Oct 2009 03:53:37 GMT

Is there an easy way of using UK Postcodes in the Google Maps function in QlikView?

The demo QVW's only appear to use lat and long but I only have post codes in my data.

Any help much appreciated.

Postcodes in Google Maps

Anonymous — Fri, 16 Oct 2009 10:34:49 GMT

Andrew,
As far as I know, Google map uses coordainates to show locations. That means that you need to find latitude and longitude for each UK Postcode and create a table. The chances are that such a table has been created already, and you only need to find it.

Postcodes in Google Maps

Fri, 16 Oct 2009 22:28:59 GMT

Thanks Michael. Any ideas where I can get a copy of such a table? I've been looking but not found anything so far.

Postcodes in Google Maps

Fri, 16 Oct 2009 22:42:10 GMT

Here is one link which one of the member referenced earlier. This might help you.

http://www.mapsofworld.com/lat_long/

--Arun

Postcodes in Google Maps

stevedark — Thu, 24 Jun 2010 23:25:07 GMT

Hi Arun,

Did you get this working in the end? I have a demo application based on UK postcodes, and a couple of files that map postcodes onto other information - such as latitude and longitude.

Cheers,
Steve

Postcodes in Google Maps

Thu, 22 Jul 2010 12:51:08 GMT

Hi Steve, Please can you share these files with us, they would be very useful. Thanks

Postcodes in Google Maps

Sun, 23 Oct 2011 11:56:58 GMT

Hi AndrewL,

Take a look at this string :

http://community.qlik.com/thread/6832?start=0&tstart=0

and below is some code taken from a post in that string where J.J was kind enough to post an example containing below code, pulling data from the google maps API, querying it for postcodes in the UK and bringing those into a table. Below code assumes you have a field called 'PostCode', you can adjust to match your tables.

let vNbRecords = fieldvaluecount('PostCode');

for i=1 to $(vNbRecords) ;

let vPcode = FieldValue('PostCode',$(i)) ;

sleep 200 ;

Adresses:

LOAD //@1,

//@2,

@3 as latitude,

@4 as longitude,

'$(vPcode)' as 'PostCode'

FROM

[http://maps.google.com/maps/geo?q=$(vPcode)+uk&output=csv]

(txt, codepage is 1252, explicit labels, delimiter is ',', msq);

next i ;

Postcodes in Google Maps

lzimmermann — Mon, 24 Oct 2011 06:38:15 GMT

Hi,

look at http://www.geonames.org/export/ .

There you will find from many countries, the postal code (with Lat and Long). There is a web service or you can download for each country a CSV file.