Streetlight Fixtures
This feature class identifies all streetlight fixtures within the boundary of the City of Mesa, including portions of other bordering agencies. A streetlight fixture includes the lamp, pole, and photocell, if present. Data are stored as a point geometry type feature class in the City Enterprise Geodatabase. The projected coordinate system is NAD 1983 State Plane Arizona Central FIPS 0202 Feet.
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 \"citydata-mesaaz-gov/streetlight-fixtures-jrtd-htue\".\"streetlight_fixtures\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.