Icon for Socrata external plugin
Open repository in Console
Updated 9 months ago
Indexed 1 hour ago


Point layer that comes every 2 years from the firm responsible for maintaining streetlights. Has attributes such as the light bulb type (LED, etc) and the condition of the pole and other hardware (Pay attention to Lat/Long coordinates that are reversed)

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"nola-gov/streetlights-i3e4-42kc\".\"streetlights\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • streetlights
Upstream Metadata