I'm trying to get weather forecasts for some cities through SQL
I would expect the following YQL to work, but it gives to me a "City not found error"
SELECT * FROM weather.forecast WHERE location IN (SELECT woeid FROM geo.places WHERE text="san francisco, ca")
It seems to me that the location filed of the weather.forecast requires some other location ID and not the woeid. I tried to get the weather information calling the forecastrss wirh the woeid of San Francisco (http://xml.weather.yahoo.com/forecastrss?w=2487956&u=c) and I found in it a different ID fro San Francisco (USCA0987)
Then I tried to use YQL again with that ID and I finally got the forecasts for San Francisco (SELECT * FROM weather.forecast WHERE location = 'USCA0987')