topic google coordinates in QlikView

google coordinates

Anonymous — Thu, 18 Mar 2010 15:37:15 GMT

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??

google coordinates

Thu, 18 Mar 2010 16:01:22 GMT

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

google coordinates

Anonymous — Thu, 18 Mar 2010 17:50:13 GMT

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

google coordinates

Thu, 18 Mar 2010 20:04:34 GMT

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

regards
Julian

google coordinates

Anonymous — Fri, 19 Mar 2010 11:22:37 GMT

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?

google coordinates

Fri, 19 Mar 2010 15:44:32 GMT

Hi,

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

Thanks,

Cezar

google coordinates

Fri, 19 Mar 2010 21:16:18 GMT

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;

google coordinates

Anonymous — Mon, 22 Mar 2010 12:05:32 GMT

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 😞

google coordinates

Anonymous — Tue, 23 Mar 2010 15:32:51 GMT

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;

google coordinates

Tue, 23 Mar 2010 15:47:26 GMT

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.

google coordinates

Tue, 23 Mar 2010 15:53:17 GMT

Thank you, I will try it!

google coordinates

Anonymous — Tue, 23 Mar 2010 16:37:20 GMT

Mm so I'm busy for a week getting the coordinates ... well they don't change that much so I will find a way 😉

Thanks you all

google coordinates

Anonymous — Tue, 30 Mar 2010 08:45:16 GMT

The solution I made was getting 15.000 postcodes per day (they maximum of requests google maps has per day for retrieving coordinates), including a sleep since the speed of the requests may not be done to fast.

I cut up the postcode list in more smaller lists and each day I run one list with my script so each day I get about 15.000 coordinates ...

It takes some time, but this list wont change in time only grow ...

This was the only way since there are indeed restrictions of the amount per day and the speed of requesting.

Thanks all for thinking with me!

Anita