advanced code snippet search

Posted By

rccc on 11/15/09


Tagged

YQL


Versions (?)

find info from WOEID

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT * FROM flickr.places.info WHERE woe_id='615134'

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: vicchi on November 16, 2009

The more generic geo.places table in YQL give you the definitive source of the data that Flickr mines for flickr.places:

select * from geo.places where woeid="615134"

which yields

    true

    46
    42
    3694



        615134
        Town
        Orleans
        France
        Centre
        Loiret

        Orleans



            47.901428
            1.904960



                47.813320
                1.809770


                47.960220
                1.993860

You need to login to post a comment.