flowchart LR
  classDef src fill:#E6F6EF,stroke:#0B8E5F,color:#0C1422;
  classDef leg fill:#F0F0F0,stroke:#9AA3AD,color:#555;
  classDef probe fill:#FBF3E0,stroke:#B26A00,color:#5b4300;
  classDef tbl fill:#ffffff,stroke:#102442,color:#102442;
  classDef view fill:#E7ECF5,stroke:#102442,color:#102442;
  classDef out fill:#102442,stroke:#102442,color:#ffffff;

  subgraph S["1 · External sources"]
    direction TB
    costar["CoStar
buildings · owners · sales · for-sale · % leased"]:::src
    lease["CoStar Lease Activity
50–200k office/flex · 2010–2020"]:::src
    cawarn["CA EDD WARN
weekly xlsx · has address"]:::src
    txwarn["TX WARN
Socrata · no address"]:::leg
    census["US Census
batch geocoder"]:::src
    propwire["Propwire distress
Denver / DFW only"]:::leg
    hubspot["HubSpot CRM
name/domain/industry only"]:::probe
    rm["Rent Manager
tenants · 21 facilities"]:::probe
  end

  subgraph R["2 · Raw / mirror"]
    direction TB
    cp["costar_properties"]:::tbl
    ssl["src_ss_office_leases"]:::tbl
    warn["src_warn"]:::tbl
    txw["src_tx_warn"]:::leg
    geo["geocode_cache"]:::tbl
    pw["src_propwire_distress"]:::leg
    hsc["hubspot_companies"]:::probe
    rmt["v_rm_tenants"]:::probe
  end

  subgraph T["3 · Normalize & classify"]
    direction TB
    fn["norm_office_addr()
owner_acq_strategy()"]:::view
    mvc["mv_costar_addr"]:::view
  end

  subgraph V["4 · Scored views"]
    direction TB
    si["v_acq_seller_intent"]:::view
    vt["v_acq_targets
→ mv_acq_targets"]:::view
    vw["v_acq_warn"]:::view
    sst["v_ss_office_targets"]:::view
    ssd["v_ss_office_discovered"]:::view
    ssf["v_ss_office_for_sale"]:::view
  end

  subgraph O["5 · Outputs"]
    direction TB
    map["Acquisitions Map
v_acq_map"]:::out
    ssrep["Single-Story Office report"]:::out
    li["Long Island report"]:::out
    gaps["CoStar gap list"]:::out
  end

  costar --> cp
  lease --> ssl
  cawarn --> warn
  txwarn --> txw
  census --> geo
  propwire --> pw
  hubspot --> hsc
  rm --> rmt

  cp --> fn
  fn --> mvc

  cp --> si
  cp --> vt
  geo --> vt
  si --> vt
  warn --> vw
  mvc --> vw
  vw --> vt
  ssl --> sst
  mvc --> sst
  cp --> ssd
  mvc --> ssd
  cp --> ssf
  mvc --> ssf

  vt --> map
  vt --> li
  sst --> ssrep
  ssd --> ssrep
  ssf --> ssrep
  sst --> gaps