PropRaven Parcel Intelligence

Parcel Intelligence is the marquee wide table — every U.S. parcel pre-joined to every enrichment we ship, on a single row. It replaces 6+ vendor data feeds with one Snowflake share.

If you're integrating property intelligence into an application or building features against the data, this is the right access mode: one query, one row per parcel, every catalogued column available without joins. The catalog has 620 catalogued columns (44 rebuilt every epoch and 576 carried from an April 2026 reference export; 56 of the 620 are withheld from sale while they are rebuilt).

• Identity & geometry: APN, normalized APN, lat/lon, geometry polygon, lot size, county/CBSA/state.
• Property attributes: year built, building area, beds, baths, units, owner-occupancy flag, MISMO-normalized property type (96.4% classified).
• Owner intelligence: 27.56M canonical entities (72.8% coverage), entity type (LLC / CORP / TRUST / GOVT / INDIVIDUAL / ...), state of formation.
• Tax & assessments: latest tax year + multi-year history, assessed values (land/improvement/total), tax amount, exemptions.
• Permits: building-permit count, recent permit activity, contractor names, business licenses, NAICS codes.
• Deeds & sales: last sale date/price, prior sale, deed count, grantor/grantee.
• AVM & valuation: PropRaven AVM with confidence (87.6% coverage).
• Risk vector: FEMA NRI overall + per-peril (94.9% rated), NFIP flood claims, NOAA storms, USGS seismic, CDC SVI, wildfire score, climate risk tier.
• Demographics: ACS tract attributes, IRS migration, HMDA loan activity, CDC PLACES health.
• Crime: FBI/NIBRS-derived rates and concentration.
• Federal overlays: HUD HMDA / FMR / LIHTC QCT, FDIC SOD branches, Justice40, EPA ECHO, FEMA disaster history.
• NEW v1.2 — extensions (PARCEL_EXTENSIONS join table): TIGER census-block / block-group / place / school-district GEOIDs, parsed address components (street number / name / suffix / unit), AVM lower/upper bands + rental AVM, REO/distress/multi-parcel flags, distance to interstate + coastline.

• CRM enrichment: hydrate a customer record with the full property profile in a single SELECT.
• Pricing models: train AVM-supplement or insurance-pricing models against pre-resolved features.
• Lead scoring: filter to your buyer cohort with one WHERE clause across the catalogued columns.
• Embedded apps: power "property dashboard" features without managing 6 vendor pipelines.

-- Catalogued columns are direct columns — no join needed.
-- v1.2 columns: AVM_LOWER/UPPER bands, TRACT_GEOID, IS_DISTRESSED, etc.
SELECT
  PARCEL_ID,
  ADDRESS,
  PROPERTY_TYPE,
  YEAR_BUILT,
  TOTAL_ASSESSED_VALUE,
  AVM_LOWER,
  AVM_UPPER,
  RENTAL_AVM_LOWER,
  NRI_RISK_RATING,
  FLOOD_ZONE,
  TRACT_GEOID,
  URBAN_RURAL_CLASS,
  IS_DISTRESSED,
  OWNER_NAME
FROM PROPRAVEN_PARCEL_INTELLIGENCE.CURATED.V_MARKETPLACE_NATIONAL
WHERE STATE_FIPS = '06'
  AND PROPERTY_TYPE = 'SFR'
  AND NRI_WILDFIRE_RATING IN ('Very High', 'Relatively High')
  AND AVM_LOWER > 750000
LIMIT 100;

Parcel Intelligence is one of three access modes for the same underlying truth:

• Parcel Intelligence (this listing) — wide table, one row per parcel, single-join workflows.
• Ontology — graph shape with canonical entities + edges; better for traversal queries ("every parcel owned by entities controlled by X").
• Vertical bundles (Lending / Insurance / Banking / SFR / CRE / GovTech) — pre-filtered cohorts for specific use cases, often cheaper.

Subscribers to Parcel Intelligence can layer in the Ontology share or any vertical bundle without redundant data ingestion.