Better, reliable availability for geo.places and geo.placefinder YQL queries....(commercial app wanting to use)


We are trying to query using yql geo.places and geo.placefinder the public data in chunks of 200. We want response in JSON format.

A lot of times the data that comes back is Missing for several of these woeids that are on the query URL or the data doesn't come back at all.
This means we have to re-try,
This can suignificantly increase time as we are trying to get this for 1200K (1.2 million).

Trying to get a More reliable response will decrease our timeline significantly to get this data.

How can we achive that? We have to end up doing 6K such queries successfully to reach around
1200K with each query being 200.

Since this is PUBLIC Data, is there a Better Paid version of this so we can get the data in a more reliable way.
Or should we try to do it in some other way.

Steps followed:

1. Filter from 6 million records places file and 2 million aliases file tsv files to create records in geoplanet locations table. We filter for 

2. We get 1.2 million in the database. In chunks of 200, we try to query to get the data that we want using http://query.yahooapis.com/v1/public/yql/?q=select%20*%20from%20geo.places%20where%
and "http://query.yahooapis.com/v1/public/yql/?q=select%20*%20from%20geo.placefinder.

Please reply on what steps we can do here, any form of paid service we can get or a US phone number where we can call to discuss this further.
Sent this through contact form also.
Would like to have a more reliable availability of this data....


0 Replies
This forum is locked.

Recent Posts

in GeoPlanet Commercial Use