Property Intel Database

The Property Intel Database (property_intel) is a PostgreSQL data warehouse powering Dora's property research and scoring engine. It stores 2,237 CivilView-scraped properties and a 13-factor scoring engine that evaluates deal quality and seller motivation.

Identity

Database: PostgreSQL
Host: localhost:5434
Database name: property_intel
Data source: civilview-scraper — daily scrape of CivilView tax records
Record count: 2,237 properties (as of latest scrape)
Related system: dispotree property model enrichment

Schema Overview

The database contains normalized tables for property records, tax assessments, ownership details, and computed scores. Key tables include:

| Table | Purpose |

|-------|---------|

| properties | Core property records with address, parcel ID, coordinates |

| tax_assessments | Assessed value, tax history, exemptions |

| ownership | Owner names, mailing addresses, ownership duration |

| scores | 13-factor scoring results per property |

| scrape_log | CivilView scrape run history and record counts |

13-Factor Scoring Engine

Each property is scored across 13 weighted factors that predict deal viability:

1. Equity Position — estimated equity vs. market value

2. Owner Occupancy — occupied vs. absentee owner signal

3. Ownership Duration — longer tenure = higher motivation likelihood

4. Tax Delinquency — overdue taxes as motivation signal

5. Lien/Judgment Count — financial distress indicator

6. Property Condition Index — assessed condition from tax records

7. Days Since Last Sale — recency of transaction

8. Price-to-ARV Ratio — asking vs. after-repair value

9. Neighborhood Appreciation — 12-month trend in area values

10. Seller Age Proxy — estimated age from ownership records

11. Mortgage-to-Value — existing debt against current value

12. Deed Type — quitclaim, warranty, or other (indicates distress)

13. Composite Score — weighted aggregate of all 12 factors

Data Flow

``mermaid


graph LR
CivilView -->|Daily scrape| property_intel_db
property_intel_db -->|Dora queries| Scoring_Engine
Scoring_Engine -->|Enriched data| DispoTree
DispoTree -->|deal scoring| Dora_Dashboard

1. civilview-scraper scrapes CivilView daily → inserts/updates property_intel records


2. dora runs the 13-factor scoring engine against new and updated records

3. Scored properties are enriched into dispotree property records via marketDataEnrichment` JSONB

4. Dora surfaces top-scoring properties for deal creation recommendations

Integration Points

civilview-scraper — daily ingestion pipeline populates the database
dispotree — enriched property data populates listing creation and compliance checks
dora — orchestrates scoring runs and surfaces high-potential properties