How Red Deer Condos builds its aggregate data.
The site turns an approved local CSV export into public-safe aggregate intelligence while avoiding individual listing display.
Import rules
- Rows are parsed locally from data/imports/matrix-condos.csv.
- Unit numbers are stripped from address strings to form building-address clusters.
- Medians are used for prices, condo fees, and sizes because condo data often contains outliers.
- Status counts use Matrix status fields such as A, P, and S when present.
- Public pages show aggregate observations only; they do not show individual listing rows, MLS numbers, public remarks, confidential remarks, agent or seller details, or listing photos.
How to interpret the output
- A row count measures sample depth, not data quality by itself.
- A building median describes observed rows grouped to an address pattern, not every unit in the building.
- A civic match adds public context; it does not certify condition, accessibility, or ownership rights.
- A review status means the next refresh needs human or source verification before the claim is strengthened.
Current data file
2,962 rows imported from data\imports\matrix-condos.csv. Date range 2008-08-04 to 2026-07-08.
Review before publishing. Market data through Jul 8, 2026; 8 civic source alerts; 29 permit clusters in review.
Open import workflowHow much of the import contains each field?
Coverage measures whether a usable value was present before aggregation. It does not independently verify the source value.
| Field | Rows with usable values | Coverage |
|---|---|---|
| Stat date | 2,962 | 100% |
| Address | 2,962 | 100% |
| Price | 2,962 | 100% |
| Condo fee | 2,961 | 100% |
| Tax amount | 2,960 | 100% |
| Size | 2,959 | 100% |
| DOM | 2,962 | 100% |
Refresh cadence
Public data changes when an approved Matrix export and the civic source refreshes have been reviewed. The site should never imply continuous live inventory when the underlying snapshot is dated.
Aggregate boundary
Unit numbers are stripped from building-address patterns. Individual listing rows, MLS numbers, remarks, photos, and confidential details are intentionally withheld from the public catalogue.
Correction path
When a source field looks wrong, the fix belongs in the import or enrichment workflow first. The public page is rebuilt only after the generated reports are reviewed.