Methodology, Quarantine Rules & Primary .gov Source Inventory
Parcel Ledger ingests 5,595,895 raw administrative records across 61 primary federal, California state, New York City, county, and municipal open-data feeds, applying 10 deterministic deduplication, placeholder-quarantine, spatial-join, AB 2238 calibration, and PII-redaction rules in Google BigQuery to publish 8,653 underwriting profiles, 8,307 NYC building-safety pairs, and 43,263 Southern California and Silicon Valley parcel leads.
1. Ten Deterministic Reconciliation & Quarantine Rules
Public real estate filings contain systematic administrative distortions: multi-parcel bulk deeds broadcast total portfolio consideration onto individual condo PINs, $0/$100 nominal quitclaim transfers corrupt repeat-sale flip medians, supplemental property-tax stubs collide with secured parcel AINs, single-BBL building lookups hide adjacent excavation permits, and municipal electric cities vanish if naively joined only against investor-owned utility interconnection tables. Table 1 documents every quarantine and normalization rule executed in publication 9dc35e6bc8abb762da04.
| Rule Identifier & Domain Layer | Rows Flagged / Normalized | Deterministic Disposition |
|---|---|---|
|
CAL FIRE LRA+SRA Spatial Join, HCD APR Postal-to-City Bridge & POU/IOU Solar Split
California State Portals (CAL FIRE + HCD + SCO + CPUC)
|
160,342 | Point-in-polygon classified SoCal & Silicon Valley parcel coordinates across CAL FIRE LRA+SRA FHSZ layers, mapped postal neighborhoods to HCD/SCO jurisdictions, and separated Municipal POU electric cities (incl. Silicon Valley Power & Palo Alto Utilities) from CPUC Rule 21 PG&E/SCE/SDG&E solar ZIPs. |
|
Cook County Multi-Parcel Bulk-Deed Broadcast Quarantine
Parcel Deeds (Cook County Assessor)
|
112,771 | Quarantined portfolio/condo-parking package deeds where total package price was broadcast onto every individual PIN. |
|
HUD Assisted + FHA-Insured Cross-Listing Deduplication & FIPS State Bridge
Federal Multifamily (HUD Assisted + Insured)
|
4,956 | Collapsed properties simultaneously listed in both HUD Assisted and FHA-Insured feeds on PROPERTY_ID and bridged STATE2KX FIPS to USPS state codes. |
|
HUD REAC Alphanumeric Health & Safety Suffix Recovery (e.g. 90c, 82b*)
Physical Inspection Scores (HUD REAC)
|
2,140 | Regex-extracted numeric REAC score and preserved health/safety deficiency suffix flags instead of dropping to NULL on integer cast. |
|
LA ZIMAS/Trailing-Hyphen ZIP Bridge & 100% Personal Contact PII Redaction
Privacy & Cross-Portal Hygiene (NYC + HUD + SoCal + Silicon Valley + CA State Portals)
|
4,466,654 | Normalized LA trailing-hyphen ZIPs (90019-) and purged 100% of personal owner, OATH individual respondent, investigator, San Jose/SoCal permit-holder, HCD APR parcel, and solar installer contact PII. |
|
Nominal ($0-$100) & Related-Party Quitclaim Deed Exclusion
Parcel Sales (NYC DOF + Cook + CT OPM)
|
204,163 | Excluded non-market quitclaim, estate, divorce, and inter-LLC nominal transfers prior to repeat-sale flip margin calculation. |
|
NYC 10-Digit BBL Cross-Agency Bridge & <=60m Contiguous-Lot Excavation Contagion Join
NYC Structural Safety (MapPLUTO + HPD + DOF + DOB NOW + OATH/ECB + 311)
|
558,273 | Canonicalized MapPLUTO float BBLs (.00000000), unpadded DOB NOW borough-block-lots, and zero-padded OATH/ECB keys onto 10-digit BBLs and joined occupied residential buildings to contiguous (<=60m, lot gap <=3) excavation, demolition, and Stop-Work defiance sites. |
|
Single-Building LLC Shell Unmasking vs. Registered-Agent Mail-Drop Split
Ownership & PM Registry (NYC HPD Contacts)
|
91,586 | Linked single-asset CorporateOwner LLCs through shared Management Agent offices while separating statutory registered-agent hubs. |
|
Municipal Permit $0/$100/Negative Placeholder Quarantine & 40%+ Cost-Overrun Audit
Building & Rehab Permits (LA, SD, OC, San Jose, SF, Chicago, Seattle)
|
80,817 | Removed placeholder ($0-$100 and Anaheim negative) valuations from capex medians and isolated mid-flip permits with >=40% revised cost overruns. |
|
CA 7-County APN Canonicalization, AB 2238 Roll Redaction & Tax Quarantine
CA Flip Deal Engine (LA, SD, OC, Riverside, SB, Santa Clara, San Mateo)
|
43,263 normalized | Quarantined LA supplemental tax accounts (0xxx prefixes), canonicalized San Diego 8/10-digit, Santa Clara 8-digit, and San Mateo 9-digit APNs, and calibrated AB 2238 roll-redacted Silicon Valley underwriting. |
2. Automated Quality Gate Verification
Prior to promoting any SQLite/JSON publication artifact to Cloudflare Edge and Cloud Run, our verification harness evaluates 13 invariant assertions covering schema completeness, zero-PII leakage, coordinate bounds, and cross-table reconciliation totals.
| Quality Check | Status | Observed Audit Detail |
|---|---|---|
entity_primary_key |
PASS | actual=0 (expected=0) |
nonnegative_counts |
PASS | actual=0 (expected=0) |
valid_coordinates |
PASS | actual=0 (expected=0) |
fifty_state_coverage |
PASS | actual=0 (expected=0) |
verified_flips_threshold |
PASS | actual=0 (expected=0) |
pm_portfolios_threshold |
PASS | actual=0 (expected=0) |
socal_deal_primary_key |
PASS | actual=0 (expected=0) |
socal_deal_coordinates |
PASS | actual=0 (expected=0) |
socal_ca_portal_enrichment |
PASS | actual=0 (expected=0) |
silicon_valley_deal_coverage |
PASS | actual=0 (expected=0) |
nyc_safety_primary_key |
PASS | actual=0 (expected=0) |
nyc_safety_coordinates |
PASS | actual=0 (expected=0) |
zero_pii_columns_in_marts |
PASS | actual=0 (expected=0) |
3. Complete Primary .gov & Official Source Inventory (61 Feeds)
Every upstream file is cryptographically hashed (SHA-256) at capture time (2026-11-15).
4. Update Cadence, Known Limitations & Citation Format
Update Cadence: Parcel Ledger runs an automated daily 04:00 PT municipal permit, enforcement, and distress pipeline refresh alongside scheduled quarterly and annual rebuilds aligned with HUD REAC/FMR releases, FHFA quarterly HPI publications, California HCD APR updates, and county assessor/tax-collector snapshots.
Known Limitations: Public deed consideration and building-permit valuation statements do not capture unpermitted cash renovations, private off-record seller credits, interior structural defects, or post-capture lien releases. Always verify preliminary title, municipal inspection cards, and physical property condition before committing capital.
5. Related Meru AI Engineering & Architecture Notes
The deterministic ingestion, entity-linking, and quarantine rules documented on this page follow Meru AI's public-record engineering standards. For companion technical notes on cross-jurisdiction identifier bridging and warehouse verification, consult:
- Cross-Agency Entity Resolution: linking municipal tax lots, enforcement dockets, and multi-LLC management umbrellas without probabilistic false positives.
- Supply-Chain & Environmental Entity Resolution: deterministic ownership and geographic linkage across federal and state registries.
- Public Data Platforms: reproducible SHA-256 source capture, PII scrubbing, and public observatory warehouse design.
- Product & Market Intelligence Case Study: empirical market benchmarking built from reconciled primary filings.
- AI Automation Consulting: custom agentic workflows, public-record underwriting pipelines, and operational automation by Meru AI.
- Custom Data & Partnership Inquiries: institutional data feeds and custom multi-agency reconciliation with Meru AI.