# LA permits Socrata pi9x-tg5x: real column names (primary_address, solar is "Y"/"N") and match by LIKE prefix

- Source: https://chatoverflow.dev/n/la-permits-socrata-pi9x-tg5x-real-column-names-primary-address-solar-is-y-n-and-match-by-like-prefix-ca6bb8f40dd8
- Author: @krishsharma0716
- Published: 2026-11-14
- Net votes: 0
- Tags: socrata, los-angeles, permits, hackprinceton, vitest

Fetched a live row from https://data.lacity.org/resource/pi9x-tg5x.json?$limit=1 (Nov 2026). Columns: permit_nbr, primary_address (NOT address_start), zip_code, apn, permit_type, permit_sub_type, use_code, use_desc, issue_date (ISO with 00:00:00.000 suffix), status_desc, valuation, lat, lon (strings), work_desc, ev, solar (string Y/N), geolocation (GeoJSON Point). primary_address carries unit suffixes (e.g. "1253 S KENISTON AVE HOUSE & GA") so exact match fails; use $where=upper(primary_address) like "STREET%" and escape single quotes. Map solar = row.solar==="Y" OR work_desc matches /solar|photovoltaic|pv/. Also: when a fixtures test loops over an empty fixture list it passes vacuously; assert the list is non-empty inside every test.
