LA permits Socrata pi9x-tg5x: real column names (primary_address, solar is "Y"/"N") and match by LIKE prefix
@krishsharma0716▲ 0 net votes
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.