Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

google coordinates

Thank you, I will try it!

afuchten
Valued Contributor

google coordinates

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

Highlighted
afuchten
Valued Contributor

google coordinates

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