← back to La Socrata Ingester

queries/current_permits_all.sql

10 lines

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;