0

Request all continents

when I request all continents (select * from geo.continents) I get:

Africa
Asia
North America
South America
Europe
Antarctic
Australia

Where is 'asia pacific' continent in this list? To request the country New Zealand I use:

select * from geo.countries where place='asia pacific'


Regards
Ricardo Goncalves

by
2 Replies
  • Ricardo,

    I don't think "place" is restricted to continents only. It seems to be some free-form input and I have been able to get results back with place='APAC', place='NA', etc.

    I am not sure why New Zealand does not show up under the continent 'Australia' ... BTW Wikipedia has an interesting page on "Continent" - http://en.wikipedia.org/wiki/Continent

    Sriram

    QUOTE (Ricardo @ Mar 13 2011, 04:39 PM) <{POST_SNAPBACK}>
    when I request all continents (select * from geo.continents) I get:

    Africa
    Asia
    North America
    South America
    Europe
    Antarctic
    Australia

    Where is 'asia pacific' continent in this list? To request the country New Zealand I use:

    select * from geo.countries where place='asia pacific'


    Regards
    Ricardo Goncalves
    0
  • QUOTE (Sriram @ Mar 14 2011, 09:11 AM) <{POST_SNAPBACK}>
    Ricardo,

    I don't think "place" is restricted to continents only. It seems to be some free-form input and I have been able to get results back with place='APAC', place='NA', etc.

    I am not sure why New Zealand does not show up under the continent 'Australia' ... BTW Wikipedia has an interesting page on "Continent" - http://en.wikipedia.org/wiki/Continent

    Sriram


    Yahoo! follows the seven continent model (see http://en.wikipedia.org/wiki/Continent#Number_of_continents). New Zealand is not part of the Australian continent because it is on a different continental shelf.

    Asia Pacific (aka APAC) is a colloquial area name that covers multiple countries (also called a supername). geo.countries supports supernames as well as continents as a place name.

    Eddie Babcock
    Yahoo! Geo Technologies
    0

Recent Posts

in YQL