Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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
I think that you need to change your google key, because there is a limit.
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
I don't know the limit, but I know that have it. Do you receive any error? any message?
regards
Julian
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?
Hi,
Could you, if possible, share your script to recover coordinates?
Thanks,
Cezar
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
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 😞
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;
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.