Parcel Ledger Methodology Independent U.S. Property, Safety & Ownership Record

Methodology, Quarantine Rules & Primary .gov Source Inventory

Publication 9dc35e6bc8abb762da04 61 Official Feeds 5,595,895 Raw Rows 4,466,654 PII Cells Redacted

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).

Source ID Ingested Rows Bytes SHA-256 Prefix & Official Endpoint
census_gaz_counties 3,222 141,679 3c337402b5c6e8d5...
https://www2.census.gov/geo/docs/maps-data/data/gazetteer/2024_Gazetteer...
census_gaz_zcta 33,791 1,013,803 7b85c04a131672f5...
https://www2.census.gov/geo/docs/maps-data/data/gazetteer/2024_Gazetteer...
fhfa_hpi_master 186,031 17,157,179 5b60e562c7421147...
https://www.fhfa.gov/hpi/download/monthly/hpi_master.csv
census_bps_county_2024 3,028 375,214 a64c2dd19be96c46...
https://www2.census.gov/econ/bps/County/co2024a.txt
census_bps_county_2023 3,029 374,707 fab11d759e905ff6...
https://www2.census.gov/econ/bps/County/co2023a.txt
census_bps_county_2022 3,033 374,937 0a88c16861ede81b...
https://www2.census.gov/econ/bps/County/co2022a.txt
hud_fmr_areas 2,622 180,768 f42ad0d8a9f06c5a...
https://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/Fair_M...
hud_multifamily_assisted 23,771 9,633,681 f34a752d03d0446d...
https://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/Multif...
hud_multifamily_insured 17,792 6,376,944 c26642b43650130f...
https://services.arcgis.com/VTyQ9soqVukalItT/arcgis/rest/services/HUD_In...
nyc_hpd_registrations 187,127 24,589,731 71bd608f8b8ed5b0...
https://data.cityofnewyork.us/resource/tesw-yqqr.json
nyc_hpd_contacts 744,753 77,043,809 2b0b03048961a992...
https://data.cityofnewyork.us/resource/feu5-w2e2.json
nyc_annual_sales 431,864 78,038,655 36161924c82e5042...
https://data.cityofnewyork.us/resource/w2pb-icbu.json
nyc_hpd_violations 355,540 50,309,658 cefcaa63fd8c2f6a...
https://data.cityofnewyork.us/resource/wvxf-dwi5.json
nyc_oath_ecb_construction 47,971 23,687,609 1ca870c7767cd518...
https://data.cityofnewyork.us/resource/6bgk-3dad.json
nyc_dob_excavation_permits 38,285 17,290,364 4d23be7fbfd703fd...
https://data.cityofnewyork.us/resource/rbx6-tga4.json
nyc_dob_job_filings 40,925 13,018,797 a83fe32d34d8c4c7...
https://data.cityofnewyork.us/resource/w9ak-ipjd.json
nyc_311_dob_structural 26,355 10,591,254 cace38ee8345f446...
https://data.cityofnewyork.us/resource/erm2-nwe9.json
cook_parcel_sales 476,356 92,099,603 d5021c04b5c64166...
https://datacatalog.cookcountyil.gov/resource/wvhk-k5uv.json
chicago_rehab_permits 165,851 71,263,225 67d199e5de1a5a36...
https://data.cityofchicago.org/resource/ydr8-5enu.json
chicago_code_violations 189,230 35,878,847 d1460f40ff4580ea...
https://data.cityofchicago.org/resource/22u3-xenr.json
la_rehab_permits 313,965 137,469,763 d251e8f3b4cd96a0...
https://data.lacity.org/resource/pi9x-tg5x.json
la_code_enforcement 28,772 3,410,289 8a1f65d756dcb0e4...
https://data.lacity.org/resource/u82d-eh7z.json
sf_rehab_permits 144,212 52,174,388 e6c38d413a9b39ad...
https://data.sfgov.org/resource/i98e-djp9.json
sf_dbi_violations 76,025 12,478,481 e1a9c5a658b558fb...
https://data.sfgov.org/resource/nbtm-fbw5.json
seattle_rehab_permits 42,773 10,476,722 174880463c80de47...
https://data.seattle.gov/resource/76t5-zqzr.json
seattle_code_violations 96,674 14,975,936 3459fab1519efcb8...
https://data.seattle.gov/resource/ez4a-iug7.json
austin_rehab_permits 215,631 48,163,472 a27ff10f0bd1daab...
https://datahub.austintexas.gov/resource/3syk-w9eu.json
ct_statewide_sales 258,376 31,754,767 2fdb773d9141cca9...
https://data.ct.gov/resource/5mzw-sjtu.json
nj_statewide_permits 247,031 35,284,004 39441ea374751ea6...
https://data.nj.gov/resource/w9se-dmra.json
la_foreclosure_2026 2,761 556,972 a1c22dfb1c131cb0...
https://data.lacity.org/resource/5nzp-isg9.json
la_foreclosure_2025 2,143 460,405 97a1978ea5463c7d...
https://data.lacity.org/resource/2qnc-kq4g.json
la_lahd_violations 94,399 14,971,250 b9f6c5d680383e99...
https://data.lacity.org/resource/cr8f-uc4j.json
la_submitted_permits 119,837 43,107,516 add323b6db76a6ea...
https://data.lacity.org/resource/gwh9-jnip.json
la_tax_default_roll 31,233 1,542,679 5797e2b5ddebd7db...
https://services.arcgis.com/RmCCgQtiZLDCtblq/arcgis/rest/services/Secure...
la_tax_auction_parcels 4,603 566,954 b7217c306de80c41...
https://services.arcgis.com/RmCCgQtiZLDCtblq/arcgis/rest/services/2026A_...
sd_code_enforcement 17,708 4,136,765 04056c46a8547513...
https://seshat.datasd.org/code_enforcement_violations/code_enf_past_3_yr...
sd_rehab_permits 68,531 23,506,994 b7a46b8fb42ea539...
https://seshat.datasd.org/development_permits/approvals_issued_2025_data...
oc_tax_auction_2025 72 7,399 634239addd87b055...
https://ocgis.com/arcpub/rest/services/Treasurer_Tax_Collector/TTC_Aucti...
oc_anaheim_permits 21,952 5,925,701 4c99aa40fadd2853...
https://gis.anaheim.net/server/rest/services/GIS/Accela_BuildingPermits/...
oc_santa_ana_parcels 9,749 892,422 1e67e9839c159757...
https://gis.santa-ana.org/server/rest/services/Public/GIS_AssessorParcel...
sb_tax_sale_parcels 1,751 171,881 b42f060b81b260f9...
https://services6.arcgis.com/YNLmFMSyAk1IznTd/arcgis/rest/services/Parce...
rivco_valueadd_parcels 1,916 203,772 41fb59e15e379e00...
https://gis.countyofriverside.us/arcgis_mapping/rest/services/OpenData/A...
lb_vacant_lots 313 82,064 bcef564eca492b5b...
https://services6.arcgis.com/yCArG7wGXGyWLqav/arcgis/rest/services/Vacan...
ca_hcd_apr_socal 197 18,085 1d87932a94a2d9cc...
https://publish.data.ca.gov/dataset/81b0841f-2802-403e-b48e-2ef4b751f77c...
ca_sco_tax_burden_socal 197 18,149 ef048fbcd8e059d3...
https://bythenumbers.sco.ca.gov/resource/rrtv-rsj9.json
ca_cpuc_dg_solar_socal 530 26,607 f31eba90acaa7932...
https://www.californiadgstats.ca.gov/download/interconnection_rule21_pro...
sj_rehab_and_expired_permits 4,806 877,885 d712af631028110f...
https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=df4...
sj_code_and_blight 8,006 1,660,735 ae89709e5188117a...
https://geo.sanjoseca.gov/server/rest/services/PLN/PLN_PermitsAndComplai...
pa_permits_and_parcels 12,389 1,212,318 94e22698841db13c...
https://gis.cityofpaloalto.org/server/rest/services/Parcel/ParcelReport/...
smc_sv_parcels 4,280 445,757 4232baf9dc38fc48...
https://gis.smcgov.org/maps/rest/services/WEBAPPS/COUNTY_SAN_MATEO/MapSe...
ca_hcd_apr_sv 37 3,755 c9b9f0899ede2ced...
https://publish.data.ca.gov/dataset/81b0841f-2802-403e-b48e-2ef4b751f77c...
ca_sco_tax_burden_sv 37 3,641 89b7abc4856a498c...
https://bythenumbers.sco.ca.gov/resource/rrtv-rsj9.json
ca_cpuc_dg_solar_sv 85 4,408 3b9ff1bdaf547538...
https://www.californiadgstats.ca.gov/download/interconnection_rule21_pro...
la_assessor_socal_parcels 21,150 3,826,985 6452f41237734434...
https://public.gis.lacounty.gov/public/rest/services/LACounty_Cache/LACo...
sd_assessor_socal_parcels 3,330 287,735 eaa93e0bc178e137...
https://gis-public.sandiegocounty.gov/arcgis/rest/services/ARCC/apprmapr...
oc_assessor_socal_parcels 1,786 161,072 53c9a7884e0917f4...
https://ocgis.com/arcpub/rest/services/LegalLotsAttributeOpenData/Featur...
socal_prop13_comps 15,208 2,381,958 3c35e95ac87789b1...
https://public.gis.lacounty.gov/public/rest/services/LACounty_Cache/LACo...
ca_calfire_fhsz_socal 118,656 7,254,186 61d982fdd037f891...
https://services1.arcgis.com/jUJYIo9tSA7EHvfZ/arcgis/rest/services/FHSAL...
scc_sv_parcels 24,239 2,669,150 3d8d1c9d82ccca1f...
https://services2.arcgis.com/tcv2cMrq63AgvbHF/arcgis/rest/services/Parce...
ca_calfire_fhsz_sv 41,686 2,541,657 ce6f53153dbb5459...
https://services1.arcgis.com/jUJYIo9tSA7EHvfZ/arcgis/rest/services/FHSAL...
nyc_pluto_parcels 558,273 80,731,940 0986708bec5b6db8...
https://data.cityofnewyork.us/resource/64uk-42ks.csv

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: