Back to GeoPlanet Enhancement Requests Forum
0

Hierachy, countries & more.

Hi Team,

I would like to use the Dataset but It's not very clear. Many hierarchical for ENG countries are correct but others are not clear to be used. Could you clearify the hierarchy, plz..

1/ Hierarchies Data
Continent > Country > State(Admin1)> It's clear but after?

LocalAdmin is an (Admin2 or Admin3 ) & parent is
County is an (Admin2 or Admin3 lebvel ) & parent is
Island parent is Country or State
Estate parent is
Suburb parent is :Town? i suposse

2/Language is iso?
Ok 3 char language but how to use, we work with cultures, need more tables to use.

3/ To be usefull we need a minimal FIXED hierarchies like Country>State>City>District for all countries.
Could you add a Parentlevel to know where is pointing.

Woied IsoCountry Name Language Placetype ParentID ( ParentLevel )

Where this point is linked
ParentLevel is the parent level in the hierarchy (parent is a Town or LocalAmin or Island?...)

4/ Lost Countries.
All countries are not here. Many countries have great details and others not exist !. For these countries, could you found a minimal level like Country/Admin1/Admin2/Admin3 and Towns. I search the ElDorado mines in EC and PE but i can't found. They are my neighbors and i can't offed-it using your data. Is the minimal for a project like yours. All countries now! but with minimal. Waiting for Update.

5/Add one point lat/long as minimal

6/split zip, poi, historical in complementary tables. The main table is indigest. 18 hours to digest using my mssql and secured transactions.I'm affraid to use neighbours in this conditions.

7/ webservice in production mode for large solutions are ready?

Regards, Romi

