Dashboard

Overview of all data

—
Uploaded files
—
Uploaded rows
—
Rows in engine
—
SQL committed
—
SQL pending
—
Polygon columns
Emergency tool: confirm pending rows
If the map still shows 0 properties after uploading files, click here to force-confirm any rows waiting in SQL.
Browser cache looks stale?
If numbers look wrong after uploading, clear local storage, IndexedDB and reload with a fresh cache key.

Coverage gaps — what to upload next

Two complementary lists. Upload the polygon for the first one; upload the data for the second one. Both lists refresh automatically after every upload and after “Re-run exact match”.

Subdivisions in the data with NO polygon

These names appear in the uploaded rows but no polygon carries them → upload the polygon in Area Metrics.

Loading…

SubdivisionZIPRowsWhy

Polygons with NO data

These polygons exist in the boundary file but no uploaded data falls inside them → upload the CSVs that cover them.

Loading…

PolygonZIPRows

Rows by dataset year

YearRowsCommittedPending
i
What “Current (no date)” means
The 9,832 “undated” rental rows are the three Current Rent files (3,320 + 2,447 + 4,065 = 9,832). They are active rentals, so they have no lease date yet. No historical rent file contributes a single row to year 0.

Why you see that number when you click the row:
1. The Year column shows dataset_year. An active rental has no lease date, so its year is 0 — displayed as “Current (no date)”.
2. The old Rent section counted every rent row, including Current, so those 9,832 rows appeared inside Rent. The rows were always fine; the bucket they were counted in was misleading.

How it is fixed — step by step:
1. The importer now files every row under the year of the file it came from. Only Current files use year 0, so a row without a date can never fall into 2025 or 2026 by accident.
2. The Rent section now counts only dataset_year > 0: 2021–2026, with no “undated” row.
3. Current Listings → Rent counts dataset_year = 0: the 9,832 active rentals, labelled “Current (no date)”.
4. Restart the app so the new code and labels load.
5. When you re-upload the Current files they will always land in the Current bucket — never in 2025/2026.

Do those rows still show on the map? Yes. Current rentals are part of the map dataset and are counted whenever the period is “All data”. They are not counted inside a specific calendar year (2025, 2026, …) because they have no year. Nothing was deleted or hidden.

Polygon assignment

Coverage gaps are listed at the top of the Dashboard in “Coverage gaps — what to upload next”.

Pending upload sessions