PropRaven Ontology

The Ontology share is PropRaven's data delivered as a normalized graph instead of a wide table. You get canonical entities (Parcel, Property, Owner, Address, Transaction, Loan, Permit) connected by edges (Owner→Parcel, Transaction→Party), each with stable PRPV_* IDs that survive source-data churn.

Choose this access mode when your queries are traversal-shaped — "every parcel owned by entities related to X", "every transaction with grantee Y across all subsidiaries", "show me the ownership chain". Choose Parcel Intelligence (the wide table) when your queries are filter-shaped on parcel attributes.

SILVER — canonical entities

GOLD_GRAPH — edges

• EDGE_OWNER_PARCEL — 162.5M canonical ownership edges (corp-only merge: name length ≥ 10).
• EDGE_TRANSACTION_PARTY — 34.7M GRANTOR/GRANTEE edges, 26% (9.0M) name-matched to canonical owners.

GOLD_INTELLIGENCE — pre-computed signals

• PARCEL_ABSENTEE — out-of-state / out-of-county / PO-box owner classifier.
• PARCEL_INSTITUTIONAL_OWNED — 3-tier institutional flag.
• PARCEL_RECENT_TRANSFER — last sale date/price + recency bucket.
• PARCEL_DISTRESS — 7-indicator composite distress score.
• OWNER_PORTFOLIO — per-owner rollup: parcel count, total AV, geo spread, type mix.
• LENDER_EXPOSURE — per-canonical-lender originated UPB and loan-type mix.
• PARCEL_VALUE_ADD_CANDIDATE — 6-indicator redev/repositioning composite.

Every row carries _match_method and _confidence_score so production queries can filter to deterministic-only matches.

• Owner-portfolio analytics: "Find every parcel owned by canonical entity X across all subsidiaries and states."
• Transaction-graph traversal: "Show every deed where canonical owner Y was grantor or grantee in the last 24 months."
• KYC / sanctions screening: name-match new prospects against the canonical owner graph with confidence scoring.
• Investor-tracking apps: watch institutional buyers expand state-by-state via canonical entity rollups.

WITH portfolio AS (
  SELECT
    o.prpv_owner_id,
    o.name_normalized,
    o.entity_type,
    op.parcel_count,
    op.total_assessed_value,
    op.state_count,
    op.primary_state
  FROM PROPRAVEN_ONTOLOGY.GOLD_INTELLIGENCE.OWNER_PORTFOLIO op
  JOIN PROPRAVEN_ONTOLOGY.SILVER.OWNER o USING (prpv_owner_id)
  WHERE op.parcel_count >= 100
)
SELECT *
FROM portfolio
WHERE entity_type = 'LLC'
  AND state_count >= 5
ORDER BY total_assessed_value DESC
LIMIT 25;

Ontology is the graph access mode for the same data exposed wide-row in Parcel Intelligence. Subscribers commonly use both: Ontology for analyst graph queries, Parcel Intelligence for app integrations. The vertical bundles (Lending / Insurance / etc.) layer pre-filtered cohorts on top of the same canonical IDs.