David Mar
All projects

Storefront Register

Active

How long a storefront sits dark between tenants, block by block — SF against LA and Chicago.

analyticsdatacivic
90,710
Active tenancies (SF)
registered storefront locations
24.5%
Re-let within a year
CI 22.8–26.3%
83.6%
Parcels occupied
commercial parcels, SF
253d
Median vacancy gap
genuine successions only

Net storefront formation, San Francisco — monthly openings minus closings

Apr 24Mar 26
Apr 24Oct 24Apr 25Oct 25Mar 26
View as table
MonthOpeningsClosingsNet
Apr 24286178+108
May 24343346-3
Jun 24256243+13
Jul 24269132+137
Aug 24248151+97
Sep 24231148+83
Oct 24259124+135
Nov 24239153+86
Dec 24189362-173
Jan 25468200+268
Feb 25232168+64
Mar 25247187+60
Apr 25297174+123
May 25241271-30
Jun 25253249+4
Jul 25390239+151
Aug 25229100+129
Sep 25219125+94
Oct 25252107+145
Nov 2517393+80
Dec 25193319-126
Jan 26388144+244
Feb 26285188+97
Mar 26301195+106

Registration dates, not trading dates. Snapshot 2026-08-17, complete through 2026-03; later months are omitted as provisional.

The full Register

Open full page

The Register keeps its own visual identity — it is a finished, self-contained page exported by the analysis pipeline and embedded here unchanged.

About this project

Local-first analytics on business formation, closure, and storefront turnover, built on open city data. Where existing SF economic dashboards report citywide levels monthly, this tracks corridor- and block-level dynamics: which areas are gaining or losing establishments, how long addresses sit dark between tenants, and how San Francisco's re-let rates compare against Los Angeles and Chicago. The pipeline (a separate Python project) pulls registry, parcel, permit, and zoning data from three cities' open-data portals, and exports the self-contained dashboard embedded here.

Details

Created
August 16, 2026
Last updated
August 18, 2026
Type
Embedded app