SGP Places V1

Singapore places dataset · Generated 2026-04-23 · Source: sgp_place_V1.jsonl (58 MB)

1. Executive summary

190,591

Records

deduped, lat/lon clean

250

Brands

14,612 branded records

166

2. Schema (12 flat fields)

# Identifier id : 12-char alphanumeric (deterministic from name+coords) # Naming name : cleaned (emoji-free, "Pte. Ltd." canonicalized) alt_name : alternate name (e.g., Chinese variant) # Location (must-haves; all verified) latitude : float, inside SG bbox (1.15–1.48), ≥4 dp longitude : float, inside SG bbox (103.59–104.10), ≥4 dp address : original address (87.5% have SG postal) # Classification (must-haves) brand : 1 of 220 SGP brands (or empty string) primary_category : 1 of 166 derived buckets # Engagement rating : 1.0–5.0, null if reviews_count = 0 reviews_count : int # Contact website : empty string if missing phone : raw scraped format

3. Pipeline

sgp_places_cleaned.jsonl192,454 rows · raw scrape

›

+ name cleanup+ 220 brand mappings

›

+ dedup− 235 chain duplicates

›

+ primary_category166 buckets

›

+ attribute fixesrating · coord · addr

›

sgp_place_V1.jsonl190,591 rows · 12 fields · 58 MB

4. Coverage

190,591

Total places

6,736

HDB blocks

Public housing

2,529

Condominiums

Private condos

211

Spatial bins

0.02° resolution

5. Quality metrics

Field completeness

Field	Present	Missing	Coverage
latitude / longitude	190,591	0	100.0%
address	178,506	12,085	93.7%
brand	14,612	175,979	7.7%
rating	109,400	81,191	57.4%
phone	127,622	62,969	67.0%
website	103,002	87,589	54.0%

Rating distribution

Stars	Records	Distribution
1.0	1,048	2.4%
1.5	464	1.1%
2.0	1,323	3.1%
2.5	2,394	5.6%
3.0	5,126	11.9%
3.5	8,436	19.7%
4.0	19,936	46.4%
4.5	27,746	64.6%
5.0	42,927	100.0%

Reviews count buckets

Bucket	Records
0	80,727
1-9	40,788
10-99	43,694
100-999	21,629
1000+	3,753

6. Top categories

Primary category	Records	Share
Other	27,155	14.2%
Uncategorized	11,656	6.1%
Restaurant	9,461	5.0%
HDB	6,736	3.5%
Tuition Centre	5,141	2.7%
Hawker Stall	4,824	2.5%
Construction	4,716	2.5%
Cafe	4,627	2.4%
Corporate Office	4,502	2.4%
Manufacturer	3,954	2.1%
Wholesale	3,541	1.9%
Logistics	3,387	1.8%
Consultant	3,253	1.7%
Software/IT	3,125	1.6%
Beauty Salon	2,983	1.6%
Parking Lot	2,687	1.4%
EV Charging	2,670	1.4%
Preschool	2,638	1.4%
Condominium	2,529	1.3%
Apparel	2,478	1.3%
Non-profit	2,408	1.3%
Medical Clinic	2,283	1.2%
Bus Stop	2,085	1.1%
Hair Salon	2,028	1.1%
Park	1,932	1.0%
Gym	1,858	1.0%
Bakery	1,825	1.0%
Car Workshop	1,727	0.9%
Playground	1,702	0.9%
Supermarket	1,588	0.8%

7. Top brands

Brand	Records
iJooz	924
DBS	560
SP Mobility Charging	511
POSB	490
AXS Station	486
CDG ENGIE Charging	478
7-Eleven	434
Charge+ Charging	402
PCF Sparkletots Preschool	372
Shell Recharge Charging	299
UOB	292
BlueSG	292
TotalEnergies Charging	278
Singapore Pools	228
NTUC FairPrice	227
SingPost	205
My First Skool	172
Edufarm Learning Centre	171
OCBC	166
McDonald's	156
Anytime Fitness	151
Star Tots Playgroup	151
Cheers	139
Pick Locker	138
Subway	136
DHL Express Service Point	135
Starbucks	128
MNL Asia Charging	122
Kimly	120
Guardian Health & Beauty	113
Volt Charging	101
Watsons	92
Marina Bay Sands	91
Sheng Siong	91
Singtel	86
Ya Kun Kaya Toast	86
MindChamps PreSchool	83
Swee Heng	78
SPX Express Locker	78
LHN Parking	77

8. Top brands per category

Validates brand assignment against expected SGP market reality.

