Hong Kong Property Neighbourhoods
Per-neighbourhood (HMA) volumes, buildings and geo
hk_property_neighbourhoods
- 行數
- 175
- 涵蓋期間
- 2026年8月至2026年10月
- 欄位數目
- 11
- 最新數據
- 2026年10月18日
樣本
顯示 8 行Every neighbourhood, full schema, no row cap. The table is small enough to ship in full.
| hma_id | hma_zh | hma_en | district_code | region_zh | transaction_count | building_count | latitude | longitude | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|
| HMA001 | 九肚山 | Kau To Shan | R | 新界東 | 12289 | 552 | 22.411317825317383 | 114.20303344726562 | 2026-10-18 11:13:58 | HMA001 |
| HMA002 | 九龍城 | Kowloon City | G | 九龍 | 21816 | 386 | 22.330095291137695 | 114.18981170654297 | 2026-10-18 11:13:58 | HMA002 |
| HMA003 | 九龍站 | Kowloon Station | E | 九龍 | 60746 | 49 | 22.306381225585938 | 114.1602554321289 | 2026-10-18 11:13:58 | HMA003 |
| HMA004 | 九龍塘 | Kowloon Tong | G | 九龍 | 28688 | 465 | 22.335466384887695 | 114.18060302734375 | 2026-10-18 05:13:42 | HMA004 |
| HMA005 | 九龍灣 | Kowloon Bay | J | 九龍 | 140747 | 102 | 22.324743270874023 | 114.209228515625 | 2026-10-18 11:13:58 | HMA005 |
| HMA006 | 八鄉北 | Pat Heung North | M | 新界西 | 1241 | 372 | 22.448087692260742 | 114.09092712402344 | 2026-10-12 02:13:53 | HMA006 |
| HMA007 | 八鄉南 | Pat Heung South | M | 新界西 | 549 | 220 | 22.424097061157227 | 114.08792877197266 | 2026-09-09 23:06:56 | HMA007 |
| HMA008 | 元朗東南 | Yuen Long Southeast | M | 新界西 | 38922 | 145 | 22.44076919555664 | 114.0444564819336 | 2026-10-18 11:13:58 | HMA008 |
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| hma_id | text | Centaline neighbourhood id (HMA###) — primary identifier |
| hma_zh | text | Neighbourhood name in Chinese (e.g. 上環) |
| hma_en | text | Neighbourhood name in English where Centaline supplies one (most do not have one; use hma_zh) |
| district_code | text | Parent official district code (A..T; Centaline sub-areas U/V folded to Q/S) — links to hk_property_districts |
| region_zh | text | Region/territory in Chinese |
| transaction_count | number | Registered sales (1995+) with a known neighbourhood scope attributed to this HMA |
| building_count | number | Number of buildings located in this neighbourhood |
| latitude | number | Latitude (WGS84): autocomplete point, else the mean of the neighbourhood's buildings |
| longitude | number | Longitude (WGS84): autocomplete point, else the mean of the neighbourhood's buildings |
| updated_at | date and time | When a registered sale in this neighbourhood was last observed in Centaline's transaction feed (UTC) — the neighbourhood's freshness, not an event date |
| id | text | Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (hma_id) are unchanged. |
查詢數據
每個數據表均可透過 Renavon 帳戶,以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hk_property_neighbourhoods LIMIT 10
需要本站以外的資料?
超出預昇公開範圍的香港物業成交紀錄,可應公司及專業人士要求提供。 請說明你的需要,我們會以電郵回覆。
多謝 — 你的查詢已提交,我們會以電郵回覆。
暫時無法提交 — 請稍後再試。