← back to La Socrata Ingester

queries/palisades_rebuilds.sql

10 lines

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;