Category	Total	Branded%	Top 5 brands
Cafe	4,627	12.6%	Starbucks (128) · Ya Kun Kaya Toast (86) · The Coffee Bean & Tea Leaf (74) · Toast Box (73) · Luckin Coffee (73)
Restaurant	9,461	4.7%	Saizeriya (43) · King of Fried Rice (32) · Tenderbest (32) · Sukiya (31) · Din Tai Fung (29)
Fast Food	851	79.7%	McDonald's (156) · Subway (136) · Burger King (71) · KFC (61) · Pizza Hut (58)
Bakery	1,825	25.7%	Swee Heng (78) · Old Chang Kee (68) · Munchi Pancakes (38) · Bengawan Solo (37) · BreadTalk (34)
Bubble Tea	626	59.7%	KOI Thé (74) · LiHO TEA (53) · itea (52) · Mr. Coconut (52) · Each a Cup (44)
Hawker Centre	218	0.0%	—
Food Court	766	5.5%	Koufu (42)
Hawker Stall	4,824	0.0%	—
Supermarket	1,588	30.2%	NTUC FairPrice (227) · Sheng Siong (91) · Giant (38) · Cold Storage (34) · Prime Supermarket (30)
Convenience Store	1,363	46.7%	7-Eleven (434) · Cheers (139) · Valu$ (64)
Pharmacy	515	40.4%	Guardian Health & Beauty (113) · Watsons (92) · Unity Pharmacy (3)
Department Store	194	17.0%	MUJI (18) · Mustafa Centre (15)
Bank	735	29.5%	UOB (55) · OCBC (44) · DBS (32) · POSB (28) · Maybank (20)
ATM	1,501	97.0%	DBS (528) · POSB (462) · UOB (237) · OCBC (122) · Citibank (72)
Hotel	907	28.1%	Marina Bay Sands (91) · Hotel 81 (27) · Pan Pacific (19) · ibis (19) · Shangri-La (14)
Hospital	267	64.4%	Singapore General Hospital (48) · Tan Tock Seng Hospital (30) · National University Hospital (27) · Sengkang General Hospital (9) · KK Women's and Children's Hospital (8)
Preschool	2,638	44.7%	PCF Sparkletots Preschool (372) · My First Skool (172) · Star Tots Playgroup (151) · MindChamps PreSchool (83) · M.Y World (60)
Tuition Centre	5,141	9.6%	Edufarm Learning Centre (171) · PlayFACTO School (68) · Kumon (49) · Zhengfei Cultural Education (47) · Cristofori Music School (36)
School	1,174	0.0%	—
Gym	1,858	11.1%	Anytime Fitness (151) · The Gym Pod (33) · Fitness First (14) · Virgin Active (6) · True Fitness (3)
Beauty Salon	2,983	3.3%	Kskin Korean Express Facial (41) · Venus Beauty (38) · Beauty Language (19)
Hair Salon	2,028	5.0%	kcuts (64) · Snip Avenue (19) · QB HOUSE (19)
Apparel	2,478	3.0%	UNIQLO (28) · Charles & Keith (24) · Bata (23)
Electronics Store	1,118	6.0%	Challenger (34) · Harvey Norman (18) · Best Denki (13) · COURTS (2)
EV Charging	2,670	96.9%	SP Mobility Charging (511) · CDG ENGIE Charging (478) · Charge+ Charging (402) · Shell Recharge Charging (299) · BlueSG (292)
Petrol Station	219	71.2%	Shell (57) · SPC (36) · Esso (35) · Caltex (28)
Vending Machine	1,030	93.7%	iJooz (924) · Ashui Vending Machine (21) · BaristaUno Coffee Vending (20)
Parcel Locker	312	90.1%	Pick Locker (138) · SPX Express Locker (78) · POPStation (39) · POPDrop (26)
Lottery Retailer	282	80.9%	Singapore Pools (228)
Pawnshop	196	67.9%	ValueMax (45) · Maxi-Cash (44) · MoneyMax Pawnshop (44)
Medical Clinic	2,283	7.1%	Raffles Medical (45) · Healthway Medical (44) · Minmed (29) · Pinnacle Family Clinic (18) · My Family Clinic (14)
Dental Clinic	498	6.6%	Q & M Dental Surgery (33)
TCM Clinic	517	4.8%	Ma Kuang TCM Clinic (25)

9. Reality check vs public counts

Threshold: ≥67% of public-known count = PASS. Sources marked as fetched (verified via web) or estimate (recall-based, lower confidence).

Fetched ground truth (high confidence)

Brand	Ours	Truth	Ratio	Verdict	Source
BlueSG	292	253	1.15x	PASS	eco-business.com — 253 stations
McDonald's	156	153	1.02x	PASS	shopsinsg.com / Statista
NTUC FairPrice	227	230	0.99x	PASS	fairpricegroup.com (supermarket-format)
Starbucks	128	130	0.98x	PASS	shopsinsg.com / starbucks.com.sg
7-Eleven	434	467	0.93x	PASS	shopsinsg.com
Watsons	92	99	0.93x	PASS	watsons.com.sg
Singapore Pools	228	295	0.77x	PASS	GRA list (incl. retailers)
POPStation	39	130	0.30x	FAIL	cheapandgood.sg / smartlocal

Estimated ground truth

