Countries & Cities

kaaleth · Post time: 2014-05-14 20:25

Here, we can start discussion about new feature that appeared out from 329 revision.

vot · Post time: 2014-05-15 13:53

Current Location Database (International) Status:

Level 1 = Countries - DONE.
Level 2 = States/Provinces/Regions - DONE.
Level 3 = Cities/counties inside provinces/states - YET NOT READY. (Only China is ready 100%!)

Dear friends, your help appreciated!

We need to add all the third-level subdivisions! I.e. cities, counties etc.

Just add your cities into your country/provinces from your AdminCP.

USAGE (How to use):

1) PREREQUISITES:

You MUST have already imported the district files from the /install/data/ folder:
common_district_1.sql
common_district_2.sql
common_district_3.sql

2) Import the common_district_4.sql for setup all the countries

3) Import the common_district_5.sql for setup all the country subdivisions

P.S.
The job is not finished yet!
You can help with this job too!
Just verify the data, correct mistakes, add new deeper subdivisions and publish your job here.

Attention:
for this stage we are working with ENGLISH version only!!! ENGLISH NAMES ONLY!

HOW TO ADD NEW CITIES:

1) If required, you can GET your country provinces/states from the STATOIDS.COM site.
In most of cases YOUR COUNTRY 2-level subdivisions placed in the page:
//statoids.com/u##.html
where "##" is the code of your country.
I.e.
http://statoids.com/uin.html = States of India
http://statoids.com/uir.html = Provinces of Iran
http://statoids.com/upl.html = Voivodships of Poland
etc.

1) GET your cities from the STATOIDS.COM site.
In most of cases YOUR COUNTRY 3-level subdivisions placed in the page:
//statoids.com/y##.html
where "##" is the code of your country.
I.e.
http://statoids.com/yin.html = Districts of India
http://statoids.com/yir.html = Counties of Iran
http://statoids.com/ypl.html = Counties of Poland
etc.

Pay attention to the code:
We need the "HASC" location code!!!
I.e. For Iran:
Abadan county = IR.KZ.AB

Here: IR = Iran, KZ = Khuzestan
So the code for Abadan will be "AB".

2) Go to AdminCP -> Global -> Regions,
and add new cities into your Country/Province manually...

OR as an alternative,
you can prepare a SQL patch for your cities in the next format:

-- Country "AA", Province "BB"
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, BB_ProvinceID, 3, 'XX', 'City 1'),
(3, BB_ProvinceID, 3, 'YY', 'City 2'),
(3, BB_ProvinceID, 3, 'ZZ', 'City 3');

Where "BB_ProvinceID" is a real numeric ID of the province with the code "BB" in our database, i.e.
ID for "US/AL = USA/Alabama" = 81301,
ID for "China / Fujian Province" = 13.

"XX, YY, ZZ" - It is a HASC Code of your cities/counties.

vot · Post time: 2014-05-15 16:36

I have prepared a real 3-level locations for "Abkhazia",
that can be a good sample of city SQL patch:

