Yahoo Weather Query by Latitude and Longitude

yql yahoo-weather-api
squall leonhart picture squall leonhart · Feb 5, 2016 · Viewed 10.3k times · Source

I want to fetch some weather data via latitude and longitude using yahoo query. but it seems this query is not available now. the query is below:

select * from weather.forecast where woeid in (SELECT woeid FROM geo.placefinder WHERE text="{lat},{lon}" and gflags="R")

is this query is changed to new one or something? or it didn't exist anymore? last time I use this format was about 2 months ago and it worked well. but now it can't fetch any data. result from YQL console is as below:

{
 "error": {
  "lang": "en-US",
  "description": "Tenant 'query_yahooapis_com' access to 'Resource [tenantName=query_yahooapis_com, type=TABLE, name=geo.placefinder, locatorType=FILE, url=/home/y/share/manhattan/application/tenantBundles/yql_query_yahooapis_com_manhattan_v2/YQL-INF/restdefs/geo.placefinder.xml, useUrl=false]' is denied."
 }
}

I already make some research, including this post: How to get Yahoo's woeid by location?

Is that true that yahoo already terminate this latitude longitude query for fetching weather?

Answer

greg picture greg · Feb 17, 2016

According to the latest reply to this answer, you should switch to the table geo.places and remove the gflags="R" part. I tried it in the YQL console and it seems to work:

select * from weather.forecast where woeid in (SELECT woeid FROM geo.places WHERE text="(latitude,longitude)")

Related questions

Yahoo Weather WebService

I'm trying to find a way to get some weather information with Yahoo Weather using Yahoo Query Language. As I'm living in France, in a city called Nice, the following query returns an error: select * from weather.forecast where location=…

Read More
Getting data from Yahoo Finance

I read about the YQL, but I didn't understand how can I get some simple data (like company ticker, market cap, stock price, etc.), for ALL COMPANIES? And an additional question, how can I get all Yahoo Finance tables and …

Read More
jQuery Ajax request every 30 seconds

I have this piece of code, but the values may change while someone is on my site. I would need to update the #finance div every 30 seconds or so. Can this be done? $(function() { $.getJSON( "http://query.yahooapis.com/v1/…

Read More