LMH Portfolio Intelligence · Pilot Workbench

Santo Terrace & Canyon View

One community, built micro-first. Real footprints, one sample asset, and every open decision in one place.
75
Buildings (OSM, partial)
221,342
Measured roof sqft
0%
Verified data
100%
Inferred data

01The Community

Footprints © OpenStreetMap (partial coverage — SanGIS layer is the authoritative next pull). Imagery © Esri. Click a building; the highlighted one is the sample asset below.

02One Asset, In Full

This is what a single asset record looks like when the platform knows only what public data can infer. Every field below is honest about its source — that honesty is the product.

Asset · Roof

Building 915942762 — Primary Roof

data_confidence: inferred
Footprint
2,401 sqft (measured, OSM)
Material
asphalt shingle (assumed — verify from imagery)
Install date
unknown (assessor / permit pull pending)
Expected life
22 yrs (category default)
Est. replacement
$13,200 (@ $5.50/sqft)
Projected year
— blocked on install date
Lease context
— blocked on ground lease terms
Service events
none on record
Field capture · concept

The Panel QR Anchor

▩ ▩ ▩
UNIT-QR → opens this unit's full asset list
one tag per unit · electrical panel · never re-tagged

Scan → unit asset list → tap what you touched → photo of data plate on first association. Tech never types. Install capture piggybacks on the shed-inventory pull, and logging auto-closes the work order — capture that does their paperwork gets done.

Open: label vendor/spec · who deploys tags · exception path wording

03Open Decisions & Follow-ups

Current-State Discovery — What They Already Have

ASK FIRST

A multi-billion MHPI portfolio is not run on spreadsheets. Each project is a bond-financed SPE with a lockbox waterfall, trustee-held capital repair & replacement reserves, recapitalization requirements, and (likely) periodic third-party capital needs assessments. The gap is probably not forecasting — it's that the forecasts are static PDFs, siloed per deal entity, and carry no lease-term or cross-portfolio lens.

Structural insight: cash generally can't move between project entities. "Where should we invest across the company" must respect per-project waterfall capacity — condition data alone gives the wrong answer.

  • KEYWhat did the investment bankers ask for that was hard to produce? (This question finds the product.)
  • OPENLast capital needs assessment per project — who, when, format, can we get the underlying models?
  • OPENComponent-level inventories in the CNAs, or building-level allowances?
  • OPENHow many project entities, which communities in which, reserve balances & waterfall position per project?
  • OPENActual ground lease expirations per project; which extensions are live?
  • OPENWhich Yardi modules are deployed — Fixed Assets? Facility Manager? Where do work orders live, and do they capture asset detail?
  • OPENHow is next year's capex budget actually built today — inputs, owners, approval, lock date?
  • OPENWhat flows to DoW/trustee already — and which metrics does leadership actually read?

Full 22-question diligence list in the Discovery Brief. Pitch shift: not "I'll build forecasting" — "your forecasts are trapped in five-year-old PDFs and per-deal silos; I'll make them living, comparable, and lease-aware."

Census vs. Forecast

DECIDED: forecast-first

Forecasting answers capital budgeting from age distributions; a census answers dispatch. A census that is 80% maintained is not a census — it's untrustworthy data. So the census is a bonus layer that fills in opportunistically; the forecast never depends on it.

Forecast-first
Value on day one · works at any data completeness · matches their #1 goal (capex prediction)
Full census-first
Requires 36,000 units inventoried before any value · decays the moment techs stop complying · adoption risk is fatal
Confidence tierMeaningSanto today
verifiedphysically confirmed (photo/scan)0%
loggedevent recorded, not verified0%
inferredmodeled from public data / imagery / vendor AI100%
flaggedknown-suspect, excluded from headlines0%

Portfolio confidence share becomes a headline metric — "our 10-yr number is 40% verified / 45% logged / 15% inferred" is a sentence a banker can work with.

Inventory Tracking & QR Strategy

DECIDED: panel QR + inventory-pull capture
ApproachProsConsVerdict
Tag every appliancePerfect asset anchor~180K tags · dies at first untagged replacement · pure burden on techsrejected
One QR per unit (electrical panel)~36K tags · permanent location · survives every appliance swap · scan opens whole unitStill needs one deployment sweepchosen
No tags (app navigation)Zero label logisticsManual unit selection = exactly where wrong-unit errors creep infallback only

