Yahoo YQL: find city WOEID by coordinates

yql yahoo-api
Ivan Bajalovic picture Ivan Bajalovic · May 23, 2012 · Viewed 11k times · Source

How to get city's WOEID if I know latitude and longitude of city using YQL?

Answer

shshaw picture shshaw · Sep 25, 2013

For those still trying to look up the WOEID by coordinates, the other answers are now outdated. Use the geo.placefinder datatable to look up the latitude and longitude, and the WOEID will be in the returned results.

Via YQL:

SELECT * FROM geo.placefinder WHERE text="{$seedLat}, {$seedLon}" and gflags="R"

(Test it out on the YQL Console.)

Via REST:

http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20geo.placefinder%20WHERE%20text%3D%22{$seedLat}%2C{$seedLon}%22%20and%20gflags%3D%22R%22

Related questions

Making Yahoo Weather API request with OAuth 1

I ran into a problem with Yahoo Weather API because it wasn't giving me any data. After visiting YDN website I've found out that all requests should be updated to OAuth 1 starting from March 15th (but I got working it …

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