-- 'AB.GG', 'Abkhazia/Gagra', 48001
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48001, 3, 'AL', 'Alakhadzi'),
(3, 48001, 3, 'AM', 'Amzara'),
(3, 48001, 3, 'BR', 'Baghripsh'),
(3, 48001, 3, 'BZ', 'Bzyb'),
(3, 48001, 3, 'GC', 'Gagra city'),
(3, 48001, 3, 'GR', 'Gyachripsh'),
(3, 48001, 3, 'KS', 'Khashupse'),
(3, 48001, 3, 'KY', 'Khyshkha (Bagnary)'),
(3, 48001, 3, 'LA', 'Lapstarkha'),
(3, 48001, 3, 'LZ', 'Ldzaa'),
(3, 48001, 3, 'LC', 'Leselidze city'),
(3, 48001, 3, 'MD', 'Mekhadiri'),
(3, 48001, 3, 'MR', 'Mikelrypsh'),
(3, 48001, 3, 'PI', 'Pitsunda city'),
(3, 48001, 3, 'PH', 'Psakhara'),
(3, 48001, 3, 'PS', 'Psou (village)'),
(3, 48001, 3, 'TR', 'Tsandripsh');
-- 'AB.GD', 'Abkhazia/Gudauta', 48002
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48002, 3, 'AA', 'Aatsy'),
(3, 48002, 3, 'AH', 'Abgarkhook'),
(3, 48002, 3, 'AD', 'Achandara'),
(3, 48002, 3, 'AM', 'Amghikukhua'),
(3, 48002, 3, 'AN', 'Ankhva'),
(3, 48002, 3, 'BA', 'Barmysh'),
(3, 48002, 3, 'BL', 'Blabyrkhua'),
(3, 48002, 3, 'DH', 'Dzhirhua'),
(3, 48002, 3, 'DR', 'Durypsh'),
(3, 48002, 3, 'KL', 'Kaldakhuara'),
(3, 48002, 3, 'KU', 'Khuap'),
(3, 48002, 3, 'KY', 'Khypsta'),
(3, 48002, 3, 'KN', 'Kulanyrkhua'),
(3, 48002, 3, 'LY', 'Lykhny'),
(3, 48002, 3, 'MG', 'Mgudzyrhua'),
(3, 48002, 3, 'MT', 'Mtsara'),
(3, 48002, 3, 'MU', 'Myussera'),
(3, 48002, 3, 'NA', 'New Athos city'),
(3, 48002, 3, 'PS', 'Psyrdzkha'),
(3, 48002, 3, 'TS', 'Tskuara'),
(3, 48002, 3, 'UA', 'Uathara'),
(3, 48002, 3, 'ZV', 'Zhvandripsh');
-- 'AB.SH', 'Abkhazia/Sukhum', 48003
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48003, 3, 'AK', 'Akapa'),
(3, 48003, 3, 'BA', 'Baslata'),
(3, 48003, 3, 'DZ', 'Dzyguta'),
(3, 48003, 3, 'ES', 'Eshera'),
(3, 48003, 3, 'EU', 'Eshera Upper'),
(3, 48003, 3, 'GU', 'Guma'),
(3, 48003, 3, 'GI', 'Gumista'),
(3, 48003, 3, 'PU', 'Pskhu'),
(3, 48003, 3, 'SU', 'Sukhum city'),
(3, 48003, 3, 'YA', 'Yashthua');
-- 'AB.GR', 'Abkhazia/Gulripsh', 48004
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48004, 3, 'AZ', 'Azhara'),
(3, 48004, 3, 'BA', 'Babushara'),
(3, 48004, 3, 'BG', 'Bagmaran'),
(3, 48004, 3, 'DR', 'Dranda'),
(3, 48004, 3, 'GC', 'Gulripsh city'),
(3, 48004, 3, 'KK', 'Katsikyt'),
(3, 48004, 3, 'MC', 'Machara'),
(3, 48004, 3, 'MR', 'Markhyaul'),
(3, 48004, 3, 'PS', 'Pshap'),
(3, 48004, 3, 'TB', 'Tsebelda');
-- 'AB.OC', 'Abkhazia/Ochamchira', 48005
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48005, 3, 'AD', 'Adzyubzha'),
(3, 48005, 3, 'AK', 'Akuaskia'),
(3, 48005, 3, 'AD', 'Aradu'),
(3, 48005, 3, 'AK', 'Arakich'),
(3, 48005, 3, 'AS', 'Arasadzykh'),
(3, 48005, 3, 'AT', 'Atara'),
(3, 48005, 3, 'AA', 'Atara Armenian'),
(3, 48005, 3, 'AG', 'Achguara'),
(3, 48005, 3, 'BL', 'Baslakhu'),
(3, 48005, 3, 'CH', 'Chlou'),
(3, 48005, 3, 'GD', 'Gudava'),
(3, 48005, 3, 'GU', 'Guup'),
(3, 48005, 3, 'GA', 'Guada'),
(3, 48005, 3, 'DG', 'Dzhgerda'),
(3, 48005, 3, 'IL', 'Ilori'),
(3, 48005, 3, 'KD', 'Kyndyg'),
(3, 48005, 3, 'KO', 'Kochara'),
(3, 48005, 3, 'KU', 'Kutol'),
(3, 48005, 3, 'LA', 'Labra'),
(3, 48005, 3, 'ME', 'Merkula'),
(3, 48005, 3, 'MO', 'Mokva'),
(3, 48005, 3, 'OC', 'Ochamchira city'),
(3, 48005, 3, 'OT', 'Otap');
(3, 48005, 3, 'OH', 'Okhurey'),
(3, 48005, 3, 'PA', 'Pakuash'),
(3, 48005, 3, 'RE', 'Reka'),
(3, 48005, 3, 'TA', 'Tamysh'),
(3, 48005, 3, 'TH', 'Tkhina'),
(3, 48005, 3, 'SH', 'Shashalat');
-- 'AB.TQ', 'Abkhazia/Tquarchal', 48006
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48006, 3, 'AG', 'Agubedia'),
(3, 48006, 3, 'B1', 'Bedia First'),
(3, 48006, 3, 'BE', 'Bedia (village)'),
(3, 48006, 3, 'CH', 'Chuartal'),
(3, 48006, 3, 'GU', 'Gumrysh'),
(3, 48006, 3, 'MH', 'Makhur'),
(3, 48006, 3, 'OK', 'Okum'),
(3, 48006, 3, 'G1', 'Gal First'),
(3, 48006, 3, 'RC', 'Rechkhu'),
(3, 48006, 3, 'TQ', 'Tquarchal city'),
(3, 48006, 3, 'TS', 'Tsarcha');
-- 'AB.GL', 'Abkhazia/Gali', 48007
INSERT INTO `pre_common_district`
(`level`, `upid`, `usetype`, `code`, `name`) VALUES
(3, 48007, 3, 'AL', 'Alakumkhara (Lekukhona)'),
(3, 48007, 3, 'BL', 'Barghebi Lower'),
(3, 48007, 3, 'BU', 'Barghebi Upper'),
(3, 48007, 3, 'CH', 'Chuburkhindzhi'),
(3, 48007, 3, 'DH', 'Dikhazurga'),
(3, 48007, 3, 'GD', 'Gagida'),
(3, 48007, 3, 'GC', 'Gal city'),
(3, 48007, 3, 'GN', 'Ganakhleba (Marchkhapon)'),
(3, 48007, 3, 'MH', 'Makhundzhia'),
(3, 48007, 3, 'MB', 'Nabakevi'),
(3, 48007, 3, 'O1', 'Otobaya First'),
(3, 48007, 3, 'O2', 'Otobaya Second'),
(3, 48007, 3, 'PP', 'Papynrhua (Saberio)'),
(3, 48007, 3, 'PC', 'Pichori'),
(3, 48007, 3, 'PR', 'Primorsk'),
(3, 48007, 3, 'RY', 'Ryap (Repo Etsery)'),
(3, 48007, 3, 'SD', 'Sida'),
(3, 48007, 3, 'TG', 'Taglan'),
(3, 48007, 3, 'SV', 'Shashikvara');

Copy the Code

Account		Remember me	Forgot password?
Password			Register