Nine pipelines. One living database.
Every number on HomeRadar is produced by an automated pipeline pulling from an official source on a schedule — with delta detection, validation gates and full run history. This page is that machinery, live. Nothing here is entered by hand.
Source → pipeline → table
Particle speed mirrors each pipeline’s cadence — weekly streams move fast, yearly ones crawl. Dashed edges are enrichments written back onto existing tables.
The pipelines
Every private-condo sale transaction, four batches per run. Only projects with new transactions are reprocessed.
projects (3,015) · transactions (138,775) · psf_by_year (12,679)
Rental contracts and quarterly medians — the source of bedroom counts and every yield figure.
rental_contracts (381,868) · rental_median (6,887) · rental_by_bedroom (4,862)
The full HDB resale archive, incremental by month — powers premium-vs-HDB and the million-dollar tracker.
hdb_transactions (234,856)
The private residential development pipeline — future supply pressure per district.
pipeline_projects (76)
Ten amenity themes plus schools: hawkers, parks, gyms, clinics, libraries and more.
amenities (3,213) · schools (312)
MRT stations — operational lines and announced future lines — plus building records for age and unit counts.
mrt_stations (183) · mrt_station_operational (165) · mrt_station_future (39)
URA Master Plan 2025 land-use polygons — 113K zones, a 180 MB GeoJSON, parsed only when the plan changes.
zoning_polygons (113,394)
Singapore's 55 planning-area boundaries — the spatial join key between private and public housing data.
planning_areas (55)
Median household income per planning area from the census — the affluence layer.
area_income (31)
Recent runs
| Pipeline | Status | When | Duration | Rows in | Skipped |
|---|---|---|---|---|---|
| ura-transactions | success | 54m ago | 23s | 2,981 | 0 |
| ura-transactions | running | 1h ago | — | 0 | 0 |
| ura-transactions | running | 2h ago | — | 0 | 0 |
| ura-transactions | running | 2h ago | — | 0 | 0 |
| ura-supply | skipped | 3h ago | 1s | 0 | 0 |
| hdb-resale | success | 4h ago | 6.4m | 0 | 937 |
| rentals | success | 5h ago | 4.2m | 0 | 34,829 |
| ura-transactions | running | 6h ago | — | 0 | 0 |
| hdb-resale | success | 7h ago | 141.1m | 0 | 235,247 |
| hdb-resale | failed | 7h ago | 9.8m | 0 | 0 |
| rentals | success | 7h ago | 4.2m | 12,662 | 41,929 |
| ura-transactions | running | 7h ago | — | 0 | 0 |
Snapshot refreshes every 15 minutes. “Skipped” rows were already present — delta detection at work.
This engine feeds the map
All 900,410 rows, cross-referenced spatially and queryable in plain English on a photorealistic 3D map of Singapore.
Explore the map — free