Hong Kong Points of Interest (multi-source)
Hong Kong amenities with category, bilingual names and coordinates
hk_property_poi
- 行數
- 32,290
- 涵蓋期間
- 2026年10月至2026年10月
- 欄位數目
- 12
- 最新數據
- 2026年10月18日
樣本
顯示 8 行Points of interest in equal shares from each of the seven amenity categories, full schema.
| category | sub_type | name_en | name_zh | latitude | longitude | address_en | address_zh | source | source_id | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Daily convenience | mall | THE CUBE | 荃立方 | 22.371149 | 114.116787 | — | — | centaline | AAPPBDPXPG | 2026-10-18 20:19:09 | bffe8e04a2c8a9e647ac6cdef169a44d |
| Daily convenience | mall | ALLWAY GARDEN SHOPPING CENTRE PHASE 2 | 荃威花園商場二期 | 22.378608999999997 | 114.10461600000001 | — | — | centaline | AAPPBKPXPG | 2026-10-18 20:19:09 | eed76e2b12e172a144178433bebf8419 |
| Daily convenience | mall | TSUEN WAN CENTRE PHASE I SHOPPING CENTRE | 荃灣中心一期購物商場 | 22.378265 | 114.107246 | — | — | centaline | AEPPBAPXPA | 2026-10-18 20:19:09 | 04285d029fec6a3bd5a8c5327decdaa7 |
| Daily convenience | mall | BELVEDERE SQUARE PHASE 3 | 麗城薈三期 | 22.371411 | 114.101714 | — | — | centaline | AEPPBBPXPA | 2026-10-18 20:19:09 | 118e7b48b82ad4ee7a59d2b957415ad6 |
| Daily convenience | mall | CHO YIU CENTRE | 祖堯坊 | 22.346252 | 114.128532 | — | — | centaline | AEPPBBPXPY | 2026-10-18 20:19:09 | 3729b4e6277912ff927ba16919804d30 |
| Daily convenience | mall | SHEK YAM SHOPPING CENTRE | 石蔭商場 | 22.366868999999998 | 114.138441 | — | — | centaline | AEPPBDPXPD | 2026-10-18 20:19:09 | e4938c47e99dc335561bb0366085be42 |
| Daily convenience | mall | DISCOVERY PARK SHOPPING CENTRE | 愉景新城商場 | 22.376441 | 114.11099300000001 | — | — | centaline | AEPPBEPXPA | 2026-10-18 20:19:09 | db922368c978dca1ffbccabf44b9a3ee |
| Daily convenience | mall | METROPLAZA | 新都會廣場 | 22.357557999999997 | 114.126726 | — | — | centaline | AEPPBEPXPG | 2026-10-18 20:19:09 | c5466ede016087e9da63b4a35db384d4 |
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| category | text | Amenity category. One of: Transport, Parking, Daily convenience, Food & drink, Health, Education, Recreation |
| sub_type | text | Finer amenity type on the shared internal taxonomy (mtr, mtr_entrance, bus, ferry, carpark, mall, convenience_store, supermarket, market, restaurant, cooked_food_stall, hospital, clinic, school, kindergarten, park, open_space, playground, library, sports, beach, cinema; grows additively as gov feeds land). mtr = stations, mtr_entrance = station entrances (different proximity grain, kept distinct). |
| name_en | text | English POI name (NULL when the source carries none) |
| name_zh | text | Traditional-Chinese POI name (NULL when the source carries none) |
| latitude | number | WGS84 latitude, decimal degrees (Hong Kong sits within 22.1–22.6) |
| longitude | number | WGS84 longitude, decimal degrees (Hong Kong sits within 113.8–114.5) |
| address_en | text | English street address of the amenity, where the source carries one (iGeoCom for most gov amenities, FEHD for restaurants, Centaline for schools). NULL when the source has no address — the per-feed CSV gov files (hospitals, sports centres, parks, libraries, ferry piers) carry none. |
| address_zh | text | Traditional-Chinese street address of the amenity, where the source carries one (iGeoCom, FEHD). NULL otherwise. |
| source | text | Which source supplied this point: 'centaline' (property-portal amenity graph), 'govhk' (Hospital Authority, LCSD, public libraries, Transport Department), 'govhk_fehd' (FEHD restaurant-licence register) or 'govhk_igeocom' (Lands Department iGeoCom GeoCommunity Database) |
| source_id | text | The point's id within its source — the source's own key where it has one (e.g. a ferry stop id, an iGeoCom GEONAMEID), else an id that stays stable across rebuilds. Unique within source |
| updated_at | date and time | Pipeline build timestamp (UTC): when this point-of-interest snapshot was last assembled, not when the amenity changed |
| 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 (source and source_id) are unchanged. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.hk_property_poi LIMIT 10需要本站以外的資料？
超出預昇公開範圍的香港物業成交紀錄，可應公司及專業人士要求提供。 請說明你的需要，我們會以電郵回覆。
多謝 — 你的查詢已提交，我們會以電郵回覆。
暫時無法提交 — 請稍後再試。