topic Re: Lat and Long for postcodes? in QlikView

Lat and Long for postcodes?

Thu, 22 May 2014 20:19:40 GMT

Hi,

Is there any third party tool to get the Latitude and Longitude for postcodes. Please can anyone suggest me.

Thanks,

Re: Lat and Long for postcodes?

jpapador — Thu, 22 May 2014 20:24:20 GMT

You can get zip codes with latitude and longitude from the United States postal service website. You can download it in CSV or Excel format

Re: Lat and Long for postcodes?

Thu, 22 May 2014 20:28:06 GMT

Thanks. Can I have the URL please? I have to get latitudes and longitudes for UK postcodes.

Re: Lat and Long for postcodes?

Colin-Albert — Thu, 22 May 2014 20:31:11 GMT

It depends if you need the following postcode or just the first part (outcode).

The full UK postcode to lat long data is available commercially, but there are sites where you can get the outcode to late long mappings which are royalty free.

Try googling "uk postcode data" to see the options what's available.

Re: Lat and Long for postcodes?

Thu, 22 May 2014 20:34:03 GMT

Thanks. I have postcodes. I need latitude and longitude. Is it possible? I googled and found GPSVisualizer. will that work? please suggest me.

Re: Lat and Long for postcodes?

Colin-Albert — Thu, 22 May 2014 20:48:21 GMT

You can find sites that have a csv or database file you can download listing outcodes and lat.long.

Try searching. "office for national statics postcode"

Re: Lat and Long for postcodes?

Anonymous — Fri, 23 May 2014 02:59:34 GMT

https://developers.google.com/maps/documentation/geocoding/?csw=1

You could run the zips through Google's Geocoding service for free. This can be used within a QlikView script, but you are limited to 2500 requests per day.

Re: Lat and Long for postcodes?

Fri, 23 May 2014 07:54:10 GMT

Thanks. Could I know what limited to 2500 requests per day means? just confused a little bit. Please help!

Re: Lat and Long for postcodes?

marcus_malinow — Fri, 23 May 2014 07:56:42 GMT

Amelia,

you could use GeoDesix (http://www.calvert.ch/geodesix/), an excel plugin which uses the Google Maps API. Using this, you can enter Excel formulae which will retrieve your lats and longs.

Marcus

Re: Lat and Long for postcodes?

Fri, 23 May 2014 08:03:23 GMT

Amelia, there are a number of other apps out there that will allow you to geocode and/or correct an address via a web service - but these are are commercial options , that all come with associated prices.

Are you looking for a free list? or something you can use commercially?

Re: Re: Lat and Long for postcodes?

jagan — Fri, 23 May 2014 08:35:43 GMT

Hi,

Check the links in attached file, hope it helps you.

Regards,

Jagan.

Re: Lat and Long for postcodes?

ThornOfCrowns — Fri, 23 May 2014 08:57:10 GMT

That means your application can ping the Google maps database 2500 times a day, i.e. allow 2500 users one session, or 1 user 2500 sessions or any combinations between.

As per your original request, see : freemaptools.com/download-uk-postcode-lat-lng.htm for the Outcodes with Lat / Long (I removed the www. from the link to avoid the mideration wait)

Re: Lat and Long for postcodes?

struniger — Fri, 23 May 2014 09:46:37 GMT

In http://community.qlik.com/message/396180#396180 you'll find a comment about how to use google to get your long/lats.

Good luck

Stefan

Re: Lat and Long for postcodes?

Fri, 23 May 2014 09:56:12 GMT

Thanks.Can I get commercial ones. please help

Re: Lat and Long for postcodes?

ThornOfCrowns — Fri, 23 May 2014 10:10:58 GMT

Again, see www. freemaptools.com for their full, free databases in either SQL or CSV:

SQL /download/full-postcodes/fullukpostcodes.zip

CSV /download/full-postcodes/postcodes.zip

Either will solve your problem.