Connected — schema not applied
BRICK Command · Leasing
System Health
diagnostics, audit trail, and admin
Operational view of the competitor-intelligence pipeline: database connection, schema integrity, last ETL run summary, operator coverage, and onboarding checklist. For analytics, see the Field landing page.
Last Run
ETL Audit
| Run ID | ca59655a-383e-45b9-b8a0-4e14423ae8bc |
| Started | May 18, 2026, 8:10 AM |
| Finished | May 18, 2026, 8:13 AM |
| Operators run | 1 |
| Inserted / Updated | 135 / 1 |
| Failures | 0 |
01 / Pipeline Status
Health
database, schema, seed data
0/9
Operators Seeded
0
Fingerprint Rules
0/6
Tables Applied
—
Daily Cron 06:00 PT
Diagnostics
Database Connection
| Connected | true |
| Schema applied | false |
| Operators | 0 / 9 |
| Fingerprints | 0 |
02 / Live Inventory
Active Listings
pulled from the latest ETL run · May 18, 2026, 11:24 AM PT
144
Total Active Listings
8
Operators Reporting
$3,403
Avg Median Rent
2,149
Active CL Ads
By Operator
Operator Breakdown
Active website listings by source
Portfolio weighting across operators in the latest ETL
Craigslist ads by attribution confidence
How well multifamily CL inventory maps to known operators
| Brick + Timber | 53 listings · $3,995 median |
| Rentals Inc. | 35 listings · $3,195 median |
| Gaetani Real Estate | 16 listings · $3,645 median |
| RentSFNow | 12 listings · $1,770 median |
| Trinity SF | 11 listings · $3,393 median |
| Mosser Living | 8 listings · $2,145 median |
| Parkmerced | 6 listings · $3,230 median |
| 2B Living | 3 listings · $5,850 median |
Audit Log
Recent Changes
| 19 Hermann St · 104rentals_inc | relistedremoved → relisted |
| 3099 Washington St · 2rentals_inc | relistedremoved → relisted |
| 2035 Castro St · 31rentals_inc | relistedremoved → relisted |
| 3900 21st Strentals_inc | relistedremoved → relisted |
| 748 Page St · 11rentals_inc | relistedremoved → relisted |
| 938 Hayes St · 6rentals_inc | relistedremoved → relisted |
| 2037 Castro St · 21rentals_inc | relistedremoved → relisted |
| 3099 Washington St · 24rentals_inc | relistedremoved → relisted |
Craigslist
Attribution Confidence
490
Definitive
0
Strong
178
Probable
1,481
Unidentified
513 of 2,149 CL ads matched to a known website listing.
03 / Coverage
Operator Roster
eight operators plus a separate Craigslist scan
In Scope
SF Multifamily Competitors
2B LivingAppFolioLive
Gaetani Real EstateAppFolioLive
Brick + TimberYardi RentCafeLive
Parkmerced (Ballast)Yardi RentCafeLive
Trinity SFYardi RentCafeLive
RentSFNow (Veritas)RentCafe · PlaywrightLive
Mosser LivingRentPress · PlaywrightLive
Rentals Inc.Webflow + ShowMojoLive
Craigslist SFsfc/apa · PlaywrightLive
Plus a separate Craigslist SF scan (apartments-for-rent, multifamily only), attributed to operators via the fingerprint dictionary in the fingerprints table.
04 / Setup
Onboarding Checklist
complete before first daily run
Required
Pre-flight
- Connect Neon database via Vercel → Storage. Confirm
LEASING_DATABASE_URL_UNPOOLEDpopulated. - Apply schema:
npm run db:apply - Create Cloudflare R2 bucket and add credentials to env vars.
- Apply lifecycle rule on R2 bucket:
Delete after 90 days. - Add GitHub Actions secrets:
LEASING_DATABASE_URL_UNPOOLED,R2_*,SLACK_WEBHOOK_URL. - Verify daily ETL runs at 06:00 PT via GitHub Actions cron.
Operations Reference
Run Book & Failure Playbook
Daily run schedule, failure modes, manual operations, and the open decisions still awaiting a human call. Read it before the first production cron tick.
Open OPERATIONS.md