使用Yql查询lat，long parms获取天气信息

Question

我使用以下YQL查询来获取天气信息

http://query.yahooapis.com/v1/public/yql?q=select%20item%20from%20weather.forecast%20where%20location%3D%2248907%22&format=json

有没有办法使用经度、纬度作为YQL查询参数来获取天气信息？

Answer 1

您可以使用子选择从纬度/经度对转到WOEID，如下所示

SELECT * FROM weather.woeid 
WHERE w IN (
    SELECT place.woeid 
    FROM flickr.places(1) 
    WHERE (lat,lon) in (55.948503,-3.198931)
);

(Try in YQL console)

Answer 2

这对我来说很有效：

..。

query = "SELECT * FROM weather.forecast " +
            "WHERE woeid in (" +
            "SELECT woeid " +
            "FROM geo.places(1) " +
            "WHERE text=\"(%1$s,  %2$s)\") " +
            "AND u='c'";

..。然后：

query = String.format(query, location.getLatitude(), location.getLongitude());

Answer 3

我发现了一些有用的东西；如果您需要预测天气yql，请使用SELECT * FROM weather.bylocation WHERE location=‘印度尼西亚’select * from weather.forecast where location=90210