ingest: skip parenthetical placeholder addresses ('(PYLON SIGN SITE)') — guards the no-sale-parcel inclusion; drops exactly 2 junk rows, keeps all 3,791 real-address no-data parcels (cycle 6 verify-before-acting: seed's '5,317 junk' was a phantom)

46ea05e2d72e8898fdb0fdbfda6e5c8459f767b4 · 2026-08-24 13:57:52 -0700 · Steve Abrams

Files touched

M scripts/ingest-usre-parcels.mjs

Diff

commit 46ea05e2d72e8898fdb0fdbfda6e5c8459f767b4
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Aug 24 13:57:52 2026 -0700

    ingest: skip parenthetical placeholder addresses ('(PYLON SIGN SITE)') — guards the no-sale-parcel inclusion; drops exactly 2 junk rows, keeps all 3,791 real-address no-data parcels (cycle 6 verify-before-acting: seed's '5,317 junk' was a phantom)
---
 scripts/ingest-usre-parcels.mjs | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/scripts/ingest-usre-parcels.mjs b/scripts/ingest-usre-parcels.mjs
index aadbdab..a93d389 100644
--- a/scripts/ingest-usre-parcels.mjs
+++ b/scripts/ingest-usre-parcels.mjs
@@ -103,6 +103,11 @@ let matched = 0, added = 0;
 for (const r of rows) {
   const addr = (r.address || '').trim();
   if (!addr) continue;
+  // skip parenthetical PLACEHOLDER "addresses" — assessor annotations like "(PYLON SIGN SITE)", not a real
+  // street address (can't be shown/searched as a property). Rare (2 in the 4-county pull) but future-proofs
+  // the no-sale-parcel inclusion (cycle 6). NOTE: a no-sale parcel with a REAL address but no assessed/sqft is
+  // a legitimate property (e.g. "1 OCEAN DR" Miami Beach) and is KEPT — only the ( … ) placeholder form drops.
+  if (/^\(.*\)$/.test(addr)) continue;
   const city = r.city ? tc(r.city) : null;
   const key = keyOf(addr, city);
   const pt = ptype(r.ctype, r.use_desc);

← acf296e auto-data-snapshot: 2026-08-24T13:25:50 (1 data files) — pub · back to Re Flyer Aggregator · properties viewer: add 'Assessed value' sort + County filter 50e3f57 →