Add palisades_rebuilds + current_permits_all views + pool/master lead exports

00f0a403284c3106db04562bc019b823ade7de9b · 2026-08-11 08:08:15 -0700 · steve

Files touched

A queries/current_permits_all.sql
A queries/palisades_rebuilds.sql

Diff

commit 00f0a403284c3106db04562bc019b823ade7de9b
Author: steve <steve@designerwallcoverings.com>
Date:   Tue Aug 11 08:08:15 2026 -0700

    Add palisades_rebuilds + current_permits_all views + pool/master lead exports
---
 queries/current_permits_all.sql | 9 +++++++++
 queries/palisades_rebuilds.sql  | 9 +++++++++
 2 files changed, 18 insertions(+)

diff --git a/queries/current_permits_all.sql b/queries/current_permits_all.sql
new file mode 100644
index 0000000..f94640b
--- /dev/null
+++ b/queries/current_permits_all.sql
@@ -0,0 +1,9 @@
+CREATE OR REPLACE VIEW current_permits_all 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.permit_sub_type AS building_type,
+       p.valuation AS project_value, p.work_desc AS scope,
+       a.total_value AS assessed_value, a.year_built, a.sqft_main AS sqft, a.use_type, p.apn, 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.issue_date >= now()-interval '90 days' AND p.valuation >= 10000 AND p.primary_address IS NOT NULL;
diff --git a/queries/palisades_rebuilds.sql b/queries/palisades_rebuilds.sql
new file mode 100644
index 0000000..a360fb5
--- /dev/null
+++ b/queries/palisades_rebuilds.sql
@@ -0,0 +1,9 @@
+CREATE OR REPLACE VIEW palisades_rebuilds AS
+SELECT p.issue_date::date AS issued, p.primary_address AS address, p.permit_type AS work_type,
+       p.valuation AS project_value, p.status_desc AS status, p.work_desc AS scope,
+       a.total_value AS assessed_value, a.year_built, a.sqft_main AS sqft, p.apn, 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.zip_code='90272'
+  AND p.permit_sub_type='1 or 2 Family Dwelling'
+  AND p.issue_date>='2025-01-01' AND p.primary_address IS NOT NULL;

← b9cec1a Add current_permit_leads view + CSV export (2,034 live resid · back to La Socrata Ingester · Add DTD-driven Opportunity Board (board.html) ed10986 →