by
Report Abuse
4 Replies
  • QUOTE (Romieux @ Sep 26 2010, 08:33 AM) <{POST_SNAPBACK}>
    Hi Team,

    I would like to use the Dataset but It's not very clear. Many hierarchical for ENG countries are correct but others are not clear to be used. Could you clearify the hierarchy, plz..

    1/ Hierarchies Data
    Continent > Country > State(Admin1)> It's clear but after?

    LocalAdmin is an (Admin2 or Admin3 ) & parent is
    County is an (Admin2 or Admin3 lebvel ) & parent is
    Island parent is Country or State
    Estate parent is
    Suburb parent is :Town? i suposse

    Parent places are always the smallest administrative place that fully contains a specified place. Administrative placetypes are Country => Admin1 (State) => Admin2 (County) => Admin3 (LocalAdmin). Some places, such as Suburbs, Estates, Zips, Airports, Land Features (parks), and POIs, may be parented by a Suburb or Town if they are associated with such a place. Countries, Continents, Oceans, Seas, and Supernames (places covering multiple countries) are all parented by Earth (WOEID 1). We prefer to use the names Admin1/Admin2/Admin33 because subdivision names may be used in multiple countries for different levels. A Province in Canada is an Admin1 place, while a Province in Italy is an Admin2 Place (Admin1 places in Italy are called Regions). The placeNameType element provides the actual place type name in the requested language.

    QUOTE
    2/Language is iso?
    Ok 3 char language but how to use, we work with cultures, need more tables to use.

    We use ISO 639/T to represent language codes. See http://www.loc.gov/standards/iso639-2/ for more details. You can download a pipe-separated list of language codes from http://www.loc.gov/standards/iso639-2/ISO-639-2_utf-8.txt.

    QUOTE
    3/ To be usefull we need a minimal FIXED hierarchies like Country>State>City>District for all countries.
    Could you add a Parentlevel to know where is pointing.

    Woied IsoCountry Name Language Placetype ParentID ( ParentLevel )

    Where this point is linked
    ParentLevel is the parent level in the hierarchy (parent is a Town or LocalAmin or Island?...)

    Countries have varying numbers of levels. Some countries have 0 levels, like Vatican City, while others have 3 levels, like China. The placetypes Country, State, County, LocalAdmin form a fixed administrative hierarchy (see answer to question 1). It is possible to find the placetype for a parent by joining the Normal table with itself, matching ParentID with WoeID. If you prefer, you could add a table field with the parent placetype data, so you have direct access to it.

    QUOTE
    4/ Lost Countries.
    All countries are not here. Many countries have great details and others not exist !. For these countries, could you found a minimal level like Country/Admin1/Admin2/Admin3 and Towns. I search the ElDorado mines in EC and PE but i can't found. They are my neighbors and i can't offed-it using your data. Is the minimal for a project like yours. All countries now! but with minimal. Waiting for Update.

    WhereHaus includes all countries (and dependent territories) that have ISO 3166 codes assigned to them, the administrative areas that subdivide them, and towns within them. If you think we are missing a country or administrative area, please let us know. We do not have many points of interest in some countries, such as Ecuador or Peru. We are always looking for more place data to add to GeoPlanet, so if you have a favorite source of place data, please let us know!

    QUOTE
    5/Add one point lat/long as minimal

    We are evaluating the possibly of including centroid and bounding box data to GeoPlanet Data. In the meantime, please use the GeoPlanet web service for any applications that require this data.

    QUOTE
    6/split zip, poi, historical in complementary tables. The main table is indigest. 18 hours to digest using my mssql and secured transactions.I'm affraid to use neighbours in this conditions.

    You do not need to ingest the entire Normal file (5.5M places) into a single table. It you are not interested in every place, you can filter the data by country code (ISO) and/or placetype before you load the data. We have partitioned the data to allow it to be represented in the fewest number of tables. There are 8.6M neighbor relationships, but there are only four fields to load.

    QUOTE
    7/ webservice in production mode for large solutions are ready?

    GeoPlanet Data is currently not allowed for commercial use. Please respect our terms of service. If you wish to use GeoPlanet Data for commercial use, please contact us at http://developer.yahoo.com/register/.

    QUOTE
    Regards, Romi

    Thank you for your questions. I hope our answers are satisfactory. When you have an application available using GeoPlanet, please tell us about it by posting to the Demos and Applications forum.

    Eddie Babcock
    Yahoo! Geo Technologies
    Report Abuse
    0
  • Hi Eddy,

    Thanks for explains. I have tested using some filters. The database are great but need more features to be usefull.

    1/Add density level for towns
    Searching cities for a State : You found alls including very small towns. This is unusable and not clear when you expose to users. We need a level of density. This is working in webservices but not in datatables. ADD Density level plz.

    2/ Add fixed Hierarchy as complement or linked table to create Friendly User Interfaces.
    We understand that some countries have 0, or 2 or 3 levels and the complete hierarchies have more than 6 levels for complexes administrations levels.
    Continent>Country>State>County>LocalAdmin>Town>suburb and others like Islands..Poi, hystoricals are linked at diff. levels.
    In this case is not possible to include these ParentsID as fixed levels and be able to jump throu the hierarchy. Of course if exist.

    ID, Name....ParentID. Density LocalAdminID(3) StateID(2) CountyID(1)

    Could you found these complementary table for current version 7.5.2 ? WOEID DensityLevel LocalAdmin(3) StateID(2) CountryID(1) to perform some test for worldwide usability.

    Thanks.
    Report Abuse
    0
  • QUOTE (Romieux @ Sep 28 2010, 12:55 PM) <{POST_SNAPBACK}>
    Hi Eddy,

    Thanks for explains. I have tested using some filters. The database are great but need more features to be usefull.

    1/Add density level for towns
    Searching cities for a State : You found alls including very small towns. This is unusable and not clear when you expose to users. We need a level of density. This is working in webservices but not in datatables. ADD Density level plz.

    I'm not sure what you mean by density. If you are referring to Population Rank, this data is currently only provided by the web service.

    QUOTE
    2/ Add fixed Hierarchy as complement or linked table to create Friendly User Interfaces.
    We understand that some countries have 0, or 2 or 3 levels and the complete hierarchies have more than 6 levels for complexes administrations levels.
    Continent>Country>State>County>LocalAdmin>Town>suburb and others like Islands..Poi, hystoricals are linked at diff. levels.
    In this case is not possible to include these ParentsID as fixed levels and be able to jump throu the hierarchy. Of course if exist.

    ID, Name....ParentID. Density LocalAdminID(3) StateID(2) CountyID(1)

    Could you found these complementary table for current version 7.5.2 ? WOEID DensityLevel LocalAdmin(3) StateID(2) CountryID(1) to perform some test for worldwide usability.

    Thanks.

    While this information can be derived from the supplied files, it may be worthwhile packaging the hierarchy (as well as area rank and population rank) as a separate file that can be easily loaded into a relational table. I'll add this to our enhancement request list.

    Thank you for your suggestions!

    Eddie Babcock
    Yahoo! Geo Technologies
    Report Abuse
    0
  • QUOTE (Eddie B @ Sep 29 2010, 01:13 PM) <{POST_SNAPBACK}>
    I'm not sure what you mean by density. If you are referring to Population Rank, this data is currently only provided by the web service.
    YES : Population Rank

    While this information can be derived from the supplied files, it may be worthwhile packaging the hierarchy (as well as area rank and population rank) as a separate file that can be easily loaded into a relational table. I'll add this to our enhancement request list.
    FANTASTIC

    Thank you for your suggestions!

    Eddie Babcock
    Yahoo! Geo Technologies


    Hi Eddy,

    Thanks. I have moved my solution to test your package. One of the great problem is the changing hierarchy. I have tested worldwide using states, admin2 and admin3 levels. When the countries have 3 levels It works correctly, but sometimes when the countries have changing levels, my solution is not able to manage. The sample : US have no admin3 level (State>County>?>Town)?. Other : CN or FR is using 3 levels. I have splitted the tables to perform speed and cached test. The request time for these countries is currently 4-6 sec by query in splitted tables. Caching or using client stored tables you can perform in 600ms. It´s acceptable for my world wide solution but not easier to maintain in current state of version 7.5.2.We need to add manually a lat/long geocenter point and some complementary datas managed. I try to decrease webservices demand's to an acceptable amount for a production model, but without a geocenter point it is not possible and very difficult to maintain.

    I understand that you are thinking about add or not the geopoints, but we can't use without this minimal. Webservices are a good complement but i can't mount a large project without this basic feature.

    In conclusion:
    Add a Rank : without this the Users UI are overloaded by smallest cities and localAdmin. Very unpleasant.
    Add a fixed hierarchy table : to allow jump in hierarchy to simplify users UI.
    Add one minimal geopoint. for State,Admin1,admin2,Admin3 and keep for you cities if you like as webservices.

    Isn't it possible to add in the current version the complementary tables?

    Regards
    Romi.
    Report Abuse
    0
✕ This forum is locked.
Ask a Question

Recent Posts

in GeoPlanet Enhancement Requests