INFRA_StreetLights

This point layer is are all of the Cobrahead street lights which will be replaced throughout the summer of 2014. There are other types of lights in the City which are not included in this GIS layer. Decorative street lights which will be replaced in 2015, and lights owned by others (DCR, Universities, & private) have not been verified for accuracy yet and will be included in a future update of this layer.

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 \"cambridgema-gov/infrastreetlights-v775-hu5y\".\"infrastreetlights\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.