0

geoplanet_places_7.4.1.tsv

We would like to import the data file ( geoplanet_places_7.4.1.tsv ) into a database and use it our application. However, since some of the rows in the datafile have place names in special characters as below, it is not helping us and we are kind-of stuck.

28628569 "JP" "佐世保グリーンホテル" JPN POI 28486857

Is it possible to have the geoplanet_places_7.4.1 data file completely in English ? Please advise.

Thanks,
Sekhar.

by
5 Replies
  • QUOTE (Chandra Sekhar @ May 11 2010, 05:14 AM) <{POST_SNAPBACK}>
    We would like to import the data file ( geoplanet_places_7.4.1.tsv ) into a database and use it our application. However, since some of the rows in the datafile have place names in special characters as below, it is not helping us and we are kind-of stuck.

    28628569 "JP" "佐世保グリーンホテル" JPN POI 28486857

    Is it possible to have the geoplanet_places_7.4.1 data file completely in English ? Please advise.

    Thanks,
    Sekhar.


    The GeoPlanet data files use UTF-8 character encoding. The software you use to read these files must support this encoding.

    Place names in the places file are in the language local to the country containing the place. You can find place names in other languages in the aliases file. Some places may not have aliases in some languages (such as WOEID 28628569); in such cases you should use the primary place name. You should plan to import place names from both files if you want to support a specific language. The WOEID of a place may be used as a key into both files.

    Eddie Babcock
    Yahoo! Geo Technologies
    0
  • QUOTE (Eddie B @ May 11 2010, 10:36 AM) <{POST_SNAPBACK}>
    The GeoPlanet data files use UTF-8 character encoding. The software you use to read these files must support this encoding.

    Place names in the places file are in the language local to the country containing the place. You can find place names in other languages in the aliases file. Some places may not have aliases in some languages (such as WOEID 28628569); in such cases you should use the primary place name. You should plan to import place names from both files if you want to support a specific language. The WOEID of a place may be used as a key into both files.

    Eddie Babcock
    Yahoo! Geo Technologies


    Thanks for your advice Eddie. When you say 'primary place name' , did you mean the one that is present in the places.tsv ( with the UTF-8 character encoding ) ?
    0
  • QUOTE (Chandra Sekhar @ May 13 2010, 08:39 AM) <{POST_SNAPBACK}>
    Thanks for your advice Eddie. When you say 'primary place name' , did you mean the one that is present in the places.tsv ( with the UTF-8 character encoding ) ?


    Yes. The places.tsv file contains the primary place name. The aliases.tsv file contains other place names for the the place.

    Eddie Babcock
    Yahoo! Geo Technologies
    0
  • which database are you using?
    0
  • QUOTE (smnirven @ May 16 2010, 09:39 PM) <{POST_SNAPBACK}>
    which database are you using?

    MySQL Server database
    0
This forum is locked.

Recent Posts

in GeoPlanet Enhancement Requests