I am New to this enviornment.
I want to fetch woeid on the basis of zipcode from the GEO table but i don't know the ways how to fetch it.
could you please provide some help on this.
I also want to know that basically Woeid is basis on what??
to fetch woeid on the basis of place name i use the following syntax in the YQL console.
select woeid from geo.places where text="Gwalior,India"
so I want to know what is the syntax for fetch the woeid on the basis of zipcode (zipcode is basically belong to particular city in a Country.)
You provide the postal code and country name (or country code) in the text:
select * from geo.places where text="474001,India"
The country name is needed in case the postal code is used in several countries. For India, we also recognize postal codes if the city name and last two digits of the postal code are provided:
select * from geo.places where text="Gwalior 1"
Note that the country name is not needed in this case because of the unique construction of the place name.
Eddie Babcock
Yahoo! Geo Technologies
