CiviCRM Community Forums (archive)

Hm, indeed our database is missing the 18 Hong Kong districts. I’ll add them to CiviCRM 1.8 and let you know how to add them to your database so it’ll work when you upgrade to CiviCRM 1.8.

I filed CRM-2125 to track this.

This seems to be the "official" order of the 18 districts
they (the hk government on their sites) divide them into 3 main categories (hong kong island, kowloon, and new territories) and then in each category the put them in alphabetical order
I have also added the Chinese characters for each don't know if this should be added here or into the translations for traditional Chinese
as far as abbreviations I don't think there are any, numbers 1-18 should be fine I cant seem to find a standard though


Central & Western District ( 中西區 )  CW
Eastern District ( 東區 )  EA
Southern District ( 南區 )  SO
Wan Chai District ( 灣仔區 )  WC

Kowloon City District ( 九龍城區 )  KC
Kwun Tong District ( 觀塘區 )  KU
Sham Shui Po District ( 深水埗區 )  SS
Wong Tai Sin District ( 黃大仙區 )  WT
Yau Tsim Mong District ( 油尖旺區 )  YT

Islands District ( 離島區 )  IS
Kwai Tsing District ( 葵青區 )  KI
North District ( 北區 )  NO
Sai Kung District ( 西貢區 )  SK
Sha Tin District ( 沙田區 )  ST
Tai Po District ( 大埔區 )  TP
Tsuen Wan District ( 荃灣區 )  TW
Tuen Mun District ( 屯門區 )  TM
Yuen Long District ( 元朗區 )  YL

Thanks. I added the districts to the database for 1.8 and to the 1.7-to-1.8 upgrade script.

For those who want to have these provinces now, please issue the following SQL command in your CiviCRM database:

INSERT IGNORE INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES
(5177, 1098, "CW", "Central and Western"),
(5178, 1098, "EA", "Eastern"),
(5179, 1098, "SO", "Southern"),
(5180, 1098, "WC", "Wan Chai"),
(5181, 1098, "KC", "Kowloon City"),
(5182, 1098, "KU", "Kwun Tong"),
(5183, 1098, "SS", "Sham Shui Po"),
(5184, 1098, "WT", "Wong Tai Sin"),
(5185, 1098, "YT", "Yau Tsim Mong"),
(5186, 1098, "IS", "Islands"),
(5187, 1098, "KI", "Kwai Tsing"),
(5188, 1098, "NO", "North"),
(5189, 1098, "SK", "Sai Kung"),
(5190, 1098, "ST", "Sha Tin"),
(5191, 1098, "TP", "Tai Po"),
(5192, 1098, "TW", "Tsuen Wan"),
(5193, 1098, "TM", "Tuen Mun"),
(5194, 1098, "YL", "Yuen Long");

(This way your install will have the same ids as our ‘official’ one, which is a Good Thing™ to have.)