Brand	Ours	Truth	Ratio	Verdict
Sheng Siong	91	75	1.21x	PASS
Ya Kun Kaya Toast	86	75	1.15x	PASS
Anytime Fitness	151	140	1.08x	PASS
My First Skool	172	160	1.07x	PASS
PCF Sparkletots Preschool	372	360	1.03x	PASS
Toast Box	73	75	0.97x	PASS
BreadTalk	34	35	0.97x	PASS
Guardian Health & Beauty	113	120	0.94x	PASS
Cheers	139	150	0.93x	PASS
iJooz	924	1,000	0.92x	PASS
Subway	136	150	0.91x	PASS
Burger King	71	80	0.89x	PASS
KFC	61	80	0.76x	PASS
Old Chang Kee	68	90	0.76x	PASS
Bengawan Solo	37	50	0.74x	PASS
Cold Storage	34	50	0.68x	PASS
Giant	38	60	0.63x	FAIL

10. Geographic distribution

Densest 0.02° geographic bins. Top concentrations in central / Marina / Orchard area, as expected.

Bin (lat, lon)	Records
(1.28, 103.84)	11,124
(1.30, 103.86)	11,112
(1.30, 103.84)	8,248
(1.32, 103.90)	7,064
(1.32, 103.88)	5,698
(1.32, 103.86)	5,296
(1.34, 103.90)	4,665
(1.34, 103.88)	4,120
(1.28, 103.82)	3,758
(1.36, 103.84)	3,499
(1.28, 103.86)	3,498
(1.44, 103.80)	3,442
(1.34, 103.74)	3,313
(1.34, 103.76)	3,258
(1.36, 103.88)	3,081

11. Sample records

One record per primary_category, showing the V1 schema.

id k72K2mpViMAX

name Marina Bay Sands Singapore

address 10 Bayfront Ave, Singapore 018956

latitude 1.2837575

longitude 103.8591065

brand Marina Bay Sands

primary_category Hotel

rating 4.7

reviews_count 63341

phone +65 6688 8868

website https://www.marinabaysands.com/?utm_source=google&utm_medium=GMB&utm_campaign=hotel_info_main

id h3WEp2joH7jJ

name iJooz Pure Fruit Juice

address 14 Nanyang Dr, Singapore 637332

latitude 1.3437598

longitude 103.683511

brand iJooz

primary_category Vending Machine

rating 5.0

reviews_count 2

phone +65 8778 9916

website https://www.ijooz.com/

id rhfOiAVuVxwi

name Anytime Fitness Bedok 85

address Blk 88 Bedok North Street 4, #01-163, Singapore 460088

latitude 1.3327966

longitude 103.9394538

brand Anytime Fitness

primary_category Gym

rating 4.9

reviews_count 1055

phone +65 8855 0203

website https://www.anytimefitness.sg/gyms/sg-0121/bedok-85-south-east-460088/

id miglFq3ny8W5

name My First Skool at Blk 229 Ang Mo Kio

address 229 Ang Mo Kio Ave 3, #01-1272 Block 229, Singapore 560229

latitude 1.369412

longitude 103.8380669

brand My First Skool

primary_category Preschool

rating 5.0

reviews_count 54

phone +65 6509 7887

website https://www.myfirstskool.com/?utm_medium=visit-website&utm_source=GMB-MK8&utm_campaign=Google&utm_term=website-button&utm_content=GMB

id JPx1XEs6HcTq

name Giant Supermarket

address 260 Kim Keat Ave, #01-01, Singapore 310260

latitude 1.3321429

longitude 103.8573398

brand Giant

primary_category Supermarket

rating 3.8

reviews_count 415

phone +65 6253 1074

website https://giant.sg/store/kim-keat-260

id PKU3rLdWbmsG

name Singapore Post - Punggol Branch

address 80 Punggol Fld, B1-01 Punggol 21 Community Club, Singapore 828815

latitude 1.3934754

longitude 103.9135381

brand SingPost

primary_category Post Office

rating 3.1

reviews_count 111

phone

website https://www.singpost.com/

12. Notes & caveats

Brand-vs-name override fix: When a record has a brand, the brand-derived category overrides any name-pattern match. So "LHN Parking - Khatib Polyclinic" is tagged as a Parking Lot, not a Polyclinic.
Bad-centroid records dropped: 1,567 records pinned to a fake centroid coord were removed. They had valid name/brand but no usable location.
Rating cleared when reviews_count = 0: Aggregate ratings without reviews were nulled to avoid misleading downstream consumers (26,448 records).
Hours and price_level not in dataset: The original scraper never captured these. Re-populating requires re-scraping.
POPStation undercount confirmed: 39 vs ~130 actual SingPost lockers. Lockers are systematically underlisted on Google Maps as POIs.
BlueSG matched stations not points: Initial 0.19x undercount was a unit mismatch — BlueSG has 253 stations × 1,000+ points; Google Maps lists stations.
Long tail in "Other": 14% of records remain in "Other" — the source has 3,039 unique Google categories; mapping covers the top ~85%.

Generated from sgp_place_V1.jsonl (190,591 rows, 250 brands, 166 primary categories). Pipeline scripts in /Users/sumanth/places/sgp-new/.