viewer: swap live ranking to permit_lead_score_v2 (0/1.58M penalized; teardown signal)

707ec146912160b73ad95b88a34e40eb2b3a21c4 · 2026-08-12 09:12:53 -0700 · Steve Abrams

Files touched

M viewer/server.js

Diff

commit 707ec146912160b73ad95b88a34e40eb2b3a21c4
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Aug 12 09:12:53 2026 -0700

    viewer: swap live ranking to permit_lead_score_v2 (0/1.58M penalized; teardown signal)
---
 viewer/server.js | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/viewer/server.js b/viewer/server.js
index f2a9b0d..931c8d2 100644
--- a/viewer/server.js
+++ b/viewer/server.js
@@ -59,7 +59,7 @@ const SORTS = {
 };
 // Per-column sort whitelist (col name -> SQL expr). Enables sort=<col>&dir=asc|desc.
 const COLS = {
-  lead_score: 'permit_lead_score(p.issue_date,p.valuation,p.permit_type,p.permit_sub_type,p.status_desc)',
+  lead_score: 'permit_lead_score_v2(p.issue_date,p.valuation,p.permit_type,p.permit_sub_type,p.status_desc,a.total_value,a.year_built)',
   issued: 'p.issue_date', address: 'p.primary_address', zip: 'p.zip_code',
   cd: 'p.council_district', work_type: 'p.permit_type', building_type: 'p.permit_sub_type',
   use_desc: 'p.use_desc', status: 'p.status_desc', project_value: 'p.valuation',
@@ -68,7 +68,7 @@ const COLS = {
 };
 function orderBy(sort, dir) {
   if (COLS[sort]) return `${COLS[sort]} ${dir === 'asc' ? 'ASC' : 'DESC'} NULLS LAST`;
-  return SORTS[sort] || 'permit_lead_score(p.issue_date,p.valuation,p.permit_type,p.permit_sub_type,p.status_desc) DESC NULLS LAST';
+  return SORTS[sort] || 'permit_lead_score_v2(p.issue_date,p.valuation,p.permit_type,p.permit_sub_type,p.status_desc,a.total_value,a.year_built) DESC NULLS LAST';
 }
 
 // --- Paginated, filtered, sorted permits ---
@@ -81,7 +81,7 @@ app.get('/api/permits', async (req, res) => {
 
     const { sql: where, params } = buildWhere(req.query);
     const rowsSql = `
-      SELECT permit_lead_score(p.issue_date,p.valuation,p.permit_type,p.permit_sub_type,p.status_desc) AS lead_score,
+      SELECT permit_lead_score_v2(p.issue_date,p.valuation,p.permit_type,p.permit_sub_type,p.status_desc,a.total_value,a.year_built) AS lead_score,
              ${ERA} AS era, p.permit_nbr, p.issue_date, p.primary_address AS address, p.zip_code AS zip,
              p.council_district AS cd, p.permit_type AS work_type, p.permit_sub_type AS building_type,
              p.use_desc, p.status_desc AS status, p.valuation AS project_value, p.apn,

← 4c7b267 Pre-stage lint-clean launchd plists for daily canary (08:00) · back to La Socrata Ingester · Add self-rotating refresh wrapper (bounds tmp/ingest.log to 5ef077c →