Please select To the mobile version | Continue to access the desktop computer version
| |
| | |

CodersClub

 Forgot password?
 Register
Search
View: 17308|Reply: 20
Collapse the left

common_district translation

[Copy link]

 Russia

Post time: 2011-08-16 09:04
| Show all posts |Read mode
The /install/data/common_district_*.sql files contains the China Province/District/City/Village info.
This files are translated by Google translator, and works ok, but the translation quality is too bad
It would be nice if anybody Chinese native speaking can help me to beautify this translation.
You are welcome!

 China

Post time: 2011-08-17 15:29
| Show all posts
I wonder if can make the area with global information not just China.

Comments

+1  Post time 2012-02-05 13:59
+1  Post time 2011-11-03 18:04

 Russia

 Author| Post time: 2011-08-17 20:49
| Show all posts
mohoko replied at 2011-8-17 15:29
I wonder if can make the area with global information not just China.

No problems.
Everybody can do it by himself from Admin-Center.

Moreover, it is available to make a special universal update for country/region data.
For do this. we have to increase to 1 all the the levels in current table,
then create China country record with level=0, and attach to it all the up-level China provinces.
After this change all other countries level to 0.
... and add what you want to any country...


 Russia

 Author| Post time: 2011-11-03 16:00
| Show all posts
make the area with global information not just China.

Working on this...

 China

Post time: 2011-11-07 15:09
| Show all posts
vot replied at 2011-11-3 21:00
Working on this...

humm, that's great, when it may be done?

 Russia

 Author| Post time: 2011-11-07 15:48
| Show all posts
Idea - make an international regional database with countries/states/cities/villages.

I think to solve this task in a few steps:

1)  Create new database with the same strucrure as in original common_district structure [DONE].
2) Add an official country list with ISO 3166-1 [DONE].
3) Add an official international region list with FIPS 10-4 [DONE].
4) Change the region/state code for US and CA with ISO-3166-2 [DONE].
5) Add the world city list.
6) Separate the regions database for use separate country/region/city names for each language installed.
7) Add Geo location for all the records in a database (for show in a Google Maps).
8) Add IP address ranges mapped to the country list.
9) Add Geo Location for each member profile (for show in a Google Maps).

 Russia

 Author| Post time: 2011-11-09 08:48
| Show all posts
5) Add the world city list. - DONE.
But some problems encountered.

The city list that I had found at maxmind.com have only 3 levels (Country/State/City),
but the real country administrative division is more complex and often have FOUR levels.

Moreover, the maxmind world city database have a lot of errors:
- non-ASCII city names
- duplicated city names in the same region
- mapping cities to nonexistent region code
- mapping cities to nonexistent countries
- mapping cities to invalid country/region
- etc.

This is bad
Trying to solve all this problems....

If anybody knows another ready to use database with Country/State/City/Village,
tell me please!!



 Russia

Post time: 2011-11-09 11:18
| Show all posts
сообщение promo изменено 2011-11-9 12:23
добавил vot в 2011-11-9 09:48
5) Add the world city list. - DONE.
But some problems encountered.

Не знаю, как по всему миру, но я видел базы городов России, Украины и Беларуси, объединенные...
А с другой стороны - если твой проект ориентирован на русскоговорящего пользователя+англоговорящего, по трафику ты видишь откуда к тебе заходят и какие страны проявляют интерес, ничего не мешает добавить просто эти страны и города, а для остальных создать "Другой город"...

Нашел его, вот он

По крайней мере, можно будет взять страны-города РФ, Украины и Беларуси.
Ну, а по всем остальным странам - исправить или писать название в оригинале.

This post contains more resources

You have to Login for download or view attachment(s). No Account? Register

x

 Russia

 Author| Post time: 2011-11-09 12:35
| Show all posts
если твой проект ориентирован на русскоговорящего пользователя+англоговорящего

А что тогда делать с вьетнамцами, арабами и латиносами?
Я добавлял только те языки, для которых есть заинтересованные и уже сделавшие свои языковые сборки.

можно будет взять страны-города РФ, Украины и Беларуси.
Ну, можно конечно...
Только мне лично нафиг не сдалось РУЧКАМИ формировать огромные базы.
Лучше уж найти общепризнанные и поддерживаемые международные базы, и сконвертировать их в наш формат, чем каждый раз колупать руками миллионы записей в базе.
А если ещё учесть, что планируется МУЛЬТИЯЗЫЧНАЯ поддержка регионов, то это лучше вообще сразу застрелиться!

 Russia

 Author| Post time: 2011-11-09 18:08
| Show all posts
I have found another release of world cities database:
http://geonames.org/

This database is more complex and have more levels for administrative divisions.

Now checking, if this can be usefull for us...
You have to log in before you can reply Login | Register

Points Rules

Archive|Mobile|Dark room|CodersClub

Top.Mail.Ru
Top.Mail.Ru

2024-03-29 02:31 GMT+3 , Processed in 0.105500 sec., 9 queries .

Powered by Discuz! X3.4 Release 20230520

© 2001-2024 Discuz! Team.

MultiLingual version, Rev. 4301, © codersclub.org

Quick Reply To Top Return to the list