The bulk-purchase reality: they buy a dozen disposals into a shed; the PO never says which unit each landed in. So capture happens in two stages — procurement → inventory, then inventory → unit at install. The install log rides on the stock-pull they already must do.

  • OPENIs shed/warehouse inventory tracked anywhere today, or is stage 1 net-new?
  • OPENLabel spec & vendor (polyester/vinyl, heat+moisture rated) — and who prints?
  • OPENTag deployment: normal maintenance sweep vs. one-time contracted pass?
  • OPENWhat system closes work orders today — can install logging auto-close them?

Tailorbird — Follow-up Questions

MEETING HELD 7/24 — LOG ANSWERS

Position: sit above it, don't compete. Tailorbird is data acquisition; this platform is the decision layer. Their output would land as one inferred-tier feed. An unproven vendor is a reason to have an independent decision layer.

  • KEYAPI or bulk export — can the full asset table with confidence scores land in our Postgres, or is data locked in their UI?
  • OPENPer-asset confidence scores exposed? Accuracy stats vs. later-verified ground truth?
  • OPENError direction — do they miss assets or invent them?
  • OPENExact Yardi requirements — modules, licensing tier, read-only?
  • OPENData ownership at contract end — does the inventory leave with LMH?
  • OPENRefresh cycle — snapshot or continuous re-inference?
  • OPENPortfolios completed at 30K+ units — reference client?
  • OPENMHPI experience — base access, DoW data handling?
  • OPENStrong vs. weak asset classes (aerial-visible vs. inside-the-unit)?
  • OPENGaps: flagged honestly, or filled with portfolio averages?
  • OPENCost + timeline of last comparable engagement?

Santo doubles as the benchmark: if Tailorbird runs it too, compare their inferred inventory against ours, asset by asset.

Utilities & Points of Demarcation

SIDE PROJECT — PURE GIS

Their goal: district personnel click any property and immediately know who owns what and who to call. Per property, track:

  • TRACKElectric / gas / water / sewer provider (service territories are largely public GIS data)
  • TRACKPoint of demarcation — where public utility responsibility ends and LMH's begins
  • TRACKOn-base wrinkle: privatized utility owners (separate companies from housing privatization) — nobody has this in one map
  • TRACKOutage contact + account numbers per service
  • TRACKWho owns lines inside the community boundary (LMH vs. utility vs. base)

Santo (off-base, city land): likely SDG&E electric+gas, City of San Diego water/sewer — to verify, which is itself the demo of the workflow.

Yardi — Issues, Pros/Cons, Cost

DECIDED: one-time export, no live interface
What Yardi has
Property / unit / lease geography · work-order history (maybe seeds the census) · the property codes everything joins on
What it lacks
The per-unit asset detail — the serial & age of the water heater in each apartment. That gap is the entire value being added.

Cost reality: interface/API licensing is unpublished, negotiated, typically metered per property per month, and gated by entitlements. At 200 communities: potentially thousands to tens of thousands monthly. But geography changes a few times a year — a static hierarchy doesn't justify a live licensed sync. One-time bulk export (even CSV) and done.

  • OPENWhich Yardi product/tier do they run — Voyager, Breeze, Breeze Premier?
  • OPENCan Mike pull a unit directory / rent-roll export for Santo (resident columns stripped)?
  • OPENAre appliance replacements logged as work orders — extractable history?
  • OPENRevisit live sync only if Phase 4 (operational overlay) gets funded.

Santo Data Gaps — What Exists / What's Missing

THE PILOT QUESTION ITSELF
DataStatusSource / next step
Building footprints + roof areasHAVE (partial)OSM now → SanGIS layer for complete coverage
Community boundaryMISSINGDraw from street grid + parcel lines
Roof material & conditionMISSINGCurrent aerial imagery, building by building
Construction / reroof yearsMISSINGCounty assessor + permit records (city land — they exist)
Unit roster (unit #s, bedrooms)MISSINGMike — Santo-only ask, resident data stripped
Ground lease termsMISSINGClient — needed for the lease-vs-life chart
Work-order / capital historyMISSINGClient / Yardi export, if logged