Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

google coordinates

Is there an easy way of retrieving a lot of coordinates at once for google?

I have a list of postal codes which I need coordinates of ...

I already have a script which gets one by one the coordinates ...

Problem with this is that somehow Google does not like it to have something like 70.000 or even more requests behind eachother.
Now I got 14.000 coordinates of the 70.000 ...

Don't seem to find a way of getting the complete list at once ...

Anyone familiar with this problem??

1 Solution

Accepted Solutions
Not applicable
Author

To prevent to many access to google maps, you can use in QV script the option sleep

sleep 100 means = send a request every 100/1000 seconds;

JJ

View solution in original post

12 Replies
Not applicable
Author

I think that you need to change your google key, because there is a limit.

Anonymous
Not applicable
Author

I did get a new key ... on the sign-up page they say there are no limits ...

You suggest that I use more keys at the same moment while loading to be sure I don't reach the limit (which limit is there??)

Thx

Anita

Not applicable
Author

I don't know the limit, but I know that have it. Do you receive any error? any message?

regards
Julian

Anonymous
Not applicable
Author

I don't recall getting any errors ... just empty values in my list.

When using the maps itself I retrieve an image of google which I assume means it went wrong or reached the limit?

Not applicable
Author

Hi,

Could you, if possible, share your script to recover coordinates?

Thanks,

Cezar

Not applicable
Author

To prevent to many access to google maps, you can use in QV script the option sleep

sleep 100 means = send a request every 100/1000 seconds;

JJ

Anonymous
Not applicable
Author

think I go try this ...

Do understand the problem of to many accesses to google maps at once ...

Only I'm afraid it will take a long time to fill all my coordinates this way 😞

Anonymous
Not applicable
Author

Script which i currently used:


TempPostcode:
LOAD distinct Code as vPostcode
resident Postcodes;

LET AantalPostcodes = FieldValueCount('vPostcode');
FOR i = 0 to $(AantalPostcodes)-1
LET C = peek('vPostcode', '$(i)', 'TempPostcode');

Temp:
LOAD
'$(C)' as Code,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS Latitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS Longitude
FROM [http://maps.google.com/maps/geo?q=$(C),+NL&output=xml&oe=utf8&sensor=false&key=ABQIAAAAmDM9MXAc9fuktt5S3GsdNRTXWNiY2Ww2Y3H-zIQNjrA6EqkOGxRLrFhU2Z2ohjnalxL3UWgmdLbMuA] (XmlSimple, Table is [kml]);
NEXT

LEFT JOIN (Postcodes)
LOAD
Code,
Latitude,
Longitude
RESIDENT Temp;


Not applicable
Author

Yep ...

We use the same API that can get 15.000 coordinates per 24 hours (set limit ... we looked it up). So to get more you have to get 15.000 each day until you have all your coordinates.

Perhaps someone else has a better solution.