Streetlights

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"nola-gov/streetlights-i3e4-42kc\".\"streetlights\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.