topic Re: Geocoding returns wrong latitude and longitude in QlikView

Geocoding returns wrong latitude and longitude

Mon, 28 Oct 2013 12:47:43 GMT

Hi all,

I have a table with only a column with a number of zipcodes.

I agreed with the customer that:

- if length zipcode = 5 => 'France'

- if length zipcode = 4 => 'Belgium'.

If there is an incorrect zipcode, Google should return 'ZERO_RESULTS' as GeoCode Status.

For the zipcodes in Belgium, this is working correct. However for the zipcodes in France, Google returns geo-date from locations in the US.

I would like to know how I can have a reliable result from Google?

See QVW in the attachment.

Kind regards,

Fien

Re: Geocoding returns wrong latitude and longitude

thanstad — Mon, 28 Oct 2013 13:04:48 GMT

Try this page http://www.findlatitudeandlongitude.com/batch-geocode/ it working good with more details than City only, but try and see if this giving you the right figures. Otherwise add more details, cut and paste and press geocode. You will receive a csv file you easly can read into QlikView.

Reagrds,

Tormod Hanstad

Re: Geocoding returns wrong latitude and longitude

swuehl — Mon, 28 Oct 2013 13:26:41 GMT

I think you get the correct error code (ZERO_RESULTS) if you use postal_code instead of postal code in your GeoAdress strings, like

http://maps.google.com/maps/api/geocode/xml?sensor=false&ie=utf8&address=postal_code=73403,country=france

vs.

http://maps.google.com/maps/api/geocode/xml?sensor=false&ie=utf8&address=postal code=73403,country=france

P.S: seems like this is a CEDEX code that google can't assign a location. As an approximation for those locations, you can try rounding these codes to the hundres:

http://maps.google.com/maps/api/geocode/xml?sensor=false&ie=utf8&address=postal_code=73400,country=france

Re: Geocoding returns wrong latitude and longitude

Mon, 28 Oct 2013 19:16:51 GMT

the postal_code is the solution indeed, thanks!

Re: Geocoding returns wrong latitude and longitude

Tue, 29 Oct 2013 07:35:40 GMT

Do you also know how I can avoid the 'OVER_QUERY_LIMIT'-status?

I can't test anymore now, it's still returning an 'OVER_QUERY_LIMIT'.

Re: Geocoding returns wrong latitude and longitude

swuehl — Tue, 29 Oct 2013 09:33:30 GMT

Seems like you have exceeded your quota.

I think you already know, but please check:

The Google Geocoding API - Google Maps API Web Services — Google Developers

about usage limits.

Re: Geocoding returns wrong latitude and longitude

Tue, 29 Oct 2013 10:15:20 GMT

I solved it by connecting with a terminal server with another IP-address.

Re: Geocoding returns wrong latitude and longitude

Tue, 12 Nov 2013 09:02:06 GMT

Hi all,

While testing with a large number of addresses, i noticed that Google is not always returning the correct location.

I think that Google sometime makes it own combination of the address string.

If the address is not correct or Google cannot find this combination, i would like to see a 'zero_result' instead of another location that looks similar to that address.

There are 15.000 locations, so i can not check all of them and I would like to garantee to the customer that the locations are correct.

My stringcombination to Google is:

If there is a zipcode, country and no street available:

ApplyCodepage('zip_code='&ZipCode&',country='&Country,437)

if there is a street, zipcode and country available:

ApplyCodepage(Street&','&ZipCode&','&Country,437) as GeoAddress,

Is this correct?

Re: Re: Geocoding returns wrong latitude and longitude

Wed, 12 Feb 2014 22:29:12 GMT

Hi, I am trying to use one of your methods to calculate the distance between 2 post codes, but it looks like I am doing something wrong. Can you kindly have a look? vCalc variable is not returning anything. Probably some problem with the alternate state?

Thanks,

Ram

Re: Re: Geocoding returns wrong latitude and longitude

Wed, 22 Feb 2017 00:18:51 GMT

It's offline

Re: Geocoding returns wrong latitude and longitude

Mon, 22 May 2017 17:55:44 GMT

This one works CSV 2 Geo Data

It allows you to specify country also as part of the address.

It should clear the issues.

regards