Add current_permit_leads view + CSV export (2,034 live residential leads, $370M)

b9cec1afed44d03336b101220a989b1be81496fc · 2026-08-11 08:03:21 -0700 · steve

Files touched

A queries/current_permit_leads.sql

Diff

commit b9cec1afed44d03336b101220a989b1be81496fc
Author: steve <steve@designerwallcoverings.com>
Date:   Tue Aug 11 08:03:21 2026 -0700

    Add current_permit_leads view + CSV export (2,034 live residential leads, $370M)
---
 queries/current_permit_leads.sql | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/queries/current_permit_leads.sql b/queries/current_permit_leads.sql
new file mode 100644
index 0000000..5e66c04
--- /dev/null
+++ b/queries/current_permit_leads.sql
@@ -0,0 +1,27 @@
+-- Current building-permit LEADS: recently-issued residential permits, enriched
+-- with the parcel's assessed value / year built / size (permit.apn = parcel.ain).
+-- "Best leads" = active (Issued), residential, real valuation, freshly issued.
+CREATE OR REPLACE VIEW current_permit_leads AS
+SELECT
+  p.issue_date::date            AS issued,
+  p.primary_address             AS address,
+  p.zip_code                    AS zip,
+  p.council_district            AS cd,
+  p.permit_type                 AS work_type,
+  p.valuation                   AS project_value,
+  p.work_desc                   AS scope,
+  p.apn,
+  a.total_value                 AS assessed_value,
+  a.year_built,
+  a.sqft_main                   AS sqft,
+  a.use_type,
+  p.lat, p.lon
+FROM la_building_permits_raw p
+LEFT JOIN la_assessor_parcels_raw a
+  ON a.ain = p.apn AND a.roll_year = '2025'
+WHERE p.dataset_id = 'pi9x-tg5x'
+  AND p.status_desc = 'Issued'
+  AND p.permit_sub_type = '1 or 2 Family Dwelling'
+  AND p.issue_date >= now() - interval '60 days'
+  AND p.valuation >= 25000
+  AND p.primary_address IS NOT NULL;

← 0c2fe12 Add --year=YYYY for resumable per-roll-year assessor loads · back to La Socrata Ingester · Add palisades_rebuilds + current_permits_all views + pool/ma 00f0a40 →