Hong Kong Points of Interest (multi-source)

Hong Kong amenities with category, bilingual names and coordinates

hk_property_poi

Rows: 32,290
Coverage: October 2026 to October 2026
Columns: 12
Latest data: 2026-10-18

Sample

8 rows shown

Points of interest in equal shares from each of the seven amenity categories, full schema.

Hong Kong Points of Interest (multi-source): Sample
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

Download sample (CSV) Download sample (Excel)

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us.

Columns

Hong Kong Points of Interest (multi-source): Columns
Column	Type	Description
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.

Query it

Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.

SELECT * FROM renavon_exports.hk_property_poi LIMIT 10

Get a key on renavon.com (opens in new tab)

Need more than the site shows?

Hong Kong property transaction history beyond what crescira.com publishes is available to firms and professionals on request. Describe what you need and we reply by email.