Track projects rather than records

Choose the unit of observation before combining sources. A permit can cover a building, units or a particular scope of work, and revisions may produce multiple records for the same project. Track an enduring project identifier, address and phase. Distinguish new residential units from renovations. Keep announced, entitled, permitted, under-construction and completed projects in separate fields rather than presenting every record as equally likely to deliver.

Follow a project through its stages

For a fictional site evaluation, follow a neighboring apartment proposal from its initial announcement to visible construction and verified occupancy authorization. Update the same register entry as its status changes. Create an earlier-delivery and a delayed-delivery scenario, then place both against your leasing window. If a project has separate phases, assign each its own timing without duplicating the overall unit count. Document the evidence behind every status change.

Preserve delivery uncertainty

Administrative records can lag field conditions, and a completion measure may differ from units ready for immediate occupancy. Financing, utilities and inspections can disrupt timing even after construction begins. Do not attach invented delivery probabilities to uncertain stages. Continue with the competing-supply register guide to turn pipeline observations into a dated, traceable inventory that can be refreshed without silently changing its definitions between monthly reviews.

General information—not personalized legal, tax, investment, engineering or architectural advice.